I have a query based on a single Table the has the
following fields:
Field 1: BoughtDate
Field 2: SoldDate

I'm using an Access MDB as a front end to a SQL 7 database. When I place the
system time in a field in Access, it used the user's clock. I'd like to use
the SQL Server system time, so that the times will be synchronized. I
suppose I can just do a pass-through query with "select ...

Mr Lebans. Could you help me ? We are trying to run your mdb to
convert access reports to pdf but we can not, because an error
happens. We are just using the A2000SnapShotToPDFver751 that is
abailable for downloading.

Trying to create a report with a subreport. The subreport needs to run
a query that returns a list of Home Grades with a Count per Grade.
This in turn needs to be done for each Neighborhood in the main
report. The report would look something like this:

My breakpoints don't work.
Have, compacted, decompiled but no change. Also turned off AutoCorrect.
Heeeeelp
Jeff

Have a couple of questions about applications developed using
MSAccess.
1. Is there a way to run and use you application OUTSIDE of the
MSAccess main window? In other words, can you use the application and

I am having a problem appending data to an existing table.  I have two
tables with identical fields and I want to append the data from one
table (T2) to the first (T1).  T1 has 136 records and T2 has 209, for
a difference of 73 records.  When I run the append query, only 72

I have an unbound form frmProdReview with an OK command button set to
OpenQuery and a Cancel command button. On the form I have 3 controls
txtDate, cboShift, and cboDept.
When I click the "OK" button the query runs. It returns a datasheet

I want to embed some BMP files into an OLE field (called BMP) in an
existing table using code. I've created the code that grabs the
filename from the image folder, finds the corresponding record in the
table and opens that record for editing (RST.Edit). However, I'm

How can this be done and what is the syntax?
Thanks,
Sheldon Potolsky

In the thread "combining multiple address fields into 1 address field",
Stuart (?) helped solve that problem.
I then tried to set up a mail merge in Word to check how I could use and
merge the data.

I've got a bit of a situation that I could use some guidance with if
possible.  I work for an auditing firm where my users audit electronic
shipping data for customers to see if they've been overcharged for
shipments by truck and rail carriers.

I have a series of queries, I have a number of temp tables which I use
as templates for my data.
I start with
1. Delete the data in a temp table

how do I, in vba code, open a report by DoCmd.OpenReport  in acViewNormal
mode and force it to print only  the last page of it instead of the all
pages ?
BzyQ

I am trying to add specific form controls to a VBA collection, so that
I can pass the entire collection to another function, and access the
individual controls later.  I have tried several different syntax
variations.  In each case, the receiving function produces the error