Search results

hi all i have a problem with access checkbox. Data is name & 5 checkbox which is mon, tue, wed, thu, fri User will access a form which have 5 checkbox mon, tue, wed, thu, fri.. The user will check the box & press enter, the input will pass on to a form to display out the name which have the...

Hi all i not very gd in access syntax, hope someone here can guide me. if i have a table name "fruit", inside have two field "fruitName" & "fruitColor" if i have a form and there is one textbox inside. wats is the code be to display the "fruitName" onto the texbox. i try...

hi all i have attach a db3.mdb(4.6mb) that i have been working on. On the top of the "volunteerform", there is drop down box name "jgroup.group" which show all the following groups. What i want to do is if i select which group, the form will automatic show the members belong to that group on the...

Hi all, how do u open a from with a set query to show those tat u wanna see.

Hi i have a drop down list which the data is taken from a table. i need to let user select from the drop down list and the list tat they chose will pass to a query to display out the data. so how do you go about to transfer the value to the query? tks.

[form].[form1].[id] [form]![form1]![id] wats the different? i thought in programming language ! = not. but in access it seem different.

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, 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...