I am somehow experienced working with databases (mainly PostgreSQL on
Linux) and with scripting (bash, Python, Basic), but total newbie when
it comes to Access. However, in this temp job I need to find
duplicities in 120,000 records table and Access comes handy. I found in

I have an Access Database that I was given to modify. I am trying to
add a Combo Box with the following choices
Yes
No

I'm hoping someone can shed some light on why my report does not output
the same results as shown in preview mode, which is to move the
position of a check box based on a field value (see code below). The
code does exactly what I want only in preview mode; it moves the check

Hello, All!
   This is probably a curly one.  I want to print a series of reports, and
for each report I want to attach and print an accompanying PDF file.  So
record 1 has a report page and then there is a PDF file that relates to this

I need to be able to access a query in VBA so I can cycle through it
and write parts of it out to a text file.
I have managed this with a database so far, but have now got a bit
stuck.

I just created a form with a text box "COFFEE" and another box that I
use to calculate the price of the coffee , with each one being $12.50
"COFFEE PRICE".
All is good except that each time I input the value in the coffee box

I'm having problem locking a table in Ms Access using VB6 code.
Actually I have 3 tables.
Assume table names is A, B, C.
Following is the process.

Is there a way to force Access to pause execution for a specified
period of time ? I would like a command button on a form to run it's
code when clicked and then pause for 2 seconds before allowing any
other user input. Thank you for any help.

I have an interesting problem that I have yet to come accross that I can't
change data structure on because it is an export from filemaker I am
reformatting for another dept. anyway. I have a table like so...
Table 1

Using A97.
Want to examine 17-char VIN entered by user. VIN codes
are alphanumeric and do not contain Oh's to prevent the
confusion that could result if zeros were misread as O's

Hi,  I have a user who somehow managed to turn off the min max close
icons in her menu bar (across Access as a whole, not just the
application that I built).  She has it in her other MS products, so it
must be an Access setting.

I need help with this apparently simple problem. I have a table with
the following records:
Effective_Date      Commodity Price
10/1/2005              0

I need the conncetion string to place inside of vba code to connect to
a sql server.  This is require so that I can add data to a table or
delete data from a table dependenting on the vba 'if-else' condition.

To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point to
a range in an Excel workbook. This is "because of legal issues..." according
to Office Support.

Access 2000
I need a query to return the Sum of the TOP 15 values for each student.
This is to rank the students according to the sum of thier best 15
scores.  Each student could have any number of scores. Ex: Dave has 55