Hi I am new to access and was hoping someone could help me.
I am getting this message:
The INSERT INTO statement contains the following unknown field name: 'CELL''
Make sure you have typed the name correctly, and try the operation again.

I am abit confused between the 3 methods. I'm assuming CopyFromRecordset and
TransferSpreadsheet  are run from Access VB and Automation is run from Excel
VB?

Could somebody help me, please? I was asked to develop an application in
Access to check the forecast accuracy and then to create new forecast index.
The original table in Access has the fields: product code, forecast group,
warehouse, seasonal indexes for 13 periods.

I'm wondering what the code would be to change Field(4) or Field("ABC") to
Field(2)-- sliding the rest to the right + 1.
If there isn't a way, I'll have to create the 3 new fields, then
delete/remake the 10 following the 3 fields, which i'm not excited about =(

I have the script:
SELECT *
FROM MyTable
WHERE ID

I want to set up something where,
If a record has a string that contains a phone number,
it will deliminate everything else and leave just the phone number remaining.
A query that checked the entire field would be nice.

I'm getting error 1390 "Too many fields defined". I don't have 255 fields
(not even near that count..), but I found out that Access keeps record of all
the changes that I make to a table's fields and the error comes weather I
have the fields of not if I make enough changes.

I have been trying to import attributes into access from autocad throught VBA.
Can anyone lead me to the right directions on where I could find any
information on this procedure or if anyone has attemped to create a
connection between the two of them, will help a lot.

Hello ..
 Please Can Help me in my qu. :
How to append index key to field in access but this field that contain data
and the access apper message :

Anyone else had this problem?
I have to run a macro about 100000 times(through a module that loops), that
appends a query to a table(only 4 fields per entry) Works fine for about
34000 times then pops up with "OverFlow" error box.

I have a table that has 100 fields in it, named Field1, Field2, thru
Field100.  I wish to write a loop to work with each field as opposed to
writing the same logic 100 times.  Is there a way to do this?  I am not much
luck.  Here is a simple code snipet to just prove the logic ...

I would like to have the calculations I am performing on fields in a Pricing
table come from a calculations table (thus allowing me to extend the amount
of calculations I do on a pricing file by simply adding additional records in
the calculations table and not having to hard ...

I need to make a program which polls every so many seconds if there are new
messages in a table.
Anyone to gice me a hint?
Thanks

I have an access 2000 format mdb on a network share that four users update.
We are running a mixture of Office 2003 SBE, Office 2003 Professional. One
of the users who is running Off 2003 SBE has installed Access 2007
(standalone) to run the shared app.

Here is the code for a "backup" button
            Private Sub buall_Click()
                Call Shell("xcopy c:\dw\*.* H:\Dw\ /E /y")
                Call Shell("xcopy h:\photo library\*.* H:\photo library\ /E