Search results for query: *

Hello - I have several fields on a main form (asfAddressAll) that filter records to a continuous subform (asfAddressAllSubform). I would like to send the filtered records on the subform to Excel. How can I accomplish this? The following is the code used on buttons in the main form for...

Hello, I am bringing to top the window of an external program (Microsoft Outlook) with the following code: Private Declare Function BringWindowToTop Lib "user32" _ (ByVal hwnd As Long) As Long Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _...

Hello. I am able to open Internet Explorer and Outlook with the following code on a button on my form; Dim X As Variant Dim Y As Variant Dim Path1 As String Dim Path2 As String Path1 = "C:\Program Files\Internet Explorer\iexplore.exe" Path2 = "C:\Program Files (x86)\Microsoft...

I have a continuous form which I filter the results by selections through 2 combo boxes and clicking a button in the header portion of the form. My code on the button is as follows: Private Sub Command17_Click() Dim mySearch As String mySearch = "Select * from qMarconL where (([City] = '" &...

I have 4 buttons on a form, each of which open a different file in a single external application. When I click the button to open File 1, the external application and file open on top as desired. After doing some work on that file, I minimize the external application and return to my Access...

Hi, I am opening IE and Outlook from a button on a form with the following code: Private Sub OpenIEandOutlook_Click() Dim x As Variant Dim y As Variant Dim Path1 As String Dim Path2 As String Path1 = "C:\Program Files\Internet Explorer\iexplore.exe" Path2 =...

Hi, I'm a beginner with Excel and I am trying to get data from a web page into my spreadsheet using VBA. I've managed to navigate to a search results page but am unable to access the data. The source code for one instance in the results list is: <li><b>154 Morris Ave</b>, Summit City, NJ<br>...

I am an amateur with Access. I have a form based on a query. I open the form in datasheet view and use the filter function to narrow my result set. I then change to form view, which is continuous. I now see a list of records (usually 5-10) of which one field of each record contains a unique...

I have a table called "Item Price History". On the first day of each month I enter the price of various items for that month. My table contents will look something like this: Item A for Jan = 5.00, Item A for Feb = 5.35, Item A for March = 5.75. Item B for Jan = 8.00, Item B for Feb = 8.10...

I formatted a number field in a query in order to have it display hard right w/o spaces (Format([SF],"##,##0"). My problem is it will no longer sort correctly in datasheet view. Thanks in advance.

I'm a beginner with Access. I have contatenated an equal sign (=) to a field in a query expression, getting a desired result such as "= $50.33". How would I prevent the = sign from showing in null fields? Thank You in advance.

I have a continuous form (Form 1) which is sorted by a combo box on a second form (Form 2). I have written the following code on the open event of Form 1 which works fine; Me.OrderByOn = True Me.OrderBy = Forms!zzfbCriteriaSortBy![cbxSortBy] I would like to add a secondary sort. I have added...

I am trying to create a report which only counts the number of records based on a few different criteria. In the control source of a field on the report, I have entered; =DCount([ID],'[qMain]','[Status] ="Active"') - this returns the correct number of records...

I have written the following on the criteria line in the qbe grid of my query;[Forms]![zzfaCriteriaForm]![tbxStreetName]. I get zero records if nothing is filled out in the tbxStreetName field on my form. I would like to get all records if nothing is filled out in the tbxStreetName field. Is...

I created a calculated field in my query. On the criteria line, I wrote "Between Nz([Forms]![zzfaCriteria]![tbxRateFrom]) And [Forms]![zzfaCriteria]![tbxRateTo]". When I run the query, a message box comes up asking for a parameter value of a field which is a component of the formula in the...

I have written the following on the criteria line of my query; (Between [Forms]![zzfaCriteriaForm]![tbxPriceFrom] And [Forms]![zzfaCriteriaForm]![tbxPriceTo] Im unable to get all records if nothing is filled out in the tbxPriceFrom and tbxPriceTo fields on my form. What am I doing wrong...

I am a (clueless) beginner with Access. After I fill out several records using a form, I go to the main table and only see the last record I entered. The table doesn't seem to accumulate records. What the heck? Thank you in advance.

I enter a form and go to a new record. In one of the 20 fields on the form I have a pop-up calculator which fills out a field. I finish the record and go to the next new record. If I happen to use the previous button and go back thru the records, the field with the pop-up calculator blanks out...

I am a beginner with Access. I fill out a form monthly in which I enter the current price for each of several items I have listed in a combobox. If the price changes for a particular item, I duplicate the record and enter the new price. I now have more than one record and more than one price...

I am a beginner with Access. I fill out a form monthly in which I enter the current price of several items I am monitoring. I am editing an already existing record which was created a month or more earlier. When I enter the current price I would like Access to tell me the difference between...