Search results

Public strDefault As String This is declared in a standalone Module that you create in the db window. Go to MODULES, then NEW. Type in the above, then save the module with a descriptive name. Now the variable strDefault will be available to all the forms in your program. The only thing left...

Glad I could help.

I think if he wants to do a "lite" version of secure for casual users (not programmers) - he can set the startup options to not allow: Display of the database window Full menus Default shortcuts Built in toolbars/Menu changes Access special keys Then he can keep an "unsecured" version for his...

I added an unbound textbox to the footer called txtTotalCost - did the calculations there (then referenced it in the main form) Very important - Remember to do all of your calculations in the subform, then just call the name of the unbound box in the subform (from the main form) and it will...

Problem one: Remove the "txt" from the fieldname in the = code in the footer of the subform. You are trying to sum the name of the textbox and not the value. I'll look at it some more later, but this should point you in the right direction. BTW, that's a very nice looking form. :)

In order to help, I need an actual stripped down version of the db. Just remove any proprietary/personal information (if any), throw in some "fake" data and then we'll have a look. I need to be able to see where you put the fields in the form and subform, what you named them, and how they...

WHERE (Date Expired-1)=Date() Will match the date one day before it is due to expire when using a query.

Hmmm. I use this method to do exactly what you are requesting - pull data from a subform to a main form. Can you put a stripped down version of your db here so we can have a look? Obviously something else is going on that we're not aware of - and we want to help.

Change it to the below and it should work. =frmStockSubform2.form!txtMaxUnitCost * I need to add that the reason it didn't work before is that you have to reference the subform control so the form knows where the data is coming from. That's why you add the ".form" in the code.

Well, sometimes to fix it, it must be reprogrammed. For example, I had an issue with a field in a form that everyone was accessing and changing. This caused a lot of confusion for others - so, I had to go back in and lock that field. I don't use activeX controls for the same reasons that...

There shouldn't be a request for data until you click the command button and run the query for the subform. That is, if you based the record source on a table and not a query. Otherwise ... Do as rainman89 said:

Same here. I downloaded the db, but don't have a clue what it is he wants calculated.

Good, glad you got that working.

If the combobox is set to order the "record numbers" ascending (and that's what is showing in the combo) - then when you open (click on the down arrow) of the combobox and enter a number in the blank field - it should already do what you want. If something else is in the combox (not numbers)...

Sounds good to me * and now back to our regularly scheduled programming :)

Precisely, Melanie. I beat my head against the wall on this problem myself. I just checked in or I would have been happy to share that info with you - (and show you the secret handshake that goes with it.) :)

Just goes to show that you never know who might be reading a thread. :)Again, thanks for the code.

Good, I'm glad you worked it out. :)

Thanks for the clarification, Dave - I'm also one of those "programming oldtimers" - but relatively new to Access and VBA.

If you are pulling the date from a form, you can use the code below for the query. (YourDateFieldFromTable Between Forms!YourFormName!YourControlName1 And Forms!YourFormName!ControlName2) Control 1 and 2 on the form will be unbound textboxes (name them something like txtBeginDate and...