I have a table with an autonumber and periodically I migrate lines in that
table to another table which saves the autonumber in a number formatted
field.
I had to reinstate a row with its original autonumber and the table lost

My report looks PERFECT until exporting it to a HTML file. It loses all of my
spacers, fonts, lines, etc that make it stand out. All the info is there but
it all runs together.
Any suggestions?

Where would I go to find some software that I can use on my DB so as stop
somebody copying it. I want to put an Encrypted code on one form that locks
all Data on that and 2 other forms will not work unless there is the right
code on the main form.................Thanks For any ...

RVB Systems Group has developed an Access database system that tracks
inventory and assets using barcode scanners.  This package is called
Track'Em and is available in two versions.  The LITE package ($395)
consists of a corded USB barcode scanner, the Access database system,

I have been getting 'Overflow' errors when trying to run a query.  I found
out it is because some of my data has a divisor of 0 (e.g. 10/0).  This data
comes from linked Excel worksheets with hundreds of rows of data.  Is there
an IF statement or something I can add to the query ...

I would like to run this update query automatically when the database
opens. At present I have it running from a macro when the form is
opened however it prompts the user twice before it runs. I would like
to eliminate the user input.

Good Afternoon,
I don't know if what I want to do is the best solution
I have built a query that I display in a list box (subform)
I want to keep the dynamics of the query so from withiin the form I can

I have the created a Macro for a RunApp with a command line of:
C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe "N:\Desktop\Tech
Database\Report-Province.xls"
This works fine, however I do have a question.  Is there any way to change

What is the general rule on these ... should they be avoided or is the
performance the same as writing one more complex query.
For example I have an audit/error table.  I have a few reports based
on this query.  I first create a query base to only gather records in

I am calculating seniority.  I start out by using a datedif command as follows.
Seniority: DateDiff("ww",[Hired Date],#3/31/2007#).
This gives me the number of weeks of seniority.  I then divide the result
by 52 to get years.  So far everything is fine.  Then I do a table lookup

I'm sure this has been answered before, but I was unable to glean the answer
from the archives.
I'm having a problem with reports where after the report is opened in
Preview mode, the code continues to run.  Is there a setting that will stop

Is it possible to open Access 2007 databases in Access 2003?  A friend mine
told me he tried to open a .accdb file in Access 2003 and got a
unrecognizable format error.  I imagine you can open 2003 databases in Access
2007.

Where do I look to place the following code to filter the form based
on the combobox result.
filter the form rather than navigate to the first match set the
form's

I'm trying to create a report based on a query.  The data source
(query and subsequent table) has about 15 columns and as many records.
I need to create a report that lists each record's primary key
followed by the results of any record that's <> null.  E.g.,

I have the following code snippet in my Access app:
Dim dbQueryDef As QueryDef
Set dbQueryDef = CurrentDb.QueryDefs("QUERY_NAME") ' (1)
Set dbQueryDef = CurrentDb.QueryDefs(26) ' (2)