Recent content by scott51

Must have missed that - stupid me. Odd it wouldn't even let me type it in, just kept saying invalid code. Thank you both.

So why not use VBA code instead? Would if i knew the VBA code to accomplish this. By the way, there's a PrintOut action in Macros. But remember to select the object (using SelectObject) before printing. There is no PrintOut action in Macros in Access 2010. The where condition filters to...

Can't, it will give "invalid code". Figure if there is a code for this it would be VBA.

Have a macro set up in a form to print a filtered report where it shows a particular invoice. (Access 2010). where condition is [Invoicenumber]=[Forms]![Invoice form].[invoicenumber] then run menu command of PrintObject That works except when the customer has 2 or more models and then it...

I thought the list box was locking, but I was incorrect. But I found a way around it by writing an Undo into the code on the list box before update which works great!

After further testing, I can get it to lock the list box by putting code into the list box click or before update. However, if you click in the invoice field, you can change any fields "locked" with the code even though there is already data (invoice) in the field. Maybe I need to change the...

Thanks, that helps. It works for standard input fields, but not when selecting from a list box. Working on that now

Am looking to prevent users from overwriting select fields on a form once they are input to try to keep garbage from coming in. Would like Field 1 to be set so they get a message but can overwrite if need (prevent oops, typing in wrong field errors). Field 2 I would like set so they cannot...

Newbie here, wanted to say hi. Am learning Access as I go, and building / refining a database. From Georgia, USA, using Access 2010. Found this place looking for a specific code and got the answer (someone had already asked). Figured would go ahead & register. Apologize in advance if I ask...