Search results

Assistance is required, I have text box on a from which I wish to display the number or records within a query, where the Due Date is before or equal todays date. =DCount("DueDate","TaskChasePackTwo") records the count of Due date, but when adding a criteria...

caddie, if Microsoft Access can't create this relationship and enforce referential integrity it suggest to me that you still have a duplicate ID , It maybe be a duplicate zero id. I would create a Find duplicate query wizard and see what that produces . Regards Ypma .

Just a thought, could you not use the following in the after update event of the entry field you wish to pass to Form 1 [Forms]![Form 1]![txtbox1] = txtbox2 Just a user not an expert, so others may well have other solutions Regards Ypma

Mee. I tested your Test:IIF(1+1=2,"yes", "no") on my versions of access which is 2016 and the syntax produces the correct result Yes . What version are you using, maybe some of the forum members have the version you are using and can assist you further . Have you tried creating a new query just...

Uncle, I see where you are coming from, but I see problems when an expert replies in the OP s language ! or even in English . The attached video illustrates my point . Regards Ypma

Olddaf294, If not your References , the DLL File could be damaged due to hard disk error, Have you tried the debase on another Pc ? If the error occurs on start up the fault might be in the Start up module . Hope this is of use to you Regards Ypma

Voxy, arnelgp demo, when the minor snags have been sorted is your best option in my Opinion. I was working on the same lines as Arnelgp, but did not use Select case . For what its worth I am attaching the demo.

Thank you arnelgp for your time . Note I am now only an interest party. The leap year now, seems to be covered , however you have omitted case 20 to 30 is there a reason for this?. Plus the TOP field is not automatically filled . Regards " being a pain " Ypma

Arnelgp, Much better than what I could have produced, It seems to work correctly when the top amount is added manually ? The OP mentioned February and leap year could these anomalies be catered in your function ? Regards Ypma

Voxy, not sure what your formula is, in you example you are adding and extra 10 days on top of your value of Field TOP , is this correct ? Private Sub Text27_AfterUpdate() If DatePart("d", [Text27]) < 9 Or DatePart("d", [Text27]) = 31 Then Me.Text27 = "Top: 10" End If End Sub I have had a go...

Yes Jon the Red tees are where the ladies Tee off from and is much nearer to the hole than the men's tees . I was being flippant , if my post was out of order i will delete it ! Regards Ypma

Don't knock it "it’s an ˌill ˈwind (that blows ˌnobody any ˈgood)" I could tee off using the Red tees !! Regards Ypma

Nicol, have you considered using mail merge , your query as the data source, which could be filtered to show the current client . The word template could be used each time showing the details of the appropriate client. I notice you are using an old version of word and you might have to disable...

MajP and Isaac, thank you for your input. Isaac , sorry if I did not fully explain the problem as Isaac pointed out the result of -1 only shows when there were no rows count . theDBguy solution has solved my problem Regards Ypma

theDBguy, Worked like a charm, the -1 was annoying me , but now all is well in my little world . Thank you Regards Ypms

theDBguy thank you for replying to my question. unbelievable the result is the same -1, strange, as it must be counting the column head . Does the list count begin a zero or 1 ? Any other suggestions ? Ypma

Expert advise is sort , I am using the listcount to obtain the number of rows in a combo box .The text box calculated control I am currently using gives the correct count, unless the number of rows is zero , in that case the output is -1 ,which is the same result as when I do not use minus...

Uncle , I have it on good authority that one of the extra restriction is the same as Tier 4 but you will not be allowed to look out of the window and wave to friends and family ! I echo jdraw " Keep alert and stay safe . Ypma

Pat, thank you for your clarification, I misunderstood the posters needs and tried to give him an out in the Forms before update event , plus the fact that if the function is called from the records Before update event, which you have been advocating from day one , no incorrect record...

Pat, thank you for your response, I fully except Concatenating a ZLS caters to both null and ZLS and will take it on board , however not withstanding that, my code gave the user the option to ignore any changes or save the record , yours code does not give him that option. I requested that...