Search results

Apologies - should have explained I had to adapt the function you suggested to fit my coding the best I could (as below). When I entered dates on Friday for the previous week it is blocked but for some reason accepts 31st January and before... Private Sub dteActioned_AfterUpdate() Dim strTime...

You can't have more than 255 characters per text field - best thing to do is just add another field if you require additional data entry

Thanks very much for your reply. Much appreciated. I've incorporated your suggestion into my coding as best I can and it blocks any entry belonging to last week. However, if you enter a date belong to last month it accepts it. Is there anyway around this?

Why would you want to open a blank form without allowing data entry?

Think I understand now. If the form is related to the table. Open the Form in Design View. Click the Field List button on the menu bar. This will bring up a list of fields from the associated table. Simply drag the required fields over to the form. Data from the table will be displayed when you...

Please explain your problem a little clearer.

I have a HUGE system which presently restricts updating a "Final Action" date to today's date only. However, I want to change it so users can input dates for only the present working week. The present coding is as follows... Private Sub dteActioned_AfterUpdate() Dim strTime As String strTime =...

Hi all - new to this forum so hope you all can help! I recently took over admin duties on a multi-user (234 users and counting) Access system (CCUSYS). Whilst compacting the linked data file (CCUDAT) my PC crashed and the file subsequently required repair. I managed to fully repair the file but...