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

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

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

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

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

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

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

Is it possible to change the error handling code generated by wizards such as the command button wizard? Bill J

I have a function in a module that will be called by one of three forms. The control names I am interested in referencing on all three forms are the same. I was hoping to cut down on the amount of code by using something like the following: If frmName & ".cboEntityType.Column(1)" = True Then...

I am evaluating the IBiz Integrator for QuickBooks. THier documentation is very poor and it doesn't help that I don't know enough about VBA coding. I have the following code: Dim cust As Customer Dim strConn As String strConn = "ApplicationName= """ & "my app" & """ CompanyFile= """...

How do I set the filter string for a stored query in my mdb database? Do I also have to set filteron after I do that? and if so how? Bill J

I have a complex nested query. I want to use the 'bottom query' to select only certain records. To detemine the values for the query criteria, I have a multi-select list box. My code determines all of the values based on what the user has selected in the list box and assembles the values into a...

In VBA, how do I take an existing file (I know it's name and location), and save it under a different name in the same location (without deleting the original file.) Bill J