insert into statement problem please help (1 Viewer)

[Rumesh Nilanka]

i've been working with mcaccess for a short time i would i like you guyz to help me i have a problem with my database in a button "salesform" called "Sell" .. i want it to add record to the sales table when i click it thank you !!
if smeone could solve this please repost the working one and tell me the mistake i've done .. ..thank you

 

[pr2-eugin]

Hello Rumesh Nilanka, Welcome to AWF

Before getting into viewing your DB, explain to us what is the set up. Why have you chosen to use Unbound forms? Access was designed around bound forms.

 

[Rumesh Nilanka]

Im doing a project in the school and making the database about a CD shop and i have a Sales form where i have listbox and i want to get data from this list box and feed them into the texxt boxes in the form and i have use insert into function to save it manually since the coloums have recordsource as the coloums in the list box ..please help its an urgent

 

[pr2-eugin]

Since it is a school assignment, I am going to give you some links to read upon !

http://msdn.microsoft.com/en-us/library/office/ff834799.aspx
http://msdn.microsoft.com/en-us/library/office/ff845201.aspx
http://forums.whirlpool.net.au/archive/472951 (Deals with Forms and INSERT)

Good Luck !

 

[Rumesh Nilanka]

Thanks alot it really Helped me