Search results

WORKS GREAT!! Thank you so much for your help. (y):)

Thanks for your reply. i am just starting to learn VBA. on the open form function it work if text is put in the input box, however if input box is left blank and they click OK, Cancel or hit the ESC or enter key it opens the form. the user has to enter a WO id # from the form Query to open...

Good afternoon. how do you get the inputbox to cancel if null value is entered or user clicks OK or Cancel buttons. when using the code from Nigel above on Form Open.

i grouped these per instruction, but still doesn't work. please see attached copy of data base. when i open report Test1 and enter the date 4/1/2019 and end date 4/30/2019 it show the detail, however the chart only shows i item. thanks for your help.

please see attached sample of the database. WIP-Delay Tracking Detail Report is the detail report. WIP-Delay Tracking Chart v2 is the report i would like to have the chart and the detail on the same report once the start and end date is entered. Test1 is what i was working on to read from the...

I have a report based on a query as follows SELECT [Delay Tracking].[Date Entered], [Delay Tracking].CODE, [Delay Tracking].WO_NUM, [Delay Tracking].MODEL, [Delay Tracking].NOTES, [Delay Tracking].OSD_DATE, [Delay Tracking].RCD_DATE FROM [Delay Tracking] WHERE ((([Delay Tracking].[Date Entered])...

Hello, I am a novice user in Access. Have built a few simple databases and now starting to learn more SQL. Look forward to learn with AWF.