Search results

Hey all, I am running Access 2013 (fun version where they took out the pivot tables and query charts) I want to average every five rows and I was wondering if someone could help, here is the data (SQL): Table Name: tblTest ID Value 1 2 2 8 3 3 4 9 5 1 6 4 7 2.5 8 6.5 9 5 10 4...

Good morning everyone, I was wondering if someone could give me a few tips on speeding up a function I made in VBA for a query. The function pulls from a table by Dlookup and determines if a a item is like the wildcard in the table. It pulls 5 times because the wildcard is different in various...

Hey everyone, I am at a loss and was wondering if someone could help real quick. I am trying to make this Dlookup Function work. I have searched the forms and have yet to find an answer. Most of the answers involve the variable on the left opposed to the right side. I appreciate your help...

Hey all, I am trying to create a query that would pull the top three recent dates for a part along with any extra data I need to add. I know how to pull the Last and First but I am confused how I would pull the top three by most recent date. Next, I would like to count them by the part it...

Hello everyone, I'm trying to avoid the TITUS Version 3.5 pop up box, Yes or No because I know the automated message does not contain non confidential data. Anyone know how to code in Access/Outlook to send a email message while automating this Yes and No Dialog? You'll probably mention I...

Hey everyone, I am trying to figure out a way to filter the average price of of a Product within the last 5 occurences (Line Items). It would pull a week back so WHERE: Between Now()-7 and Now(). Example: PARTID | Price | Date --------------+-------------+---------...

Good afternoon everyone, I am trying to write an if statement that will only capture a string if the string is in the following format: '76___-_____-___'" / 'S92___-_____-___'". IIf([PART#] = '76___-_____-___'", "Yes", "No" Is there a function I can use to get the results I want? I...

Append data in an Access Pivot Table to a Table (or requery on it) in Access Hey everyone, Is there a way to append a pivot table to a table or possibly make a query based on a pivot table? I need to get a count of Part Numbers and I need the average price for all these parts. Additionally I...

Hello everyone, I want to automate a query so when the user views it they see only the columns that have data. Columns that do not have data are not there. Is their a way to do this? I am using MS 2007 My Access tool is setup to import data into tables and then the user views the data...

Hi everyone, I am trying to get the code below to delete rows with the specific text in Me!Project_Name. I have the code 99% complete, however, the "Enter Parameter box" is poping up and a blank input box. I can input the same text and it'll run but I want to bypass this "Parameter box"...

Hey everyone, I have a startup code that I found but I haven't been able to set it up to my required needs. In VBA I want to do the following: 1. I want to: Search the workbook in column A for something like the word "*Dollars*. 2. The code locates which rows have the keyword dollars and...

Range Class Fail, Subtotal Access to Excel VBA Hey everyone, I'm trying to subtotal data in an excel file but I am getting a subtotal method of Range class failed in the red text below. I have been trying to get this to work with no success. Any Ideas? Thank you!!:banghead: Public...

Hey everyone. I am trying to do the following with the code below: 1. It copies the header of the sheet into SPBName for storage. 2. The code finds YR8 and copies over 7 cells to the right to YR15. 3. The code looks in each column for like *text* and delete the columns. 4. Copies the header...

I'm trying to do the following with the code below: 1. If the file is not in your My Documents folder than goto errhandler and a message box pops up asking you to retry or cancel. 2. When the user clicks retry it goes back and trys again but if the file still isn't there a runtime error 1004...

I have the code below and I want it to open a file from my documents folder. The only problem is that every computers path is different to this folder. Does anyone know an easy way to work around and open a file in My Documents without the full path? I want to eliminate the part of the path...

I can't get the code in red below to work. How would I go about coding this section? Is it possible to code this part? " "lastRow = ws.Cells(ws.Rows.Count, "F").End(xlUp).Row 'Error 1004" Errors recieved: "1004" Application-defined or object-defined error The objective is so it will look in...