Recent content by socko139

Follow Up When I try copying this code I keep running into a compile Error: User Defined Type not Defined. Then when I go to debug its highlighting my bold parts: Private Sub Command100_Click() On Error GoTo Err_Command100_Click 'Dimension the Variables Dim xlApp As Excel.Application What...

Ok ..Finally I see some light here. I finished my validate code, but one problem.... my code is not setting focus properly upon error. Although it works when I apply my code to a command button (Ive created an Excel form with multiple text boxes) it will not work when I tab out of the field...

Hey guys..I've almost finished writing my code, but I need to know how to get it to work when I leave my text field: I wrote the following code: Private Sub TextBox4_LostFocus() If Not IsDate(TextBox4.Text) Then MsgBox "Please input a valid time." Else TextBox4 =...

I've been struggling through this one and keep getting errors with my code. I was hoping if anyone has ever written or can help me write the code to validate a time. I need to validate if a user entered in say for example 5:55 AM or 10:10 PM. (I'm doing the validation on a text field in...

Hey thanks for the suggestion, only thing though is I have the form created in Excel and I dont believe there is anywhere to enter that but actually as VB code to do the validation. I have a text box on a form in excel. Any suggestions?

Ok I'm not sure if this is a tough one, but I was hoping someone could help me write VB code that validates data. I want to make sure the user is entering in 10:55 AM into a box. That time format? Any suggestions how to validate?

I wanted to mask a text box on a form in Excel. Any idea what the code would look like? Thanks!

Thanks. . .worked perfect!!! !!!!!!!!

I tried this posting before, but no luck so far. I want to create a Form in excel with a macro button. When this button is clicked it will take the system time off the computer and post it to a text box. The code I wrote for the macro button was: Private Sub CommandButton1_Click()...

When I entered these lines of code for my command button..then clicked it... no times were placed in my textbox(TextBox1) Anything Im leaving out? Private Sub CommandButton1_Click() Me![TextBox1] = mytime End Sub

All, I need some help with one of my forms. I want to create a Form in excel with a macro button. When this button is clicked it will take the system time off the computer and post it to a text box or label in the form. Any ideas? I know part of it is MyTime = Time, but how do I now post...

Hey guys. I've created a report which is based off a query. The query is a exact replica of my table with some sorting done. In the query I have such field as issue ID, Priority, Region, Phase and Issue Team. What I want to do is create a form with these four/five fields and allow the user...

I have three tables I need help with placing on a form. If anyone can help me I would appreciate it so much. My first table is an issues table. Whenever we get an issue we enter it into an issue table. Our second table, a recommendations table, we enter any recommendation we have to help...

I was trying to write a piece of code that would help enable me verify someone is entering a WC_ID. What I've created is a tabbed form where WC_ID resides on the first tab. I want to prohibit a user from trying to enter data on another tab without initially entering a WC_ID (This is done by...

Thanks... Figured it out all by myself.. . pat on the back here..