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

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

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

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

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