Search results

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...

Hi, I have separated the data from forms/reports/etc to facilitate future updates: - Program MDE - Data MDB (if I understood forum threads properly, this is the recommended technique) What is the normal way to deploy these? Do I just provide the user with instructions to link to the...

The only difference I can think of is performance. My tables will holds hundreds of records. How many will yours hold, millions? Robert

I've been pulling out my hair trying to figure how to use IF PartName <> PreviousPartName when PartName lost focus; it quickly became a nightmare. EDIT 2: Solved! Checking for keypress set me on right track, added a shared table checking module that reduced complexity. Robert

I don't know if this is possible from VBA. I have a main Part form and a Spec subform linked via Part key. I need to add 6 Spec records automatically when a new Part is added so user can select desired Specs (default value is "n/a" for al 6 entries). Right now I have the Spec entries...

I tried to import this into Access 2002 but it seems as if this is for a more recent version (it's not in the available list of suffixes). Has anyone converted this to Access 2002, or earlier? Robert