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...

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 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. ...

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

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. ...

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...

I am trying to create a report that would calculate different employee rates over a large period of time. Rates change so I created two tables. All Payroll...

Can I use a wild card criteria in an Access select query? For example, I have on the Criteria line under the Signature field. The only way it works is if...

I have function module that converts date to fiscal year called FiscalYear. I have a query with date fields, say, StartDate & EndDate that need to be shown as...

I have a custom collection named CourseDates. In a procedure after I Dim Col As Collection, what is the syntax to set Col = to CourseDates? Thanks! Scott

-- akkrug

I am trying to replace a "*" that is inbedded within a text field. this field sometimes is populated and sometime is blank. When the field is populated this...

I used Access 2003 on xp professional. On form TIMESPENT I have four fields., ,,,. I want to calculate time elapsed when working on a project. The control...

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 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...

Hi, I've managed to get Access to send information directly to a Word document filling in the necessary fields in the Word document as necessary...

I need help! I am using the existing address database that comes with Microsoft office for a roster of fellow shipmates. We use it for keeping others in...

I am having problems with my syntax I think. I have a combo box on a form called 'ListType' - It can be set to one of three values (values present in the ...

I have a form open with data in various fields - I have a field in a table called "PURL" - I have the value displayed in a control on the form - I can access...