Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at

I have a group of Sales Mangers that are using an Access 2003 program. The
main database (the front-end) is linked to a file (the back-end) in the same
folder on their computer. They are using laptops at remote locations which
are on a VPN with a firewall. When completing a ...

For the location recording of pallets in our warehouse we use a three
dimensional grid as follows:
Left to right, rows A to M
Front to back, stacks 1 to 4

I created an application and saved it to a company server. I then split the
database and created an MDE file. Using the MDE file, I copy it and then past
it to each user's desktop.
Access 2003

I have a table where I import data which I need to update periodicalloy from
another source.. I do this by:
1)Importing the source data into a new table.
2)Deleting all the records in the existing table but retain all the existing

I have just started having a problem with query design view in Access 2000.
Whenever I try to right click to modify a selected output field, Access is
crashing.  It does this in all, but one of my applications and I cannot
determine what might have changed or is different.  If ...

Microsoft needs to fix this bug!
When compacting a DB on a network drive the original file stays and it
creates the compacted one with the name db1.  For whatever reason it does not
delete the old file and rename the new one.

Are there rules of thumb? Back in the days before Microsoft vanquished
programming efficiency, you could calculate sizes fairly precisely  -
multiply integers by 2 and longs by 4 and so forth (allowing an
address table and code and certain overhead).

Any idea why I can no longer select the the reference "Microsoft ADO Ext. 2.8
for DDL and Security?"
It's not in the list anymore?

I have an application developed in Access 97 Front-End and Back-End
also.
I own licenses of Access 2003 retail version and Access 2003 Developer
Edition.

I would like to be able to copy a record and then give the user a message box
to fill in one field on the form, specifically, revision number.
Can anyone help me with this? I have the button already which copies and
pastes a new record, but I want to make sure that the user will ...

i have a quick question.
when building an application that is made up of many different "modules" or
"work types" is it a good idea to build a separate frontend and then merge it
later?

Hi, everyone
I have a samll DB of debits(expenses, food, etc) and
credits(deposits).
If the general balance becames negative I need a query that will give

What is the maximum number of fileds allowed in an Access 2002 table?  In an
Access 2007 table?
As always, any aassistance is greatly appreciated!
Thank you,

Hi, I have a few queries that I use to display data as graphs (pivotchart
view). I inserted all the graphs in a Form through Subforms (using the
queries directly as the source objects of the Subforms), so that each Subform
displays one query, always in pivotchart view.