Search results

  1. Y

    Invalid Use of Null

    Alot of it came from Northwind mate so all over the place.
  2. Y

    Invalid Use of Null

    Think I fixed it with Nz function.
  3. Y

    Invalid Use of Null

    I think it is down to this bit of code: Extended Price: CCur([Quantity]*[Unit Price]*(1-[Discount])) Could that be the issue?
  4. Y

    Invalid Use of Null

    What are you trying to convey?
  5. Y

    Invalid Use of Null

    The error happened today. The client last used the DB on Friday and it was fine. The 2 other queries calculate fields to feed into the original query error. Having just been looking closer at the make up of the original query, I found those 2 queries feeding it. I tried to run them to see if...
  6. Y

    Invalid Use of Null

    Order Price Totals is calculated to give Sub Total. it will be the Expressions used to calculate but why would it error today when its had a years worth of data in?
  7. Y

    Invalid Use of Null

    I notice I get this error on 2 other queries which feed that code above. Order SubTotal: SELECT [Order Details].[Order ID], Sum(CCur([Unit Price]*[Quantity]*(1-[Discount])/100)*100) AS Subtotal FROM [Order Details] GROUP BY [Order Details].[Order ID]; Order Price Totals: SELECT [Order Details...
  8. Y

    Invalid Use of Null

    It did do yes. For the past year. Now today it doesn't.
  9. Y

    Invalid Use of Null

    Yes. But now if I go to proper database and try what you said it doesnt work. Not sure if another step has effected it. But not working.
  10. Y

    Invalid Use of Null

    It is working now.
  11. Y

    Invalid Use of Null

    Says Syntax error. The queries are set up using Query Builder not pure SQL.
  12. Y

    Invalid Use of Null

    If I input an order its ok. Its just the displaying of active and completed orders on the forms. I think.
  13. Y

    Invalid Use of Null

    Deleted all of Feb data and still getting the message.
  14. Y

    Invalid Use of Null

    I aint changed anything. The client has the database and says they haven't changed anything. So they might have and not say. I have a backup that does work and nothing seems to have changed in the structure. I will delete some data and see what happens.
  15. Y

    Invalid Use of Null

    The message I get is: This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)
  16. Y

    Invalid Use of Null

    Yes it does. It is an error in the query. I know what query it is, and that query is built up of a couple of tables/queries. How do I step debug?
  17. Y

    Invalid Use of Null

    Hi. I have a query feeding a form. It displays Active Orders. So the SQL is: SELECT Orders.[Order ID], Orders.[Employee ID], Orders.[Customer ID], Orders.[Order Date], Orders.[Shipped Date], [Order Price Totals].[Price Total] AS [Sub Total], Orders.[Shipping Fee], Orders.Taxes, [Sub...
  18. Y

    Making Data Secure

    Yeah. I will give it a go later. Having never done it I don't know if it's a case of having 2 passwords and certain passes show certain fields or whether I have one password to show all and if you cancel you get a basic view of what they need?
  19. Y

    Making Data Secure

    The password option appeals to me. That would then lead me to ask what the vba would be for such a feature?
  20. Y

    Making Data Secure

    They both open same database. Manager clicks Management form, enters password. Consultant clicks Consultants Form. In here they see another dashboard with selected forms on. If I then make Contracts form visible to the Consultants, I still can't get head around how I restrict certain fields...
Top Bottom