Search results for query: *

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...

Here are the two queries ---------------------------- Query: UpdateInvoicePartPrice UPDATE ShipperMain INNER JOIN InvoicePrices ON ShipperMain.ShipperNumber = InvoicePrices.ShipperNumber SET InvoicePrices.PartPrice = [unitprice], ShipperMain.Invoiced = Date() WHERE (((ShipperMain.Print)=Yes))...

The problem I have is this: I like to print multiple invoices at the same time. To do this I have a yes/no field [tobeprinted] in [datatable1]. The query for the Invoice reports selects all records in the [datatable1] where the [tobeprinted]=False. So far, so good. Next, I have a command...

Thanks, Works great!

I have several fields in a form where the default value is usually the date. But i often have to change it. I am wondering if it is possible that if the plus key or minus key on the number pad of the keboard are pressed it will add 1 to the date or subtract one to the date. Example Date =...

Thanks for the help all, I never found out the problem, but I found a drastic solution. I put in a server and put all the main data on it. Then I formatted and reinstalled software to the original pc settings. Everything now seems to be working great. I do think the problem was with user...