Recent content by MattMeat

Herb, I sent you an email with the database included. Thanks, Matt

Hello again Herb, You were exactly right. The expected=expression error was solved but the other is still ocurring when I load the main form. The error is the one I posted above: Run-time error '2465' Application-defined or object-defined error. Here's how my code looks as of now: Private...

Herb, Thanks to your help, I feel like I'm really close to getting this done. I have done everything exactly as you said but I'm getting a error. It says: Run-time error '2465' Application-defined or object-defined error. Here is how the my code looks: Private Sub Form_Current()...

Herb, First of all, thanks for the persistent help. Secondly, I'm not quite sure what to insert for the last half of this code. What do I use in place of "form" and "recordset"? The part I'm talking about is bold. set forms!mainform!subform2.form.recordset =...

Hello, I was wondering if I could get help on this problem I've been trying to solve for a while. I'm making a Service Order Entry Form for our Warehouse to use. I have a form with 2 subforms on it. The first subform is in datsheet view and contains about 8 fields. The last field in this...

Hello everyone, I'll try to be as clear as possible. I have two subforms attached to a form. The first one contains many fields, one of which is called "notes". The second subform is just made up of one field by the same name ("notes"). The first subform only shows a...

Sean, Yeah. I tried that but no prompt comes up. The only time I see a prompt is when a change has been made in design view. Otherwise, the button closes and saves the form, even if "Prompt" is set in the macro's closeobject line. Do you know another way? Matt

Hello Everyone, I was wondering how I could get a Save Prompt ("Yes" or "No") to come up on a form when a command button ("Close") is pressed. The button is already attached to a Macro that brings a prompt up if there is a change in the design view of the form...

YvonneNina, Not only did you solve my Access problem, but your words gave me a great idea for a song I could write. I thank you very much. Mattmeat

jtmach, I considered this at first too, but the "On Enter" event happens when the field is entered, not when the enter key is pressed. I need the code to run when the "Enter" key is pressed. Does anyone know how I can assign this event to the "Enter" key...

Hello Everyone, I have two forms. The first is in datasheet view and has a column entitled WorkOrderNo. When you double click on one of the numbers in this column, the second form opens (form view) to the corresponding record. My question is: What code can I use to make the...

Thanks Lozere, I think I understand what you are saying but I haven't been able to print the Current Record. Whatever record the Form is showing when the command runs is the one I want to appear in the report. I tried Where_Clause=Current_Record but it was no good. I appreciate your help...

Hello! Hope everyone had a good weekend! My question is probably a simple one for most experienced Access users. I just need to know how I can print a specific report by pressing a command button of a form. I've already created the button, the only problem is that it prints all the records...

Thanks UncleJack, You were right. Mattmeat

Hello Everyone, This is probably an easy one but I don't know it. I have a Service Order Report that is linked to a Service Order Form. The Form has two subforms. Basically, I just need to link the subforms to the report. I tried the expression builder in the appropriate fields' control...