need to send a command from a POS Application in Microsoft Access 2000
to open a cash drawer.  If anyone can help, please contact me.  I will
pay $$ for very specific directions if I have to.  please email me at
carl@technology4all.com.  Time is of the essence.  :-)

I have two tables I'm using in a query. I have pulled several fields
from 'tblEmployeeList' and need to pull a Yes/No field
'FileStampNumber' from the table 'tblFileStamps'. However, I need to
create a statement saying that if field 'CurrentFile-Stamp?' is true,

I've got a multi-page subform with a tab control on one of the pages.
The code that moves you from page three to page four, which is where
the tab is, changes the tab captions according to some information
stored in a table. Only it's not working. Actually, it is working, and

I have an Access 97 database, quite large, and have started getting the
error, Error 3048: Can't Open any more databases.
-The data is split from the application (front end and back end).
-The application has a fair bit of VBA

I'm sure there is an easy solution for this problem. On "FORM A" is a
combobox with a separate table as its record source. If the data
required in the combobox is not one of the available choices in the
underlying recod source, the user is prompted to "click" a button

I need some help here. If anyone has encountered this, knidly give me
your advice.
I have a command button (Command0) and a listbox (List1). Upon
clicking the command button, I want my listbox to be populated. Please

I have an Access 97 database, quite large, and have started getting the
error, Error 3048: Can't Open any more databases.
-The data is split from the application (front end and back end).
-The application has a fair bit of VBA

I've got a form, and I'm trying to set up a way of emailing from it.
Does anyone know, if I've got an email address in a field called
[Phone Number], is there a way that I could create a command button
which, when clicked, would open up an email, with the value from the

Does anyone know of a source of some good exam (pop quiz) type questions
on Access? Looking to test candidates in a job interview. Pref a mix of
multiple choice and ones that have real answers.
(Also same for SQL Server & VB)

I have created a form in my database, how do I get the form to open
automaticly whenever I open the database?  Any help would be appreciated.
Chris Booth

i need som help!!!
I have a form wich a user type some new data in! And when he/she hits
the 'Add' button... i want the data on the form to fly straight into
an existing table!!

I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report.  I need it to
seperate the pages by only allowing it to start an a new client heading on a
new page

I have come across some code to walk through the records of a corrupt table
and copy it record by record to a new table.  It comes from the MVPS.Org
site and is as follows.
-----------------------

I have a database with several tables, one of which is [Master Data
Table]
I use this to bring up a form so you can unlock the record (set by
using a yes no box on the data input form to prevent unauthorised

When i type data in a form, the data will be saved in a table when I
close the form.
How can I created a button, or what would be the function -
to save the data (without the need to close the form)?