Search results

so anyone know how to solve my problem?

hi tks. below is the link http://www.sana.org.sg/chris/test6.mdb There are 3 form inside, check - the form to select the days name - to display out the days selected input - to manual select which user are free on which days.

Hi boblarson, how do u redesign the table? coz i think the problems lies on the query part...if i can get the query part right, my problem will be solve ^.^

anyone know how to solve my query? Tks ya.

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, but my one got foreign table. "jgroup" to link "members" & "vgroup" together.

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

tks everybody. i solve the problem myself. ^_^

Wat i trying to do is display the ppl who join cathoic aftercare. but the data is from other table which is link with a relationship with the maintable. Just the current table i can [forms]![frmMyForm]![lstMyList] but now the table is from another table. so how do i do abt tat? tks.

oh i got it!! but how to do u reference if the form is with a relationship? like i have 4 member and each member can join different club and each member can join different club. relation is like many to many sample pic below. tks.

can you show me a sample?

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

oh i get wat u mean...but the dot still can be referring to a value right?

wat do u mean another way?

i still dont understand..they seem to be the same.

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.

y do we need to run a query when we already state it to run on the button when click?

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

Hi Msef, i saw this codes inside the vba, wat does this one do? Private Sub Form_AfterInsert() DoCmd.SetWarnings False DoCmd.OpenQuery "append" DoCmd.SetWarnings True End Sub