Search results for query: *

Hello, I have a query that I need to filter dates and return records for the last three years. I have done this by using Year: Max(DatePart('yyyy',[date_received]))[/indent] and then filtering it by Year(Date())-3 However, I have relized this is not working because there can be to records...

Hello, I am looking to export data from an access query to an excel workbook. I can do it for cell ranges using the following code: ExcelSheet.Range("H144").FormulaR1C1 = Me.[Parts Number] However, I need to export data into a column range and when I tried using the code below its not working...

Hello, I am trying to return records for the last five years with out using specific dates. I have figured out how to return one year by using the formula Year(Date))). I can also return records by from 5 years using Year(Date))-5. However its only returning records for that specific year...

Hello, I am looking for assistance with mapping multiple plot points to a google map using a URL. I know I need a function to find all of the longitude and latitude however I am not sure how to start. Any help would be appreciated. I have search articles and found open source code however...

Hello, I am looking to plot point multiple pins in google maps using vba code. I am using this code to plot point one property using lat and long: Private Sub Command92_Click() On Error Resume Next If IsNull(Me.Longitude) Or Me.Latitude = "" Then MsgBox "No Longitude and latitude info found"...

Hello, I am having problems with my code below. It will filter the form but its returning only a blank row. I do not think it is able to filter based on my query I am not sure why it is not able to select records from my query. What am I doing wrong? Private Sub Command1611_Click() Dim...

Hello I am getting a syntax error in my code while tying to filer with a list box. Here is my code: Sub Search2() Dim strSearch, strCriteria, strBuilding_Type, strCounty As String Dim Task As String Dim varItem As Variant '''=========== code for Building Type List box For Each varItem In...

Hello, I am trying to copy records from a form then export them to excel and transpose the data. I am getting the Runtime Error "1004" application defind or obejct-defined error. In the code that is highlight in yellow. The line is also posted here ".ActiveSheet.PasteSpecial...

Hello I am trying to open a second form from my first form based on the records on the selected on the first. The code I am using is DoCmd.OpenForm "Expense Report List", , , "id = " & Me.number However it is only returning the first record from the first list and not all five. What am I...

Hi, I am using Allen Brown Search criteria to filter and return records that I need. However I need to do a numerical range instead of a date range. I am not finding any information online to help me. I have a column that lists a number of units and I want to be able to search for a range of...

Hello, I am looking for help with a max query. I have four columns ID, afs_fye, date received, and header_id. The problem I am having is the max of the data received might not be the most recent afs_fye. So if the latest record is for another fiscal year I still need it to pull the most...

Hello, I need some imput on how to autofilter pie charts with pivot tables. I have a workbook that I am setting up to filter records. . I have one worksheet that contains all of the data. One summary work sheet. I have a combox in therory once a name is selected then all records assoicated to...

Hello, I am currently to to summarized data so I can create a pie chart in Access 2010. What I have done is tried a union with different number of columns however I am unable to get it to work. If this is not the right approach suggestions are always welcome. SELECT distinct [Cleveland...

Hello I was wondering if you could help me I have modified the Access template for Inventory. I have modified the template to add all of the current stock on the add inventory sub form however when I go to the inventory transactions list it will not show my totals on actual inventory when I...

Hello, I have this code to autofill the check box if a property that is in its table is selected. I put this code in the after update event on the field and its not working. I am not sure what I am missing. Thanks, Keri Private Sub Is_RD_Property_AfterUpdate() Dim FillCheckBoxSQL As String...

Hi I am having a problem with importing tasks from outlook. It is taking all of the recurring tasks and making individual appointments for them Does anyone have any suggestions on how to fix this. Thanks, Keri

Hi I have a question about the following vba code. I put a break point in the code the id is returning the value i need but the reserve for replacement id and excess income id is returning null. What should i do to correct this? an open args? Any advise would be help ful. when i try to open the...

Hi I am trying to sink to forms with a main form on open. I have everything done the instructions told me. My query is not reading the code for criteria [Forms]![Task Details]![ID]. Its reading it like a paratmeter. Does anyone know how I might trouble shoot this. I am using this...

Hi I am trying to sink to forms with a main form on open. I have everything done the instructions told me. My query is not reading the code for criteria [Forms]![Task Details]![ID]. Its reading it like a paratmeter. Does anyone know how I might trouble shoot this. Keri

Hi I am trying to sink to forms with a main form on open. I have everything done the instructions told me. My query is not reading the code for criteria [Forms]![Task Details]![ID]. Its reading it like a paratmeter. Does anyone know how I might trouble shoot this. Keri