The Right Way To Make A Query By Form

Jan 30, 2006

Hello,

I have a query by form named QBF_Form, I use it to help users query a form without having to open the query directly. A query, Cert, is based on this form using expressions like:
Like Forms!QBF_Form!Sales & "*" Or Forms!QBF_Form!Sales Is Null

This Cert query is a source for a form called Manage. I have a macro to open the "Manage" form, run the Cert query, and close the query . Everything works fine when I do this.

But when I click on the Manage form directly, I get this: Enter Parameter Value:
Forms!QBF_Form!Sales

How can I prevent this from happening? How can I change the logic?

Thanks for your help again!

View Replies


ADVERTISEMENT

Make A Query From A Form

Jan 2, 2008

Can this be done?

I would like to genreate a query from a form. So when I want to run a monthly report for a month I can pick a mont or a date range and a criteria for the form such as crew meetings attended, paperwork in on time or up to seven different points of interest for a particular person.

I can do this relative simple in parameter query, but he users want a more efficient input form. Or maybe the word i "quicker". And if they use a drop down box from a data table to start the form/query, there won't be as many input errors.

THANKS,

Nav4

View 6 Replies View Related

Queries :: Create A Query To Make Calculation From Form

May 16, 2013

I need to create a form that using combo boxes selects a product-size-quantity, and then calculates total price.I asume that I create a query to make the calculation from the form, but for the life of me, I can't fathom out how to do it.

View 3 Replies View Related

Hard Code TIME To Selected Date On Form (to Make It Date&time) For My Query Criteria

Aug 17, 2006

Hello buddies :D, do you have any idea how to make this work?

To select data that falls within this criteria of date range between cboDate and cboDate2 (fields on my form). The date in [tblJobDetails]![timeIn] come in this format "08/17/06 10:24 AM", but the cboDate/cboDate2 (takes in date only e.g 08/17/06) what i am after is to evaluate specific hard coded time in addition to the date entered, i.e. even tho, i haven't entered time on the cboDate/cboDate2, I want specific time hard coded where e.g If i select a date range of 08/17/06 and 08/18/06 on my cboDate and cboDate2 it should really be evaluating: 08/17/06 8:00 AM to 08/18/06 8:00 AM.

