Search results

Thank you. Yes, I'll try that and using the Before event, I should get there before the auto message. Many thanks.

With a simple form and datasheet subform, if the user tries to create a new record in the subform before a record has been created in the parent form, then Access displays a message which may not be understood by the user. I would like to handle it so that I can give a more helpful message...

That's done it. Many thanks. Andrew

In writing a simple expression to calculate pay, I have in VB written ShiftPay = WeekdayRate ......where the WeekdayRate is stored in a module as a constant. If I had 2 or more shops, I would have more lines in the module and would have more blocks of code. I would prefer to have the...

Bob. I finally got there. With USA settings it worked OK. With UK settings, I had to change to mm/dd/yyyy. Thanks very much for all your help. What a great forum; I'll be back!

That could be it. Good to hear that it works OK on your system. I'm on Windows 7, but I have an old laptop on XP, so I'll try it on that. Thank you so much for your help and perseverance; very much appreciated. Andrew.

OK. Many thanks. I'll give it a try. ........ I've tried it, but I'm afraid it still doesn't always work. In my HOLIDAY table, I have 7 April and 27 April. If I input 27 April and press tab, both checkboxes become True. If I enter 7 April, they remain False. It's so strange, because the...

Here is a version in Access 2000. I remembered to Compact and Repair this one!

Hopefully the file is attached. I'm most grateful for your time and patience in looking at this for me. The file is called ShiftWork.

OK. It's a tiny file. I'll try and figure out how to attach it here.

Yes, definitely. I will zip it first. Can you give me an email address or can I send it through this forum?

OK thanks. I'll try the mm/dd/yyyy format. (My idea of using the Int(....) didn't make any difference). Just tried mm/dd/yyyy, but same result. I have written a tiny new Db just to try this. 2 tables: HOLIDAY with 2 fields HolDate (DateTime) and HolDescrip (Text 25). SHIFT with ShiftID...

Thanks for your message. Yes, I've checked datatype. Making sure that I have the same in the form and in the table, I tried using the dd mmm yy format and then tried the built-in Medium Date. Curiously, with one exception so far, I have found that when the date has two digits eg 23rd of the...

It seems very strange, but sometimes the function works, but then with another date - already in the Holiday table - it doesn't. I've tried using the DCount and DLookup functions, and the results are nearly always the same. My code is as follows: Private Sub StartDate_AfterUpdate() 'Use DCount...

Bob. Thank you so much. It works perfectly. I would never ever have found that solution on my own. Thank you. Andrew

In a table (HOLIDAY), I have noted some dates as being official holidays. Within a form, I am trying to use the DLookup function to see if the date I am using is recorded as being a Holiday. My line is: If Forms!frmShift!StartDate = DLookup("HolDate", "HOLIDAY", "HolDate =...

Many thanks for your message; it's great to receive so much help. By good fortune, the details of my problem - via a well placed source - reached the Microsoft development team. The answer was that "this is a known fault.......... but will not be fixed in the next Service Pack". I can't help...

Many thanks for your message and words of welcome. It's good to hear from you. Yes, I'll try those ideas and it might well help to pinpoint the area of the problem. I wrote the db on my computer in Access 2000 and it's being run on another computer down the road on A07. I will get back there...

Using a database written in Access 2000. Simple form with datasheet subform. In the subform, right-click and try to choose "Delete Record", but the option is greyed out. Also the toolbar "Delete Record" button is greyed out. Have checked out the Trusted section and the "Allow Deletions"...