Search results for query: *

Thanks for your response hvass. I will have a look at your suggestion monday and let you know how I go. Still trying to get my head around writing queries like this after years of development using the access query designer, slowly getting there:) Thanks Justin

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

Hi Skip, the code creates user accounts on a windows server machine and assigns the users to groups and sets a number of options like 'allow user to change password' and 'password never expires', these can be seen under 'computer management\users and groups'. There is also a option to set the...

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

thanks for the reply jrbarnett. After sh*t loads of googling, I managed to get it working with the following code: (might come in handy for someone in the future) Private Sub Command1_Click() Dim Container Dim ContainerName Dim User Dim NewUser Dim Group ContainerName = InputBox("Enter the...

I have managed to get working with the code I had (I was entering the wrong domain) found it by going into command prompt and running 'set'. My next issue is how can I assign the user go a group? and set their startup program?

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

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

Thanks for the replies, shortcut technique won't do it as the users may open it through explorer. I will have a look at your suggestion thanks KenReay. The issue I have is that it is a database that is used in a large organisation, it is currently split with a front end under each users folder...

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

Thanks JerryKlmns, that will do it!

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

JerryKlmns, Thankyou It works perfectly:) have a star

Thanks for the reply JerryKlmns. It appears to be exactly what I'm after, I will try your code later today or early tomorrow and let you know how I go (and give you a star of course:)) Thanks Justin

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

Sorry, the cells at the bottom contain formatting/merged cells. It would be much easier if I could just create a new row in the sheet at a specified point. So the sheet can grow according to how many records there are. Thanks Justin

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