Search results for query: *

Hello, I have a cmdButton to email a report. HOwever, I have the database secured with the users who would need to email the reports as "new data" and "update data" users. Apparently only users with full permissions can currently send the email becasue of the CreateObject command. The error...

Thank you for your help! I especially like being able to save it where I want it. It works great! Teresa

I have a report generated by a dynamic query. I want to save the report using two fields, [NvrNumber] and [JobNo]. For example. I would like a report to be named "NvrReport_24_3000" where "24" is the [NvrNumber] field and "3000" is the [JobNo]field on the form. For the next report it ,might...

Thank you very much! It works perfectly. Teresa

I have a main form: JobInput2, and a subform: PartNumbers. On this main form linked by a field named [JobNo]. I want to be able to check each PartNo record on the subform to see if the field [NveRequired] is checked true. If it is true, then I want the [NvrNo] generated on the main form to be...

Thank you for the help. It is working for me now with the format you suggested.

I have been struggling with the following problem. I have a table of forecasted parts (tblForecast), separate from my partnumber table (PartNumbers). When I add a partnumber to a form in my database, I want to be able to check to see if it is in the forecasted parts table automatically. If it...