Recent content by gselliott

Is it possible to show a control tip style message box when you click on a certain row in a list box? So if I clicked on a particular row it would show me the control tip text which would be from one of my fields in that row?? Thanks.

Thanks for the reply All of our Databases are delivered via Citrix using Access 2000 Runtime, all of the security is setup in Windows 2k and Citrix so I don't think it is a permissions or security problem as we have been working fine with numerous databases for over 2 years now and nothing has...

What does the Admin File actually do? we are having a few problems where we get an error message saying Could not use 'Admin'; File already in use.. I was just wanting to know what this file is used for. Thanks gselliott

Thanks for the reply. I understand what you are saying about the permissions and these have not changed for the last 18 months at least and everything has been working fine since then so I can't see this being the problem. Any other ideas would be appreciated. Thanks again.

I am experiencing some problems with Access 2000 Databases, when a user tries to open up the Database they sometimes get a message saying the Admin File is Locked other times they can login as normal. This has just started happening to a number of our Databases and the only way we can seem to...

I am experiencing a few problems with References when I create a database running Access 2000 on a Win 2000 PC. The database will work fine on my PC but when it is run on another PC via Citrix using Access Runtime the Database will throw up runtime errors. When this happens I have to logon...

Is it possible to set the focus to the first row of a ListBox when the form opens? Thanks in advance.

I have found the following code on another site that does stop the Write Confilct error message appaearing initially but once I click Yes or No the Write Confilct message appears again. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 7787 Then If...

Is there anyway of stopping the Write Conflict message box appearing and automatically selecting 'Drop Changes' ? I am using a Multi User Helpdesk system and this message only rarely occurs when two users try to accept a job at exactly the same time. It would be useful if this message could be...

Thanks, works a treat!!!!! Much Appreciated!

I am wanting to be able to click on a record in a List Box and then display the relevent record info on a seperate form, is this possible?? Thanks in advance.

I am in the process of creating a new helpdesk database that will be used on a number of PC's eventually running via Citrix. The jobs will be entered into the system by one person and ideally everyone else will be able to select and accept the jobs from a list box as they come in. I have...

Thank you all for your help it now works a treat!

Nope sorry that still doesn't work any other ideas i've hit a brick wall now!

Thanks for that that would work but I need to keep the original value (Column 1) in the combo box and have the value from column 2 be placed in the new Text box hope this makes sense? Is there any way this can be done? Thanks again.