Recent content by dmbfan73

Thanks, I would have done that next but I figured it out. I have 2 lookup tables that feed dropdown lists, and in some records these fields were left blank. When I put data in them, the export worked fine. So now I made the dropdown fields mandatory.

I'm trying to export a report to Excel, but am getting the following error: "Contract Listing 2 can’t retrieve the value of this property. The property isn’t available from the view in which you’re running the macro or Visual Basic code, or Contract Listing 2 encountered an error while...

I have a problem that I've been trying to fix but can't figure out at all. I have a main switchboard form with six buttons that open six other forms. Each of these forms has a button that takes the user back to the main form. Everything usually works great, i.e. I can get the individual...

Thanks Casey, I didn't try that one, because I found one that works: DoCmd.RunCommand acCmdAppRestore

Sorry, I meant AutoExec, not AutoExed

I have an AutoExed macro that minimizes Access on startup so that my switchboard form stands alone. However, off of another form a user can select a report to print, but the report opens up in the access window, which is still minimized. Anyone know the VB code to maximize the access window...

Thanks pdx_man! I had thought about using an imput mask before, but when I was using the wizard I didn't realize you could make your own. Works great now! Thanks again!

In order to only display forms, I have hidden the access database by creating a shortcut and then setting the shortcut's property to minimize. All of my forms are popup and modal. However, I have one form that allows the user to select a report from a dropdown box and hit a button that...

Tried that too, and I still get the error even if I put in a valid format. Am I missing something obvious?

Thanks for the reply, but I tried that and it didn't work. I entered a number without dashes and I still get the error.

sambo, thanks so much, it worked exactly how I wanted!!!

I have some email fields set up in a form so that the user can click on an address and have it automatically open up outlook and fill in the "To:" field. Everything works fine, except if you decide not to sent the message and close outlook, I get the following visual basic error: Run-time...

I need some help with a validation rule. I have a field with ID numbers, and don't want users to be able to put dashes in the numbers. (I have my report set up to automatically put the dashes in the right places) I've tried using ="aaaaa", but of course this restricts the amount of...