Recent content by saraUSIT

I am trying to create an audit log - which will add a record to an audit table-whenever a record is added, deleted or changed. I am using an access form that is in datasheet view-and the user has the ability to delete the record just by selecting the row. (To the user it looks like he is...

Would you mind to send me the code that produces the results you dispalyed? Also, I'm not sure how to do the reset ERR to zero that you mentioned. Would you mind to expound on that idea as well? Thank you.

Would it work if the printer is a network printer? Also would I be able to check the printer dialog programmatically - as this application runs at night when no one is in the office and I would like it to skip that step if the printer was turned off or having problems instead of causing the...

Is there a way to check the printer's status- whether it is on or off by using the printer object? I am trying to print a report from access in VBA- but if the printer is off I don't want the code to hang (I can't do on error resume next because there is other code that I don't want it to resume...

Thanks MajP! I set the delay to 1 second and it actually worked! I wonder if the issue was that it was a calculated field and it still needed to do the calculation prior to the CF so it needed that small delay to process- I really appreciate your help! Thanks again, Sara

Is there any way to make the code pause and not go on to the next step until the form finished populating?

MajP, here is my code: Public Function runSheets() 'other lines of code' DoCmd.OpenForm "SupplierResults", acFormDS DoEvents msgResponse = MsgBox("Does the report look OK -Continue running program?", 4100) If msgResponse = 7 Then DoCmd.PrintOut acPrintAll...

The way I currently have it - is that this whole module is running from a separate macro. The form that displays the results is in DS format and the msgbox is just the next line of code in the module.

The user is running code that does multiple things - it's importing data and later on it will update a table with the imported data. After the module runs the imports - it opens the form which is meant to display to the user the counts of items that will get updated if he confirms "Yes" when the...

I am opening a form in a module that displays data that the user has to confirm is ok. Some of the fields in the form have conditional formatting that changes colors depending on the results. After the docmd.openform - there is more code and a msgbox that comes up that the user has to select...

I am opening a form in a module that displays data that the user has to confirm is ok. Some of the fields in the form have conditional formatting that changes colors depending on the results. After the docmd.openform - there is more code and a msgbox that comes up that the user has to select...

How do I code a form that it will show the user an empty new record when user opens form? I don't want them to have to click on the new record button to get to a new page. Thanks

I'm trying to run a query thru a module on a table that gets created in middle of the module, and there is no primary key or unique fields. I need to find the duplicate records, but since there is no unique identifier it makes it complicated - is there a way to query on an internal record row id...

I'm trying to get the image dimensions of images that are urls. I tried to use the loadPicture function but it seems that it will only work for local images. I found ways to do it with js and php but I really would like to do it in access - is there anyway to create an object for an image url...

Thanks MajP, I used the raise error function and it worked beautifully. Thanks for the help! I was just wondering about a line of the code you provided (I know it has nothing to do with my original question - but I always like to learn new things...) You put into the sample code the following...