Search results

No problem, you will need to register the .dll and then reference it in the Visual Basic tools menu.

I think the vbsendmail.dll project should work perfect for this; you can find the .dll here - http://www.freevbcode.com/showcode.asp?id=109 along with the source code. Once you have got it built to your needs you can just use a macro to call the module. You could have a table containing your...

Cheers vbaInet, its working a treat. Hiding the access taskbar button was something I ideally wanted to do so it’s worked out perfect. Thanks again for you help

Just created the new form and removed startup, unfortunately got the same result. I’ve attached (i think) a stripped down version with the elements you requested. Cheers again Paul

No luck; just got the error again. Just to check I’ve put it in the right place, this is how the code looks: Private Sub Form_Open(Cancel As Integer) On Error GoTo errorhandle Err.Clear Call fSetAccessWindow(SW_HIDE) exit_errorhandle: Exit Sub errorhandle: Call...

Ok so error handling is now working correctly thanks (I understand much better now J and link worked fine). For some reason I still can’t get the SW_HIDE to function correctly though, just keep getting the same message. Could it be that the form_open sub does not have the form in the correct...

I’ve got the error handle in as recommended and coded as below: Private Sub Form_Open(Cancel As Integer) On Error GoTo errorhandle Call fSetAccessWindow(SW_HIDE) errorhandle: Call fSetAccessWindow(SW_SHOWNORMAL) End Sub I’ve also got the form set to popup “yes” and set the form to open...

Thanks again vbaInet – I’ve managed to get the SW_SHOWMINIMIZED to work ok, however when I pass SW_HIDE I keep getting the msgbox “cannot hide access unless a form is on screen” which from what I can gather in the code is what is supposed to happen: nCmdShow will not = 0 therefore the message...

Thanks vbaInet – however I’m still having a problem trying to call the code. So far I have pasted the code into a new module then added the following to the form open event: Private Sub Form_Open(Cancel As Integer) Call fSetAccessWindow End Sub I keep getting “compile error: argument not...

I’m using 2003. I’ve set start-up to open from form which has prevented the Access dialogue box containing tables/queries/modules etc opening, however I don’t want the actual windows MS Access screen to open either. Hope that makes sense?

Does anyone know of it is possible to have a database display a form when opened without the main MS Access display in the background?

Thanks David, worked a treat! Much appreciated Paul

OK, I’m new here and relatively new to access……… I have a form containing a sub form. The sub form is a data entry form which contains 6 fields. I have created a command button to add the fields to the table on click. So far this works ok, however here’s where my problem begins. I want an...