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

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

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

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

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

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

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

Hi, Is it possible to generate a word document from access ?. If yes, then how can i do it ? Thanks for the help Joy

Hi, When i define a referential integrity between 2 tables, does the access database automatically create an index for the relationship ?. Thanks Joy

Hi, I need to capture the windows user name who modifies the data in the form/table, is there a function or command to capture it in access 2007 ? Thanks for the help Joy

Hi, I am writing ddl statement for creating tables in access, i would need to provide a default date for a date column, how can i do this in a ddl statement ? In the table design window in the gui, i can do it by providing the default as "=format(now())" but it seems not to work in the ddl...

Hi, If two developers are working on two seperate databases, is it possible to merge the work done in both database together, that i mean to say is, can we export the form/report/query from one database and import it in the other ? Thanks Joy

Hi, I have a column called "lastModifiedDate" in a table, i would need the form to automatically capture the date and time when any of the data elements are modified in the form, also i don't want the user to modify this column in the form, is this possible ?. if yes, then how can i achieve this...