Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. saraUSIT

    Create Audit Log when changes are made in form

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

    Check Printer object Status - if printer is on or off

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

    Check Printer object Status - if printer is on or off

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

    Check Printer object Status - if printer is on or off

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    Conditional Formatting in form waiting until end of code to display

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

    How to make form show user empty new record

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

    Is there an Internal Record Row Id in Access tables?

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

    Get Image URL dimensions using Access VBA

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

    Error Handling - With function running multiple functions

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

    Error Handling - With function running multiple functions

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

    Error Handling - With function running multiple functions

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

    Character limit in SQL propery of a QueryDef?

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

    Character limit in SQL propery of a QueryDef?

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

    Character limit in SQL propery of a 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...

Part and Inventory Search

Back
Top