473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

<<help>> with sql statements run from a macro

I am trying to copy the information from a form into a table. I have
tried running the sql code from a macro by using the command :

This works and writes the work 'test' into the field name 'name' in the
'temptable' table:

insert into temptable (name) values (test)

But I don't know the correct syntax for writing the field on the form
into the test table. I tried (with no luck) to use this code:

insert into temptable (name) values (forms!frmsupplier.name)

But this writes the word 'frmsupplier' into the field.

Any help would be appreciated.

Thanks
Chuck

Jul 6 '06 #1
2 1824
The problem exists cause you have a field or control named Name.
The form also has a property called Name, so your statement is ambiguous.

Rename the control to something like txtName, and change the query.

There are more than 1000 of these reserved words and problem names. Date,
Year, Month, Caption, Height, and so on. For an up to date list, download
the sample database from this link, and see tblBadWords:
http://allenbrowne.com/AppIssueChecker.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"WØCBF" <w0***@yahoo.comwrote in message
news:11**********************@a14g2000cwb.googlegr oups.com...
>I am trying to copy the information from a form into a table. I have
tried running the sql code from a macro by using the command :

This works and writes the work 'test' into the field name 'name' in the
'temptable' table:

insert into temptable (name) values (test)

But I don't know the correct syntax for writing the field on the form
into the test table. I tried (with no luck) to use this code:

insert into temptable (name) values (forms!frmsupplier.name)

But this writes the word 'frmsupplier' into the field.

Any help would be appreciated.

Thanks
Chuck

Jul 6 '06 #2
Thanks Allen,

I will stop slapping myself after this sinks in. You were right and it
was the "reserved name" syndrome. Also, thanks for the DB utility.

Thanks
Chuck

Allen Browne wrote:
The problem exists cause you have a field or control named Name.
The form also has a property called Name, so your statement is ambiguous.

Rename the control to something like txtName, and change the query.

There are more than 1000 of these reserved words and problem names. Date,
Year, Month, Caption, Height, and so on. For an up to date list, download
the sample database from this link, and see tblBadWords:
http://allenbrowne.com/AppIssueChecker.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"WØCBF" <w0***@yahoo.comwrote in message
news:11**********************@a14g2000cwb.googlegr oups.com...
I am trying to copy the information from a form into a table. I have
tried running the sql code from a macro by using the command :

This works and writes the work 'test' into the field name 'name' in the
'temptable' table:

insert into temptable (name) values (test)

But I don't know the correct syntax for writing the field on the form
into the test table. I tried (with no luck) to use this code:

insert into temptable (name) values (forms!frmsupplier.name)

But this writes the word 'frmsupplier' into the field.

Any help would be appreciated.

Thanks
Chuck
Jul 6 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

31
by: da Vinci | last post by:
OK, this has got to be a simple one and yet I cannot find the answer in my textbook. How can I get a simple pause after an output line, that simply waits for any key to be pressed to move on? ...
4
by: Chuck | last post by:
Hello, I have an Access XP database that has several fields. One of the fields is a text field and has an account number that is preceeded by a text character, like: F102354. Every account...
1
by: Chuck | last post by:
I have a query that uses the query with the critera set to . We I run the query the msgbox pops up asking for the name information to be entered, but on the top (blue background) of the message box...
2
by: Chuck | last post by:
I am trying to retrive one field from the "company info" table that contains several fields but I want the "company name" field. There is only one record in this table. When I entered the code...
1
by: Chuck | last post by:
I appreciate any help!!! I have an application that has 4 different forms that display the same information except for the fact that they are fed from 4 different parameter queries. The 4...
1
by: WØCBF | last post by:
I have an Access application that was written in ver 2002. I have distributed the application to our other offices using the Developers Toolkit and installed a runtime version of Access. At that...
3
by: WØCBF | last post by:
I know this code has worked before but now appears to get a compile error. The code it seems to choke on line 12. I receive the following message and it highlights the "rst!" statement. Error...
2
by: V e X y N | last post by:
OK, here's the deal, if anyone could help me with a link or two, I'd be delighted. I'm just learning C (I learned over the summer, so a few months), and I was wondering what (*free*) compilers are...
1
by: WØCBF | last post by:
Greetings, I have a form that is bound to a table that has about 15 fields in it and all of the fields are displayed on the main form. I have 4 fields that will be updated and I want to write...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.