Search results

The last thing I want to do for the DB I'm making is create a report that shows me the products, quantity of each product, and cost of materials I used through the whole year. I attached the query view with the tables I'm using. To calculate the year, I figured I could sort the aggregate query...

Worked perfectly! I'm forever in your debt for all your help pbaldy! A million thanks!

I wanted to send a copy of a report in pdf format to an email address and I thought the code would be: DoCmd.SendObject acSendReport, "WorkOrderFinalR", acFormatPDF, "email@email.com", , , "New Work Order TEST", , False And it works, except it sends me all of the reports, not just the one from...

Still gives me the #Error

I created an aggregate query to feed a report that I want of all products i use in a year and a total price for all products. I used a sum function of the line totals in a text box to display the total expenses for all products, but it keeps giving me an #Error message. I attached the pictures...

I actually solved this by removing that code from the before event altogether. Just fyi. Thanks for the help though.

No. The form is for users to submit what will more than likely be jpegs of issues, things that need to be fixed, for my repair people to get an idea of what they are looking for.

Good day all! In the DB I'm building, I have a field in a form bound to a table where I want users to be able to attach a picture; however I can't use an attachment because the user who submits the form may delete or move the picture. So I thought about using an OLE object that saves the...

See attached for a picture of the error.

Re: Prevent automatic ms access message when closing unsaved form Sorry about the confusion. I didn't mean to paste that. I went too far down on my notepad. The code stopped at the first End If. I tried copying and pasting your code and I'm still getting the same message when I try and exit...

I'm creating a work order db where users can submit work orders for different problems. I would like to create a button where they can attach a photo of the problem if need be that will be bound to that particular work order record in the work order table. I have no idea where to start. Any...

Prevent automatic ms access message when closing unsaved form Does anyone know how to prevent the ms access message "You can't save this record at this time. Microsoft Access may have encountered an error while trying to save a record. If you close this object now, the data changes you made...

Re: Prevent incomplete record saving And still haven't found a solution...

MS Access You can't save record at this time...still! Is it possible that the code belongs somewhere other than the before event?

And I tried plugging in that code and it gives me the compile error: expected: )

I'm absolutely positive. The code is in the before update of the form. And everytime there's a partial record and you try to close the form or the database the ms reminder pops up.

I still get the ms access message "you can't save this record at this time. blahblahblah. do you want to close anway."

I'm trying to prevent incomplete record saving so I entered this code in the before event of the form to prevent the record from saving if any of those fields are blank: If IsNull(Me.SectorCombo) Or IsNull(Me.StationCombo) Or IsNull(Me.BuildingCombo) Or IsNull(Me.Description) Or...

Re: Prevent incomplete record saving The form is bound to a database table and @ Pat, thanks for pointing out the AND, I chose to go with Or. Where do I put the function if not in the Before Event? And I'm still getting the warning telling me if I can't save the record at this time do i want...

I have a listbox with a doubleclick event that opens up a record. Then only way to delete that record is by opening it up from that listbox and then using the record delete function on the form. I don't want to create delete buttons so that if they decide to delete a record the deletion is...