Recent content by Mikeauz

PHV. Gold, so simple

Hi, I have a problem where an address looks like "Art Road " and I'm trying to get rid of the blanks at the end without loosing the blank between the words. For Example "Art Road " becomes "Art Road" If I was just trying to trim blanks where a single word was involved I would...

Hey This isn't really my area but I use this connection string in Access Pass-through queries to informix using the 3.82 driver...

Crowley, Thanks for answering but not opening the queries or tables in design mode

Hi, (Access 2000) I'm using append queries, pulling from pass through queries to append data to access tables. These have worked for ages without change but now when I try to run the below code I get the error 'You can not carry out this action at the present time' on each of the .openquery...

Hi, Anyone have any idea if there's any shortcuts etc for displaying a combobox list without using the mouse. The combobox always showing it's list after change and stopping when it's lost focus would be even better. Thanks for the help Mike

OhioSteve, 1, All fields are Date Time,in the format dd/mm/yyyy 2, Nope, always same day Thanks for the help!

Hi, I'm trying to produce a report that shows a subreport with Sign-in/Sign out times and the difference between the previous sign-out time and the current sign-in time. For example: Difference Sign-in Sign-out 08:00 09:00 01:00 10:00 12:00 00:30...

vanleurth, I'm not sure what yout trying to do "A combobox that's a hyperlink" but if your trying to open webpages/addressed emails by selecting options in a combo box then the basic code is Application.followhyperlink "www.website.com" or application.followhyperlink "mailto:name@yahoo.com" on...

AccessUser22, I've used this method heaps and never had any corruption issues with it. I would say it's because you are simulating the user closing the db themselves rather than actually remotely booting them.

Hi, I'm retreiving external data from an Access 2000 db using excel 2000 and sometimes when I use the below code I get the error "Application defined error". Sheets("Data").Select Selection.QueryTable.Refresh BackgroundQuery:=False I can always fix it by manually going to the sheet and...

JonFer, I'll keep trying your suggestion, but haven't had much luck so far. I've changed what I'm trying to do slightly in that I'm now trying to get Month to Date Averages. For example: tblMaster Date(dd/mm/yy) Staff Adherence% 01/01/01 A 97 02/01/01 A...

JonFer, Thanks for the help but I'm not sure on how to test using the select distinct function, I'm using Access 2000 if that helps.

Everyone, Worked out a solution to this, a listbox with the following rowsource: "SELECT * FROM msysobjects IN "C:\Remotedb.mdb