Search results for query: *

This opens Google maps in internet explorer at an address location. You may need to determin the location of internet explorer Dim Street As String ' full or part address like 1600 Pennsylvania Ave NW, Washington, DC? Dim mev1 As String mev1 = "C:\Program Files\internet explorer\iexplore " &...

I think your problem is your variable is inside Quotation marks so the where statement is passing the string "varAreaCode" rather than the content of the string try "'" & varAreaCode & "'" instead

This is how I log users in an out of an Access based system. I have not written an add previously unseen user module but it should be possible but not necessary in my application. It takes the persons network login and uses it. Private Declare Function apiGetUserName Lib "advapi32.dll" Alias...

Thank-you, this solved the problem. Though I found that you needed to add ODBC; to the front of the connection string displayed in the MSysObjects table to get it to work. I would like to identify the base cause of the miss-save.

I am using MySQL as a backend to an Access 2003 frontend. I have recently had to update one of the tables to add several fields. Previously when linking to the backend tables the connect string has been stored in MSysObjects as...

I have used almost similar code but .AddAttachment "C:\CPASO.xls" rather than .Attachments.Add "C:\CPASO.xls", olByValue, 1

I have found that ExpressClickYes which is freeware found here http://www.contextmagic.com/express-clickyes/ kills most of the popup boxes when trying to email/access outlook. You have to allow it the first time through then it remembers the actions for you.

I found this code somewhere and modified it, I cant remember where it originated but it works. It creates an ics file which you then attach to an email and send. This can then be imported into outlook Dim DTSTART, dtEnd, strSubject, strLocation, strDesc, mymonth, myday, BuildVCalendar, dtstamp...

I use the following VBA to transfer results of multiple queries and tables to a prepared excel template for reporting. Dim wbk As Excel.Workbook Dim wks As Excel.Worksheet Dim MyTemplate As String 'template file as used to create mulitiple graphs Dim MYOutput As String...

It appears only to have occurred recently and the "Dead" area approximates to the locations of the posts.

System:- Laptop ASUS Notebook F3 Serise, Vista Home Premium Problem:- In a Limited area of the desktop neither hyper-links or buttons will function. Moving the window to a new area restores the function. Problem occurs with both touchpad and usb mouse I have updated the touchpad drivers to...

I have a strange problem. I am generating an ics file by code (VBA within Access 2000) and emailing it. It is sent by one of two methods depending on the location of the user (Some are on LAN others access via a Citrix server) 1. Via Outlook (LAN users) 2. Using CDO 1.21 (Citrix Users) When...

Have you tired under tools>options>advanced>Network>settings 1. Setting the proxy to auto detect or 2. Simply copy the IE settings into the manual settings for firefox

I have dealt with several of these machines, replaced ones from my work. Modern cables 80 conductor dont work on either primary or secondary ide. CD rom seems to only work on secondary ide with original cable which is 40 core with a single outlet not a standard dual outlet cable. The only time...

I think you will find it is to do with Outlook "Security". I know I had problems when I first changed to Outlook 2003 it marks most things as "un-secure" it was Access databases that drove me up the wall.

It may be worth looking at this http://www.majorgeeks.com/AutoPatcher_XP_Full_d4901.html

Dont Know if this is relevent. I was getting this and similar messages from my laptop "USB Device not Recognized. One of the USB devices attached to this computer has malfunctioned, and Windows does not recognize it." it would not connect any to any USB devices. The USB devices were working on...

Having been through the hassles of trying to get emails to behave across multiple environments I use these two modules. Module 1 – Using CDO Library You need to add CDO for windows 2000 library to the references Then you can use this code Sub emailfunction(FromAddress As String, ToAddress...

On Xp your Firefox Bookmarks are in a sub directory of your profile this is under >Documents and Settings> User Name> in a hidden tree Aplication Data> Mozilla> Firefox. You will need to show hidden files and folders in Windows Explorer to see. IE Favorites are under >Documents and Settings>...

Thanks everyone for your help.