Search results

Rubi What exactly is the message you are getting say?????? Is it say that "Your field cannot contain a null value" or is it displaying a messagebox you told it to display if the field is blank.

ok, I didn't anyway. both of the fields I wanted to change were general numbers named Grade and Box Number... THanks again

worked perfect!!!! Thank you.

Hi. I want to create a make table query where 2 of the 6 fields are set to data type number when the table is made. As it stands, the default data type is text. Is this possible??? Thanks in advance.

I'm not mad, try selecting each of the forms controll sources again.

You never asked about the questions. I was responding to this: I've tried and tried and can't get this straight in my head. I have 3 tables; tbl_questions, tbl_surveys, tbl_results. I have a nice form with a continuous subform. The form has 5 subjects from tbl_surveys, the subform contains all...

Try This!

Just copy it from my previous post, and paste it over the existing information in the record source. You could also use the query builder. Add the two tables to the query builder and then select the fields you wish to use. Just like making a reqular query.

Set the subforms record source to this: SELECT Tbl_questions.pageCode, Tbl_questions.qtext, Tbl_questions.reference, Tbl_questions.Notes, tlb_results.Answer FROM Tbl_questions INNER JOIN tlb_results ON Tbl_questions.qID = tlb_results.qID; Then you can set the controll source for you hidden...

I agree 110%. I have used this forum more then my fair share.

Try to requery the form. If that doesn't work, try to requery all the fields that are not filing in properly. I would place the requery behind the on open event of the form.

Huh?????????????????????

I could not get it to work... Here is my code: Option Compare Database Option Explicit 'PlayWaveFile Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" (ByVal filename As String, ByVal snd_async As Long) As Long Public Function PlayWaveFile(sWavFile As String)...

I changed my code around and got it to work. FYI, I place the code in the before update command. this is what it looks like now. Private Sub txtMPShipCode_BeforeUpdate(Cancel As Integer) If Len(Me.txtMPShipCode) < 15 And Len(Me.txtMPShipCode) <> 5 Then bytYesNo = MsgBox("MP SHip...

Works great! Now I have another issue. When the message box appears it asks the user whether or not they want to continue. If they choose yes, the msgbox closes and the focus is set to the next field. If they choose no, I want the focus to move back to the field the scanned the barcode into...

Foster try this

I know this is probably simple, but I can seem to get it to work right. The user scanns a barcode into a text box. I need a message box to appear if the number of characters in the text box is less then 15 characters (ie. 8888 instead of 888888888888888). Here is my code. I can't see what is...

thanks Rich

I was wondering if there was a way to play a short audio file when a certain record is found. Basically I have a form with a text box, the user scanns a barcode into the textbox. If the db finds a corresponding record, I want it to play an audio file. I have this working with a message box...

Is that in Access 97. I can't make changes to it, but you can. I think I know what you are trying to do, correct me if I am wrong: You want the fields Item1Q, Item2Q etc to be aligned so that whether the number shows 4 or 4000, it always stays to the far right of the field... Correct? If this...