General

How many rows of data will an access database table hold?
How many rows of data will an access database table accept? I was told around 2G, but I need a row count. If not an exact count an approx. ... 1 Feb 2006 08:46

Automate: Composite Order Number
I'd like to automate my PO number in my orders table it is NOT the PK OrderID number which is an autonumber. It can be duplicated ... the 001-199 part could be changed but the projID/CatID/PurchID should be tied to the fields It is taken from 3 fields in my order form which is based on a qry LLLL000000LL ... 2 Feb 2006 03:00

access quiz
how many records can microsoft access hold in total? ... 31 Jan 2006 00:47

access database
HELP! please, I inherited an access database. The access database prints out subcontractor time sheets, I record their time as data entry, we print a time sheet audit report, which automatically shows hours/$$ which we compare against invoices. The problem I need help with: The subcontractor has changed t... 31 Jan 2006 13:57

Error Message
Hi, I received the below message when i was using the form. Please show me how to fix the problem. "Can't set value to NULL when CheckBox property=False" Thanks Chi ... 20 Jan 2006 13:58

Opening another access database from within an access database
I have a number of unrelated databases that I commonly use. I would like to create a central form in another database that would allow me to open any database at the touch of a button. I have tried using the open application command in a macro but it doesn't work. Any suggestions would be greatly appreciated ... 18 Jan 2006 12:53

Fuel VAT Calculations
Hi all I have an expense system that covers several countries. For the UK transactions we can claim VAT back on vatable items. The user always enters the gross expense and I have a table that I use as a lookup to work out net and VAT based on 17.5%. This all works ok (I divide the gross amount by 1.175 to ge... 21 Jan 2006 18:28

Alphabetical sort order
I have a music database listing, amongst other things, recording artists and track titles. I have two similar problems: 1. When listing tracks alphabetically, those that have a bracket at the beginning come first; how can I make Access ignore these punctuation marks and sort by first letter only? 2. How can I m... 12 Jan 2006 14:33

rounding errors in access
I am trying to get Access 2003to round to 2 significant digits, but it keeps truncating instead. For example, $1107 x 3.5% (or .035) is $38.745, and should round to $38.75, but Access keeps calculating $38.74. $99 x 3.5% is $3.465, and should round to $3.47, but Access gives me $3.46. My formula is Round([Dolla... 10 Jan 2006 17:39

Microsoft Jet database engine
When launching an existing Access database, which has always worked before, I get this error, "The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name and the path name correctly." ... 4 Jan 2006 14:02