Search results

If you make your date field a hidden textbox on your form it would make it easier to manipulate the date.

Your only recourse will probably be to size the form in design view to fill the whole screen and set Auto Resize = Yes, Auto Center = Yes, Border Style = Dialog or Thin & Remove the Minimize and Maximize buttons. Hope this helps.

Try adding your subform name. Like "*" & [Forms]![myForm]![YoursubfrmName]![Fltr1] Hope this helps.

DoCmd.Maximise will maximise all of your open forms. DoCmd.Restore will restore all of your open forms to their original size. Hope this helps.

I'm not 100% positive but I don't think there is a way to do what you describe. The only thing you can do with your footer is turn it on or off. Hope this helps.

You could put your report names in a value list of your combo box and then use just one command button to open your reports with the following code. Private Sub YourButtonName_Click() On Error GoTo Err_YourButtonName_Click Dim stDocName As String stDocName = """ &...

You could just use an input mask so that they cannot use special characters, only letters & numbers.

If there are no records in your table to show then your form will be completely blank. Hope this helps?

You will not have any control over printing the form itself, so a report will be the only way that you can regain any control over exactly what is printed. The Printout Method (VB) might work.

Try: If Me.status.Column(0) = "Washed" Then Me.searchali.Visible = True Else Me.Searchali.Visible = False End If Hope this helps?

If the line is broken as your example try SQL = "INSERT INTO tblContainers (Container) " & _ "VALUES ('" & [NewData] & "');" hope this helps?

Good idea ShaneMan. I have used that before on a zipcode lookup table.

In the On Change Event for the textbox for ID number use DLookup to populate the other relevant textboxes such as: Me.Yourtextbox = DLookup("[fieldToReturn]", "TableOrQueryname", "[IDnum] = " & Me.ID) Me.YourNexttextbox = DLookup("[fieldNextToReturn]", "TableOrQueryname", "[IDnum] = " & Me.ID)...

In the criteria of your part number field in your query use: Like "*" & [Enter Part Number] & "*"

The message indicates a variable not defined, but might need more info to narrow it down.

If form is already opened DoCmd.GoToRecord , , acNewRec

In the on Close Event of the Edit or Add form Set the focus to your viewing form and requery Forms![yourformname].SetFocus Forms![yourformname].Requery Hope this helps?

Try this Private Sub Check26__AfterUpdate() If Me.Check26 = -1 Then Me.Case_Detials.Enabled = True Me.Case_Detials.SetFocus Else Me.Case_Detials.Enabled = False End If End Sub

Not sure if this is what you need, but this will filter for records that match "name" Private Sub edit_Click() On Error Goto Err_edit_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Input Form" stLinkCriteria = "[name] = '" & Me.name & "'"...

Hold down the shift key while opening the database from the menu at the top choose Tools - Macros - Visual Basic Editor This will open up the Visual Basic code window. Then choose Tools - References From this pop-up you can check for missing references.