I Have Finished A Point Of Sale Program On Access, I Still Need To
ControlThe Cash Register Drawer By Code.
In The Manual It Is Mentionned
To Open The Drawer through com1 under qbasic

I have two problems I am trying to solve.
1) I am needing to be able to double-click on a list and have it open
another form with the details.  I will need the detailed form to be a
stand alone form, so I don't think I can use a sub-form.  I've looked

I have a table in an Access 2000 database and a web page.
I want to use various pieces of data from this table to drive certain
areas of the website, but I do not know how to do this.
For example, say my table contains info about authors and books and I

Hi, I have access 97.  I can upgrade if I have to (but that will cost
more money :)).  If I want to read a row, parse that row, and then save
the values to an HTML file, will VBA do that?
Say I want to write:

I was wondering if anyone out there can help me with this SQL problem:
I have a database that has two tables: EMPLOYEE and JOB_TITLE
The EMPLOYEE Table consists of a salary and job_title _code columns,
among many others; the JOB_TITLE table contains job_title_code column,

I am trying to open a Word template, fill some fields, and mark some
check boxes as checked.  Here is the code I am using:
   ' Launch Word and load the report template
   Set objWord = New Word.Application

Hi Gang
I have a simple table with some duplicate values.
Field1    Field2   Field3
Andy     Smith    10

I would like to create a search for that is based on the CaseFiles
query and have no idea how to go about this.  I would like the user to
be able to search by CaseNumber, FirstName, LastName, or ClientID.
Any help would be much appreciated.

Ok I've read it is not necessarily a good ideal to create a hyperlink
field in a database, but I've tried. I've also read that a hyperlink
field is a memo field with attributes of dbHyperlinkField +
dbVariableField. So I tried using the code below, and received the error

Hello I am trying to create dcount field but is not working I have
tried every way possible and I can't get it to work.  here is my code:
=Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and
[calldate] between #01/01/2001# and " & [calldate])

OK,  I'm confused.  SOME folks here seem to be saying it IS possible
to link to or otherwise access and manipulate MDB files stored on a
web server (from the client) and others seem to be saying it's NOT
possible.

Thanks in advance for any help with this query. I'm getting syntax
errors and "too many arguments" errors.
What I'm trying to do is count the number of trucks only if the
TotalLoss is above $0.00:

I have designed a "Time Tracker Database"... Basically a Time Clock.  I
have report that calculates the number of regular hours worked per
week.
Currently I am running the following query:

Just a quick question that I've spent a few hours trying to solve with
no luck (although one would think this should be fairly easy).
I have a form with a subform. The subform is based on a query. The
criteria for the query is based on the user's input in the main form.

Hi all... I've been trying to copy a VFP table into an Access database
and I haven't had much success... The code I'm using below (Access VBA)
returns a "Syntax Error" in the SQL statement. If I reduce the SQL
statement from an "INSERT INTO" to just a plain "SELECT * FROM eg", it