This is the criteria i curentlly have on my query in design view tha works perfect in selecting date only.
([tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Or [tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Is Null) And ([tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Or [tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Is Null)
How can I incorporate 8:00am to 8:00am into my cboDate and cboDate2. What can i do to make this happen? Your kindness will be greatly appreciated http://www.naijaryders.com/forums/images/smilies/thankyou.gif

View 10 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

Queries :: Combine Two Query Sql Code To Make Only One Query

Apr 5, 2013

First query = Sum Products:

Code:
SELECT Sum(Tab1.Inputs) AS SumOfInputs, Sum(Tab1.ValInp) AS SumOfValInp, Sum(Tab1.Outputs) AS SumOfOutputs, Sum(Tab1.ValOut) AS SumOfValOut, Products.Product, Products.VAT, Products.UM
FROM Tab1 INNER JOIN Produse ON Tab1.ProductID = Products.ProductID
GROUP BY Products.Product, Products.VAT, Product.UM, Tab1.ProductID;

Second query :

Code:
SELECT Nz([SumOfInputs],0)-Nz([SumOfOutputs],0) AS Stoc, Nz([SumOfValInp],0)-Nz([SumOfValOut],0) AS ValStoc, IIf([Stoc]=0,0,([ValStoc]/[Stoc])) AS CMP, [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
FROM [Sum Products]
GROUP BY [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
HAVING (((Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))>0.09 Or (Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))<-0.09));

I need to combine those two query sql code to make only one query.

View 3 Replies View Related

How Can I Make A Form Always Return To The Form That Called It?

May 16, 2005

I have several forms that can be called from more than one other form, but I need to build my forms so that the user is returned to the form from which they started.

I have looked in the help files and FAQ and I can't find what I am looking for.

Please, can someone direct met to the required information or tell me how to achieve this?

Thanks,
Kev.

View 1 Replies View Related

Is It Possible To Do Make Table Query From Union Query ?

Nov 14, 2007

can't seem to be able to do so..

View 2 Replies View Related

HELP M!!!!! With Make This Form

Oct 8, 2005

hi i am making a database and i need some help trying to make this form if anyone can tell me how to make this form can you MSG me!!!!!!!!!!!!!!!!!!!

i trying to make this Form

http://office.microsoft.com/en-au/templates/TC010178391033.aspx?CategoryID=CT011366681033

it the CALLS tab on the form

anyway thanks for trying to helping out if you dont know how to do it

View 2 Replies View Related

Help Me Make A Form Please

Jun 29, 2006

I have 3 tables.

1. Bulding numbers....1 to 15
2. Rooms....each bldg. has 22 rooms so altogether 650 rooms
3. Maintenance work...for each room every maintenance work

Now I need form where by choosing room# I can found what work was done.

I would post a file but it excedees 100kb

thank you

View 7 Replies View Related

How To Make This Query?

May 15, 2006

I have a little problem with making a query and would need your help.

I have the following temporary table that gets filled automatically with 2 records every day:

DATE | TIME | NAME | CODE

The first record will have the DATE, TIME, NAME ( always the same ) and the CODE that can be START or STOP.

What i need, is to put the 2 records from the same day in a single row to get something like that:
NAME | DATE_START | TIME_START | DATE_STOP | TIME_STOP | NAME

Until now i was able to make 2 different queries. One can give me the START info's, the other one the STOP info's.
My question is if there is a possibility to combine those 2 queries or to make one query to get the result i need.

View 2 Replies View Related

How To Make That Query

Oct 31, 2007

I have 2 tables: first table has 4 columns:
/job code/project1/project2/project3/
job code is some digits, and in next columns are the job description (different for each project).

The second table has
/project name/job code/description/working hours/date/

I made the query what shows how many working hours was consumed for each project monthly
and my working codes, but I would like to have job descriptions after job code, If its project1
then the description should be taken from first table from the column "project1". Is it possible to do it with
query?

View 1 Replies View Related

How To Make This Query?

Dec 15, 2007

Hello,
How would I make this query:

I have with me a gene database. I have primary key as ID and another field, called Field2. It looks like this:

ID | Field2
1 BRCA1 (br1)
2 BRCA2 (br2)
3 APRE (apx)

I have several more ids like this in this database. I am fine with the first gene abbreviation, but the second one in the parentheses is redundant. I want them eliminated however it will take too long to go through and manually delete these redundant names.

Is there a way to make a query to erase the text in parentheses and the parentheses themselves?? I think it will go as an Expression in the query or perhaps I can use an Update query, but I am not sure beyond this point.

Please help. It is urgent. Thanks.

View 5 Replies View Related

How To Make This Query?

Dec 17, 2007

hello,

I am having some trouble here.

I have a gene database with several tables. One table is called GenesMain. The other is called temp (temporary table). The GenesMain has a little more information (more fields and pulling info from other tables in the db) than the temp table (which is the basic template with basic info)

When I find new genes from places like NCBI or other genetic databases, I make a temp table and put them in there. My hope is to update the GenesMain table with this info using an append query or update query.

The first time I run the database over a new batch of genes, I am fine making a temp table and producing a GenesMain table.

The 2nd time I run the database over a newly found set of genes (like a few days later or few months later), I can easily make a temp table.

I am having trouble now updating my GenesMain table to reflect this newly found information.

Does anyone know how to update my GenesMain table with the newly made info from the temp table? Thanks

View 4 Replies View Related

Can't Make Form Visible, Again

Sep 20, 2005

Greetings. I have three forms that are open at the same time. They are related and cascading. The first form (frmEventAdd) is the anchor. Each event can have many Trials. The second form is frmTrialInfo. Each Trial can have three Classes. The third form is frmClassInfo. These forms are used for update and adding new records.

The user displays an event for update (frmEventAdd). Then clicks on a button to display the Trials for that event (opens frmTrialInfo). frmTrialInfo displays information for one Trial at a time. The user clicks on a button to display class information for that trial (frmClassInfo).

One of the fields on frmClassInfo is called cboJudge. It's a combobox with names of Judges (judges of dog competitions). The judge information in the combobox comes from two tables: tblPeople and tblJudges. If the user wants to add a new judge they may click on the btnNewJudge. btnNewJudge will open a form that is used to add a new person (frmPeople).

Because frmPeople is opened from many different points in the application, I found it easier to simply make the three, already opened, forms INVISIBLE.
So...command button btnNewJudge opens frmPeople and makes frmEventAdd, frmTrialInfo, and frmClassInfo INVISIBLE.

When frmPeople is closed (btnClose), it checks to see if each of the previously opened/visible windows is open and then makes each VISIBLE, again. frmEventAdd and frmTrialInfo reappear just fine. However frmClassInfo does not.

I have traced the btnClose_Click routine in frmPeople and it certainly looks like every line of code is being hit, but the line that should make frmClassInfo visible does not do anything (nor does it generate any error).

Here is the code from btnClose_Click in frmPeople. Can you help me?

********************************************

Private Sub btnClose_Click()
On Error GoTo Err_btnClose_Click

Dim blnEventAdd_Open As Boolean
Dim blnTrialInfo_Open As Boolean
Dim blnClassInfo_Open As Boolean

blnSecondChance = False

If blnDataChanged = True Then
If DataHasChanged() = vbYes Then
Call btnSave_Click
End If
End If

'================================================= =======================================
'blnSecondChance=False = NO SECOND CHANCE ... Close this Form
'blnSecondChance=True = USER GETS A SECOND CHANCE ... Do NOT Close this Form
'================================================= =======================================
If blnSecondChance = False Then
'Zero out Relative Record Number from Array
svRecNo(intCallerIX) = 0
blnDoUpdate = False
blnDataChanged = False
DoCmd.Close acForm, Me.Name

'Is the frmEventAdd form open?
blnEventAdd_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmEventAdd") And _
acObjStateOpen

'Is the frmTrialInfo form open?
blnTrialInfo_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmTrialInfo") And _
acObjStateOpen

'Is the frmClassInfo form open?
blnClassInfo_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmClassInfo") And _
acObjStateOpen

If blnEventAdd_Open Or blnTrialInfo_Open Or blnClassInfo_Open Then
If blnEventAdd_Open Then
Forms("frmEventAdd").Visible = True
Forms("frmEventAdd")!cboContact.Requery
Forms("frmEventAdd")!cboSecretary.Requery
End If

If blnTrialInfo_Open Then
Forms("frmTrialInfo").Visible = True
Forms("frmTrialInfo")!cboTrialRep.Requery
End If

If blnClassInfo_Open Then
Forms("frmClassInfo").Visible = True
Forms("frmClassInfo")!cboJudge.Requery
End If

intCallerIX = intCallerIX - 1
Else
DoCmd.OpenForm PopCaller(), acNormal
End If
End If

Exit_btnClose_Click:
Exit Sub

Err_btnClose_Click:
Call ShowError("frmPeople", "btnClose_Click", Err.Number, Err.Description)
Resume Exit_btnClose_Click

End Sub

******************************************
Regards,
SueB

View 3 Replies View Related

How Do I Make A Bound Form.

Feb 14, 2006

I have a form that has a subform in it. I want the key field in the form to dictate what fields show up on the subform. When I try to set the Link child and master fields, I get a 'can't build a link between unbound forms'. How do I make this subform bound to the form????

Thanks, JOe

View 3 Replies View Related

How To Make Changes In The Table Through A Form

Mar 15, 2006

Hi, I am new to Access. Pardon me if I post it in a wrong post. I've a field name "HotelAmt" in "Meeting Members " table. I've four fields on the form 1.Hotel arrival date 2. hotel depart date 3. Hotel Cost/night 4.Total Amt.
All these fileds are in Meeting Members table. I gave the formula to calculate "Total Amt = ([Hotel Depart date]-[hotel arrival date])*hotel cost" I put this formula on Total Amt field on the form (properies-control source).
This one is working on the form.
My question is, when i make query for this to pull total Amt, its coming $0 (defalult) . I checked back in the Table, there its not inserting the Total Amout.
Anyone can you please give me the answer.

Thanks,
Sam

View 4 Replies View Related

Help! Need To Make Attendance Form!

Mar 20, 2006

I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,

**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.

View 6 Replies View Related

How To Make A Query Run Faster

May 8, 2007

Hi,

I am opening a query in Access which has two linked sql tables but it takes to long to open. Can I choose a method (ADO) opening that query? If not, is there a way to speed up the process?

thanks

View 1 Replies View Related

How To Make A Row With Totals In A Query

Sep 12, 2005

I have to make a query using information out of an existing table. In the table there are two columns which I have to use in the query. I need to have the totals of these two columns. The table looks like this:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3

What I want the query to look like is:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3
16 14

As I am dutch, my english will not be perfect
Thank you in advance

View 6 Replies View Related

Make Table Query

Dec 22, 2005

When using a make table query, can you include an ID tag. in the output table? if so how

View 2 Replies View Related

Make Table Query Help

May 15, 2006

:confused: I am using a Make Table Query to filter a Linked Excel Table. Is there a way to cut/drop the first 8 characters of the text out of one of the fields as it creates the new table?

Field NameExcel DataFinal Data
Model_NameLATITUDE D600D600

Also, the final table has two Relationships with two other tables. When I run the Make Table Query once a week, I have to break the relationship to get it to run. Is there an easier way to dial with this?

View 2 Replies View Related

Make-Table Query ??

May 19, 2006

Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!

View 2 Replies View Related

Help To Make Query By Time

Aug 28, 2006

Good day,

I have a table with many records each record has specific time. I would like to make query by time to see how many transaction has been done every 10 minutes.

I made a query its show me only one period. how to see all others period.

For example:

Start Time--End Time -- Amount (Total of amount for the period)
10:00:00 -- 10:10:00 -- 2000
10:10:01 --- 10:20:00 -- 1500

and for all other period :

I have attached the file with the data table and query.

any help is very appreciated..

Thanks in Advance

View 7 Replies View Related

Make A Query Look Nicer?

Dec 15, 2006

Hi, Is it possible to load the results of a query into a form? I have a form where Id like the results of a query to go into. Can it be done?

View 3 Replies View Related

Make A Query Look Nicer?

Dec 15, 2006

Hi, Is it possible to load the results of a query into a form? I have a form where Id like the results of a query to go into. Can it be done?

View 2 Replies View Related







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