I have a field of Autonumber in my table i would like to start at 50000 so i use the method of appending a record with the value that i want the auto number to...

I have a database that has active & inactive names I cannot separate them. Is there a way to color the row that is inactive. I have tried but the whole...

i try to create a switchboard through the switchboard manager for my database. the problem is that i cannot add more than 8 items on a page. can i troubleshoot...

I inherited a perl CGI application that uses the integer primary key in the Microsoft Access database fabricate as the file name of flat text file to hold...

I have a table of employes set up with an autonumber field as the primary key. Someone deleted one of the members. I'm would like to restore the member with...

i have 2 columns in my report. but i am not able to get page header 2 times. how to get the same page header for multicolumns?

I have down loaded an update. When I try to execute the file I get this message. Jet35sp3.exe is not a valid Win32 application. Any ideas?? Thanks

Before split my DB, I can open one of my tables. But after splitted my DB,I couldn't open that table from my BE DB. The warning message is "Property value is...

I've recently converted a database created with Access97 to Access2002 version. The problem is when I open up one of the forms I created before, a window pops...

With the need to create a relationship between tables, I am wondering if it is okay to link more than one table's Primary field with the main tables Primary...

does anyone know how to create a table with a currency field that automatically places the decimal 2 places to the left I would like to be able to enter a...

Hi, I recently set up a number of databases on a new server in another country. The server (windows 2003 small business server) with windows 2003 loaded, had...

I recently added a field to an existing table, and shortly began receiving "Field '(fieldName)' cannot be a zero-length string" error messages for various...

I tried to locate the "Compact on close" feature. Opened Tools, General tab, Options but I do not have a compact on close feature. Is this only available in...

Hope someone can help.... I was asked to create a contract databse, however, there are over 100 contracts with a minimum of 5 pages, each page containing at...

I am working on a application that has several date fields, some of which are optional. I know that you insert/update date fields enclosing them with #. How...

I have a two field table, where the first fields allows a user to choose from a drop down box a list of categories (from a table). Based on their choice of...

I have a table with a hyperlink field. I have set the hyperlink base in the database properties to c:\folder. I want the user to be able to type in the...

I have a few simple questions: 1. How can I know the actual size in KBs of each table in my database? 2. Is there a way to force a database attached to a...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...