Does anyone have any ideas on how to write self-destruct code? I need to run a one-time procedure the next time a database opens. If the procedure is...

I am using a database to which 10 telemarketers are connected. When I run a query with specific criteria I get a number of records that fit the criteria. My...

Greetings, I'm using access 2000 and using switch board for my menu control. I don't want to spent too much time to design a form layout so decided to...

I am just starting to work with event procedures and almost everything so far I have copied and pasted from the nice people on this forum or from other places,...

That's because SQL Server uses single quotes, not doubles. Graham R Seach Microsoft Access MCP, MVP Sydney, Australia "HM" wrote in...

How can I get help and/or examples for built in functions such as CHR or Left$ etc? I have Access 2002 (XP) and with an older version of Access I seem to...

Hi All, I have a single NT Domain with a PDC running Exchange and a BDC. I want to upgrade a new server to Win 2k server. Should I install Win 2k Server on...

Hi, which shortcuts can I use to get list of functions or list of arguments when I am in VB editor Thanks alekm

I created a form from a query. When I run the form I only see blank form with no fields, but in design view all filled are there and have been correctly linked...

Hi, HELP!! HELP!! We have an and a but they are not fixed, eg: 03/05/2004 - 07/05/2004 and 05/05/2004 - 10/05/2004 and 12/05/2004 - 14/05/2004.

I recently upgraded to Windows XP Home. I am having a few problems with it but the one right now is: Incoming Email's font is very, very large. I understand...

I am very new to Access and have been working forever to try to get a simple form together for my boss. It's a form which tracks incoming work orders on...

Hello, I have a database that I thought up untill today was working fine. It has 3 tabs of information, and two subforms. When I use the 'built in' search...

I found some documentation about how to do this. I have two drop down list boxes and 4 text boxes. They are not registering the input. I can enter the data I...

I work in a company where Access is just starting to be utilized... and now all of a sudden everyone wants to use it. Since I am one of the few people with...

I am attempting to create a query where a particular date should not be displayed due to the size of records. Lets say I want the date 12/27/2004 not to appear...

I want to duplicate a record on a form because only two fields are changing value from record to record.I have created a duplicate record button. When I click...

I have an add-in, authored in 1999, that debugs to VBA where references indicates comdlg32.ocx is missing from my machine. I have comdlg32.dll. Is there...

I am not sure I understand your problem completely. It sound like you're copying all of the values in one record and then adding a newing record with those...