Search results

David, I had to switch "m" to "n" for minutes but otherwise it works great!!! Thank you! Now if you could tell me why my colleague wrote the Date_Entered as DATE ONLY half the time and date AND time the other half..... Mike

I have a system that date/time stamps data entry of a record into a table. I want to be able to allow changes if they occur within 3 minutes of original entry-otherwise the record is locked. I can do the lock/unlock. What I haven't figured out is the 3 minute time difference. I'm thinking...

I'm currently using a text box with the control source of ="There are " & Count([AMOUNT]) & " projects funded by the " & [FUNDING_SOURCE] & " valued at " & Sum([AMOUNT]) which works fine but the dollar amount at the end is just a number i.e. 250000 How can I get it to show up as currency...

I have a simple form with 4 fields in one row. The form is set to continuous forms so several records are visible at once. The fields are set so that when they "GotFocus" the back color changes from white to yellow...makes it easier to see what field you're in. The problem is that when you're in...

I have a simple form with 4 fields in one row. The form is set to continuous forms so several records are visible at once. The fields are set so that when they "GotFocus" the back color changes from white to yellow...makes it easier to see what field you're in. The problem is that when you're...

Perfect, thank you!

When my database starts the main database window (with tables, queries...) is hidden. I want to put in a button with some code to unhide it. I know it's easy to do but I can't find the right code. Thanks! [This message has been edited by Mike Smith (edited 08-23-2001).]

I'm trying to use the form footer to show totals of cases per agent and their value. The lines below work: =[Agent] & " is responsible for " & Count([ID]) & " cases totalling " followed by =Sum([Amount]) and generates a line such as: David Hall is responsible for 47 cases totalling...

I want to add some code to my db that will log out a user if there is no activity for a certain period of time (say 10 min). I suspect it has something to do with watching for keystrokes but beyond that I'm lost...any ideas? Thanks!

I have a form where users will generally view data but a few people might have to do edits. I want to capture the date and time of the last update for a given record. I set the form's After Update property to me.lastupdate=Now() but that locks me in a loop (everytime it updates the update...

Thanks, both replies rock!

I wrote the following code: If FunctionName() = "ClarkL" Or "SmithM" Or "ThomasS" Then Me.cmdEdit.Visible = True End If and get a Run-Time Error 13 Type Mismatch. Not sure what the error is indicating, so I rewrote the code: If FunctionName() = "ClarkL" Then Me.cmdEdit.Visible =...

I have a field where the users input a product code. I need to look at the third digit of the code they enter and determine if the character is a number or alpha character. I can get the third character with the Mid function but I don't know how to evaluate the character...is it alpha or...

Stu, I had the same problem & have a great solution. Wish I could take credit for it but I can't. I got my help from Gyula Gulyas over at allexperts.com. 1. Insert this code into a new module 2...

I want to highlight a form's field whenever it has the focus. It's easy enough to do by assigning code to the GotFocus Event for the field (Me.ActiveControl.Backcolor=10079487) but I don't want to have to go in to all 235 fields to...

I want to highlight a form's field whenever it has the focus. It's easy enough to do by assigning code to the GotFocus Event for the field (Me.ActiveControl.Backcolor=10079487) but I don't want to have to go in to all 235 fields to do it. Can I assign this change...

I want the background to change color if and only if the field has the focus. I tried inserting a call statement but don't think I got it right. Unfortunately I don't know much at all about the Debug window...

I selected the appropriate fields and set the "Tag" property to "HighlightFields". I then entered the following code in the Class Module: Option Compare Database Option Explicit Dim frmMyForm As Form Dim ctlMyCtls As Control Set frmGeneral = Forms!frmMyForm For Each ctlMyCtls In...

I want to highlight a form's field whenever it has the focus. It's easy enough to do by assigning code to the GotFocus Event for the field (Me.ActiveControl.Backcolor=10079487) but I don't want to have to go in to all 235 fields to do it. Can I assign this change globally and if so how? Thanks!

I have a form where the user enters a 10 digit project number in an unbound control, presses a button, and the project data appears--no problem. If the user enters a 10 digit number that DOES NOT exist, I get either a completely blank project data form (even without controls/labels) or I can...