Search results

The field is text. I placed single quotes and I tried double when I do this now I get the error of "Too Few Parameters. Expected 1" on the code SET RS = CURRENTDB.OPENRECORDSET(A$).

Did you check to see if the fields Days Open and Times Reopened are numeric fields if they are text you need to place quotations around the number for example ((qryDiarySystemPartOne.[Times Reopened])="0").

I say LIKE because the field is a text field and would read something like "Accepted 02/26/03" so I am trying to find all the records that have the date 02/26/03 in it. When I use an actual query this works perfectly. It's when I copied the SQL statement to code to do it that way that I have...

I tried your suggestion and it didn't change anything. Thanks for trying though. Maybe this will help... I am assigning the SQL statement to a variable and I don't receive the error until I do the statement Set RS = currentdb.openrecordset(a$). But it says there is a syntax error somewhere...

Here is the SQL statement UPDATE [CCI NEW HIRES] INNER JOIN [Last Paycheck] ON [CCI NEW HIRES].ssn = [Last Paycheck].SSN SET [CCI NEW HIRES].Active = "NO" WHERE ((([Last Paycheck].[MaxOfPay Date])<DateAdd("d",-60,Date()))) WITH OWNERACCESS OPTION; But even if I break it down to two queries...

You were right again but that still doesn't solve the syntax problem. But again thank you soooo much for trying to help me I really appreciate it.

You were right again but that still doesn't solve the syntax problem. But again thank you soooo much for trying to help me I really appreciate it.

I counted the brackets and they all seem to be there. Thanks again for trying.

I didn't realize before but the error says "Missing Operator in query expression" if that helps anyone

Thank you so much I didn't notice that but it's still giving me a syntax error. I've looked at this time and time again I don't know what's wrong with it. Someone please help.

Without getting into full details can anyone by looking at the following sql statement tell me where the syntax error is... a$ = "SELECT [First Choice].ID, [Res Rep Volume].SSN, [Res Rep Volume].Net, [First Choice].Type, [First Choice].[Product Code] FROM [First Choice] RIGHT JOIN [Res Rep...

Do you mean like a primary key because I have an ID Number field which is my primary key and it is indexed (no duplicates) and it still doesn't work.

I have a database that we use for data-entry and payroll for our employees. I have a table which lists all the employees that have worked for us past and present and I have a field in that table called Active. I created a select query to show the SSN each employee who's last pay date to see if...

win2000 and access xp

I received the message "The database is in an unexpected state, Microsoft Access can't open it. The database has been converted from a prior version by using the DAO CompactDatabase method insted of the Convert Database command on the Tools bar menu. This has left the database in a partially...

Create a macro you can create a macro using the output to as the action and then at the bottom select table as the object type, Wbt_Orders as the object name, for the output format choose excel and where it says auto start select YES. And place "DoCmd.RunMacro stDocName" where your other code...

I'm creating a form to add records to a table. I want to be able to view the last records entered to which I can do in a report. But is there a way to include the report on my form. I can't use the subform because I want to display multiple records at one time. Thanks in advance.

Adrianna Thank you so much that worked perfectly.

Does anyone know if it's possible to open a form from a seperate database with a command button. And if so could you please tell me how. Thanks

That worked great thanks soooo much