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!

Search results for query: *

  • Users: meagain
  • Content: Threads
  • Order by date
  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, 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
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. meagain

    Restricting Access to specific tables via Excel

    Hi, Is there a way to restrict Excel users from accessing a particular table(s) in a Pervasive sql database? Currently they can access all tables via Excel's Data - From Other Sources facility, even when they are unauthorized to view these tables' data via the ERP application which connects to...
  11. meagain

    Dlookup for multiple conditions

    Hi, A form's open event has run the following code successfully for years: Private Sub Form_Open(Cancel As Integer) If DLookup("Level", "USERS", "[USER ID] = '" & CurrentUser & "'") = 31 Then DoCmd.RunMacro "Blah Blah Filter" Else: DoCmd.RunMacro "Dog" End If End Sub However, we now need to...
  12. meagain

    Supress Action Failed on Cancel of Append Query Dialog Prompt

    Hi All, Is there anyway to instruct a MS Access (2002) application how to respond to a user pressing cancel from an Append Query criteria dialog prompt? The Append Query is executed from a macro. When the users press Cancel now, they receive an Action Failed window. Would prefer the Action...
  13. meagain

    TreeView Simplified Generic Code

    Hi MajP, The links in thread 702-1592037, are no longer valid, and I would greatly appreciate looking at the info/code contained within: http://www.4shared.com/file/233728794/34e5b70a/Generic_TreeView_v11_with_Add_.html http://www.4shared.com/file/236183722/27a298ee/TreeView_v12.html to see...
  14. meagain

    Relocating Backends - Need quick method to update the Front Ends

    Hi, I'm relocating several backends to new locations. As you know, the front ends will require their linked .mdb tables redirected to the new locations. The only thing that is changing is the drive letter. Does anyone have a solution/code which would replace the drive letter of all of these...
  15. meagain

    Remote Desktop 2012

    Hi, When setting up a remote desktop 2012 facility, should the Access front end be placed on the terminal server or can it be left on the main server? The current Citrix setup (for over 10 years) has been on the main server. Thank you, LP
  16. meagain

    Identifying lowercase characters in a field

    Hi, I need to search a field in a table and locate/identify any records containing lowercase characters. I will be making a table of these records. If you know how I can do that, I would greatly appreciate your help. Using Access 2002. Thanks, LP
  17. meagain

    Displaying a group total broken up on two lines

    Hi, I have a report which groups and lists the totals by category for the year. One of the categories needs to be listed on 2 lines as a 60% and 40% split of the category. It's been a while since I've done anything in Crystal, so I'm having a hard time wrapping my head around what to do...
  18. meagain

    DLookup Correct syntax for *5

    Hi, I have a form which runs the following code on opening: If DLookup("RUNS_LEFT", "SD_TRACKER", "[KEY] = 1") = 0 Then DoCmd.RunMacro "ABC" Else DoCmd.RunMacro "RESUME AFTERHOURS" End If I need to change this so it runs macro "ABC" whenever the number in the "Runs Left" field ends in 0 or...
  19. meagain

    Office 365 and SkyDrive

    Hi, Just wondering if anyone out there has set up and maintained an access backend on Skydrive? The users would have a local frontend, and link to the backend on Skydrive. We'd need to update the backend daily, and specific data frequently throughout the day. Being a Skydrive (and Office...
  20. meagain

    Error in formula running report on a Windows 7 workstation - Crystal X

    Hi, I have a report which runs fine on a Windows XP workstation, but errors out on a Windows 7 workstation. We're using Crystal X, and the error message is: Report Engine Error 000000515 - Blah blah blah Error in formula <ProdCodeNDesc>. 'stringvar array x :=...

Part and Inventory Search

Back
Top