Search results for query: *

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

MajP, Thanks for your help, but I'm not sure how to code it - this function actually has a parameter that gets passed into it from the main function. How would I get the function to return a different value when it errors out to the main function? I tried adding code into the error handler with...

How would I get a main function to exit all successive functions if there is an error in one of them. I created an error handler on the main function, but I needed to create an additional error handler in one of the functions - because if there is an error in that specific function somewhere in...

Thank you PHV and MajP - I got it to work! I didn't realize that the problem was just the locals screen... Thanks again for your help.

This is the beginning of my code: Public Sub GetSkuSold(strQueryName As String) Dim strSQL Dim origStrSQL As Variant, begStrSQL, endStrSQL, x, ctStrClause Dim minDt, maxDt, intPos1 As Integer, intPos2 As Integer Dim ctCriteriaGrtr, ctCriteriaLess Dim db As Database Dim qd As DAO.QueryDef...

I'm trying to work with the sql property in a querydef but it seems like the sql keeps on getting truncated at around 250 characters- I know that the sql is somewhat lengthy, but I wanted to know if there was a way for the sql property to hold more than 250 characters? I am using the sql from...