Search results

Thanks everyone for your help. Simply used the below code. me.lstbox.ListIndex = desiredrow I knew it would be simple in the end. Thanks again. JC

Tried both suggestions with no luck. For your information the Multi Select List Box is unbound and I use the results to update a separate table. Any other ideas?

I have tried adding the start command to the beginning of the line but now it does not seem to be reading the Workgroup file for security. Any ideas?

Hi I want to use a batch file to start the DB. This will check if the Front End is on the users machine and if not copy it over. It will then check what version of Access they are running and use the appropriate shortcut to open the Database. This all works fine except that the Batch File...

Hi I have a list box setup with all the dates from 01/10/05 to 31/12/08. I want to always start the list box at the current date while still allow the functionality to backdate if required. I have used the undernoted code to set the row correctly but I cannot figure how to get the box to...

You were right I had to use the column option to bring back the correct data. Works a charm now. Me.List0.Column(1, var) Thanks for your help. JC

Hi I am creating an input form to assign an engineer to a project for x days. The form consists of two Text Boxes for the Engineer Code and Project Name. I also have a Multi Select List Box which is linked to a table. The Table contains two fields ID-Autonumber and Date-ShortDate. This...

You can just change the rounding to 1 like so This would mean as in all rounding it rounds to the nearest 10th. Up or down. Is this ok? JC

Try the Expression in a query. JC

Sorry worked out. Never knew about the Column Heading Property. Thanks anyway.

Just found out about the Column Heading Property which solved this for me. Thanks anyway. JC

Thats great. I never knew about the fixed column headings. Solves one problem for me. Is there a way to also fix the row headings? JC

Hi folk I hope someone can come up with a suggestion for this one. I have a Crosstab query in my database which looks for the age of accounts on each status. The query itself runs fine but the problem is if there are no accounts on that status. For instance if there are no accounts on an...

Hi I was wondering whether there was any resolution to this since I am encountering a similar problem in that I have an Excel query based on my Access Crosstab Query. The Excel query works fine if every account status is represented but if there are any missing then I get the Microsoft Jet...

Hi I have the Crystal Report Viewer control setup in an Access Form to display and refresh a Crystal Report. This works fine if you have crystal on your machine but can this be refreshed by other users through the viewer and if so what files do they need on their machine. Any suggestions...

Figured it out. Just add the code Simple when you manage it. JC

Hi From looking at various posts here and elsewhere I have managed to create a form containing the Crystal Report Viewer Control 9.0 Active X and a command button with the undernoted code. This allows me to open the report in the viewer with no problems. But if I try to refresh the data then...

Hi I have started encountering a problem whereby I get the following error message when the Audit Trail tries to run, I have looked at Google and have noticed that other people seemed to encounter this error when there Memo fields went above a certain size. My largest memo field appears to...

Hi all. I have a small bug here which I can't seem to find a way round. I have a subform setup to show Engineers assigned to a call. In the subform header I have a Command to add new Engineers. When this is pressed the form is changed to a Data Entry form to allow additions. This all works...

Thanks Rural Guy. Thats a lot simpler and I have learned something knew. All in all a great response. Thanks much.