General

Trouble importing Excel field correctly
I am trying to import an Excel file that has a field formated like a zip code (Must have 5 characters). Some of the numbers in this field have leading zeroes. In Excel the format is correct (after I format the field for zip codes), but when I import it into Access 2003 Access strips out the leading zeroes. I ha... 4 Jan 2006 14:33

Proper address for a former state governor in the inside address
What is the proper address for a former state governor in the inside address and the salutation? ... 3 Jan 2006 18:11

How can I enter and display date in Military format?
I'm doing an application in which we wish to enter and display all dates in Standard Military format. I am using general date format. Date Time Group is to be entered and displayed as: ddHHnnZmmmyy For example: 011200ZJan06. The Z is the ZULU or Greenwich Mean Time Zone. ... 22 Dec 2005 22:25

ADO, DSN, ASP - HELP
Hello, This question may not be particular to this site, but since this community has been so helpful in the past, I thought I would give it a try. I have an asp web app, that is connecting to an Access DB. The connection is done through the following function. However I keep receiving a 'Data source name... 20 Dec 2005 00:07

example of resigning letter to employee
i want to write resignition letter to my employyee i need sample buisness letter ... 19 Dec 2005 04:13

How can I correct Invalid Argument Error 3001
I have been entering data into a form for family history. After I have entered the data for one form and tab to the next blank form I receive the following message. Invalid Argument (Error 3001). Other information about this database may have some relevance. -One cell in the database is for images. I have ... 18 Dec 2005 14:47

Access & Outlook
We have some VBA code that generates and automatically sends emails..the code looks like... Dim mobjoutlook, mobjcurrentmessage Set mobjoutlook = CreateObject("Outlook.application") email_form = email_form_name Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form) send_to ... 18 Dec 2005 05:22

networkdays formula in MS access.
Is there a replacement formula for Networkdays in Access. This formula is availabel in Excel n not in access. ... 16 Dec 2005 04:46

Query/Parameter Question!
My table has the following fields- EmployeeID, RqstDate, FollowupDate, and Rush(Yes/No) My users would like me to create a form that they would be able to enter the following information to filter the Records in the form. information as follows Select Employee ---[EmployeeID] between RqstDate 1 and RqstDate... 16 Dec 2005 05:48

Access 2003 error "unsafe expressions"
Hi, Has anybody found a solution to this error message when you first open a DB: "Security Warning: Unsafe expressions are not blocked" It goes on to ask about Microsoft Jet 4.0 Service Pack 8 must be installed, and then finally gives you a window to open the application. This application was developed i... 15 Dec 2005 23:39