How do bulid a databese can show out Qty In, Qty out and Balance on same Forms? Because I'm new users..

I have a search form that searches for, among other things, lastname. There are several fields in the underlyling table that contain lastnames (call the...

I have minimal knowledge of Access database design, but have fiddled around with a few in so far as I've added fields and data and constructed a few queries...

How Accessible is Microsoft Access? Why Access may or may not be the right choice for new users? How Access can be improved to help new users? What the new...

I think I have some non numeric data in a column I had code working added some records and now the query dies with a compile error every time I run it I have...

In a query when I use the following expression dhAddWorkDaysA(12,,Array(#5/28/2007#,#7/4/2007#,#9/3/2007#)) I get an error message "Data Type mismatch in...

So when is it OK to use one? Must I banish combo boxes to outer darkness?

I use the following to find a record and set the Bookmark in a Forms Recordset. This should set all of the Fields that are displayed in my form to the...

Hi My access app uses word and outlook references which I can not get rid of due to certain features that my app has. I have this problem that I need to...

I have set up a basic form using the wizard and now I need to add some fields from another table - how do I access the other tables that I want to...

Hi Everyone, Access 2003. I am adding a new subform to a form. I has 2 fields for a record, date and hours. The subform is on a tabbed form. My other...

I am trying to have an Item added to a Table when it is not included in the Drop Down combo box. Have tried to enter the code in a module as advised on...

Hello I need a simple code or even few commands to change resolution of screen

i need a suggestion on how to best setup a password. i will have a dialog that asked how the main form is to be viewed. a password will be required if the user...

I want to generate a StudentID (that I want to be the Primary Key) from the first 3 letters of the LastName and then the first two letters of the FirstName...

Hello, I was wondering if somewhere in the options of access there is a field where I can change from centimetres to inches (word & excel both have...

I have a Table to store Stock Items and this consists of Make - Model - Serial Number - description amongst others. In order that I dont have the same Make...

I want to add an text box or label which will display the number of sales an agent has made on the agent form I have named the form frmAgent as it is based on...

Newbie to access (using access 2003). I need to split a large table (65k rows) into as many parts, each part should not exceed 60k rows. Thanks for insights.