Recent content by nectar

Thanks Fizzio, will try it ASAP!

Hello, In an Offers DB, I have a form with two fields BeginDate and EndDate. When clicking on a button, it opens a continous form with a DoCmd.OpenForm and a criteria based on the 2 dates (i.e. it shows all the offers that were created between the two dates). What I would like to do is to...

It does exactly the same behavior!! The upper limit is one day less than it should be... The only other thing I do before is to format the date with: strDate1 = Format(Me!Date1, "mm/dd/yyyy") As a matter of fact here in belgium we have date as dd/mm/yyyy. I've read somewhere that I should use...

Rich, Many thanks for the hint. I did rename the field, however it doesn't make any difference for the problem described in the post!

Hi In VBA I need to count records from an Offers table, that were created beetwen 2 dates (strDate1 and strDate2). Using the DCount as follow gives me strange results: records that were created ON strDate1 are taken in account while records that were created ON strDate2 are not. Records that...

Very nice!! Thanks in advance

Thanks Fizzio, Could you just help me with "filter the recordset at query level", please? Where do I have to filter it?? Within the code of my button? at a onOpen event in the form I open?? TIA

Hello all, I've a form "FormCurtain" which contains a subform listing the different size of the curtains. When I try to open the Subform with the following code (from a search form) it doesn't work. It opens the corresponding form but doesn't move to the right record. Dim strDocID As...