Solved Adding Records Using VBA

[Pat Hartman]

Maybe you could assume that i am dyslexic rather than an idiot given that I specified the name of the form and how to interpret the code. I did indeed post the wrong file.

If the OP wants it, I will post the actual file since it includes the example of how to use a query to append a set of records at one time.

 

[MajP]

Maybe you could assume that i am dyslexic rather than an idiot

I assumed neither. I only assumed you posted the wrong file, I do it all the time. But you were coming down pretty hard on the OP, and I am guessing they are like "WTF is going on," especially after @DDJKSA was so polite

Thanks Pat, appreciate the help and your time.

Instead of saying "what is this crap supposed to show?"

 

[Pat Hartman]

All of the experts who answered the original post assumed incorrectly that the OP knew what he was talking about and helpfully jumped right in to solve the red herring. So, the "wake up" comment was directed at all of you rather than the OP. Arnel got the point at least and looked again even though he didn't care for my comment. So, if you notice, in the next comment, I complemented Arnel and very politely and completely explained the actual solution. Then I attempted to post a sample that showed how to actually solve the problem. So, yes, I was annoyed with the OP for completely ignoring my helpful comments. He never looked at the sample or he would have asked WHAT are you talking about? None of that is in the file that was attached.

So, if the OP wants the solution I offered, he can ask and I will post it. Otherwise I'm done.

 

[DDJKSA]

Thanks again everyone, all great suggestions. Really appreciate all the time you guys are giving me.

DDJ

 

[DDJKSA]

Maybe you could assume that i am dyslexic rather than an idiot given that I specified the name of the form and how to interpret the code. I did indeed post the wrong file.

If the OP wants it, I will post the actual file since it includes the example of how to use a query to append a set of records at one time.

Thanks Pat. I did have a quick look at your original DL but couldn't really figure it out so makes sense it was the wrong file. I would appreciate the correct one if could could UL it. Even if I don't use it now it'll be handy for future projects.

Cheers

DDJ

 

[DDJKSA]

All of the experts who answered the original post assumed incorrectly that the OP knew what he was talking about and helpfully jumped right in to solve the red herring. So, the "wake up" comment was directed at all of you rather than the OP. Arnel got the point at least and looked again even though he didn't care for my comment. So, if you notice, in the next comment, I complemented Arnel and very politely and completely explained the actual solution. Then I attempted to post a sample that showed how to actually solve the problem. So, yes, I was annoyed with the OP for completely ignoring my helpful comments. He never looked at the sample or he would have asked WHAT are you talking about? None of that is in the file that was attached.

So, if the OP wants the solution I offered, he can ask and I will post it. Otherwise I'm done.

Hi Pat

I DID look at the sample you posted but couldn't see how it applied to my post and, being a raw noob, assumed it would involve too much work to interpret and adapt, especially when @arnelgp solution works so well. Your very first comment was perhaps intended by you as helpful but was certainly not received as such. You're all taking your valuable spare time to help me out and I thank each and every one of you. No hard feelings.

Cheers

DDJ

 

[Pat Hartman]

DID look at the sample you posted but couldn't see how it applied to my post and, being a raw noob, assumed it would involve too much work to interpret and adapt,

You didn't even notice that it bore no resemblance to what my comment said???? All you needed to do was to ask. If you think that arnel's solution solves your problem then you're right. I cannot help you. Good luck.

 

[DDJKSA]

Hi Pat

You didn't even notice that it bore no resemblance to what my comment said???? All you needed to do was to ask. If you think that arnel's solution solves your problem then you're right. I cannot help you. Good luck.

Not sure why you're so angry, is it because you posted the wrong file, I only looked at it briefly deciding it was too difficult to see how it pertained to my situation, I adopted a different solution or you feel you answered my original post to the letter and others didn't? Do you remember when you first started using Access? Whose help would you have responded more positively to? I did ask for the correct file a few days ago but you never posted it so you've clearly taken the hump with me for some reason. Have a great weekend anyway.

DDJ

 

[Pat Hartman]

I'm not angry. I am disappointed that you think you've got the answer though. Good luck.

I remember my journey learning Access which continues to this day. You'll eventually figure out that the people who answer your questions are answering from the pain of having made the same mistake themselves. But, when you remember your solution to the mistake, you are then able to help someone else. In my case, I've been using RDBMS' since long before I discovered Access so I never did attempt to create a solution by creating fields on the fly. I always knew that would be wrong. I came to Access already understanding relational database design. But there is still always the siren call of ignoring normalization and resorting to hard coded buttons, checkboxes, etc and we see it frequently enough to relate.

Nothing you have said so far has convinced me that you have the solution you were originally looking for. The database arnel posted is a start but it is incomplete. It gives you an idea of how the data should be stored correctly but that is only part of the problem. I tried to explain how to get all the way but you don't seem to have any interest or you simply cannot yet see that your solution is incomplete so let's just leave it at that. If you ever decide you want to see the example I intended to post, let me know. Eventually, you'll get tired of having to enter each row separately.

 

[DDJKSA]

I'm not angry. I am disappointed that you think you've got the answer though. Good luck.

I remember my journey learning Access which continues to this day. You'll eventually figure out that the people who answer your questions are answering from the pain of having made the same mistake themselves. But, when you remember your solution to the mistake, you are then able to help someone else. In my case, I've been using RDBMS' since long before I discovered Access so I never did attempt to create a solution by creating fields on the fly. I always knew that would be wrong. I came to Access already understanding relational database design. But there is still always the siren call of ignoring normalization and resorting to hard coded buttons, checkboxes, etc and we see it frequently enough to relate.

Nothing you have said so far has convinced me that you have the solution you were originally looking for. The database arnel posted is a start but it is incomplete. It gives you an idea of how the data should be stored correctly but that is only part of the problem. I tried to explain how to get all the way but you don't seem to have any interest or you simply cannot yet see that your solution is incomplete so let's just leave it at that. If you ever decide you want to see the example I intended to post, let me know. Eventually, you'll get tired of having to enter each row separately.

Hi Pat

I appreciate your feedback but as the OP it is surely my decision whether or not my problem (and, yes, perhaps not initially phrased correctly) has been solved and yes, it has, so again, thanks to @arnelgp for his/her help. That said, I understand it didn't answer the original question of inserting rows/records into a table using VBA. I am still interested in getting your solution (as I have already stated) and even if I don't need it for this particular occasion I'm sure I will need it at some time.

Regards

DDJ

 

[Pat Hartman]

Here it is. Review my earlier post to see what to look at.

 

[DDJKSA]

Here it is. Review my earlier post to see what to look at.

Thanks Pat, really appreciate it. Once I've finished up with my current project I'll have a play with it and will no doubt come back with a ton of questions to bug you with I'll obviously have to get much more confident with the design and use of sub-forms.

Thanks again

DDJ