parameters

I am having issues with this code calling the public function EditEntry on frmRunEntry Private Sub CommandButton1_Click() Dim Response As Long Dim RowNum As Variant 'Get the record ID from the user Response = InputBox("Please enter the ID number") 'Test the user input...

I would like to develop a user-friendly Excel 2010 spreadsheet that would allow the user to enter from 1 to 10 (i just picked this number at random just to have an upper limit) employee numbers in cells A1-A10 and "click" on the VBA Code button that would invoke an Access Query and in the...

I have a Microsoft query that I created in Excel 2003, and saved the results as an Excel spreadsheet. The query pulls the data from another spreadsheet. I refresh the results each month by opening the spreadsheet, right-clicking within the results table, and choosing Refresh Data. I recently...

I have an MS Access query that contains a parameter. The parameter is a date field, and I have configured that in the Access query. If I run the query within the MS Access user interface, it prompts me for the paramater value as expected, and runs just fine. However, I want to connect to this...

I've written a VBA process that already passes 12 parameters to a Sub. In re-writing my code I find I want to pass another 12. There are four permutations of three variables. Since they are similar I thought there must be an easier way to pass these values. I looked at passing a...

I have a pivot table linked to an Access Query. Until today it was working, the data would refresh OK. Today I tried to refresh and got the error message: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters. Expected 1. The pivot table will not update and I cannot figure out what...

I've created a VBA-based query that uses a worksheet cell value as an input parameter. The query uses an Access database and returns with the desired record(s). It works just fine BUT....I get a new "Connection" listed in my Data - Connections and a new "ExternalData" range name listed in...

Hi All I have an order form. The first field is unbound and is used to write in the customer surname. on Key down event a second continuous form opens to the required search results through using "Docmd Openform where condition." you then select a name the form closes transfering the...

I have the following SQL query: SELECT "TransHeaders"."Logged", "Branches"."Name", "Departments"."Description", "TransLines"."Quantity", "TransLines"."SubBeforeTax", "TransLines"."SubAfterTax", "TransLines"."TransNo", "TransHeaders"."TransStatus" FROM ((("AKPOS"."dbo"."TransLines" "TransLines"...

Hi there, I need to create a query for a database in Access 2003 (I did not create it but have experience in using it). There is a table of Courses - when you click [+] by each course, it will give a list of names of students who enrolled for that course, and the date they enrolled. It looks...

Hi there, I need to create a query for a database in Access 2003 (I did not create it but have experience in using it). There is a table of Courses - when you click [+] by each course, it will give a list of names of students who enrolled for that course, and the date they enrolled. It looks...

Problem in running dtexec command with multiple parameters in macro:- ------code in macro----- Dim Rsvr As String Dim Runm As String Rsvr = Sheets("update_xml").Range("C6") Runm = Sheets("update_xml").Range("C7") ' MsgBox Rsvr ----value= Hi ' MsgBox Runm ----value= Hello Call...

Hello! I am trying to obtain some cost of living information from bankrate.com by using a web query to extract it into excel. I cannot seem to get the query to return anything other than the original parameters that load automatically in the webpage. The actual webpage in my query is...

Hi, I'm trying to query external data from an access database and trying to parameterize the IN() part of the where statement and I can't seem to get the syntax right. I am not sure if it is a part of the syntax of the sql or the syntax of my inputs. My sql reads: SELECT column_name FROM...

I have several worksheets using external data connections with parameters and am pretty comfortable working with this. I'm trying to do something now that I thought I had done before (2003?) but not having any luck. I'm probably close but not quite on target. The dataset I want in my table has...

Hi, I've tried adapting some VBA code from other posts and I'm not having any luck with this. I could really use some help. I have a Stored Procedure in my SQL 2005 database called: sp_Count_All_YN_Answers_WTP It contains these parameters: @OneStop varchar(50) = '%', @CaseManagerLName...

I used macro recorder to create two SQL queries for me. The first query works fine and I can put in variables in the Where clause, but the second only works when my string is less than 5 parameters. I can't figure out why 1, 2, 3 and 4 parameters work but anything more than that doesn't...

I'm looking for a way to allow the end users to enter multiple criteria in a parameter in a query. In theory I thought this critieria would work, but instead it returns nothing. Criteria value: In ([Enter Item#(example: "D05494","IM5506")]) If I hard code the item numbers like this: In...

Hello, I am working on a dashboard and I would like to be able to use different parameters to select background colors for each metric without having to manually indidivual conditional formatting rules for each metric. Here is an example of my data: Metric RedC YellowC GreenC Wk1Value...

Hi, I am extracting data from an SQL database into Excel 2007 using MS Query. I've used the following SQL code to prompt for the parameter: "WHERE casosdeuda.ConceptoDeuda LIKE (3) and a.`TipoCaso` in (?,?) and a.`TipoDeuda` in (?,?)" Using...