Search results

I smashed mine. After my wife hounded me for not responding to the PHONE, when ever, where ever she called from, I got tired of it. I smashed mine.

I guess from the images I could best guess the Field Names!? It looks like there might be only 5 fields. Odd way of making instructions. Nothing states to create a second table with some field names Only when you get to Step 3 do you realize part way thru it that you need a second table.

On this page: A Beginners Microsoft Access Tutorial http://www.access-programmers.co.uk/learning2/tutorial.htm The tutorial takes you through some steps Step 1: Creating a blank Microsoft Access Database http://www.access-programmers.co.uk/learning2/tutorial-creating-blank-database.htm Step...

Your not going to tell anyone what the solution was?

Attached is a DB. It is small and has a few forms. I am using this to teach my self some DB design and programming. I have good practical experience with VB and VBA (90% Excel). The intital DB design special thanks to jzwp22. The form "DataImport" is finished. (jzwp22) The form "tblJobs" is...

Impressive, I will have to study that one. ;) I found a method that works on Excelforum.com (c/o romperstomper) http://www.excelforum.com/excel-programming/705956-using-the-registry-how-to-know-if-key-exists.html (cross post) Not quite as impressive, but it does what I need. Sub testreg()...

I should have been more clear on this. Example: Private Sub sPartNumber_AfterUpdate() If bOk = False Then 'bOk is Boolean Me.sPartRev.SetFocus 'set focus to any control Me.sPartNumber.SetFocus 'set focus to desired control Me.sPartNumber.Value = "" 'set value to "" (null) End If End...

(Solved) Using the Registry. How to know if Key exists? This is a sample structure. The text in orange is the AppName, the text in violet is the Key. Writing to and reading from the registry is easy to do, determining if a "AppName" or "Key" exists is not so easy. In this case the string...

As with Excel, I have not been able to get the highlighting to work. This is my work around. I find it easier to set the value of the combo box, text box, etc. to nothing after returning focus in the "After_Update" event Me.yourCombo.Value = ""

Thanks for the reply. I am working with both scenerios, teaching myself "how to". I have the combo boxes and they have been set to "Limit to List", unfortunately this still allows a wrong choice. The first combo box has more than one choice, thus the other three combo boxes have lists...

I have four textbox's, the first sets a value compared to a table. If the value entered match's a value in the table the user advances to the next textbox. The value entered in the next textbox needs be evaluated to the relationship of the previous table. Textbox1 = Part Number TextBox2 = Part...

Final code: If DCount("*", "tblParts", "txtPartNo = '" & Me.sPartNumber.Text & "'") Then 'MsgBox "Match found" 'for testing Else Cancel = False MsgBox "The part number doesn't exist in this database. Please re-enter the part number." 'do some code here End If

With a minor edit, your code works. Had to add quotes around the asteric. If DCount("*", "tblParts", "txtPartNo = '" & Me.sPartNumber.Text & "'") Then Cancel = True MsgBox "Duplicate value" End If Thanks for your input!

Odd that you mention this because I am working on this as well, I assumed understanding the textbox would aid me in understanding a combo box. Thanks ;) Edit: Its not as pretty as my userform but it works quite well, again thanks for the tip!

Thank you for the info. If you would lend your time further. I get an error with this string Private Sub sPartNumber_BeforeUpdate(Cancel As Integer) sPartNumber.Value = DLookup("txtPartNo", "tblParts", _ "Criteria = '" & Forms!Form1!sPartNumber & "'") End Sub I do not know what the...

FWIW You can save data to the registry. Example: sLogin is the User Name entered into a textbox. You can save the value. SaveSetting appname:="AppNameHere", section:="SectionNameHere", _ Key:="Login", setting:=sLogin Where AppNameHere" is a label you make up Where SectionNameHere is...

(Solved) Using a textbox on a form with a table Hi, Im quite new to Access and database design allthough I have practical VBA and VB experience, I notice I dont have enough to do minor techniques in Access. :rolleyes: I have a textbox on a userform that a user will type in a value and I would...

Yes, I am just confused on how it writes to a workbook and where the workbook is located. Thank you for your help ;)

Thanks, that definately helped. The text in Red, where does this workbook go? I would think it makes a default name "Book1" but it is never displayed. Perhaps Im am seeing to much into this and dont need to know about the workbook?

I didn't catch this in my intial reply. There is no "sligthly imprecise" about "90*0.7", it is the same as "90*7.0", both should always result in a WHOLE number. Using excel I set up a formula "=SUM(90*0.7)" and set the cell to 100 decimal places. This number is the result of the same...