Hello. Using Access 2003 on WIN XPpro. Why am i getting this error when executing a report: Syntax error (missing operator) in query expression '(="BLAIR...

The following bit of code appears to have a syntax error. This line is supposed to tell access where to find the attachment I want attached to my email. ...

I have failed to get this working: =IIf(=-1,"Joined " & & " " & Format$(,"d mmm yyyy ")","CharterMember ") Error message reports syntax error, comma...

I have a command button that opens a record based on what company is selected from a combo box. A new company that I have has an apostrophe in the name. ...

Can someone tell me what's wrong with this statement? I keep getting a syntax error when I try to add a combo box to this form. SELECT DISTINCTROW...

I am trying to set the status of certain deliverables. I get an invalid syntax error with this statment. I am sure I am missing parentheses somewhere but I am...

I have the following expression: strName = """ = """ & strLastName & ", " & strFirstName & """""" & """" It Evaluates to: "= "Lee, Larry""" It Should...

Although I've taken 2 Access courses, have Cashman's book and read countless posts; I'm still uncertain "wording" & syntax. I've created a form with a...

Is there a way to automatically query and select the first data on the second combo box when I make a change in the first one?

Me and my college work on same Access database filling data in, but we work separate, "decentralized type". Can we somehow merge or synchronize our tables...

Hi, I am running Access 2007 and have an database used to track Issues and Tasks. Currently I am running the master copy on my laptop as we are not in the...

I am fairly new at working with an access database. I am attempting to synchronize the Design Master with a Replica and I am receiving an error message...

Help! I am having trouble synchronizing two combo boxes. The first one is Departments and the 2nd one is models. I need for the 2nd combo box to display the...

Hi, I'm trying to synchronize a data entry form to work together with a table that has a lot of entries. Here's my problem: I have a field called First mailing...

Thanks for your help in advance I have a table called Tblpersonal details- this has 4 fields- IDno, Surname, Fname and Dtae of Birth- IDno is primary key for...

Hi, I'm re-posting and rephrasing my question. Using Access97 and WinXP I'm trying to control the drop-down list shown in a subform combobox from the...

I think i may be totally stupid, but.. I have read all the previous answers on this but i still do not understand. This is my first try with access, and i...

I have a database that runs on our network (Access 2000). We have service engineers that go out to our clients sites. I want them to have a copy of the...

Hi, I have Table Orders as Subform in Datasheet View with fields ID_Order, Customer, Date, Task. Field Customer is Combo box (Source from Table Customers). I...

I have successfully synchronised 2 combo boxes but need to add 1 more. Combo box 2 (cboFeature) is sychronised to combo box 1 (cboRequirement). I would like...