General

the database doesn't admit Activex control
Hi, Using Access2007 enterprise, I try to add the mscomm32.ocx control to an Access form but the app rejects this action showing a message like: "the database doesn't admit this Activex control" (i'm using other language) Before to install Access2007 enterprise, this Activex control worked fine and it has bee... 24 Mar 2010 10:01

Memo field suddenly lost half of entries
Hi, I have an access database which is used as a contact database for customers, in the main data table we enter in the last contact information. it was working fine until last week when all of a sudden over half the data dissappeared and it set itself as a 50 character length and deleted anything after this... 24 Mar 2010 17:02

How do I use a table to validate data being entered into another
I have a table called DATA ENTRY into which data is being entered in a CAMPAIGN field and 5 different UPC fields. The second table is called UPC and has a CAMPAIGN field and one UPC field. This table has multiple records with the same CAMPAIGN but each record has a unique UPC. Now - each entry in the DATA ... 23 Mar 2010 19:30

Chart Information
I'm using AC2003. I have a chart on a form. Sometimes the chart has no data and the chart displayed is blank, which I expect. My question is, is there a way to determine whether the chart has any information on it? I'd like to display a label that says something like "No Information Found". Thanks in adv... 23 Mar 2010 20:38

Return Null Values
Does anyone know how to correct the SQL below... I would like to say if the text in the form control is not equal to "*All" then give me the results from the form control. However, if the text in the form control is equal to "*All", then give me everything. SELECT Step5qry.[Customer Name], Step5qry.[Customer ... 29 Mar 2010 12:30

DLookup fails in Form's Text Box Control Source when using Windows
DLookup works fine in Form's Text Box Control Source when using Windows Vista and earlier, but fails when using Windows 7. ... 23 Mar 2010 18:21

cannot email from a word document
Previously thought It was all outgoing mail,but only the word docs, any help apprecaited. The connection to the server has failed. Account: 'pop.west.cox.net', Server: 'smtp.west.cox.net', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 10013, Error Number: 0x800CCC0E --- frmsrcurl: http://msgroups.net... 23 Mar 2010 13:40

Access 2007 to mimic spreadsheet
I have an existing spreadsheet I would like to mimic via Access. Group heading are: total System kwh, System Demand, ECA Within each group are the following columns headings: Month, 2006, 2007, etc... an example of the 1st two lines of the spreadsheet: Total System kwh Syst... 23 Mar 2010 13:40

cannot send or receive email using windows XP
The connection to the server has failed. Account: 'pop.west.cox.net', Server: 'smtp.west.cox.net', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 10013, Error Number: 0x800CCC0E --- frmsrcurl: http://msgroups.net/microsoft.public.access ... 23 Mar 2010 14:49

How to compact a database using macro or vba?
Request how to add Compact and Repair action to Macro. Trying to create Macro that deletes many old and large tables, then runs Compact and Repair, then imports new tables through ODBC. Currently: Step 1: Delete old tables. Step 2: Run the compact and repair from the tools menu Step 3: Import. Intent is to c... 23 Mar 2010 19:30