Search results

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)

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...

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...

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...

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

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

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

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.

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

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.

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...

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

Fair point - how about that lollipop??

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

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

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...

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

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...

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...

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: