TopValues Parameter From Form?

Dec 28, 2006

I searched and read everything found regarding TopValues- since those answers don't fit exactly what I am trying to do here is another post :)

I have a query that selects records for a table based on a users input on a form-

They would like to be able to input the TopValues number [set to 100 for this query] from that form, also.

The code for the query is below-
*******************************************

INSERT INTO tblGeneratedRandomRecords ( recid, ACCOUNT_ID, UNIFORM_BUSINESS_ID, ACCT_ACTV_DATE, REGION_NUMBER, CountOfRISK_MAIN_SUB, SumOfPREMIUM_ASSESSED, SumOfTOTAL_UNITS, YEAR_QRTR, ACCT_STATUS_CODE, [Total DrvdFTE], FIELD_AUDIT_FLG, LAST_FIELD_AUDIT_DATE, IN_COLLECTION_FLG, OUT_COLLECTION_DATE, RandNumGen, NAICSCode, NAICSDesc )

SELECT TOP 100 tblRollUpPayRoll.recid, tblRollUpPayRoll.ACCOUNT_ID, tblRollUpPayRoll.UNIFORM_BUSINESS_ID, tblRollUpPayRoll.ACCT_ACTV_DATE, tblRollUpPayRoll.REGION_NUMBER, tblRollUpPayRoll.CountOfRISK_MAIN_SUB, tblRollUpPayRoll.SumOfPREMIUM_ASSESSED, tblRollUpPayRoll.SumOfTOTAL_UNITS, tblRollUpPayRoll.YEAR_QRTR, tblRollUpPayRoll.ACCT_STATUS_CODE, tblRollUpPayRoll.[Total DrvdFTE], tblRollUpPayRoll.FIELD_AUDIT_FLG, tblRollUpPayRoll.LAST_FIELD_AUDIT_DATE, tblRollUpPayRoll.IN_COLLECTION_FLG, tblRollUpPayRoll.OUT_COLLECTION_DATE, acbgetrandom([recid]) AS RandNumGen, tblRollUpPayRoll.NAICS_Code, tblRollUpPayRoll.NAICSDesc

FROM tblRollUpPayRoll

ORDER BY acbgetrandom([recid]);

****************************************
Any help is appreciated!

View Replies


ADVERTISEMENT

Parameter Form

Aug 10, 2006

I want to have a form that is based on a query. I want the first box to be a dropdown and fill in 6 textboxes after selectino (I have already made this) Then I want to select a start date and an end date for whomever was selected in the begining dropdown. I don't know how to get the query to do this. It is like a parameter but I don't want messages, I want txt boxes.

View 1 Replies View Related

Parameter In Form

Aug 18, 2006

Does anybody know how to have a text box on a form "satisfy" a parameter in a query? I want to enter two dates and have a subreport show information from them? (The records shown will only be between those two dates) How do I do this? (I don't want the parameter to pop up on form open) Something like (Date1) = Parameter1 (Date2) = Parameter2

View 2 Replies View Related

Open Form Parameter

Aug 24, 2006

I've run into a strange problem. I'm trying to have an image box that you can double click and it will open a different form with a full sized image. When I open my form with the larger image, it asks me for a Parameter Value. Is there any way to stop it from asking me for that? Also, what is a parameter value and should I be typing something there?


Any ideas you may have would really help me out. Thanks a lot in advance!!

View 6 Replies View Related

Top 'X' Values From A Parameter Form?

Nov 21, 2006

I have a simple parameter form where the users enter selectives for their queries.
They usually want the top 100 records, but would like to select the number of records from that same form.
I tried adding the forms' field name into the top records field in the query but it will take only a number.
Any suggestions about setting it form the form or using VBA?

Thanks

View 2 Replies View Related

Display Parameter Value In A Form

Mar 31, 2005

I have a form that allows the user to "Enter a Parameter Value" that determines the data that will show up
on that form. I'd be pleased to know:

1) How can I display the Parameter Value, choosen by the user, in the form.

2) Consider a form that will display all the students whose name is having Vincent.
If the user doesn't know the complete name, how can he define the parameter value. I mean in some
languages I can use Parameter Value = Vincent* and it will show me all the students whose name includes
Vincent. And in Access? How can I do that?

