Search results for query: *

Hi all, I have been trying out dhookom’s calendar (http://www.invisibleinc.com/divFiles.cfm?divDivID=4)which works great but my problem is that I want to use it for shifts where some may be overnight, i.e. start at 10.00pm one day and run through to 8.00am the next day. I have been using the...

Thanks for the reply Rudy, This still doesn't work I am afraid. The same error is returned. Cheers, Zippy

Hi Nowell, Many thanks for the reply, the problem still persists. The last bracket is actually the closing bracket for the nested SELECT DISTINCTROW statements and relevant UNION statement. Although, the problem may be that there is something I have missed or is in the wrong place, or it is...

Okay, I finally gave in again, I have been checking forums to see if any light can be shed on my problem but no joy. I want to pull data together from three different tables, eg. course date and hours, shift date and hours, leave date and hours, to do this I have used unions to join the three...

Hi All, Not sure if I am on the right track with this one or not, but I created a datasheet subform to add in records from two tables. When I add a new record directly into the datasheet (without it being in the main form), the tables update great without errors. However, when I try to add...

Hi mtwildtrout, Hey, this is my first reply on the tek tips forums. I am still getting to grips with Access but I have been using a different option, ie. to close without saving data, eg. DoCmd.Close acForm, "your form name", acSaveNo Good luck Zippy