Recent content by mleiser

Hi! I have a MS Access 2003 split database with user level security. I use a shortcut to open the database in order to facilitate logging (I'm not sure why it has to be this way). I want to use the following VB code to clone the frontend upon login, but I can't figure out how to get the script...

I managed to fix the problem. Something must of corrupted with the second sub form. I removed it from the main form and added it back, and now it works fine!

Here's some more information in case it will bring someone closer to a solution to my problem. My event procedure looks like this (a little different from my last post): Private Sub Form_Current() On Error GoTo Current_ErrorHandler If CurrentProject.AllForms("Catalog and Web Work...

Bob: Perhaps you can help me again. I'm applying this same technique to another Form (main form with datasheet subform and single view subform, and I'm trying to link the two by copying the VB code you sent me previously. Here's what I have, but it's getting stuck on me.ID: Private Sub...

Thanks a million!! Mutty Leiser

Hi again! Here's a mini-version of my database. I hope I attached it correctly.

Hi again! I created a master form called “Promotions” which contains two secondary forms, “Promotions Summary” which is a datasheet Form, and “Promotions Details” which is a single form. In which form to I set up the filter, in “Promotions Details”? I’m not sure I know where and how to do that...

Hi! Thank you very much replying! I'm sorry I forgot to include that information. I'm using 2003. Do I have to upgrade to do what I want?

My users find it hard to use my parameter queries because they have to enter exact spelling. If the field that has the parameter value is driven by a list or table, is there a way to provide a drop-down with the values for the user to choose from?

I need to create a form that has two parts, one part that shows a list of records as a datasheet, and a second part/subform that shows details about the record that is selected in the first part of the form. Any ideas?

Thanks for replying! I'm using 2003.

I have my main switchboard set to open by default, but it doesn't open. How do I fix this?