I posted the below question and received the posted below advice which doesn't work. Advice as to correct syntax or correction of existing advice would be...

I have a table in which records are uniquely defined by four columns, being name, counterparty, account and date. I now want to make a form (bound to the...

Hi folks, I've read through as many posts as I can but I would appreciate some help in the following: I am trying to create a form for data entry in Access...

Is there a rule when primary key is needed in a table? For example I have small tables with 5 - 20 posts. These are used with Comboboxes in another table. I...

I'm creating a userform to be filled in and when the "OK" control button is clicked it will fill the information in on the next available row on the...

I have created a Contacts database based on the Contact Management template. The form for entering contacts has a command button for phone calls. When I click...

I have a database with voter information and ten fields that tell the elections they voted in or if they were absentee. I basically need to be able to filter...

I have a need to call a pdf stored document from a list returned by a query. The user selects a category and results are returned, one of the fields is...

I have a form with fields Name, title, Company,etc.. I set up the Name field as combo for adding makes easier. When I add new records, if the same person...

How can I be sure that data in a new row is saved to a table before I issue a .Requery? That is, if the data is entered, but the user doesn't move to the...

I want to hook up a roll printer to access 2002 to create receipts for certain transactions in the database. Does anyone know if this is possible. If so, is...

I need to separate data now in field "parcel" into fields "section", "block" and "lot", which is prently separated by dashes. Help as to the proper syntax...

I am new to Access. I created a mail merge recipient list in Word. How do I open it is Access? It is saved as a .mbd file. I tried opening it in Access and...

I am attempting to print 42 Reports. For some reason not all Reports print, only some. The reports are all using the same table for data. A Form version of...

Have been following recent thread on calculating ages. I have a Club membership list, including a D.O.B. field. I wish to calculate the current ages of the...

I have a Form automatically loaded when my Access 2003 db opens and the Database Window is "hidden". I know pressing F11 will show the database but I'm trying...

I have some MS Access 97 database with security i.e usernames and pw. I am converting them to MS Access 2003. However, when i tried to open these dbs...

I have some code using the CreateEventProc features when it creates a form. Problem is that as it executes, the Visual Basic editor window opens and remains...

Hi, I really, really hope someone can help me. I have been working on this problem for days and days, etc. First off please know the following: I have...

I've got the following query and it works fine. SELECT tblMasterClients.ClientName, . & "-" & . & "-" & & "-" & Mid(,InStr(1,,"-")+1) AS...