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, Thanks for your response. I went with If Weekday(Date())<>2 Then ... It works great :)

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

Perfect. Thank you!

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

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

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

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

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

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

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

Worked like a charm pmax9999. Thanks so much!

I'll give that a try. Thank you!

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

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]

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.