Recent content by johnzila

How use macro to open different forms Let's say i got a few buttons in 1 form...Each is use to open different forms.... Then how do i use 1 macro to solve it.. is macro able to detect wat button i click so as to open the correct form? :confused:

thx another question.... How to i delete the last record of a table from a FORM? like i just enter a new record... i just wana delete tat new record? The default wizard button dun cater to that... i need something like move to last record and delete? anyone know the codes? :confused:

Thx a million!!!! :eek: OH GOD man !!!! U save my live!!!! i was really few days with tat assignment.... THX A MILLION BRO!!!!

Hi can anyone help me...i am really desperate in help... I got this database... When i palce an Order...i specified my quantity... i just wana check my Stock table whether the quantity i specified is avaible... Pls take time to vet thorugh my database... I really need help.... ignore some...

ok...so u mean i dun do the continous form things? ok i got this prob i wana ask... i use a SQL to select some fields out from a table e.g item_number from Inventory table i put into a form e.g Item then i add another filed in the form e.g. quantity Thus i wan to save the item_number and...

:confused: i use a SQL to select some fields out from a table e.g item_number from Inventory table i put into a form e.g Item then i add another filed in the form e.g. quantity Thus i wan to save the item_number and quantity to a new table... How do i do it? Need i the code?

Thx... So how do i solve it?

i am sorry.i dun really get u. I use a Insert query to add the items on the screen to a table the prob is with tat unbound fields. Let's say i enter a 12 for the 1st record, the following record all will automatically change to 12... y is it so even if i nv enter for the other? :confused:

I got a prob with a continuous form There are 10 fields in the form... All are using an SQL statement to retrieve, except for 1 fields which i manual create to catach user entering of data. But whenever a data is input to the field, it automatically admend all the other records to the same...

thx...i get wat u mean... But the idea is tat when i click a record tat appear on the sub form(Data Sheet View) i wana click on a command button to delete. I would like my form to be more interactive to those beginners who use my Access Database... Therefore, is it possible to have codes in...

How do i delete a record selected in a form. Wat are the commands... Main form : Inventory Sub Form: Stock How do I create a button to delete the record i selected in Stock. Just delete tat record i selected will do Really urgent Thx :