I have a database with 2 different tables. I have one for direct employees and another for temp employees. I want to be able to combine them into 1 list and...

I have a query that is the Row Source for a combo box that is used to filter a form by date field. Is it possible to have the query pull only the blank...

How do I disable append and update messages?

None of the make-table queries in my access database will run. I get an "Invalid Arguement" message when I try to run them. But when I change them to a...

Thank you begin date end date subtract number in days 1/1/2004 5/1/2004 4 15/1/2004 20/1/2004 5 I...

Hello and thanks in advance. I have a database with SEVERAL tables linked together. (using Office 2000). One table is an instructor table. Each instructor...

Please help. I am trying to creat an autolookup fields. I have 2 tbls a Calls tbl and Callers tbl. I want to be able to select a callers name from a drop...

Hello, i want to make a update query, but i can't. In my event: i have a query1, with field Name, Number with SUM for each record from table1, and group by...

I have a main form called PrintRequisition with the following query as its record source: SELECT Print_Requisition.PrintReqID, Print_Requisition.ProjectID,...

Hi, Is it possible to make the parameter query so that the item to be queried on can be selected from a combo box? Many thanks, Aniko

I need to semi-automate the following steps but I don't know how. Can someone offer some suggestions. First run a query that will append all the data...

Is it possible to use a global variable as a criteria in a query Example: I have a table: year stuff --------------------- 2002 things 2003 more...

I'm looking for an easier, more elegant method...I have code in a form that creates a temp query using sql, then using dlookup to get data, eg. using sql to...

Basically, I have a string in a query (used as rowsource for a list box). I've pared it down to try to find the error. Right now, I've got: --- Outgoing...

I have a Seminar table and an Attendance table, seminars and Attendance joint by Seminar Number (Attendance table also has attendees Social Security Number)....

I've created a Time & Expense access program. I've created a query with muliple headings. I want to create an expression that will combine the headings into...

I keep getting an error message stating that there is a data type conversion problem. here is my SQL: INSERT INTO Case_Issue_Tech_t ( , , TechID,...

I have created a form that Prompt the user for criteria used in a query. The queried data is shown in a Subform Datasheet. I would like the user to be able to...

Is there anyway to compare memo fields using queries? I can create Unmatched Queries to compare text and quantity fields; but I can't perform the same type of...

Andy, You must be frustrated about something? If you need help just post it in the correct area and you will get help as soon as someone can get to you. I...