Search results for query: *

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...

In the following sub, the call to ahtCommonFileOpenSave does not always happen. Does anybody have a clue why this call would not be triggered every time? Private Sub CreateWorksheet() 'Create Excel spreadsheet Dim strSQL As String Dim qdf As DAO.QueryDef Dim...

I have a fairly large system with 50+ forms, etc. The back end is a mdb file. I would like to be able to put the back end on a web server and have my users acess their data over the web. I have come to the conclusion that the first step would be to redevelop the back end into a SQL server...

Thanks guys for giving me some comfort that I am going the right way. I have that set up for my home network. What I don't understand then is what url people will enter. To get to our web site, they will still go to torontophil.on.ca What about a user who wants remote access? What url do they...

We are a very small NFP. We have a donated copy of SBS 2008 and an adequate box to run it on. Our primary need is to have all files backed up and for users to be able to access their computers from their homes. Our website is hosted by an ISP. Internet access is from a cable provider. We cannot...

I want to change the background color of a text box if the value of another control is null or = "". I have the following expression in the Expression Is box but the color does not change. nz(txtQBDepositID,"") = "" txtQBDepositID is a bound control What am I doing wrong? Bill J