Several users and myself have observed an annoying problem in my Access 2003
app, where a combo box is not consistently being refreshed after new records
are added. This seems to occur when the combo box's query is based on a SQL
Server 2005 Express view, rather than the multiple ...

does anyone know how to get a driver for my Vista program for a Lexmark X75
printrio?
Any help appreciated?

While trying to access my Database, I'm getting the following error
" The Microsoft Jet Database Engine could not find the object 'MSysDb'. Make
sure the object exists and that you spell its name & path name correctly.
I need help to open this Data base. Urgent help is needed.

I need to have a query where it displays all dates in a fiscal month.
Fiscal Month runs from the 21st to the 20th
so if i run a querie for this month it should show the dates for May 21st
through June 20th.  (The month to be displayed will change depending on what

Here's the breakdown:
I am working with a separate Internet database tool that allows me to export
information. I chose the categories I needed, exported the info, and imported
into Excel, to then import into Access (2007).

I have  an append query that appends to a table a bunch of fields.  One of
those fields is the date in which I ran the query.
I only want to keep the current days data on the table and the previous days
data on the table (so basically 2 days worth of records).  So I thought of

Hello - I have 2 tables both created by MakeTable Query.  Both were designed
for mailing labels.  We have sent invitations to the people in the first
table and would like to send invitations to the people in the 2nd table, but
some of those people are also in the first table.  ...

  Is there a way to make a value in a field "unlimited" or does not empty.
I'm using a running balance in my inventory and there is a certain product
which i want to become "unlimited". Is this possible?
  Thanks in advance!

I have a table with two fields, Date and Sales. The data goes back 25 years.
I would like a query that gives me the 365 day avg for each month in the
last two years; i.e. The avg for May 06 thru May 07, then April 06 thru
April 07, and so forth. The final result would have 24 ...

How to filter query to list all date field who have birthday from NOW date?
Tnx

I have 3 Qrys: QHInd_12_01_VacasTotales, QHInd_12_02_CargaAnimal,
QHInd_12_03_Natalidad%
QHInd_12_01_VacasTotales
SELECT F02_Hato.CodProd, Sum(F02_Hato.Cabezas) AS TotalVacas

I need a query to find "T"s and "Z"s which are preceded by a single number
and followed by 4 numbers. For instance, "1Z0235" or "8Z4086".  This pattern
is found in the midst of a lot of other verbage.
Thanks so much for your help,

I am unable to figure out how to tell the query which table I want to delete
the records from.

I have two tables with identical structure.
I need to copy all records with a certain date from table to table
I use this SQL but it gets syntax error:
  rs.Open "INSERT INTO tblAddress SELECT * FROM tblAddressOnline" & _

I have a "Make Table" Aggregate Query which is not producing the same data
consistently.
Are there any known issues doing this?
Never had to before, but if I use a Function to see if "TableExists"...find