Recent content by Crownknox

Add the following to a text field in a form =CurrentUser()

There is a FAQ under Microsoft:Access Other Topics

SAME ERROR! But Thanks Again

OK Thanks: HERE is what I did. I CUT and pasted the section below under the Option Explicit. ---------- Static PrevControlName As String Static PrevFormName As String Static ExpiredTime ---------- I get the ERROR MESSAGE: "Invalid Outside Procedure"

Sounds like it would work better that way....but, it's unfamiliar territory for me. It is something I want to do though. Is there any faq's with a sample of this global code. Maybe a download? Or does anyone want to share theirs?

How might I make the variables global to the form? I have had some problems noticed since I've been using the inactivity procedure that I previously listed using the timer function.

Thanks for the reply: After posting I searched many web sites for help. I found this solution in a Microsoft support community post. I then have added the formname "Closemsg" that has the command Application.Quit. after a msg "....will close in 5 minutes". The command...

Thanks for the help. I am a new user. fExitApplication has not been established by me. Do I need to add it to a module? If so, do you have a sample code? Also, the only thing I have done to accomplish logging off inactive applications was adding the code I first mentioned in a hidden form...

"How can I close My Application if Nobody works on it?" I found this link in a previous post. http://www.unsoftwareag.com/FAQ_Start.asp What I have done is 1.Made Form "IDLE MINUTES" to startup in hidden mode 2.Added the code(Listed below) to OnTimer()event to this form...

I am working an a stats report that gives detailed info for individuals. (For Example: If an individuals [Daysworked] is more than anyone else, I would like it to be bold or another color.) I've tried using an if...Then statement in the OnFormat section but I get errors about using...

I have a similiar situation but the form is in Datasheet view and list records of Parts inventory. I would each record instead of whole fields background to be different if the Part records Due Date is past due. Example: &quot; I just don't know the code for this&quot; If me!duedate < Date...

What I'm trying to do is add all ticketid's in subform to the comments field on the main form. Subform TicketID fields: 89100; 89102, 89103 MainForm Comments field: Processed with 89100, 89102, 89103 ANY HELP?

Just to be clear. I have a field on the main form bound to the comment field with the same record as the ticketid on the main form.

I want to put the comment on the main form. Would the same code apply?

I have records for each product that we process at work. In a form, there is a field [TicketID]. Also in this field I have a subform from a query to show all other [ticketID]'s that were processed at the same time in the same machine. Example: Current Form [TicketID] = 89100...