Recent content by DemonDNF

Woohoo! I figured out question 1; I added msgboxes every time I touched txtMessage and I clear it in cboSpecs_AfterUpdate. D'OH! So I'm left with question 2; how can I get to the old value in cbospecs.column(1,1) when ListIndex is -1? Robert

Yup. Reread the post #2, I use a textbox to add new values, the combobox is used only to modify an existing record. As I was producing the pic above for you, I noticed something weird as I was switching views between VBA debug and the form. txtMessage is displayed on the form until...

This is how I use a textbox and combobox to handle add, modify and delete. Clicking on ADD activates a textbox to add Specs in bulk mode. txtMessage is updated and displayed after Spec s4 has been added in AfterUpdate event (now ready for next new entry). Clicking on MOD activates the...

A 2 part question. SQL related with Spec combo box: SELECT S.Key, S.Spec FROM tblSpecs AS S ORDER BY S.Spec; NotInList code: Private Sub cboSpecs_NotInList(NewData As String, _ Response As Integer) ' MODIFY SPEC ENTRY. 10 Dim db As Database 20 Dim strSql As...

I'm using a modified version of this error handler: http://www.utteraccess.com/wiki/index.php?title=Image:ErrorHandlingTutorial.zip It has a feature to auto-send an email via outlook when an error occurs. I would think it has everything you need. I removed that feature because I don't have...

---- Edit: That's the problem, Value is the correct technical term for this field. And I can't prefix it, tblValue is linked to tblSpecs which is linked to tblParts. Parts can be anything; resistors, capacitors, transistors and who knows what electronic component that I have not used yet...

Here is the manual insert:

This is from a SAVE RECORD button: Private Sub cmdSaveNewValue_Click() 10 Dim db As Database 20 Dim strSql As String ' Add new tblValues entry for New Value textbox. 30 Set db = CurrentDb 40 strSql = "INSERT INTO tblValues (SpecID, Value) VALUES (" & _ txtKey & ", '" &...

Galaxiom, I knew it, I can see the future! Robert ;)

Lightwave, check out the tool in post #4. It's open source too, so you can open it up and take pieces that suit your needs. I just looked at the main screen, haven't had time to look at what goes on in background. I glanced through the help file, didn't understand everything 100% but I...

I've also been looking for a way to force a record to be added/saved, thanks! Robert (this post is to thank, and to help me refind this info quickly when I forget)

I am more interested in an installer-level password. Access 2002 information is all over the web. Anyone that reallly wants to can get into the MDB. It won't do them much good if forms, reports, VBA etc are in an MDE. This is targetting hobbyists with a specific need; priced similar to...

I haven't seen anything from stopping a user from opening the data MDB and playing with the tables directly. I do understand that using an MDE for the "program components" protects my work to a limitted degree. Is there a way to lock the data MDB from user editting? Do you know of a utility...

LOL That is excellent. I was going to do a skeleton version; a form to manage the path to the data MDB and storing it in a hidden table. That puppy does it all, neat stuff! Robert

Like I said in post #1, it is mainly to make things easier if I have to send a user updated VBa code, forms, reports, etc. In theory, the intent is to market this MDE. :D It is intended and designed for single-user environment. I guess I answer my own question because if I send the user an...