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!

  • 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!

Recent content by meagain

  1. meagain

    Identifying Users in Access 2016

    Happy New Year! We're moving from 2002 format(on windows 7)to 2016 on windows 10. Converted without issue. Previously we had the users log in via the shortcut "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\applocn\appname.mdb" /wrkgrp "N:\appdir\system.mdw" (target =...
  2. meagain

    Automatic Option Setup

    Hi All, We need a way to automatically set up the MSAccess options for each workstation, so they are consistent. Options like trusted locations and Enable all macros are very important for the applications to run properly and IT finds it taxing to manually perform this per workstation. Office...
  3. meagain

    If Conditional Expression based on day of week

    Hi, Thanks for your response. I went with If Weekday(Date())<>2 Then ... It works great :)
  4. meagain

    If Conditional Expression based on day of week

    Hi, We're looking for an If conditional expression to enter in a macro, to run an action based on whether it is a weekday other than Monday. Thank you, Lori
  5. meagain

    Negative numbers to Bracketed text

    Perfect. Thank you!
  6. meagain

    Negative numbers to Bracketed text

    Hi, We need to convert numbers into a string, to include it in a comment, and when the number is a negative we want brackets around it vs a minus sign. Here's the current formula being used: "KE"+CStr([numberfield1])+"-"+[textfield1] So let's say the [numberfield1] = (2.00) and...
  7. meagain

    Updating a main form field from an unbound sub-form field

    Hi, I have a main form listing items with quantities, and a sub-form that lists the transactions that make up the quantities for the corresponding item. On the sub-form a user changes the quantity in a field, and this sets a value in another field to the difference between the original...
  8. meagain

    Passing data from a table thru to Dos

    Thank you Andy. I'll try them out over the next week or so.
  9. meagain

    Passing data from a table thru to Dos

    Hi Andy, No I wasn’t aware. Please do share. 😀 As indicated above, I’m looking to replace the ZZ9 portion of the new file name in the first green line above, with the up to 20 character Order# field data in the ClaimNumber table from an access database that will be open at the time. If I...
  10. meagain

    Passing data from a table thru to Dos

    Hi Andy, The specific dos command in the batch file would be: rename path\md.xlsx "%curdate%-md-ZZ9.xlsx" where ZZ9 would be the data from access table = ClaimNumber field = Order# The Order# is a 20 character text field. The batch file would be executed via the following Event Procedure...
  11. meagain

    Passing data from a table thru to Dos

    Hi, I want to rename an excel file to the contents of of a data field via batch file. Is it possible to pass the field data from access thru to dos during the rename? Thanks, Lori
  12. meagain

    Open form - Display Message Box when form is empty

    Hi All, We have a form based on a query. On opening the form, we'd like to display a message box "Nothing to Approve" instead of the form, when the form has nothing to display. How can we accomplish this? MS Access 2002 is in play, and the form's name is "F-Web_approval". Thank you for your...
  13. meagain

    DLookup with Multiple Criteria

    Thank you Andrzejek, it worked like a charm [smile]
  14. meagain

    DLookup with Multiple Criteria

    Hi, We have a button on a form that we want only certain user levels to see. Users are listed in a table which identifies their level. The majority of the user levels are allowed to see the button, however levels 4 and 7 should not. We're able to accomplish hiding the button from level 4...
  15. meagain

    Conditional and Right Trim formula

    Worked like a charm pmax9999. Thanks so much!

Part and Inventory Search

Back
Top