Search results for query: *

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...

Thanks a lot Lonnie, That is exactly what I wanted to know. It worked out great. Matt

Hello, I have a "Service Order Entry" Form that I'm making for the warehouse here at work. On this form I have a tab control with 2 tabs. Each Tab page has a subform on it. The subforms are called "MemoItems" and "Tasks". The field on the form just before tab...

Hi Everybody! I just finished searching the FAQ but I couldn't find an answer to my question. I have a form called "Service Order Entry" which contains one subform entitled "MemoItems". After I enter the subform by using "Tab", I am not allowed to tab out of...

Thanks Terry, This worked out well. Mattmeat

Hello Everybody! This is Mattmeat. I have a form called "Memo" that has two fields. One field is the "Memo" and the other is Username. Upon pressing Enter in the "Memo" field, I need the "UserName" field to update the Environ UserName. So far, I have...