Search results

They are accdb files. Is it just a matter of changing the file extension?

Well...I don't know what that is... This is the first time I'm distributing my work.

Please jump in! (y)This is the route I would prefer to go. I have tried the following alternate sequence (this one does not use an autoexec), but even the form's on load event isn't working without content enabled. The most important being hiding the toolbar. But when I open it when content...

Sorry I have been on vacation, but now back to business :cry:... I'm still having trouble with this one. I don't know how to create an "if" scenario that recognizes when content is not enabled. If you could set me in the right direction, that would be great. Thanks!

There's a lot we can't do. We don't even have administrator access in our computers. This is a local government office, and all of our IT services are handled by another division.

Finally got this, and it's error number 3044... So I was able to address the issue of not being connected to vpn, and the appropriate message box. The other error happening when content is not enabled I can't test until I'm back in the office. I think I probably made this remote computer a...

I actually do already have the unbound form. It is frmOpen. Its a blank blue form so that the screen is aesthetically pleasing :) upon opening. The login screen just popup opens on top of that, and when it closes and the other form opens, it closes frmOpen. So I'm thinking then instead of the...

Interesting...by this do you mean not pop up the login form, and instead have a login link that will pop up the login form..? I'm going to try tinkering with that immediate window. The first time someone downloads and opens the Front end file, I'm getting this and its not handling it based on...

I know this is an old thread, but I have the same issue with reaching capacity for the back end. (Please tell me if your preference is that I create a new thread as some forums frown on bringing up same issues that have been discussed before.) The files being stored in mine are Contract pdfs and...

Thank you! This works!

Can I simply reuse my login form to switch users. My question is basically, if I assign a Temp Vars, does it replace any existing Temp vars, or is there another bit of code I'll need to use to clear the old Temp Vars first? Here is the code for my login form: Private Sub btnLogin_Click()...

Tried as a module and it works; however, it is not recognizing the "Case 2950" because it is popping up the "Else" message. Here's the fn code (below are some screenshots): Function fnAutoExec() On Error GoTo AutoExec_Err DoCmd.OpenForm "frmLogin", acNormal, "", "", , acNormal Cleanup...

OK, and then what about naming the module? I vaguely remember something about module and function not being the same name...

I have an AutoExec macro that opens my login form. But I want to add some error handling because I forgot to log into our VPN this morning, and I got error 2950. So I want to have a message box deploy for that error. I used the convert feature, and it created it as a Function in a module. So...

Thank you. This works!

I have the following error handling added to a button, but I want to add another handling for another type of error. This one in particular is if the user fails to select a report from the list box prior to clicking the "Email Report" button. Private Sub btnEmailReport_Click() On Error GoTo...

It has to be a disk? Can't be an internet file location?

Is this possible? I have .pdf files in the attachment fields of records. Is it possible to send those in an email? I can't seem to find a way to do this using SendObject. Thank you,

Thank you! This worked! (Just checking to see if everything works the same now)

The database is saved here locally on my c: drive. What other work is there to do with the import? Relationships? Anything else? Thank you,