Replies

Thanks for the quick response Hans! I gave that a shot, but I’m getting an error, an action failed. Any clues?

Action Name:
OutputTo
Arguements:
3, Summary by Association, RichTextFormat(*.rtf), sharepointsitesteamsitesHOAProjectsreplacementreserveReports” & [Forms]![frmReports]![lstReports] & Format(Now();”yyyymmddhhnnss”) & “.rtf”, No, , 0

A macro to execute after opening the workbook on the toolbar.

Hi Hans,

Thanks for the suggestion. I gave it a shot, but no luck. Same behavior.

Actually, I don’t have a validation rule in the table design. But, I do have the field set as required and also to disallow zero length.

(Edited by HansV to make URL clickable – see Help 19)

Nevermind, resolved. In case anyone is interested, the following link gives a great example…

http://www.databasedev.co.uk/blank_query_parameter.html%5B/url%5D

That did it! Thank you! Just curious, why do I need the # signs before the zeros?

Unfortunately, the database is actually a pervasive database, which makes up our Accounting back office software. I use Microsoft Access as a front end reporting tool for the users. Unfortunately, the database has an owners table with multiple records for each user, with an owner id as the identifying record. So for example, I can have the following:

1-53001, Test User, Addr1, City, State, Zip
2-53004, Test User, Addr1, City, State, Zip

The 1-53 being one property and 2-53 meaning another…

SELECT IIf([Client Version].[Version_ID]=[Version].[Version_ID],”True”,”False”) AS Test
FROM [Client Version], Version;

I’m trying to test the version of the users front end against the newest version. If it is true, that means the user has the most up to date copy, otherwise if it’s false, then I’d like to run a macro that informs the user via a message box to contact me to get the new version, and then automatically closes without letting the user proceed. I’ve got the macro complete, I’m just not certain on how to complete the other.

Thank you for the replies. So I added the form.

Sub IdleTimeDetected(ExpiredMinutes)
DoCmd.OpenForm “frmWarning”
End Sub

But is it possible to have it display for a minute then automatically shut down if nothing is detected?

I just used the example from the Microsoft site. You’re correct, they will not be saving. They simply use the app to view reports and utilize forms to edit and add data. As a result, should I just use the following instead:

Application.Quit

Instead of Application.Quit acSaveYes

Hi Hans,

I implemented the code in the link you provided. But I had a few questions…

1. I’m using the automatic close

Sub IdleTimeDetected(ExpiredMinutes)
Application.Quit acSaveYes
End Sub

Is it possible to display a popup message and still automaticall close a few seconds after. For example, we have detected Inactivity, this application will automatically close in one minute? Additionally, I have set my db to automatically compact and repair on exit, does this still occur if it shuts down like so? As always, thank you for any input.

Patt,

The Cancel=True code worked perfectly. Thank you, thank you, thank you!!!

I revised my code and came up with the following…

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.ACH_Status = True Then
Me.PageFooterSection.Visible = False
Else
Me.PageFooterSection.Visible = True
End If
End Sub

This works for the first ACH_Status that is true. But it does not reset on the next example. It corrects itself in a later instance and then messes up again. It’s almost like it sets a session and doesn’t reset. Any clues…

Hi Jerry,

Thanks for the response. I gave your code a try, but can’t get it to work correctly. Here is what I have so far…

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If ACH_Status = Yes Then
Me.PageFooterSection.Visible = False
Else
End If
End Sub

Basically if ACH_Status is = Yes, then I want the section to be hidden. Otherwise, display the footer. At the moment, the code above hides the footer no matter what. Thanks again for your assistance.

Thanks! Another question. Is there a “safe way” to record the user versus using the previous function.