Time/Date

[June7]

I can't open Winzip anyway, only Windows Compressed file.

Copy database and remove confidential data, run Compact & Repair, zip if still large, attach to post. The Attachment Manager is below the Advanced post editor. Up to 2mb zip allowed. If this fails, must be security on your end that prevents - office?. Try at home?

[jmorris]

I can't open Winzip anyway, only Windows Compressed file.

Copy database and remove confidential data, run Compact & Repair, zip if still large, attach to post. The Attachment Manager is below the Advanced post editor. Up to 2mb zip allowed. If this fails, must be security on your end that prevents - office?. Try at home?

Hi think I have managed to attach it, the charity are very garteful for your kind help, many thanks

[June7]

Here is what I did to your project:

1. Set Navigation form properties:
Data Entry - Yes
Allow Additions - Yes
Allow Deletions - No
Allow Edits - No

2. On Navigation form, set the RecordSource to Sign In_Out table

3. On Navigation form, add a textbox. Bind the textbox to the Sign In field. Set Default Property to Now(). Or can eliminate the textbox and set the DefaultValue property in the table.

4. On Navigation form, add an unbound combobox. Set combobox properties:
RowSource - SELECT Surname & ", " & [First Name] AS [User], Surname, [First Name] FROM Volunteers;
ColumnCount - 3
ColumnWidths - 2";0";0"
AfterUpdate event - [Event Procedure]
Code for the event:
Me!Surname = Me.cboUser.Column(1)
Me![First Name] = Me.cboUser.Column(2)

5. Change Click event for Quit Database button to [Event Procedure]
Code for the event:
Me![Sign Out] = Now()
DoCmd.Quit

6. Set the Navigation form Close Button property to No.

I tried to do the code with macros using SetValue action which is supposed to be available in 2010 but it did not show up in the list of macro actions.

Additional Comment: You have the Navigation form set to open as default in the Current Database settings. Also have Autoexec macro opening the Navigation form. Don't know it is in issue but don't think is needed in both.