Search results

I didn’t know how else to title this--and I am in the process of learning some things in Access--but I have a database where I have, I believe, a one to many relationship between two tables. I have created a main form that is based on tblHub and a subform based on tblNode with a combo box on the...

Oooh! I wish I thought of that!! Thank you, plog. I appreciate your help.

(Yes, I'm sorry, I got off track b/c my 1s,2s, 3s, etc. for the Status field I thought was converted to text and so it wasn't populating my Status combo box on my form. I think I was actually looking in a record that wasn't supposed to have values. I'm sorry about that.) Yes, though I have...

Yes, I do have a table for Status' that has complete, not complete, etc. And I'm trying to put the primary key value from that table into my node table, which has the text, complete, not complete. Here is my node table with the statusID after the update query with what I thought were the...

plog, Yes, then that must be why I'm having so much trouble populating my combo box for the StatusID on my form. It is b/c the numbers I'm updating that StatusID field to is not a number b/c of this query. What I'm trying to do is change my text values, like Completed, Not Started, etc. in the...

Hello, I am updating the StatusID field in a table using an update query. Can I update one field with different values in the Criteria field and the Update To: field? I have to update the values if StatusID says "Complete" update to "1", if StatusID says, etc. (pic below)...

ANSWER: I had to create a subform based on the Node Table of just the Node Names, Node A and Node B, and add that subform to the Node Setting pop up form. https://drive.google.com/open?id=0B9IyKJSJ52ghRjh4X19YSDZ3UUE Now when I click to open the pop up form from the parent node subform, I will...

OK, I am taking some tutorials, so I will post when I work at that part of it b/c I think that is the problem, too. Everything else like how I set up the command button to open the pop up form, etc. is by the book/these tutorials I'm taking, so something is wrong elsewhere. I will post when I...

The problem, IMO, is that the subform and the popup form do not draw data from the same table. That is true, I created a separate NodeSettting table that the Node Setting pop up form (NSPU) is based on. This table has NodeSettingID, NodeID, NodeA, NodeB, and some foreign key ID fields for some...

I don't know if you are still assisting with this issue, MarkK, but I've opened the pop up Node Settings form and selected the NodeID field on there and put the path below in the default value property of that field. (BTW, Please let me know if you have halted on this project, so I can close it...

Hello, MarkK. Yes, when I added the new cmdOpenSetting button (the "Open Form" button on the subform), I used the command button wizard, which embeds a macro in the form. I'm sorry b/c I should have mentioned the embedded macro more explicitly. I mentioned that I've removed the code you worked...

Hello, I've uploaded the database. Thank you for helping. I've tried some other steps below and, per the classes I'm taking, these should work, but the command button to open the pop up form is not opening the Node Setting pop up form to the corresponding Node from the subform. The pop up...

I'm using the code you last provided, the one from 12/8.The code is behind an On Click event of a command button, I call cmdViewNodeSettingsFrm. And the command button (it looks like text b/c I made the background of it transparent) lies in the subform. You can see it in the pic where it says...

Sorry for the delayed reply; I did nothing this weekend. I need 3 conditions, but I think I will just leave it with 2 conditions as you have it. I did want the pop up to be read only if it was not a newly added record, but I think you were talking about the time stamp thing. You have fixed the...

I'm sorry, I might be able to try it today, but I will aim to try and reply tomorrow. Thank you!

MarkK, Let me look into this tomorrow b/c I forgot that if it's a new record, I will need to add the values to the blank form, but I do need still need the new record's pop up to open to the same node as the originating subform. I will look at this tomorrow and let you know what happens. Thank you!

Thank you, MarkK. I added the code you listed and this time my Node Settings pop up form has the field text boxes on it with the labels (so it's not completely blank), but the values are missing. https://drive.google.com/open?id=0B9IyKJSJ52ghY3lEbDhoS044U0E I see a new record that I just...

Just checking back to see if anyone else has any help? I'm trying to get Access to not open a pop up form when the record in the continuous subform is blank, open the pop up in read only when the record in the subform already exists, and open the pop up in add/edit when the record in the...

Yes, I've had that happened to me, as well. I do like the OP (original post) says and draft my question in Word, and then copy and paste to the forum. I think you have to add links or links to pics after you paste your text to the forum and use their tools to do all of that. Helpful forum...

Hello, --Yes, NodeID is the ID of the node I tried to save in the subform. --Do you know the code save the record if it's not force the dirty to update? I would like to have the command button to do 2 things to a new record: save it and open the pop up form in edit/add mode. --I'm not sure...