Search results

  1. Fizzio

    ORDER BY question

    The Quotes will be important in this. The correct quotation method should be strSQL = "... ORDER BY "& getFieldName(Me.sort0) &" ASC, " & getFieldName(Me.sort1) & " ASC" But also what is passed from getFieldName(Me.sort0) will have to be a valid feild name (and table qualifier if necessary)
  2. Fizzio

    passing null value

    I'll give you a temp solution but it would be better to filter a null value before it is passed to the function. If you use the function in a query, use the iif function to select whether to run the function or not. Anyway, to butcher the Sweaties code :p [code] Public Function...
  3. Fizzio

    Quotes to Orders

    Cheers Rich. Thankfully, he is more than happy using Sage to do all the financial stuff for him and he wants no stock control built in. The production process he wants to track is what work is actually done on a particular day, by whom and whar materials did they use (he does not want to use...
  4. Fizzio

    Quotes to Orders

    Cheers Neil, I'm beginning to realise the enormity of the project (just when I'm in too deep!). I have asked them to produce a process map of the three separate processes they want the Db to capture Quotes, Orders and Manufacturing (ie creating job cards from the orders and allowing the machine...
  5. Fizzio

    Trouble getting vba to work in Windows XP

    2 things I would do to see if they solve your problem. 1. Import everything into a clean Db and see if you can create code then. 2. Upgrage Access to Service Pack 3 (the latest service pack) This fixes a particularly annoying bug with the vba environment - which may help
  6. Fizzio

    Database splitter

    Have you checked all of your queries as well. Especially those that may call a user defined function.??
  7. Fizzio

    Quotes to Orders

    Is that what the sports car is for? Rich, do you have any more help that you can offer? I appreciate your input.
  8. Fizzio

    Change 'Font' colour depending on condition

    Scouser, you still need some code in the Form_Current event to format the controls on a per-record basis. Private Sub Form_Current() with me if .OrderClosed = True then .OrderStatus.ForeColor = 255 else .OrderStatus.ForeColor = 16711680 end if end with end sub That should do it.
  9. Fizzio

    Change 'Font' colour depending on condition

    Thanks for that lesson Mile-O. You really are a haven for useless information - your family must be proud ;)
  10. Fizzio

    Change 'Font' colour depending on condition

    Meddling is the fun bit and where you learn from mistakes. The Code bit is fun and frustrating to learn (a bit like watching the reds actually) Greek is OK as I believe they are the forefathers of the current Alphabet - so eventually it will evolve.
  11. Fizzio

    Change 'Font' colour depending on condition

    scouser - Liverpool were truly awful today - thet have not fired on all cylinders at all this season - Monsieur Houllier is in for a rough ride!.... Anyway, your two code snippets seem to conflict with each other. On one hand (Form_Current) you are setting the OrderClosed value according to the...
  12. Fizzio

    Quotes to Orders

    I do not even want to contemplate how you know that :eek: Cheers for the calendar tip...
  13. Fizzio

    Quotes to Orders

    Fair point - how about that lollipop??
  14. Fizzio

    Quotes to Orders

    I'll try to remember to send you the basic structure I come up with - remind me on in a couple of weeks. :cool:
  15. Fizzio

    Quotes to Orders

    Yep, that is always a worry but I trust him to be fair for the work I do. Anyway, it gives me an excuse to come in here again for a bit banter - surely that can be compensation enough?? :p
  16. Fizzio

    Change 'Font' colour depending on condition

    Tidied up a bit Private Sub Form_Current() Dim ctlControl As Control DoCmd.Maximize With Me If .TotalGross >= "0.00" And .OrderBalance <= "0.00" Then .OrderClosed = True .OrderStatus.ForeColor = 255 For Each ctlControl In .Controls On Error...
  17. Fizzio

    Change 'Font' colour depending on condition

    See those fingers have not aged then Mile-O (git) :mad:
  18. Fizzio

    Change 'Font' colour depending on condition

    Also this will only format the control on the first record that you show in this form as you have placed the code on the Form_Open event. If this is a pop-up form that will only display one record then fine. However if the form can show many records by scrolling / navigating through. The Form...
  19. Fizzio

    Quotes to Orders

    Hey Rich, nice to see you again as well :p After 'agreeing' to do this - it soon became apparent what a can of worms I'd let myself in for. Luckily, he also sees this and has agreed to 'compensate' me for the time I take on this. Thanks for your interest and I'll try to answer your questions...
  20. Fizzio

    Quotes to Orders

    Yes, Fiz is back (well for a while anyway!) Cheers dcx, that is the answer I was hoping for as I was slanting towards that anyway. Thanks for replying at the weekend. No doubt by Monday, this post will have disappeared from the front page and no one will notice I sneaked in! heh heh :cool:
Back
Top Bottom