Search results

In the OnClose event of your second form.. Forms!frmYourMainForm.Refresh IMO

Create an Unbound text box on your report and enter this into the Control Source: =Left([YourField],InStr([YourField]," ")) Changing "YourField" to the name of the field in the table which contains the text IMO

In the AfterUpdate Event of your first Combo put code like.. Me.YourSecondCombo.Visible = true and in the AfterUpdate Event of the Second Combo.. Me.YourthirdCombo.Visible = true and so on. In the OnOpen event of the form have.. Me.YourSecondCombo.Visible = false Me.YourThirddCombo.Visible...

In the Forms properties set PopUp = Yes and in the Forms On Open event put this code DoCmd.Maximize IMO

Like this? IMO

Do you want your form to cover everything (taskbar etc.)? If so, see attached. To maximize the form to fill the Access window add the following code in the 'On Open' event of the form... Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub IMO

Do a search here on 'Audit trail', there have been many posts and examples on the subject. If you still have no luck, post back and I'll send an example. IMO

Not much fun :mad: If I come across something I'll let you know IMO

Maybe this Link could help. IMO

Private Sub YourButton_Click() If Me.OrderBy = "Column1" Then Me.OrderBy = "Column2" Me.YourButton.Caption = "Ordered by Column2" Me.YourButton.ForeColor = vbRed Me.OrderByOn = True Else Me.OrderBy = "Column1" Me.YourButton.Caption = "Ordered by Column1"...

Glad you got it working IMO

I see what you mean. Just another idea, What about saving it as a .PDF for your website? IMO

Create a Query containing the same fields as the table your form is based on adding the extra field within the query, then change the Record Source of the form to your new query. Now you can drag and drop from the field list. IMO

Is the conditional formatting still there if you don't use Word but just output to html? DoCmd.OutputTo acReport, "YourReport", "HTML(*.html)", "", True, ""

If it's not listed in the field list then it's not in the table or query that your form is based on, so you'll have to create an unbound textbox and make sure your tables are related correctly, or, add the field to the table or query that your form is based on. If you'd like to post a stripped...

In the listbox properties change 'Multi Select' to 'None' IMO

Is this form hidden? Goto Tools >> Options and on the view tab check the 'Hidden Objects' check box IMO

I thought you wanted to replicate before updating IMO

Maybe... DoCmd.RunCommand acCmdCreateReplica ? IMO

In the Double Click event of the textbox you want to zoom, put the following code... Private Sub YourTextBox_DblClick(Cancel As Integer) DoCmd.RunCommand acCmdZoomBox End Sub IMO