Search results

Welcome to the forum! Please post an example with the form and query.Then we can help you. Thanks Andy

Try something like this: If IsNull(me.fieldname) Then me.fieldname.visible = false Else me.fieldname.visible = true End If Andy

See my sample db in the sample db forum http://www.access-programmers.co.uk/forums/showthread.php?t=62414 Hope this helps the situation. Andy

Have you used Keith's suggestion by changing the private sub to public? Andy

Sorry not to good with reports myself. Try posting a thread in the reports forum or do a search. Glad you got your original post sorted. Andy

Sorry, won't work on switchboard. I have just tried it but it does work on forms. Apologies don't use switchboards in any of my db's Andy

I think there have been examples posted, try do a search for logout users. I suppose you could put the following code on the timer event of a form and set the timer to 1000 If time = "21:30:00" Then '21:30:00 would be the time you want to shut down docmd.quit End if This should shut the db...

Make Sure your Switchboard as the focus when f1 is pressed. It should work and for info it does overwrite access help when pressed. Well it works for me. See zip Andy

I do the following : Put the below code on the keydown event of the form: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyF1 KeyCode = 0 docmd.openform "yourformname1" Case vbKeyF2 KeyCode = 0 docmd.openform...

What code are you running in the private sub? The only reason I ask is because if I have read you post you wanted to add a new order, the code I supplied should do the trick. Also you wouldn't want to open the form2 on it's own so transfer the code to the form Load event. Because if you...

In VBA using the following code to open the form which adds a blank record upon loading of the form. DoCmd.OpenForm "Form2", , , , acFormAdd Andy

is this ok?

goto Tools>Options Then select the General Tab and there is an entry that says 'Recently used file list' set this to the number of files you want to see on startup. Hope this helps Andy

Hi, Try this http://www.access-programmers.co.uk/forums/showthread.php?t=62414 It might help you but it does include a little bit of code. The example using the commondialog control to show the windows open dialog box but you can customise it to show files in a specific directory. Hope this...

Hi, The reason you are getting the error message is because of the relationships set up (RI). The SHip to address needs to be completed before you can enter any comments in the Emergency form. You could just add code to wherever you are going to trigger the emergency form to lookup up if the...

can you post a db with no data in? So we can take a look. Andy

Both apply to the situation. Well it works for me anyway. Andy

I know you want to create a macro but if you use code then the checkbox question would be : me.checkboxname = true docmd.openform "yourformname" As Far as the email question do a search of the forum for 'outlook' and I am sure you will find loads of posts on this. I think in both scenarios...

Create a new database and import all of your objects into the new db. Use File > Get External Data > Import Have you tried compact and repair? Andy

Try this instead: Private Sub Command5_Click() DoCmd.Close acform,"yourformnamegoeshere",acsaveyes End Sub Let me know how you get on. Andy