I have a control named "cboProjectMatl" on a form called "frmMainScreen" that I am trying to reference as criteria in a query, but I get no results. I...

Hello, I'm trying to build a query that will do 3 things: 1. Find matching names within a database 2. Find matching dates within a database 3. Exclude an...

We recently upgraded to Vista and queries that used to run without a hitch are throwing an error message. The error is Not enough space on temporary disk. The...

How do I automate the running of 5 Access mdb apps ? No experience in this area so I really appreciate any assistance ... I want mdb A to run at 1 am...

I have a table linked to an ODBC 2005 SQL database. One of the values in the table is a date stored in the table as "Date/Time". When I try to create a...

Access 2007 does fine connecting as a client to SharePoint linked lists (WSS3) remotely in certain situations but perhaps someone could help improve my...

Hi all, I am using the following: If Me.txtDescription "" Then varWhere = varWhere & " LIKE """ & Me.txtDescription & "*"" AND " to search but...

Hello All Why is the query below so slow - it normally takes 30-45 seconds. There are ~4000 records on table and ~100,000 records in table : surely these...

Dear all, Using MS ACCESS 2003, I'd like to launch a series of query using the same parameters for all of the queries to refresh (starting date...

I have a table that contains multiple accounts. each month I have filter those accounts that I did not received and invoice. Is there a way on a query that I...

I have to use number 1 -14 in a Column . When reaching 14, numbering must start at 1 again. Can you please help me with this?

I have a public function that does Luhn validation (verifying whether a credit card number is of valid format). It looks something like this: Public Function...

Hello all, me again. I have email addresses listed in my database that I want to be able to click on a button and have this create an email distribution...

Want to create query showing orders 30 60 90 days overdue. would like to calculate these dates without vba....tku 2003 or 2007

Using Access 2007, I'm having fits designing a query that seems like it should be fairly simple. I'm trying to count the number of plant species in different...

Access 2007 I am getting a "Specify the table containing the records you want to delete" error when trying to delete rows in a linked table containing an...

I am trying to create a time sheet for appointments that tells how long each appt lasted so I can bill them per hour. The expression I have entered with the...

I want to use IFF statement in a querry but so far am unable to figure out how to do it. If someone could guide me I will be greatful. following are the...

I want to be able to insert a whole bunch of records from one table into another table using a query. I need to be able to set/increase the value of a field...

How do I put multiple values into the value portion of a crosstab query? Or perhaps a more appropriate question would be how do I represent the data in a...