Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bansi
Starting Member
5 Posts |
 Posted - 2006-03-25 : 20:49:09
|
| hi... ive been told that by directly using SQL statements, i can essentially overlook the relationships defined in an MS Access 2002 db.. firstly is this true / feasible / possible?if yes, then if someone could help me with this pretty basic prob it would be much appreciated. how would i go about assigning SQL statements to controls i have in a MS Access form? i think im looking for INSERT statements, but if someone could point me in the right direction as how to exactly use such procedures? i have nothing more complicated yet, just the syntax to write data from control fields in a form, into tables that have already been created (tables are also MS Access)thanks |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-03-26 : 02:34:00
|
| Welcome to SQLTeam, looks like you have your question duplicated herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63731 |
 |
|
|
bansi
Starting Member
5 Posts |
Posted - 2006-03-26 : 06:10:50
|
quote:
Originally posted by afrika
Welcome to SQLTeam, looks like you have your question duplicated herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63731
apologies - i wasnt sure if this post belonged in the Access or SQL Syntax forums..if somebody could help me out with this, heres what ive found and where im confused :INSERT INTO tblShipping (ShippingEx)VALUES tblShipping is one table. The ShippingEx is a column (fields) in the table. Now, i dont want to manually insert values - i want to bind this SQL statement to a form control that takes the details entered by the user and inserts that. can someone help me out with how to complete this statement pls? how do i essentially say "INSERT INTO tblShipping (ShippingEx)VALUES (as entered by the user in the form)" ?should i first run a query, then edit it in SQL view?thanks |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-26 : 06:56:59
|
| I am not sure, about these since i worked on MS-Acess form around 3 years back.. but in every controls as property called data, where you can specify the default value or control value.. and it automatically links with the table field.. you can do some R & D with that .. hope its work for you..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
bansi
Starting Member
5 Posts |
Posted - 2006-03-26 : 08:09:33
|
| does anyone know how i can get this done.. ? im pretty worried cos i cant even get my forms to write to my tables! would anyone have any prior examples of the code i could use to perform this simple data entry process? |
|
|
|
|
|
|
|
|
syntax for writing to Access tables