Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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