I have a listbox whose rowsource is set to a saved query (call it
"qry_customer_list.") When I add customers to my database, I call the
listbox Requery method so that the listbox will display the customers that I
added. Unfortunately, the listbox display does not change. If I ...

This code does not return focus to Me.txtDiskSerailNumber, it moves it
to the next textbox in the tab order. How can I force it to setfocus
where I want it.
Private Sub txtDiskSerailNumber_AfterUpdate()

I am writing a database for sales forecasting.  All of my entries are
in a table, each entry has a Projecting Booking Date.  I need to write
a report with 4 groupings:
0-30 Days Out

I have used this code to append my records:
INSERT INTO EducationTbl
SELECT *
FROM EducationTbl IN 'C:\ProgramFiles\AMSRepUpdate.mdb';

I'm trying to update a record in a table with data from text boxes on a
form.  As a background to this, I managed to add a new record to the
table in a similar manner with the following:
   Set db = CurrentDb

I have a chart in  form the 'X' axis is in time values
ie 06:00 - 07:00,  07:00 - 08:00,  08:00 - 09:00  .....etc
over a 24 hour period
Access is returning this on the chart starting at 00:00 - 00:01

whenever i open a compressed file in pen drive, a temporary file forms
in windows temporary folder, which disappears as soon as i close
compressed file in pen drive. but this temporary file in windows
temporary folder which has though disappeared, can be recovered by using

I am trying to conditionally print a field on a report based on the
value of another field in the query that the report is based on.
In the Control Source for SerialB I have typed:
 = IIF(nz(QtyB) > 0," ",SerialB)

I am wondering about including binary files in my MS Access database
application.  I want to keep my application as just a single MDE or MDB
file, but the users of the app may need some additional files. One file
is an ODBC driver for connecting to an external database, this is a ...

How can I ramdomly select a list of records from an existing table?
For example: 500,000 names divided by 20,000 samples = 25. The N is
25, meaning samples would be sent to every 25th name on the list.
Any help will be appreciated?

i am a pilot by profession. i want to create a database of my logbook
using ms access 2002. i am facing a problem regarding the format of
time field. when i select "Data/Time" data type for my time field then
this format gives the liberty to record times uptill a figure of 59 in

I'm having another one of *those* days today.  I have a form which can have
many data sources which are chosen from an option group.  This all works
fine except that the subform doesn't refresh even though I'm calling the
main form's open event from the option group's update ...

I got a CSV file with more than 300000 raws so I couldn't open it in
Excel. I decided to use Access but I can't access the data using
standard way such as Workbooks(Name).Cells(i, j).Value as I used to do
in Excel. I really need to do some manipulatons with data and SQL is

My problem:
I'm having trouble with a query taking much too long to run; a query
without any criteria evaluating only 650 records takes over 300 seconds
to run (over the network. On local drive takes 120 seconds).

I have a 2 table query in Access 97, with a Vendor "short"
name in the main table pulling a Vendor "long" name from
a linked table to print a report (Sql is below)
This all works fine, EXCEPT when I have not updated the