Search results

yeah tats wat i want!!!! but is it possible to add a delete after appending to the query?

actually wat i want to do is very simple. i have two table, i need to duplicate one record from one table to another table. tats all. due to the fact tat it have 30-40 field i try to avoide using mysql to avoid mistakes. so is there any easy wat?

doesn't work it prompt me a box to fill in a number. but still cannot get the current record number or id number

actually i have 2 table. my main purpose is to duplicated field1 from table1 to table2 n deleted field1 after i duplicated. i do it on a form so i need to know how to set query for criteria to select the current record on the form. but i dun know wats the criteria. i not going to use sql as...

hi all, i create a form which have a button to append the current entry to another table but i only want to append the current entry tat is open. So how do u set the query to append one entry(the current open entry on the form) using the criteria. i notice the query only have sum, aver, +-...

oh i c thks. as i new to access..

hi all, i create a form which have a button to append the current entry to another table but i only want to append the current entry tat is open. So how do u set the query to append one entry(the current open entry on the form) using the criteria. i notice the query only have sum, aver, +-...

Hi all for query criteria. I have a field which is Yes/No. i set criteria 0, it will select those with No value or those which is not check. but if i set criteria to 1, nothing will be selected. how come? tks for reading.

hi all is it possible to run both query at a time on a form? example i click the button, first query run then goes to second query

Hi i new to access and i hope somebody here can guide me how to create this using VBA. i have a table which have employee records. I need to create a form tat when i click the button, it will move the record to another table and also remove the record from the current table. any idea? Tks for...