NeoPA,
thanks for your help i will keep working and try to sort it out with the suggestions. so far i keep getting errors but will get it worked out.
Thanks
Gary
GLEberts
Last Activity: Jan 5 '12, 09:26 PM
Joined: Mar 29 '08
Location: Doylestown, PA
-
jpatchak,
thanks for the reply and suggestion. so far i am coming up with an error but i will work on it awhile and try to sort it out.
what i have is:
=DLookUp("Statu s","Status details","Order ID=txtOrderId AND txtStatusDate =" & DMax("txtStatus Date","Order Details","Order ID=txtOrderID") )
thanks for you help - i will post...Leave a comment:
-
Show Result from Text Box in continous form
I am trying to show a result in an additional text box on my form - from the last line in a continous form.
(1) My main form - fmInvoice
(2) My sub form - fmInvoiceSubfor m
(3) Text box in "fmInvoiceSubfo rm" = txtstatus [this is the one I am trying to duplicate with the last result]
Example:
I have 4 lines of data in a continous form. What I want to do is have the last or... -
Will give it a try - thanks for the replyLeave a comment:
-
Grand Total in a Continous Form
I am trying to calculate a Grand Total in a continuous form. This question has probably been beaten to death but I could not find any answers or solutions on how to solve. I am trying to stay away from storing a calculated field in a table.
This is what I have -
Form: fmdepositsbydat erange
Textbox: “txtdeposittota l” with control source =CDbl(nz([txtamt1],0))+CDbl(nz([txtamt2],0))+CDbl(nz([txtamt3],0))+CDbl(nz([txtamt4],0))+CDbl(nz([txtamt5],0))+CDbl(nz([txtamt6],0))+CDbl(nz([txtamt7],0))+CDbl(nz([txtamt8],0))+CDbl(nz([txtamt9],0))+CDbl(nz([txtamt10],0))... -
thanks for the help! that did the trick!!!
thanks again.
garyLeave a comment:
-
Syntax Error 3075
I can not seem to get rid of this syntax error - hope someone can help out.
the error I am getting is:
Run time Error 3075
Syntax error missing operator in query expression
[AcctHolderID]=name
I have two forms (1) one with a combo box "cbobankacc t" on form "accttransactio nlist"
I am successful to have the value from the combo box generate into a text box of...Last edited by Stewart Ross; Feb 28 '10, 09:25 AM. Reason: Please use the [code] tags provided to bracket your code segments, like this [/code] -
I just worked it out -
thanks
GaryLeave a comment:
-
Crosstab Query
I have a crosstab query for 12 months of sales. It works well except is adds all the months sales together for every year. Does not seperate 2009 from 2008 and so on. It sums all the years together per month.
Column 1
Field: Salesrep
Table: tblJob
Total: Group By
Crosstab: Row Heading
Column 2
Field: Expr1: Format([BoardDate],"mmm")
Total: Group By
... -
JobInvoiceID is defined in my table as a "AutoNumber "
Command Button 1158 is placed on the subform "fmjobinvoi ce" not the main form "fmjob"
"JobInovice ID is placed in the subform "fmjobinvoi ce" not the main form "fmjob"Leave a comment:
-
Syntax Error
I am getting the following error when I click on a command button.
Runtime error 3075
Syntax error (missing operator) in query expression "[jobinvoiceid]'=.
I have a main form "fmjob" with a subform "fmjobinvoi ce"
both are linked together by "jobId" and "jobinvoice id"
I have a command button with on the click handler:
Private Sub... -
Thank you
thank you very much - worked like a champ!
i should of posted what i was using - would of won the most embarrassing code award. - although could of given you a chuckle. (smile)
thanks again
GaryLeave a comment:
-
Check box help
Could someone help me with the code for a calculation
When I click on a check box I want to be able to insert a answer for state sales tax in a text box (txtSt1)
Check Box = (ckst1)
Text Box to calculate sales tax = (txtSt1) Pa state sales tax (.06)
Text Box that has total to be calculated = (txtTotalCost1)
NOTE: don't know if this makes a difference but (txttotalcost1) is a unbound calcuation... -
I got the problem sorted out.
ThanksLeave a comment:
-
Thanks for the advice got it up and running after a few tries. works great.
Thanks for your time again.
Gary...Leave a comment:
-
thank you for your reply and explaination
you are correct i am trying to "multiply one textbox value by another and put that result into a third textbox, and then repeat this for each record on the continuous form" - is this correct?
I have inserted the code as you suggested.
it seems to only return a answer for the first record in continious form. if there are 2, 3 or ... more records the...Leave a comment:
-
the combo box is bound to table: tblswo
the field name = "meshtype" displays in the combo box (cbomeshtype)
yes the field "meshtype" is listed in the Ccombobox control source.
thanks
Gary...Leave a comment:
-
update:
the table name is: "products" not "tblinvento ry"
the row source is -
SELECT [Products].[ProductID], [Products].[ProductName] FROM [Products] ORDER BY [ProductName];Leave a comment:
-
thanks for your reply however I am confused as to where to use this in the form to sum in a continious form-
Private Sub Command0_Click( )
thanks
GaryLeave a comment:
-
D-Lookup
I have a ton of DLookup results in by database and it works great.
However I just built a pop up form (fmswo) that I am using as a worksheet while viewing a invoice and when I click on the combo box (cbomesh) the choice comes up properly but populates the first value in the table where it is stored.
what I have:
where value is stored to be lookup up - "tblinvento ry"
field name to look...
No activity results to display
Leave a comment: