Search results for query: *

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

Flyover789, I'm getting the error "No read permission on Myssysobject" on the openrecordset line Thanks for the help Mike

Hi, Using Access 2000 I'm trying to display a list of tables in a remote access db either in a listbox or msgbox, without showing all the system tables. The reason for this is that new tables are added to the remote db and the macro in the first db needs the name of the most recent one to run...

Just bringing this post to the top. Thanks for any help

Hi, I'm trying to export a listbox to excel which is populated from a search screen, (Users select their criteria and the sql is built from that and then applied as the rowsource of the listbox) so I'm grabbing that same sql and applying it to a query which I am then exporting to excel and I'm...

Agates2, If you and your users have winzip 8 you can create a self extracting executable, in which you can specify where to extract it to. This can then be emailed or stored in a central location with a shortcut emailed to your users. Mike