Recent content by vexing
-
V
Form to pop up dialog every 6 hours
Okay, I haven't gotten much help with any of this anywhere. Let's see if you guys can help me. Here is the situation: I have a form named Trouble Tickets. In that form, I have a field named Alarm. The form also contains several other fields, including Date and Time. Then I have another form... -
V
macro to run every 6 hours
Hello, I have a form named Trouble Tickets. In that form, I have a field named Alarm. The form also contains several other fields, including Date and Time. Then I have another form (a pop-up one) called Trouble Ticket Alarm. This is what needs to happen: Someone enters a record into Trouble... -
V
Adding a new record to a table through a form
I'm not having any problems with the code that creates the ID. I know all about Autonumber. I do, in fact, use Autonumber as the primary key for the Customers table. The Customer ID is not the primary key for that table. Anyway, that's not the issue, thanx though... -
V
Adding a new record to a table through a form
I am trying to build a form that allows clients to enter new customer info to a customer table. The form is based on a query that pulls info from 2 tables. One table id "Customers" and one table is "Key Box Information" I have built a query, "Customers_Keybox Info" that pulls info from both... -
V
Validation of data entered into a form
Sounds like a good idea, I'll spend today looking into recordsets...since I know nothing about them... -
V
Validation of data entered into a form
Sounds like a good idea, however; I wouldn't BEGIN to know how to trap an error. I am VB inhibited...heheheh. Anyway, I just want to be able to have a client enter in a customer ID, have the form atuo generate a customer ID, and then check to make sure the ID does not already exist in the... -
V
Validation of data entered into a form
Ok, I posted yesterday about having problems with code in a form Here is what I've come up with do far: Private Sub Customer__Name_LostFocus() Dim vTruncate vTruncate = 4 Forms!Customers![Customer ID] = Left(Customer__Name, vTruncate) End Sub Private Sub Customer_ID_NotInList(NewData As... -
V
Creating a form that updates a table, only if data is not already in the table
Ok, this is a tough one I apologize for knowing next to nothing about VB code, but I really need some help here. This is the situation: I have a table - Customers I have another table - Key Box Information They both contain a field called - Customer ID They are linked by this field key box info... -
V
Automatically update date/time field
Thanx for your help, I think I got it working. This is what I'm using: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Date = (Now) Me.Time = (Now) End Sub -
V
Automatically update date/time field
I am having trouble with a time field in a form. The problem is: The time field is set to default of '=time$()' so the time field is filled in automatically with the current time. Problem is, I need the time field to only fill itself in AFTER the record is entered, not at the beginning. Reason... -
V
Force entry in a field if value of other field = "x"
Thank You so much for all of your help! It is working now... -
V
Force entry in a field if value of other field = "x"
actually, I already tried that, and it didn't work; so I just took that stuff off to fiddle with it. I just put it back on, though, and it still doesn't work. I do not get prompted at all when I choose "other". It just lets me right through... -
V
Force entry in a field if value of other field = "x"
Thanks, here it is: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Notes) Then If Action = other Or Problem = other Then MsgBox "If you choose 'Other' you must enter details in the 'Notes' field.", vbOKOnly Me.Notes.SetFocus Cancel = True End If... -
V
Force entry in a field if value of other field = "x"
doesn't work....I tweaked it every way I know of (I am not experienced with Code) Message box never comes up... -
V
Force entry in a field if value of other field = "x"
2 of the fields in my form are combo boxes with set choices. I want to force the user to put notes in the "Notes" field if they choose the "other" option from either field. If have tried various macros, events, etc. I can't seem to get it right. Can anyone give me a few pointers or a bit of...