what is the best way to create a client data base from scratch. "L" plater here.

How can i update the form to have a pull down menu for field and have it update/input to the master table: TYPE SEPARATION (Officer,...

Hello i have a query set up but its pulling all the records. One filed gets a total $amount and the second gets a count of all payments. what i need is to get...

I tried to switch and i got a message "a recently installed program 'tvt_gina.dll' disabled the welcome screen." I found it in my windows system32 file but...

I bought budget planner and now I can't get it to open on my computer. What do I need to do? or do I get my money back.

Hi there I was asked by my company to sort out some shared excel workbook problems and I thought I'd give access a try.I created 3 tables each being linked...

I JUST WANT TO START MY TEXT AT THE TOP; NOT THE BOTTOM OR CENTER. MY EXCEL DROPDOWN LIST FOR VERTICAL ONLY GIVES ME THE OPTION OF JUSTIFY, DISTRIBUTE, BOTTOM...

I am trying to create a field in which the date time will change when I edit any field in the form. I can't figure out how to do it even though it is...

I know that I have made an error, but would like to correct it. In some of my tables I have set the Primary Key Field's Data type to "Number" when it should...

Hello, I'm new to VBA and am having a problem understanding asynchronous processes. I've a Form in Access that I want to start an out-of-process object...

I have created two form filters in Access 2003 and I want to run them from the All Cases Form using a Command Button for each filter , but when I create the...

Hi, all: I have a subform, which RecordSource property is set by VBA. And then, I want to bound one of recordset's field to a control, but It sounds wrongly....

Currently my employer uses Access 97 in September our Network is going over top & Office 2003. Problem, I have many Access 97 databases that have to...

In work we are changing over from Office 97 to Office 2003. To save money it has been decided that in future only a few people will have the full...

I have an Access Database in Office 97. In a Report based on a Query I need to calculate how many cases there are that fall in "Segment 1" and have a tick in a...

Is it possible (Office 97) to Link an Access Query to an Excel File. What I am trying to do is incorporate the filtered Access data into a Chart...

Hi I'm using Access 97 & in a form I have a Memo field restricted to 1200 characters, although you can type away until the limit set by the coding is reached...

SwitchboardID ItemNumber ItemText Command Argument 1 0 Main Switchboard 0

I have to use Access 97 for work is there a way of allowing the users to add or delete records (via Forms) from the Tables and locking everything else? Best...

I would like to calculate the difference in mileage between records filtered for a specific vehicle. I also could not find a means of determining the current...