Search results

theDBguy: Most excellent, now i can continue with my little project. thanks again for your patients Regards Ypma

theDbguy: The £64 i quoted in my last should have been £65 , which is on the left of form Field Amount Due . This is only one record the other three instalment fields ignore ,as i will programme them once i have sorted how to get the £65 into the appropriate field, depending on if the check...

theDBguy: The 193 is the sum total of the fee paid from the three records which have all been checked as paid. I was using the Dsum expression to give me a clue on how to get the amount £64 in the new box, if the check box has been checked. Eventually i will be working with the instalments...

theDbGuy. Thank your assistance to date. I am happy to send a copy of my project. Note i am not a professional i just enjoy creating small database for my and friends and extended family. The form will open with the Flash screen . click Button "Details Form" In the general form , click fees...

theDbGuy: i liked your script , however it brings up an error . i did not think it required a Domain reference as i am only trying to total the active record . as mentioned in my original Op i managed to get the Dsum to work. if i wished to. just have the amount in the paid field i would have...

Thanks theDBbadguy . If there the check box is not check , the fee paid will be zero Hope this explains my question ? YPMA

Further assistance is respectfully requested . In my form i have field named Total Paid, I wish to have the amount amount Due reflected in the field if the check boxes has been checked when paid. I Successfully produced a Dsum #=DSum("AmountDue","FeeDueQuery","Paidinfull =-1")# Which...

Minty: Sorted many thanks . removing the brackets did the trick. Ypma

theDBGuy: Thank you for getting back to me. Your suggestion produced an error message ," the form named is not recognised. or does not exist. " I double checked the spelling of the Named form. Any other suggestions ?

Assistance would be appreciated. i have a Flash form which has a combo box , i am trying to open the Contact Details form with the record ID selected in combo box. My efforts open the form as a new record . # DoCmd.OpenForm "Contact Details", acNormal, "", "Combo288.column(0)=[Forms]![Contact...

Amir: Not sure from you example exactly what your result should be. If you are looking for duplicates IE Where Box and Product are the same ? Then use the query wizard to find duplicates. Hope this is of help to you? Regards Ypma Reread your post, and realise you want the product that is in...

CJ London, thank you for the Late Binding Link . Not tested yet, but it appears be the answer to my problem. Regards Ypma

Good Morning from the UK. I am currently testing out MS office 2019 on my home laptop. All seems fine even when I open a database created in MS 2010, all the References are updated from Office 14 to Office 16 , However when I try the reverse and open a database in MS 2010 ,created in Office...

C J London:Appreciated the fact that you had not tested it . i used the alternative code you supplied #Me.date_sent = date_sent + Time()# and the time zones do not match, hence my question. i am using UK time zone and when the using code produced a time in the future as shown in my post...

CJ London: As an exercise i tried your code in the after update event #Me.date_sent = date_sent + Time()#. I triggered the Now() resulting in 26/09/2019 17:10:42. I then used the date picker to enter today's date resulting in: 27/09/2019 04:50:55. Note, I am using UK time and date should this...

Pat, I did not fix my initial problem but worked around it. Normally I trigger a general date using the after update event.# eg me.dateconfirmed= now# My user wanted to be able to change this date by using the date picker, which of cause only produces the short date . Wrongly I thought i could...

Pat, i asked for advise and expected constructive replies , you did just that , i did not take you post as a put down , but took you comments on board . Regards Ypma

Thanks to all of you that commented on my post. The point that a date picker is what it says on the can, is well made. I was initially testing at table level and Pat put me right there. The idea was for the user to enter a date in a date field on the form, resulting in a date and time element...

arnelgp thank you for your quick response. i have entered general date in the date time field ,general drop down. Not sure what you mean "add Format Property of the textbox." sorry if i am no being very clear. Ypma This is at table level only .

Advise sort. I have created a new date field in my table and set the Date format to general . When using the date picker to enter a date, only the short date is shown . I have tried the format mm/dd/yyyy hh:nn AM/PM, however the result shows short date plus 00 00 and not the hours and minutes...