General

Import Spreadsheet missing field
I am having an issue when I attempt to Import an Excel spreadsheet into Access. There are 18 columns and the right-most column is a free-form text/memo field conatining an audit trail of user inputs (ie dates and text). When I attempt to Import the spreadsheet, this column does not appear in the Import Spread... 12 Jul 2008 13:34

Outlook GAL to table possible? (Access and Outlook 2003)
Is it possible to extract information from the GAL in Outlook 2003 to a table in Access 2003? I am interested in getting NAME (Display), SMTP, ALIAS tx ... 8 Jul 2008 07:58

Combo box trouble
Hi, (Access 2007) I have two combo boxes which are unbound. I want 2nd combo box to show value list according to the value of 1st combo box. As a sample: If combo1 has value of 1 then combo2 should show list of 1001 and 1002. If combo1 has value of 2 then combo2 should show list of 2001 and 2002. I have ... 7 Jul 2008 15:36

Grouping Query
I have a table containingg 4 fields: [Member ID] [Trans Date] [Code 1] [Code 2] I would like to create a query which indicates for each [Code 1] what possible combinations of [Code 2] are there for any given [Trans Date]. For [Code 1] there are 9 different possible values. There are about 400 different... 8 Jul 2008 16:11

Fill Word docs from Access DB tables
When it comes to VBA or any type of programming, I know practically nothing. Not to mention, I don't know much about Access, however I'm hoping that this is within' my reach. What I'm trying to do is populate 4 or 5 different Word documents with data found inside an Access DB. These 4 or 5 Word docs are all ... 8 Jul 2008 10:01

Slow connection thru VPN
Hello everyone! Maybe you can help me with this matter: I have my LAN, an Access 2003 application, splitted in front and backend. The 'server' is winXP Pro The clients are XP too. The server user needs to work from home, so he's carrying the pc to his home. We have hardware (fortinet) as firewall and other ... 9 Jul 2008 00:24

data update by time/date
Hello- My need is very specific. I need to store data on a daily basis using the same name and location, some of the fields will be updated and I need the updates to be saved via date, with the remaining data unchanged. The problem I'm running into is that every time I update data I am unable to save the old d... 7 Jul 2008 14:33

Analyze With Excel
I have a DB that I created and gave to another department to use. If this user tries to "Analyze with Excel" the DB crashes, he gets a "Do you want to send" error box with no explanation as to why. If I try the same process with the same date, it completes with no problem. How do I fix???? Thanx ... 8 Jul 2008 00:49

Avoiding Error message (3314) when creating a new record
I created a database in which a new Client ID (primary key) is created (via AutoNumber) when a new record is created. When I click "new record", a blank form pops up. But once I start typing data onto the form, the following message appears "The field "Clients.ClientID" cannot contain a null value because the r... 7 Jul 2008 16:37

this site's email notification
I've been having the same problem for a long time and accidently just stumbled upon an answer. Although those links are to the right place, one needs to be logged on to the site in order for them to work. If you go to the Communities site first and log on then the link will open properly. I'm wondering if using... 7 Jul 2008 13:32