Search results

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

Hi, I have a requirement where i need to use word 2007 to create reports by pulling data from access 2007 database. i would need to know how can i do this, and are there any examples or good book that i can refer ? Thanks for the help Joy

Perfect, Thanks Wayne.

Hi, I have a column in the form for questions, I would need to add a "?" (question mark) at the end of the sentence automatically, how can i do this in the form. any help will be appreciated Thanks Joy

Thanks, but will it work for insert too ? Thanks Joy

Hi, My table has the below columns code desc created createduser in the form, i have the below 2 fields code desc i have before insert event as Private Sub Form_BeforeInsert(Cancel As Integer) Me.Created = Now() Me.CreatedUser = fOSUserName() End Sub The problem is when i insert a new row...