Search results

I have a command button that runs an append and delete query. The append query works, but the delete query does not work. I currently have this working in another form and duplicated the query's but changed the form name to it would work on this form. At a loss as to why the delete query tells...

Error w/New Record Where would I put the code Me.Undo in oirder to make this work? It would be better to put something in code to have it work better.

I get this error when I am testing: I enter a value in the text box for a new record, I delete the value and try to move to another text box or move forward/ backward to another record. Error reads: You have tried to assignq NULL value to a variable that is not a Variant data type. Any...

Validation - Name Try this and change to meet your text box names. Private Sub txtITEM_DESC_KeyPress(KeyAscii As Integer) On Error GoTo Err_tbItemDesc_KeyPress 'Convert keyed characters to uppercase and reject keyed numbers If KeyAscii >= Asc("0") And KeyAscii <= Asc("9") Then...

Validation for Letters How could I use this: Public Function IsItAlpha( stInput as String ) as Boolean Dim boAnswer as Boolean Dim stChar as String Dim loI as Long Dim loJ as Long boAnswer = True loJ = Len( stInput ) For loI = 1 to loJ stChar = Mid$( stInput, loI, 1 ) Select Case...

I use this code to validate for numbers in a text box: Private Sub txtCS_NUM_BeforeUpdate(Cancel As Integer) If Not IsNumeric(Me![txtCS_NUM]) Then MsgBox "The data must be numbers only" Cancel = True Me![txtCS_NUM].Undo End If End Sub How can I change it to validate for text?? and is there a...

I am having a inout mask problem. I have a text box where a date needs to be, this is the format ##/##/##. When I put short date as the input mask I can not move off of the text box when I enter numbers into the text box

Date - Input Mask I have this for the input mask for a date text box 99/99/00;; When I enter the date I can not move from the text box, essentially you are stuck there.

Works now I forget I had this sub routine Private Sub txtNMMI_NUM_BeforeUpdate(Cancel As Integer) If Not IsNumeric(Me![txtNMMI_NUM]) Then MsgBox "The field must contain numbers with A proceeding the numbers" Cancel = True Me![txtNMMI_NUM].Undo End If End Sub

I get a dialog box stating " The field must contain numbers with A proceeding the numbers" I type in A213312 a sequence of any 6 digit number and get this error. I am putting in the text box what it needs and still get an error mesage and ideas? I have put L000000 in the Input Mask

I have tow separate functions to validate for either numbers or text. Is there a way to allow a text box to get both. I want an "a" tp proceed the 5 digit number? I can post what I have for validation so far that works if needed. Bill

Validation Have you tried the validation code in just th subform?

How about letters and number combination I have a text box where the user enters an a before the number is there a way to tell them to enter an a if they have not in the text box? My other text boxes are either letters or numbers, this is the only with a combination.

It now works thanks to ghudson Yes It now works. Some one was trying to tell me to use the Input Mask with a L as the criteria, but this did not work. Do you know what they were trying to do?

Which OnKey Event??? OnKey Up, Down, Press do you want me to put the code?? I want to valdate that the user has entered letters instead of numbers.

Iwant to validate for text I want to be able to validate for letters and it some one enters a number, show a dialog box stating no numerica values allowed.

Validation for text not numbers I have this code listed below to validate for text to be entered in a text box so when you enter numeric values you are presented with a message box. Private Sub ITEM_DESC_BeforeUpdate(Cancel As Integer) Dim Pos, strChar Pos = 1 If IsNull(txtITEM_NUM) Then Exit...

Validation How would you validate a text box that is supposed to be filled in with text so when some one enteres a number they can not advance to the next text box until corrected. I am using a sql table linked to a access db so I do not have the options of the validation rule and text like I...

Validation I need to check People_ID, First_Name, Middle_Name, Last_Name for duplicates. Do I need to use the same code just substituting different field names?

Validation I have this in the BeforeUpdate Event in the People_ID text box under properties. Private Sub PEOPLE_ID_BeforeUpdate(Cancel As Integer) Dim intSearch As Integer, varX As Variant intSearch = 1 varX = DLookup("[People_ID]", "dbo_RifleInventory1", _ "[People_ID] = '" & Me.PEOPLE_ID &...