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. 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!
  16. meagain

    Conditional and Right Trim formula

    I'll give that a try. Thank you!
  17. meagain

    Conditional and Right Trim formula

    Hi, We're looking for 2 formulas. The first is a conditional one to determine whether the field named [venum] has 3 "_"s in it or not. The second formula is to trim everything to the right of the 3rd "_" including the "_", in the field [venum] For example, let's say [venum] contains...
  18. meagain

    Tracking users

    Hi, As Iameid mentioned, you can use the autoexec macro to run your Update Query on log in, and if you've already got a menu for the users, add an Exit button to it. The Exit button could run a macro containing the Update Query to indicate the user has left the app. As long as the users use...
  19. meagain

    Dlookup for multiple conditions

    Hi KJV1611, I did mark it as a Great Post 3 days ago, at the same time I commented that MajP's code worked like a charm [smile] That is why the pink star appears beside the thread in the forum list. [smile]
  20. meagain

    Restricting Access to specific tables via Excel

    Thanks for your response Mirtheil. Wouldn't the Database Security be for the whole database? I'm looking for a handful of tables to be unavailable via Excel. Thanks again.

Part and Inventory Search

Back
Top