I have a text field that contains "1.25" and want it to be a number field.  
It errors on Data Type mismatch when I try to put it in a numeric field.  Is
there any way to get text to be numeric so arithmetic can be done?  Thanks
for the help!

While using the docmd.openquery method in VBA, does Access pause execution
until the query is completed?  The reason I am asking is that I run 2 queries
with this method, the second is  based on a table created from the 1st query.
I keep getting the "Unexpected Error" where ...

Just started with Access 2003 and don't understand the Help layout very well
yet. I want to write a Sub in a VBA module which will fetch some records from
the current db but can't figure out how to  do it. Do I have to go back to
DAO syntax or can I use ADO? I see the CurrentDB ...

I need to simulate File->Get External Data->Import, to have user pick a file
for import.  How can I accomplish this in code?  I use Access 2002.  Thanks
in advance.
Ben

I'm having problem with the event procedure to add new values to a combo list
in a form. The form is tied to table (Data) and the combo list gets it's data
from another table (Diagnosis). Relationships are set between the two tables.
I've done the below and can't get it to work. ...

Hi, Access 2000 linking to SQL2000.
To update database structure I have a procedure that will add columns to a
table (pass-through query).
In sql, I can see the new columns. However, in Access the new fields are not

I have several queries that are run once each month with date fields that
have to be changed.  I have tried replacing the actual dates with functions
and formulas, but they all slow the queries down way too much to be of any
use.

I have a form that asks the user for filter information. When the user clicks
"OK" that form closes and another form opens showing the data with the filter
applied, and the user can update data, etc. on the second form. Sometimes
users search for items that do not exist. When ...

Looking for the best way to store a summed field value (e.g., =Sum([field1]))
to a table.  When I use a ReportFooter OnFormat event to store the value, it
sometimes tries to store the value multiple times.

i have got this error message catastrophic failure, i dont know hot to debbug
it or what is causing it.
When i execute the database in Microsoft access 2000 under a Windows 2000
there is no problem but when i execute the file in a Microsft access 2000 and

thank you all in this wonderful group.
a special thanks for introducing me to the wonderful world of regular
expressions
can anybody tell me how to use a simple wildcard in regex?

I have a list that has a variable field with numbers.  I want to use this
field and create records in a table equal to this number. ie... if the number
is 10, I want Access to create 10 records, containing the same information.  
Is there a way to do this?

I have an access db that has worked fine for years. Now, I've upgraded
(again) to XP & I'm getting a "Database or Object is Read-Only" message.  I
think it's an easy fix, but at my age, I can't remember what I did when I
went from Access97 to 2000, & Win98 to NT.  Thanks, -Bill.

First off, forgive the messy code, being a newbie, I know this is not tight.
My problem lies in the line:
"For Each varItem In strItemsSelectedList"
I get a data type mismatch error.  I think the problem has something to do

In my access module I call on Outlook and automatically send emails.
Basically my code reads as follows to set up the CC address:
Dim stEmailAddress As STring
Set objOutlookRecip = .Recipients.Add(stEmailAddress)