parameter

Hello Everyone, I've just joined this group and I have a simple question for you that I swamped while coding it :) First of all, I have a dummy TEST and PARAMETER table in my first sheet. Which is like; <tbody> Parameter 1 Parameter 2 Parameter 3 Parameter 4 Parameter 5 Parameter 6...

Hello! I have a sheet that looks like this: I need to do graphs through VBA with it, but for that I need to store the row numbers of the years. For example, if I want to find the row values of the years exactly below "Parameter 1" to put as the graph range, how should I do it? It needs to be...

I am executing a Stored Procedure via a Workbook Connection. It allows for 3 parameters. I, along with a few others, can change the parameters and Refresh the file just fine. However, a couple of other people get the Invalid Parameter Number error when putting in the same parameters as me...

Hi, I have two identical tables in Sheet 1 as given below: <tbody> Sr. No. Header 0 Header 1 Header 2 Header 3 Response 1 Parameter 1 Data A Response 1 Parameter 2 Response 1 Parameter 3 Row with some other data Row with some other data Row with some other data Row...

Hi, I have two identical tables in Sheet 1 as given below: <colgroup><col><col><col><col></colgroup><tbody> Sr. No. Header 0 Header 1 Header 2 Header 3 Response 1 Parameter 1 Data A Response 1 Parameter 2 Response 1 Parameter 3 Row with some other data...

Hi! This should be simple, but I'm an Access/Query newbie and can't figure out syntax to accomplish the following: How would I change the criteria syntax to make it return ALL records with value >0 if they just click OK and don't enter a specific value? PRICE SELL QTY (Parameter Query so it...

I recently changed the name of a column in a table. When I try to open the table in datasheet form I get "Enter parameter value for "the old column name". How do I get rid of that? tia Jack

Haven't had any luck searching for a solution but then I'm not sure exactly what to call it. I have several queries created that reference an external database using the 'IN' statement. That works fine however what I'd like to do is setup the path to that external table in either a global...

Hi folks, for a job I applied for I was today asked to create a (complex) work schedule, due for tomorrow. In this schedule I have to plot clients A to G, assigned to employees 1 to 4. Some clients have preferences, and both clients and employees have limited time availability during the week...

Hello Everyone, I'm writing a function to calculate confidence bands for a linear regression of some data. I currently have my function set so that I can choose what range I show my bands over and what % Confidence is used for each fit. As of right now I have successfully made these two...

Hi All, I have setup a datasource in Excel and I am using a Parameter to pass the value from Excel to the SQL database and return the results, this all works fine. What I would like to do is have the parameter set to the same cell (in my instance this is H14) but the worksheet changes. I have...

I have a worksheet function that takes two range variables as parameters, each with 5 cells. I want to switch the values such that Xi(1) = Xi(5)...Xi(5) = Xi(1) and do the same for the Yi values. I can not seem to set the variable correctly and it crashes as indicated below. Below is the image...

Hi Everyone, I'm using Excel 2007 on Windows 7 I'm not sure how to best describe this with the appropriate terminology. I appreciate the patience of you experts. I have a range of monthly performance for a benchmark and my portfolio. I am looking to identify periods where I can set the...

I have a table query and I have a column called Class codes which contain SK8G, SNOW, VAS1A, VAS3A, VAS3B, and CFL1. I want the query to have a parameter to only pull records with "CFL1". I added my column to the criteria in the query and it was set to equal "CFL1". Then I try to return the data...

I am trying to find out the urls by extracting common parameters (bolded in black) in the following sample urls and add the views/visits column values of these URLs that have the black bolded variables in common to essentially eliminate duplicate rows (as shown below)...have tried multiple...

Hi I have a database with a Date of Birth field. I have a query with a field that calculates the age from the Date of Birth (DateDiff("yyyy",[Date of Birth],Date())+Int(Format(Date(),"mmdd")<Format([Date of Birth],"mmdd")) and it works fine As a criteria in this field I want to be able to...

Hi Good morning everyone. Having a tough time passing a parameter value from a cell into the query. The field I am filtering is a string but I can only query based on the first 12 characters. So I have been trying to use "begins with" or with "like" and wild card characters, without any luck...

I'm trying to run a complete MI suite for the current year, but early next year I need the ability to run it for the previous year too. I'm already doing this in Excel, but The Management has decreed that as there are no Excel skills in the team (I'd also argue a lack of Access skills too!)...

I have built a report and, as an example, one of the tables uses unions to bring in various sets of information. Previously they just wanted to look at the last 6 months, which was fine as I could use the getdate() function to bring back the data to Pivot within excel. They have since...

Hello Everyone. I have searched the web with no luck on finding an answer on what I need to do. Here is hoping someone on here can help me out. I have a workbook that is pulling data for every hour of the day from an internal website. The macro is built to pull data 24 times (each hour)...