Good Afternoon, I have a database with one table called Referring Providers. I have a control, "referring provider id" which I defined as an autonumber and...

I am building a table with several list boxes. When entering a record, I want the user's selection in one list box to effect the choices in another list...

Hello all, I've been trying to get my head round how to do this and completely failed. I've got a report which I can print off without any problems to a...

Hi, To collate my research notes - at the moment the data is in an Excel spreadsheet which is getting very large and difficult to manage - I need to create a...

I had the developer extensions working fine, then one day the developer button disappeared. I ended up re-installing Access, removing and re-installin the...

I have Office Small Business 2007 on Windows XP Pro. I would like to download a trial of Access, but in looking at trials available, I see only Office...

Hi i was hoping someone could help me with a problem im having in access. I have a many to many relationship between two tables tblPerson and tblDoctor. These...

Greetings, I am doing research for my wife. She needs to get MS Office programs that will allow her to compile a database of client information (is this...

In a report I want the value of a textbox to appear within parentheses when a Yes/No field in the underlying query is positive and without parentheses if the...

When I click on the referential integrity box this error msg pops up: "Relationship must be on the same number of fields with the same data types." what...

Hallo Is there please some easy function (maybe DSUM or SUM or whatever) which is possible to use to get a sum of field in recordset instead of using do-loop...

I know I posted this question time a go, but I have to keep trying I am connecting MS Access to a Pervasive SQL Server with a very old table structure...

When you are using a table in access in one field you type 1 then hit enter to go to the next field and automatically a 2 appears. HOW DO YOU STOP THAT? It is...

I have created a few drop down lists on a form using a wizard. I have entered the values on individual tables for the drop down lists and the values are...

You can only split an MDB. If the developer didn't give your friend an MDB version of the application, you're out of luck, since you can't convert an MDE from...

is there a good way to approximate a sql trigger within access - without using a forms after insert event?

Hi, I have been reading a lot lately about possible database configurations and I am not sure whats best for my situation. I want to make a database for my...

I have a form with two listboxes. At this point I can select a name in listbox 1 and it just pulls that name (CustomerID) to the listbox 2. I need all matching...

Hi Everyone, In my table I have a field named Short_Description and in this field contains various part numbers...example...6312-2RS(D),...

I have a form that gives the total hours worked each day, I would like to add all these up to give a weekly total hours it of course only displays up 24hrs,...