Search results

RuralGuy you are a genius!!!! It worked!!!! Thank you sooo much I don't know whether it is bound... I don't know what that means :-) I think I have been a bit ambitious with this database lol... it's getting there slowly though! The next step is to update the comments shown on form one with the...

I have used some queries, infact I think I have used way too many in other areas, but in this case I haven't

Private Sub Form_Load() End Sub

Thank you I noted that he Ridders is from Somerset :-) In terms of the frm_addedit_comment it saves data to another table that I called project_comment This links the project_ID, Employee_ID, comment, date_time stamp. Hope that makes sense

I'm using a combo box incase the user decides to switch the comment to another project? But I could just do away with this is need be and only let them add a comment to the project they are in?

@ridders haha I can't help but feel sorry for the next person who googles and stumbles by this post and has to read all my questions, just to get what they need done... but then again maybe it will help someone else out if it is very basic!

OK I understood what you meant reading it back and changed that line. I've tested the button and it just loads the form in the same way as before

Hello, yes I am still here :-) So if I clean up the yo... to to... where am I pasting this code though? I closed the btn code as it opened the form, so do I just continue on in the same place?

Ok so to be clear do I apply this code to the second form now (frm_addedit_comment)? Also, I'm laughing at how dumb I am because I don't know if when you say yo... if you are talking or I need to actually paste the whole thing in there?

Yay that worked! So far so good, so that opens the form. Now I just need to set the combo box in the second form to the project_ID that was stored in the original form. thanks so much for your help.

That didn't work, it says the form name is spelt wrong... Just to check, this code is being applied to the button in the first form? It needs to open the form frm_add_edit_comment

Hello, I only see this in there... Private Sub btn_add_comment_Click() End Sub

Hi, thanks for that. I'm in the UK and don't mind waiting for a response - I'm just thankful people are!

Hello, I've added the button but cannot see how to open the code for this. I'll see if I can read up on the help guide again. Thanks,

If you could post a clear instruction then I would be happy to paste in code. Like 1. open first form , F7 to open code, paste this: 2. open second from, F7, paste this: Something like that, easy to follow, I will be glad to work with! Then I can use this example for the rest of the database.

Hello RuralGuy, Firstly, thank you so much for your quick reply - I've never used this forum before and I was so shocked at how fast your message came in! I'm sorry to sound ungrateful, but I have looked at your example... and I don't understand :-( I'm way too beginner at the moment to see how...

Hello, I am a beginner so if anyone is able to help I was hoping for a clear explanation please :-) I have two forms and a button [1.] frm_view_project (includes a project ID, project name and some details, and a button: [btn_add_comment]) When I click this button it loads: [2.]...