Is it possible to re-start an autonumber field with "1" after all the data has been deleted?

I have a table question that I cannot figure out. I have a date field in my table. All the records have the field populated with the same date...12/08/2004. ...

Hello, I want to use an image from your website in a presentation I have to make for the Business Professionals Club in January. Can you please grant me...

I have multiple projects that can be located in multiple places (muncipalities). I have a table of projects and a table of municipalities. I would like to be...

I never had this problem before; however, I have a main form and subform linked together. When I type in data in the first field of the subform - I get the...

I've just moved two databases to a folder on a network drive for testing: one is a database of service requests, which contains several tables linked to...

I have forgotten how to create a hider macro. Basically the macro hides a row if it has the text "hide" within that row

We have to save the print to file in a specific folder for an exam question. Why does Excel and Access not allow you to have afull dialogue box for entering...

Is there a way to generate SQL scripts for existing objects(e.g. a table) in Access?

Hi, In the event of a corrupt database(like now), how do you recover the records from the several tables within that database and transfer those records to...

Hi all - Access 2002 XP - W2K I am a regular responder on a few newsgroups and forums, and needless to say my resource and reference files are getting quite...

I need to develop a database application for a client that uses 2002 and I have 2003. It is a simple application that will have a user front-end and data file...

I've recently installed Office 2003, and added Access 2003, and they run fine, but, when I try to open an Access database I created in Office 97, I get a...

Im trying to assign auto date(current date) to the date field.However everytime I do this, there is an error, saying im trying to assign a null value to the...

Hi, I have a major problem with Access forms, I developed a form based on SQL Server table (.adp file). I'll describe the tables: Table Employee (ID, Name...

We have a n ODBC link towards an SQL server application. In a table there are notes stored. If we want to retreive them via the ODBC link with data type "memo"...

Hi all. I have several tables in my database and some are linked. I want to modify Table1, field4 to have a lookup to another table I created (Table2). ...

I have a join problem I can't figure out. I have two back-end databases joined on their control numbers through a front-end query (db2 on the left, db1 on the...

Hi all. Thanks in advance. Ive been putting together this database for the office. Luckily I've had time to experiment with quite a few suggestions and they...

Access 2003 Can I restrict the output of a NAME field to print only the FIRST LETTER, i.e., the INITIAL? Or do I have to create a separate Initial field?