Search results

Why not use a Combo box to change the code like if me.cboCalculation = LWD then 'calculate Length width depth' else 'calculate Depth Diameter' end if

You will probably need a parameter delete query like: [Enter Player to Delete] in the criteria under name field or tailor to your need. then on your button you could do some thing like this: Private Sub Command9_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "yourquery" End Sub

you could make the three text boxes invisible then wright code to make them visible again General use you could use key press lost focus etc.... Private Sub yourfield_AfterUpdate() Select Case Me.yourfield.Value Case 1 'make text 1 true and the other two false in case user changes field imput'...

The on load event should bring up a new record every time the form opens what is it doing when you close and open it back up? also go to design view right click on your combo boxes-properties-check the control source. Are you storing the value of the combo box in the field of the table if...

What i have is a program that runs through a telephone switch a records available numbers to a text file that looks something like this area code prefix last four 333 333 3333 444 444 4444 what i would like to do is just take the prefix and last four and put into a table...

I'm not sure why it would be writing over previous data unless you are doing it have you tried an on load or open event so that you don't change your own data. :confused: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub The only other thing i can think of is make sure your field...

I have a form that its only purpose is to look up names in a table what i want to do is have a button that opens another form and takes the name fields of the current open record and inserts the current time and date into other fields my thinking here is like an electronic sign in sheet what is...

I'm new at this so any help would be great what im trying to do is: I have a form where i want to update records to a table on this form i have a text box labeled fldclearance for the type of security clearances a person has this text box is controlled by a lookup table called clearancetbl in...