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 strongm 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: juddymarch
  • Content: Threads
  • Order by date
  1. juddymarch

    Issue with update query in a stored procedure

    Hi, I'm new to MYSQL to please bear with me. I have a table called tblEquityDetailDaily: fldRecordID fldEquityDateID fldDate fldLiveShares 1 55 1/1/08 100 2 55 2/1/08 200 3 60 1/1/08 500 4...
  2. juddymarch

    Using vba to set user accounts -"start the following program at logon"

    Hi I had a previous thread to create users accounts and assign them to groups on Windows Server. I have managed to achieve almost everything bar setting up the "start the following program at logon" and "Program file name" option under the Environment tab, which is one of the most important...
  3. juddymarch

    Create a windows user account from access?

    Hi, I have computer running "windows server 2003 Standard edition." In order to create a new user account I go through the process of: Start/Control Panel/Administrative Tool/Computer Management then Under System Tools/Local Users and Groups/Users/Add new user. I need to be able to automate...
  4. juddymarch

    Issues with running action queries in a network environment.

    Hi, I have a form which contains code to run a large number of append and update queries on a number of tables as well as some dao code to alter data. This method works fine when testing on a single machine, but I have noticed that on our clients network it occasionally needs to be run twice...
  5. juddymarch

    Code to determine if another user has the database open

    Hi, done a few searches on google and on here but I can't find what I'm after. I'm just wondering if anyone knows if it is possible to determine if anyone else has the current database open. I want to quit out of the database if the user opens it but another user already has it open. Thanks Justin
  6. juddymarch

    Using Shell command to open exe file

    Hi, I have an access form that is used to open other access applications using the shell command. This is working fine but now my client would also like to be able to open one of their third party programs from this form as well. There is currently a desktop shortcut which is used to open...
  7. juddymarch

    Open another database from current database security issues

    Hi, I currently have a database (Which I didn't create) that contains a listbox of access database names and locations in which a user can select one and then click an open button to open that particular database. The file is opened by using the following code. Dim varDatabaseLocation As String...
  8. juddymarch

    Adding a new row into an excel spreadsheet from access

    Hi I have an access application that uses automation to pass out data from a query to an existing excel file. The code works fine and I can export the data into the template, however I would like to add a new row in the excel file every time a new record is added. I need to do this as I would...

Part and Inventory Search

Back
Top