Search results

I have several data entry forms that I am adding before update checks to so that I can minimize mistaken data entry, this works well but I have a question about it: Assuming all of the entered data is accurate, I would like a final msgbox to ask the user if they are sure they want to save the...

bump! this is awesome

1. Create the two formatted phone number fields (with the input mask), set their Visible property to No. Name them whatever, for this example I called them home_tel and work_tel 2. Create a new field which would have a source that would look something like this: ="H. " & [home_tel]& "W. " &...

you have to put the same input mask in the report control...

1. Create a report based on the record on the form you are wanting to do this from. 2. Create a macro with the SendObject command in it(I would put a null condition in case someone removes the date on the form). Fill in the information at the bottom (to address, subject, message text, etc.) 3...

same exact process, just change the reference to Forms![FormName]![ControlName].[Locked] I use the Enabled because it gives the end user more of a visual cue that they can't do anything to the record... but either one will work pretty much to the same effect: you can't edit the control. :-)

has anyone done this? I have a table that tracks a set of codes for each user, users can 1+ codes each. I can pull the code list from a query, but is there a way to get that information (the query results) to display on a single line in a report like this: Code1 Code2 Code3 Code4 Code5 Code6...

the way I would do it is after the "requery" function, add an expression that sets the unbound text box control Enabled property to "no." Then all you have to do is make an edit button that performs the opposite function (sets the enabled property to yes). I dont' know the VB code, but it looks...

OK, 5 cigs later I realized this was futile, so I went a different route & I thought I'd share: I changed the form control to single form view, and added a subform to the footer... tinkered a little bit and now when you create your record and make your selections, it updates to the form on the...

ok, after four hours I got the first part of this to work... but now it's driving me nuts I have a form that has three combo boxes; the selection made by the user in box1 determines what is available in boxes 2 and 3. This works with no problem, I added the requery option so if they changed the...