Recent content by 48Highlander

I have upgraded to Win 10 and I have no e-mail client installed. How do I send e-mails using the Windows 10 mail app from MS Access? Everything I have found is based on sending mail through a desktop client or through web mail such as G-Mail. Win 10 mail does not appear to be an installed app...

I have the following code in a sub-routine: strSQL = "UPDATE tblMapping SET tblMapping.MapTo = 2" DoCmd.RunSQL strSQL Sometimes it works and sometimes it updates only some of the records. The field MapTo is a long integer and it is not indexed. The table tblMapping is not...

Using ACC 2003. I have an application being used by several clients and I need to password protect the back end mdb database. Currently using Access security with .mdw file and there is NO pwd on the back end. I have thought of two approaches: [ol 1] Based on a change in the build number, have...

The first line in the code snippet should turn on the hourglass. Right? Bill J

In my form I have a button that opens an HTML file and puts all of the HTML into a text box. It takes several seconds for the file to be opened. Before I call the function that calls the GetOpenFile api, I want to display the hourglass but it never displays. I have the following code...

I have an XML string contained in a string variable. I am new to XML so would appreciate some guidance on getting started. I am trying to extract the <Country> value from the string below: <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <HostQueryRs statusCode="0" statusSeverity="Info"...

Thanks AceMan and PHV. I wasn't able to get back to this until now. I have encountered this problem before and just ignored it. But now I can ensure my app doesn't crash. THanks again. Bill J

I am tying to import data from an Excel spreadsheet and my code works if the spreadhseet is closed and also if it is open with the following exception: if the spreadsheet is in edit mode, Access goes into some sort of infinite loop. I read somewhere that the Transfer Spreadsheet method waits...

AAARGH [censored] Found the problem. The code was working fine - the control that had the focus when the form opened also had a HelpContextID and it was pointing to a non-existant topic. Bill J

I have an autokey macro for the F1 key to display help for each of my forms. For some reason, the related code is not running for just one form. I have been over and over the code behind the form and I can't see anything that would stop the execution of this code. The macro / code works on all...

I am designing a form with some of the fields from each record in a continuous form format at the top. At the bottom will be displayed many of the remaining fields from the record selected on the top part of the form. I think I have three choices: 1. make the main form a continuous form and in...

Thanks Skip and Duane. I knew that dates were stored as a number. What was throwing me is that there was no change in the format of medium dates when I switched my Regional Settings from Canada to the US. I had anticipated that the medium date format would have changed as well. How anyone would...

I am in Canada and so I created this system with the Regional short date setting of dd/mm/yyyy. Because of the potential for confusion over date formats, many of my controls have the format property set to "medium." (Displays as 04-Mar-2010) One of my users wants to be able to use a short date...

Thanks guys. There is nothing to the left right or below the memo field. I have tried using a subreport in the past but the framework is still there even if there are no records in the subreport. Am I missing something? Bill J

My report has two lines of data: the first line will always appear. The second line is a memo field that I want to appear only where there is something in the field. If there is nothing in the memo field, I want the size of the detail portion of the report to be reduced so that only one line is...