Search results

You could try this, place an unbound checkbox in the forms header or footer, set its default value to False and in the OnClick event put the following code changing all in red to the correct Names... Private Sub YourUnboundCheckBox_Click() If Me.YourUnboundCheckBox = True Then...

Make sure that none of the buttons have a Hyperlink Address in the properties (even a space will cause the toolbar to appear) HTH IMO

Like this? HTH IMO

Place the report on a popup form, like you did here IMO

Maybe this link will help. IMO

Why not just password protect the button? IMO

Create an Unbound TextBox on your form and call it txtTimer, set its default value to 10. Copy and paste the code below changing "YourButton" to the Name of the button you want to disable. Private Sub Form_Open(Cancel As Integer) Me.txtTimer.SetFocus Me.TimerInterval = 1000...

You have no reference to "Microsoft DAO 3.6 Object Library". Open any form in design view, Goto View >> Code.....Tools >> References and select it from the list. HTH IMO

In the Form Open event, change... Me.AcrobatPath = "C:\" to the path and file name that you want to open automatically, ie... Me.AcrobatPath = "C:\Documents and Settings\temp\My Documents\YourFile.pdf" Goto Tools >> StartUp >> Display Page/Form and select the Form. HTH IMO

Open your form in design view, select a text box, goto Format >> Conditional Formatting. Select "Field Has Focus" from the drop down and pick the Back/Fore colour you would like. Open the form in normal view. HTH IMO

I think the maximum size is 55.873cm * 55.873cm, but I'm not 100% sure IMO

If you're using A2k or above, you can use conditional formatting to change the back/fore colours on a form IMO

Try setting "Auto Resize" in the forms properties to Yes IMO

There is no point in having two Check boxes (Yes and No) because the value of a single CheckBox is Yes or No (True or False). One will work fine. In the On Click event of the "Yes" Check box put.... Private Sub Yes_Click() If Me.Yes = True Then Me.TextBox2.Visible = True...

In design view, click the label thats attached to the text box and press delete. This will not affect the data. IMO

Here's a very quick example for you. IMO

Thanks for the reply. The listbox refreshes ok, it seems to be this bit of code that only wants to fire once... I've got no idea why!!! Anybody ever encountered this problem? Thanks IMO

I have a db which imports a sheet (Shipping Details) from Excel to a table. The user then selects a supplier code from a listbox for deletion and the following code runs a query (criteria based on the ListBox) to delete that supplier from the table, then transfers the table to a new sheet within...

Glad you got it working IMO

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41442&highlight=progress+meter Do a search here for progress bars, there are many examples. IMO