View 1 Replies View Related

Parameter Query In A Form

Dec 27, 2005

Hi. I have a parameter query viewed in a form.

How do I show the results in a list rather than singular?

Other than a report...

Thanks!

View 6 Replies View Related

Parameter Query In Form

Aug 18, 2006

Does anybody know how to have a text box on a form "satisfy" a parameter in a query? I want to enter two dates and have a subreport show information from them? (The records shown will only be between those two dates) How do I do this? (I don't want the parameter to pop up on form open) Something like (Date1) = Parameter1 (Date2) = Parameter2

View 7 Replies View Related

Value From A Form As The Parameter In A Query

Oct 14, 2004

Hi, I have a combo box based on a parameter query, which is on a sub form. I want the query to use the existing value from a field on the main form as the parameter, without getting the "Enter parameter" box. please help.

View 3 Replies View Related

Parameter Form Textbox

Nov 8, 2006

I have searched the form and what I am trying my best to do right now is create a form with a textbox and a button. In the textbox I would just put in the parameter of a query and the query result or report would open up that is based on it. Can someone give me an example or point me in the right direction.

The reason im trying to do it this way is I would be able to customize the form to go with the rest of the database's layout....

View 6 Replies View Related

Code For Parameter Form

Feb 24, 2012

I currently have a parameter form named "Fm_Commander_Parameter" and a report named "Rpt_Bldgs_by_Commander". On the parameter form I have a unbound drop down. On the After Update have I this code that opens the report.

Private Sub Cmb_Commander_AfterUpdate()
DoCmd.OpenReport "Rpt_Bldgs_by_Commander", acViewPreview
DoCmd.Close acForm, "Fm_Commander_Parameter"
End Sub

In the Query for the report for the Commander field I have the parameter as [Forms]![Fm_Commander_Parameter]![Cmb_Commander]..how to write code very well and am unsure this can be done, but what I would like to do is remove the 'After Update' on the form and on 'Open' of the report I would like to write a code to go to the form, allow them to select the commander, then go back to the report query with the selection. This way I could use the Parameter Form with other reports. Below is the code I've come up with that will be place in 'Open' on the report.

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "Fm_Commander_Parameter", acNormal
(I don't know what to enter to keep the form open to enter the data. Without the below command it will run the report but the parameter form stays open.)
DoCmd.Close acForm, "Fm_Commander_Parameter"
End Sub

View 14 Replies View Related

How To Get A Parameter From Form Into A Query

Jun 25, 2014

how to get a Parameter from a form into a query.I have a form with a subform and a table. However I want to enter a number in the Form and then the subform shall display all entries from the table with that number as a specific field. So to speak i want to apply a filter. Can i do that somehow without using VBA ? And without entering the number in that tiny dialog window that pops up when i use "[ ... ]" brackets in my query ? This is may query so far .... and it is the datasrc for my subform ...

Code:
SELECT tbl_autos.ID, tbl_autos.Typ, tbl_autos.Alter, tbl_autos.BesitzerID
FROM tbl_autos
WHERE tbl_autos.GaragenID = <Param>;

i want to replace <Param> with the content of my form.

View 5 Replies View Related

Form Enter Parameter Value Pop-Up

Apr 20, 2014

I have Created This Macro (Photo1) to Display Clients Home Address on A Bing Map, however, When I run Code I get A "Enter Parameter Value" Pop-Up. (Photo2) When I actually enter ClientID number in this case 5 it Does what I want See (Photo3). How do I get it to open directly to form with out Enter Parameter Value popup?

View 2 Replies View Related

Parameter From Form Displays Garbage

Nov 28, 2006

Hi there!

I'm trying to use an Invoice number from an Invoice form to populate a table of Invoice Lines with relevant records (linking by Invoice number). I realise the following SQL code isn't an append query, but I've simplified it to make it easier to explain

SELECT [Forms]![fInvoices]![SPInvNumber] AS MTInvNumber, tInvoices.SPInvNumber
FROM tInvoices
WHERE (((tInvoices.SPInvNumber)=[Forms]![fInvoices]![SPInvNumber]));

The output I get for this query is something along the lines of:

MTINvNumber | SPInvNumber
쉠 | 49760

THe MTInvNumber should read the same as the SPInvNumber, but it doesn't. If you can't see the above, its some sort of weird chinese/japanese character I think!

I thought maybe it was a display error, but I tried using it in my append query, and it inserted it as garbage too. The weirdest bit is it actually regards the form information as equalling the SPINvNumber from the tInvoices table! :S

Any clues on how I get it to format correctly??? I'm very tired now so it's bound to be something simple!

View 2 Replies View Related

Passing Parameter From Form Into Query?

Sep 3, 2007

I know this is probably a basic question- but Im not finding a clear answer here.

Basically- I have a value that I want to select from a drop down box on a form (not created yet). That value will get inserted into my query for a calculation I am doing. The form will pop up the results of the query in a table/dataset.

How do I designate the variable in the query that is being inserted from the form? I am using Access 2002- is there a way to visually perform this task (ie- drag/drop type thing)?
Thanks guys!

View 6 Replies View Related

Query With Combo On Form For Parameter

Dec 15, 2007

I have a report query that uses a combo box on a form to collect the parameters. I would like to be able to include an option that would be like not having any criteria at all, to show all the records. I have tried several combinations in the criteria to get it to work and haven't found a way yet.

IIf([Forms]![MyForm]![Mycbo]<0,Like"*",[Forms]![MyForm]![Mycbo])

I have tried various different versions of what you see above and none have worked. The true part and the false part both work if separated and tested. Is it possible to make this work or is there better way to do this?

View 2 Replies View Related

How Do I Pass A Parameter From A Form To A Query?

Sep 11, 2005

Hi

I am struggling with what seems like should be a straightforward task. Unexpectedly however it has become an infuriatingly difficult one (no doubt due to my complete novice status).

I have a very basic d/base (3 tables) that I have been searching using basic SQL queries. I want to create a simple 'search' form that produces the results of my various queries without the need to work in SQL. Enter one or more search criteria, hit ENTER, results presented in datasheet perhaps?

Thought this would have been easy but I've had no luck. Can you please explain how I can pass a parameter from a form to a query?

Many thanks

Stuck21

View 1 Replies View Related

Get Input For Parameter Query From A Form

Jul 23, 2006

I am not a programmer and I don't know VBA/VB.
I am using this as a workaround to avoid VBA functions (since I don't know them).
I can't seem to find a simple? solution to this.
I have a query that does a radial search in decimal degrees. I have created an unbound form as a dialogue box that converts degrees-minutes-seconds to decimal degrees and displays the results in a calculated text box. What I want to do is have the query take the results in the calculated text box as its parameters (along with a third parameter- distance) without prompting the user. How do I get the query to take its results from the fields on the form? I have tried Like [Forms]![frmName]![SearchValue], but I can't seem to make it work.

View 2 Replies View Related

Queries :: Using Datevalue As Parameter From A Form

Apr 23, 2013

In my QBE, I have a field call [startDate]

In my criteria, I am passing a parameter from a form.

Currently, I am using: DateValue([forms]![myForm]![txtStartDate])

From myFORM, the value of the text box is 3/1/2013

When I run the query, it runs as expected and returns all records with the 3/1/2013 dates.

But now I want to make it where if the parameter is null.

How do I change that criteria if that parameter I am passing is null from my form's textbox? I want it to return all records that have a null entry in the [startDate].

View 5 Replies View Related

General :: Opening A Form From Parameter Box

Jan 16, 2014

I am using a query with parameters set. when the user enters a search and clicks ok they get routed to the correct form. however if they click cancel on the parameters pop up box the form wont open and it leave them without a form to reopen anything within the database. How when they click the cancel button i can make a different form open up?

View 1 Replies View Related

Queries :: One Parameter Form For Several Query

Jul 9, 2014

I have always used parameter forms for inputing query/report criteria. However, they have always been for one query or report. However, all searches I have done for trying to use one form for several queries all I find is a simple response of "Create a form and then direct all the queries to grab the parameter from the form.". Sounds simple enough but I can never get it to work.

I have created a macro that runs 12 Append queries. I have also created a parameter form that has an unbound combo box. The combo box is fed by a query that gathers all the Data Dates for the user to select from. So if there are 24 different data dates then the combo box displays them all.

I tried creating a macro that first opens the form then opens the query, however, it runs the query before I can finish entering the criteria in the form. Then I just get a pop up of "You are about to append 0 records..."I have found several walk-throughs for having a query use a form to grab parameter, but have not been able to find one that shows you how to set up one form to run several queries.

I keep trying to find an answer, then give up and continue manually entering 12 dates for 12 queries when they pop up after running the macro. Now I need to create a macro that runs 24 queries and I don't want to have to go through 24 parameter pop-ups.

View 5 Replies View Related

Set Parameter For A Query As A Control Value Of Form

Oct 21, 2014

i have a question concerning setting of parameters in a query:

I have a query with a parameter and a form with a control ... however, i want the value of the control to be used as parameter in the query.

For example a checkbox "chkb". Now i specify a query as RecordSource (or ...set ... i'm not sure) for a subform and i want it to change the parameter-value with the value of "chkb".

Is it just necessary to assign the name of the parameter correct (in the query-definition, put smth like [Me].[chkb].[Value]), or do i have to set the parameter in VBA ? And anyway, is it clear what i mean ?

View 3 Replies View Related

Use Form Control Value As Parameter For Query

Feb 7, 2012

I have a pop up form that is run by a query that needs to grab the parameter value from a field on the open form. It grabs the value for "QuestIDfrm" from the form "frmQuestionDetail" using the statement below pasted into the query parameter.

Code:
[Forms]![frmQuestionDetail]![QuestIDfrm]

This works fine when I call the pop up from the form "frmQuestionDetail". What if I want to call this same pop up form from another form that has the same control (QuestIDfrm).

Is there a generic syntax that would grab QuestIDfrm from the current open form? Something like

Code:
[Forms]![CurrentOpenForm]![QuestIDfrm]

View 2 Replies View Related

How Can The Field On The Current Form Be Used As A Parameter For A Query?

Dec 21, 2007

Hi-

I have an Access DB with several different forms all relating to one master table.

Each record in the table can be resolved=yes or resolved=no.

Right now each user must click the resolved box to resolve the entry and then enter the date.

I have created a button that will run the update query below.

UPDATE [TBL Master] SET [TBL Master].[Resolved] = Yes, [TBL Master].[Date Completed] = Now()
WHERE ((([TBL Master].[Primary key])=[forms]![frm name]![primary key]))
WITH OWNERACCESS OPTION;

The query allows me to update the record on that form efficiently. However, I do not want to create one query for each form (30 plus) for this.

Is there a way to use the form that was used when the button was clicked without naming the form specifically?

View 4 Replies View Related

Form Open Code To Select A Parameter

Oct 9, 2006

I have a database with lists clients across the UK. I have now been asked to provide options where users can select clients grouped by geopraphical area e.g say clients in Scotland.

I can of course do this but having numerous identical forms where the source queries have different parameters depending on the regions required.

The only problem with this is that I would need numerous forms and queries. Additionally, there are options on the form to navigate to linked forms which would all need to be unique.

What I would like to have options on my main (Switchboard Type) Introduction Form to select the region. The code on the relevent command button would include the parameter. I would therefore not require the additional forms.

The open form codes includes:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmClients"
DoCmd.OpenForm stDocName, , , stLinkCriteria

I feel i need something after "frmClients" such as qryClients.ClientArea = "Not Scotland". Various attempts to incorporate something has created errors.

Any quidance on code would be appreciated.

Thank you...Paul

View 3 Replies View Related

Modules & VBA :: Open PDF From Form With Search Parameter

Sep 10, 2014

I have searched for bits of code to copy other people better than I, and had some success but I am failing to complete, so it is now time for me to visit you all. I am trying to open a PDF from a button on a subform. The location of the PDF is specified in a field. I want to open the PDF and search for a Member ID criteria also listed in a field on the Form.This is my code:

Code:

Private Sub Text12_Click()
Dim strPath As String
Dim Searchmem As String
strPath = [Notetxt]
Searchmem = [MemID]

[code]....

Adobe Reader reports "There was an error opening this document. The file cannot be found." but then opens the file (that's something).So it's the "search" bit that is the problem, and I cannot for the life of me get my search parameter to be used.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved