Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rmork
  • Order by date
  1. rmork

    A checkox is not doing what I intended...

    I made it... I must be sleeping!! Thanks guys. You came through again...! The code was working, I was using it wrong. (Not used to SQL view.. :-) ) Have a star!
  2. rmork

    A checkox is not doing what I intended...

    ...AS TotalAmount, funcAVD01OrdersQueryGetCalcCommissionPercent([AVD01Orders].[AVD01OrderID]) AS CommissionPercent, ([Commission]*[exchangerate])-([Installments]) AS Difference, AVD01Orders.FullyPaid, AVD01Orders.ExpectedDueDate, Currencies.ExchangeRate, AVD01Orders.InvoiceNumber...
  3. rmork

    A checkox is not doing what I intended...

    Thanks PHV, but that did not do it.. :-) It lists both with and without sailed date. I wanted a separate report for those without sailed date, so when you tick the box it should ignore the "from" "to" - fields, and only list blank sailed dates... Am I making sense? :-)
  4. rmork

    A checkox is not doing what I intended...

    I have a form that prints a report based on a ship's sailed date. Some ships have no sailed date, and I would like to print those separately. To achieve this I have put in a checkbox, that when is checked only those ships with sailed date = null will print: The checkbox is called "SD", and the...
  5. rmork

    Why is this not working???

    To be honest with you I'm a highshool teacher, and all of this is pretty new to me. I'm trying to learn, but I feel the learning curve is a bit steep... Have been kind of thrown into this by a company that in the beginning was just looking to change some reports layout...
  6. rmork

    Why is this not working???

    I'm afraid that is right. They started out as two different problems, and have merged into one big one.. :-)
  7. rmork

    Order number "from" - "To" in form not working when combined

    Thank You ProgramError. I will try this when i get back from vacation. My wife is naging me to go now... :-)
  8. rmork

    Order number "from" - "To" in form not working when combined

    update: It does not work if I choose the "all" criteria in the combo... Error saying: the expression is to complicated to be evaluated...(something else in norwegian)
  9. rmork

    Order number "from" - "To" in form not working when combined

    I fixed it by adding this line to the cmdReportPreview_Click(): DoCmd.OpenReport "rptAVD02PrincipalCommission", acViewPreview, , "[OrderNumber] >= " & Me.ONrFrom.Value & " AND [OrderNumber] <= " & Me.ONrTo.Value & "" how can I get results without entering ordrnumbers in the fields. I know I...
  10. rmork

    Order number &quot;from&quot; - &quot;To&quot; in form not working when combined

    Very interesting JoAtWork.. So how can I implement the ordernumber from/to in this code? In the query I have tried between [] and () but it stops when nothing is filled out. I am not a programmer so this is very difficult for me, but I'm learning.. :-)
  11. rmork

    Order number &quot;from&quot; - &quot;To&quot; in form not working when combined

    ...AND ((Principals.PrincipalID)=[Forms]![rptAVD02PrincipalCommission]![PrincipalID])) OR (((AVD02Projects.OrderNumber) Between [Forms]![rptAVD02PrincipalCommission]![ONrFrom] And [Forms]![rptAVD02PrincipalCommission]![ONrTo]) AND (([Forms]![rptAVD02PrincipalCommission]![PrincipalID])='*'));
  12. rmork

    Order number &quot;from&quot; - &quot;To&quot; in form not working when combined

    ...Between [Forms]![rptAVD02PrincipalCommission]![PeriodFrom] And [Forms]![rptAVD02PrincipalCommission]![PeriodTo]) AND ((Principals.PrincipalID)=[Forms]![rptAVD02PrincipalCommission]![PrincipalID])) OR ((([Forms]![rptAVD02PrincipalCommission]![PrincipalID])='*')); You help... :-)
  13. rmork

    Why is this not working???

    ...Between [Forms]![rptAVD02PrincipalCommission]![PeriodFrom] And [Forms]![rptAVD02PrincipalCommission]![PeriodTo]) AND ((Principals.PrincipalID)=[Forms]![rptAVD02PrincipalCommission]![PrincipalID])) OR ((([Forms]![rptAVD02PrincipalCommission]![PrincipalID])='*')); Have a star.. :-)
  14. rmork

    Why is this not working???

    could it have something to do with fact that not all of the options in the list will generate a result. There are principals in the list that has no orders. If I try to select these principals, the report wil generate, but with "#error" instead of values. Is there a way to ignore all principals...
  15. rmork

    Why is this not working???

    ...And [Forms]![rptAVD02PrincipalCommission]![PeriodTo] Between [Forms]![rptAVD02PrincipalCommission]![PeriodFrom] And [Forms]![rptAVD02PrincipalCommission]![PeriodTo] And there was a new column added called: [Forms]![rptAVD02PrincipalCommission]![PrincipalID] with ='*' as condition Any idea?
  16. rmork

    Why is this not working???

    Thankyou for quick response. I'm working on this now, so this is perfect.. :-) Hope this is what you are asking for...: WHERE (((Principals.PrincipalID)=[Forms]![rptAVD02PrincipalCommission]![PrincipalID]) AND ((AVD02Projects.OrderDate) Between [Forms]![rptAVD02PrincipalCommission]![PeriodFrom]...
  17. rmork

    Why is this not working???

    Very kind of you to help me... here is the code: Private Sub cmdReportPreview_Click() On Error GoTo Err_cmdReportPreview_Click DoCmd.OpenReport "rptAVD02PrincipalCommission", acPreview Exit_cmdReportPreview_Click: Exit Sub Err_cmdReportPreview_Click: MsgBox Err.Description Resume...
  18. rmork

    Why is this not working???

    ...of the principals in the dropdown list its shoving that particular Principal in the report... SELECT Principals.PrincipalID, Principals.PrincipalName, Principals.PrincipalNumber, Principals.Active FROM Principals UNION SELECT "*", "<All>", "", "" FROM Principals ORDER BY...
  19. rmork

    Why is this not working???

    ...property below is something like: "Found characters after the SQL-sentence" I hope you can help me. You have been good to me before:-) SELECT "*" AS Principals.PrincipalID; "ALL" AS Principals.PrincipalName; 0 AS SortOrder FROM Principals UNION SELECT Principals.PrincipalID...
  20. rmork

    copy content from one bound control to another

    Thank you for quick replay Not sure I got this right. The mainform is called "AVD02Projects" The textbox in the main form is called "ProjectValue" I would like to copy this to a textbox called "InvoicedCommissionAmount" in the subform called "AVD02Projects_subInvoices" There is allready an...

Part and Inventory Search

Back
Top