Search results

This site is so good. Glad to have help at my finger tips. All a learning process for me. Anyway I actually got somewhere with some code, Private Sub txtAcquisitionNo_BeforeUpdate(Cancel As Integer) If Len(txtAcquisitionNo.Text) > 6 Then MsgBox "Incorrect Length" Cancel...

Im up to here with Access....getting really frustrated.... Ok the above example is just one of the things i had to do. But i was able to do it to the field i called AcquisitionNo. This code below was actually working... Private Sub txtAcquisitionNo_BeforeUpdate(Cancel As Integer) If...

Hello again, this time im struggling to set a validation rule (remember im fairly inexperienced at all this, this is why im asking about such simple things to you) I went to set a password so that it can only bring up 6 characters . Thought i would add a validation rule such as: Acquisition...

How do i make it so the print button only prints out certain fields on a form. Any help appreciated. lizzie

Problem though Great help guys. Well i thought it was all going well until i reopened access later and it decided it wasnt going to work now, even after i saved it. This was my new code. Dim strMsg As String, strTitle As String Dim intStyle As Integer If IsNull(txtArtist) Or txtArtist = ""...

When a field in form (in this case txtArtist) is blank i want to be able to make it so they cant move on or aware that the field is blank. I wrote the following code but it doesnt seem to work properly, it works after i type a name in the field and then delete it and move on, it comes up with...

Is there a way to start at the top of the page in a field and be able to press tab to get to the next field instead of the cursor jumping down the page to the last or middle one. Cheers :cool:

ok it didnt work. it brings back the 1st and 5th number. Eg- type in 123456 brings up 15 I dont know if i said but this is a assignment and he gave us examples of what should happen. eg ID Number 123456 1+5=6, 2+4= 6 6+6+3=15 1+5= 6 6 is the same as the 6th digit, therefore valid id number...

I put in a option group, thought it was the easiest way to go for my problem. I could set it to option buttons, set the default etc. But I want to be able to make an event on click on one of the options. However im not giving this option, it doesnt include On Click to perform an even. SO I...

thats ok Hey, It doesnt matter, all helps.

I have no clue how to do the following Check Digit Validation Step 1- Add 1st and 5th Digit of a ID number, giving total of 1 Add 2nd and 4th Digit of a Id number, giving total of 2 Step 2- Add 3rd digit of Id Number to total 1 and total 2, giving total 3. Step 3- While total 3 is...