Recent content by joyaccess1

Hi, need to know what data-type to choose (access 2007) if i need to store hours in the table ? Thanks Joy

Hi, I have a combo box in the subform, when i select the value in the combo box i need all other fields in the subform to be refresh with the data, i tried requery and refresh, both don't work, the data in the other fields in the subform doesn't get refresh. is there something that i am...

Hi, I have a continuous form datasheet, one of the field in the continuous form is a combo box, when i click on the combo box i need the list of values that are not already selected in the previous rows. for example : if the combo box initially has value "a", "b", "c" from a table, if i select...

Thanks, i had to set "Data Entry" to "yes" in the property sheet.

perfect, it worked, thanks for the excellent suggestion. have another problem, i am using tab2(subform2) to add records too, when i start typing i get the below errror "you can't assign a value to this object" any suggestions on why am i getting the above error ? (i am not locking any...

Hi, i have a requirement for a tab form, where tab1 will be a continuous form and tab2 will be the details for the row that is select from tab1, both tab1 and tab2 contain subforms, my question is, how do i pass the value(s) from tab1 to tab2 so that the corresponding details appear in tab2...

Thanks, got it.

Hi, In a form i need to disable the fields based on the value from the parent table, i am planning to write a event procedure to execute an select statement and then compare the value returned from the select statement to enable or disable fields in the form. I am unable to figure out how to...

Thanks, will not use the sub-form then, thanls for the help & inputs. Thanks Joy

yes, the form tabs are a subform, here is an example what i am doing tab 1: name age tab 2: name address other fields so when i enter the name and age in "tab1" and then click on "tab 2" i get the message that other fileds in the table are blank (as it is trying to insert the row), what i...

Hi, I have a situation where the fields of a table are in 2 tabs in a form, i need to know how can i pass the data entered in form tab1 to the form tab2. also, since the fields of a table are divided in 2 tabs in the form, when i enter data in tab1 and click on tab2 the form tries to insert...

thanks cyberlynx, it works like a charm.

Hi, In a form i have combo box for country and state, based on the country that is selected in the country combo box i need the states displayed in the state combo box for the corresponding country selected. how can i do this in the form ?, can i create a dynamic query in the state combo box ...

Hi Gary, I am little lost. How and where to "check the samples " ?, please provide me more details, i am new to this forum. Thanks Joy

what is super easy word method ?, and where can i check for samples ? Thanks Joy