New to Access

[orange]

Good stuff Dave!

[Capt Scott Cook]

That looks amazing. Dumb question and I should be able to figure this out on my own. I didn't include all of our groups. It is a simple Copy past thing and give it a group route name?

[davegri]

That looks amazing. Dumb question and I should be able to figure this out on my own. I didn't include all of our groups. It is a simple Copy past thing and give it a group route name?

Not quite that simple. The subscribers must be added to tblSubscribers. The groups must be added to tblRoutes. Then conversion code must insert the key of the route into each tblSubscriber record's Route_FK.
The supplied DB has code in module basConversion to do that, but it was not designed to do it in two steps. Did you see my PM?

[Capt Scott Cook]

I did, I will have to try and get an account set up today.

[davegri]

I did, I will have to try and get an account set up today.

No, I don't think you did. Your account here is blocking private messages (PMs). If you aren't willing to communicate via PM, then I can't continue assistance via this online thread.

[Capt Scott Cook]

No, I don't think you did. Your account here is blocking private messages (PMs). If you aren't willing to communicate via PM, then I can't continue assistance via this online thread.

Excuse me you asked if I had Skype. I do have Skype installed. I have yet to set it. I am sorry some times at work I get busy and when I get done working I have other real life things to do. Fire calls to attend. Take care of the family make dinner life stuff. So I am sorry I have not communicated with you.

[davegri]

Excuse me you asked if I had Skype. I do have Skype installed. I have yet to set it. I am sorry some times at work I get busy and when I get done working I have other real life things to do. Fire calls to attend. Take care of the family make dinner life stuff. So I am sorry I have not communicated with you.

You must have me confused with someone else. I never use Skype.

[davegri]

Scott, did you get satisfactory resolution to your posting here? The thread seems to have come to a dead end. Your account at this forum is still blocking private messages so I can't reach you with that method.

[Capt Scott Cook]

Scott, did you get satisfactory resolution to your posting here? The thread seems to have come to a dead end. Your account at this forum is still blocking private messages so I can't reach you with that method.

I don’t know how to unblock private messages or I would respond to you.

[davegri]

like this:

[Capt Scott Cook]

Yeah I dont have that on mine..trying emailing directly if you wish scook.gcfd@gmail.com