Search results

Thanks for your reply Bob. Yes they are in a SELECT statement which will be used to filter a report. The dates are entries into unbound controls on the form. I have already read them in and checked them for null entries with If IsNull(Me.StartDate.Value) Then dStart = "01/01/2000"...

Can someone please give some guidance on how to construct an SQL that is taking two dates from a form. The section I can't get right is: ....Between dStart AND dFinish...... dStart and dFinish show in the Locals windows correctly as #01/01/2009# and #12/01/2009# But I cannot get the right...

On the basis of no suggestions I have decide that I will: Count the number of records, n, in the new table Create another second new table with just 1 to n in it, and then join them with a Union query. pnb

I am making a table selecting certain records from a bigger table. I would like the new table to have record numbers, starting at 1. Is there a simple way to do this? Cheers

There is a SELECT count available using SQl I believe. What is the syntax for this to return a value to my code? Thanks

Have a look at this link: http://www.fontstuff.com/access/acctut19.htm pnb

For this example, what would be another way, not using DCount, to determine how many records there were in a opened table that matched a number of criteria? pnb

Thanks namliam, I know they can give unexpected results. Dave's suggestion worked jus fine. Thanks all

Good tip, it now works fine !! However I must get to grips with all those "s, 's and &s, if only for the mental challenge! Thanks again pnb

Thanks, I have tried that and now I can't get the Dcount syntax right! Can you help me again? pnb

I am trying to simplify a DCount statement as it has to make 10 tests in its criteria. The a slightly simplified version for just 2 criteria is: crit1 = "SPMB2/001" crit2 = "SPCOH2/001" number = DCount("[goods_no]", "Goods", "[goods_returnno]=Form.[return_no] And [goods_partno]= '" & crit1 &...

I consider that but it does not give the detail in the fields I need to choose the form. A liitle more explanation might help you. The form is a consignment record The subform is a list of items in that consigment The subsubforms are two test result record forms, for just certain items. I use...

This is complex to describe, please bear with me. A record has a form and this has a subform. The subform can have several records. The subform has a button that opens one of two another forms dependant upon the value of a control on the subform. However as there can be several subform records...

Yes but BackStyle keeps the outline instead of making it dissappear completely. I am imitating a LED flash as an 'aid' for the form filler. peter

I have tested and see how it works, just the control is effected. I changed it to use BackStyle instead of colour, which makes it look like it is going on and off. Thanks

Thanks Bob, That's interesting, I have never used a forms timer control ! Will anything else on the form be effected by the timer? peter

Can anybody suggest some simple code that will change the colour of a control about once a second? Cheers

If it works for you but not a colleague it could well be due to the path it is trying to save to. Try adding the path to the OutputTo command DoCmd.OutputTo acOutputQuery, "Business Type Exceptions Review", acFormatXLS, "C:\My Documents\LIQ and OSP Review.xls", True For example

Yes, sorry, typo in my post. It should have a comma not an = sign. Thanks

Access 2003 I have report with many records appearing in the detail section The records include a date field. I want to put a total in the report footer that is the sum of the records with 2004, 20005 ..... and 2009 dates. For some reason my usual way of doing this is erroring. The field with...