Search results

Thanks Fizzio, I tried that and it does open my report but it shows all records and not the current form. this is code I put in strcriterion = "[workorder] = " & Me![WorkOrder] DoCmd.OpenReport "rptNewWorkOrder", acViewPreview, , strcriterion when I hover my mouse over the strcriterion in...

I'm Stumped!! How do I make the report only show the current record? I only want to send the current record as it is generated. Could you please help?

Thanks, Calvin But, I do need to send a "snapshot" of the form so that Director can see problem immediately. I found the code I needed to open Lotus Notes and send attachment...but, I cant figure how to only send a snapshot of current record... Can anyone help?

I am working with a database that Safety Director needs to track work orders. She only wants an email every time a new work order is generated. I already have acquired the vb code to open lotus notes and send attachment. My problem is that it sends the entire database...this is the line of...

Please HELP!!!! Could someone please point me in the right direction? I have no clue as to how to write the code for my sendobject to go to Lotus Notes. Thanks

Okay, I have gotten to the point that I need more help. This is my code for command button to submit the work order. Private Sub Command41_Click() DoCmd.SendObject acSendForm, "workorderentry", ".txt", "noreene_patrick@averydennison.com", , , "New Work Order", , False MsgBox "Another Work...

Thanks for your quick reply. I am going to work on this....but I may have some more questions as I build this....I love Access but I can really get confused on some things... Thanks, Noreene

Thanks, Travis. No, it doesnt have to be printed...it can be an email but printing it just seemed to be easier of an idea than email. So, could you at least give me a start on exactly what code? I would need? You said a boolean field, I am not exactly sure how to go about this. Just an...

I am setting up a new database for work orders. The thought process right now is: When a new work order is generated, then I would like for the new record (entered in a form) to print to the Safety Director's printer. This way she will be aware of all new work orders as they are entered. I...

It worked!!! Thanks so Much!!

I have a field on my form that is bound to a table. It allows me to type in spouse first name. That works great. But, when I exit the field, I want code to take the spouse first name I entered and add the last name which has already been entered previously on the form...(It just keeps from...

Thanks, Valerie I will try this. I have another project that has come up today, but as soon as I can, I will work on this one. Thanks again!!

I have a report that needs to query by date, but I need to use an input box when report opens to enter date and then I only need it to return dates using month and year. Such as: When report opens I want to put in the input box this date, 04/04, and it returns all employees whose license...

Thanks Casey. It does make sense and it is working correctly now. Thanks again!!!!

I have a main form with 2 unbound combo boxes. When I drug the icon for my subform over to the main form and tried to link the fields, it said: Can't build a link between unbound forms. I know there has to be a link between the forms but I cant figure exactly what I need to look for or...

Thanks Rich....I always appreciate your help.

I think the next event is On Dirty. Because if you have moved into the control then the autonumber generates then. Correct me someone, if I am wrong.

Okay, maybe I do need to adjust my thinking. The problem is that it doesnt look good with the black background. I have tried everything I know to make the black appear white to blend in with the datasheet row. Rich's idea sounds good, but I dont know how to do that. I am still a novice...

I have a main form that has a sub form. My sub form needs to show in datasheet view. But, the window of my form should show only 10 lines. But, if I have only one record in that form, it shows the rest of the window as black. I dont want it to do that. I want to have 10 blank lines in the...

I have a database that is on our network drive that I want other users to be able to view the database but not be able to make changes. As it is now, only one person can be in the database at one time, and since it is needed to be viewed by all supervisors, I need to be able to allow many users...