Search results

I have a data entry form, corectly tab indexed etc changes colur where the focus is and everthing. there are three dropdowns which drop down on the onenter event and whose values depend on previous entries. Despite advice to the contrary Users insist on using the mouse to select values from...

I am trying to populate a combo box on a client side access form from a server side stored procedure on sql server. using ado Im am getting the record set accross and the debug.print prints out from 1 to 4 addresses but I cant seem to bind this record set to the combo box in my form...

i have a continuous sub form to which the user adds new records the validation rules & tab stops vary depending on the value in the first and sometimes the second field of the subform Problems arise when the user decides to edit a control in previous entry I am trying to prevent the user from...

I have a parent form with a sub form so to refresh the form I am doing this Private Sub Case_But_Click() DoCmd.Close acForm, "Caseworker", acSaveNo ' do stuff here updating record set DoCmd.OpenForm "Caseworker", acNormal End Sub fine so far except that when caseworker reopens i get the...

Unfortunatley the table names have improper names with spaces in them but i have no controll over that:( when i try to run this function in the immediate window I do not get the results I anticipate The Table [Time Recording] has three entries which match the criteria passed but im...

im a bit green with VBA This what im trying to do If MyVar NOT IN ( String1, String2, String3, etc) Then Test = True but no matter what i try I just get Compile error..expected this or expected that Can someone clue me as to how this should be coded

every time I create a new record it gets a sequential reference number Like this: Me![CaseNumber] = Nz(DMax("[TableCaseNumber]", "[Main]"), 0) + 1 (BTW this is not the primary Key) Whilst i imagine this is fine in most circumstances, the situation i'm in sequential numbers are causing...

i'm a bit confused with If's and end if, I am quite new to access and VBA so perhaps im missing the bleeding obvious I have discovered (i think) that If a condition is met and I only want to do one thing , i only need If/then but if I want to do more than one thing when a condition is met I...

I want to force the data input to be done in a specific order(the forms tab order) I suppose the simplest way would to prevent the mouse from interacting with form completely. and force the data in-putter to rely solely on the Keyboard. (a few googles revealed no clues as to how this might be...

I have Main table and one form with about a dozen fields I have field which is counter of records which 'opened' on a given date The openDate is a field in the form and in the table I originally got the function to work like this Private Sub InputBY_Exit(Cancel As Integer) Me![3DigitCode] =...

I have a simple table & form the table has a created date field (value is set by default when the record created) and Openeddate field (value is inputted as datetime) I have a Counter Field which I want to set as 3 digits so that the first record inputed which has a openeddate of say...