Recent content by stevievee

Hi, I have the network name of a user, but would like to know the domain they are on. Is this possible? Or...can I assume that if I can retrieve the user name that they are on the same domain? Thanks in advance.:rolleyes: :rolleyes:

Thanks :D

Hi, I am experiencing problems with a small app I have written which is an Excel form and an Access database. I think I need to distribute the ActiveX components I have used to these users, in particular the Tree View. Is there a way to do this? I realise I need to distribute the files and...

Hi, I have tried to secure my database, using simple, one level security. When I try to open the database via an Excel form, in a Jet workspace, it says that system32.mdw is not present, which is correct. The main problem is that this database will be accessed by many people, all via my Excel...

Thanks, Mile-o-Phile, I have just been experimenting and worked out how to do it. I had confused the functionality behind the "multi" option, thinking it was like extended, but with the SHIFT key. Thanks for the help.

Changing the list to simple only allows one item to be selected, I want as many items as required to be selected. The Check boxes become radio buttons to force this.

Is there a better way to allow a user to select multiple options from a list box (or other control) without having to use the [CTRL] key? At the moment I have a listbox, multiselect is set to advanced, and the list style is set to include the check box. I would like the user to be able to...

I've got a little further with this. The code as it stands is not too bad. It does work as a popup, the msoBarPopup parameter takes care of this. The function it calls (popOpt in my case) must be in a separate module, not in the Form module. This stops the error 400 occuring. I'm now trying...

Doh! That'll teach me to post in a hurry :p

This is in the Form Initialise event... This is the code that reacts to the click of an option... PopOpt is triggered, but the message "400" appears before any code is executed.

...or in code left(text,1) = uCase(left(text,1))

But what value do I save? At the moment, each option runs a function called popupClick() In this function, I look at the commandbar properties to see what was pressed. However, as soon as the function is called, it brings up an error "400" with no explanation.

Hi, I have created a popup menu programatically, so that the user can take options in a tree view by right-clicking. My popup menu is created using the commandbar object type, and is called cmdPopUpMenu. How do I process the option taken? I have added options such as Edit, Delete etc., but I...

I would create a .bat file, write all the net send commands to this file, then use Shell to run the bat file.

I have worked it out, after reading Mile-O-Phile's post again. You use DAO.Database, as stated, but then you also need to use DAO.Recordset as well. A plain RecordSet object is obviously not compatible anymore. Dim db as DAO.Database Dim rs as DAO.RecordSet set db = CurrentDB set rs =...