Using VBA to get data from Access into a userform

[SCOTTY9]

Hi all,

First time I've been here! I'm kinda still learning VB at the moment so struggling a little bit with this.

I'm currently working on something that requires me to use an access database with an excel userform.

I have a team of around 50 people who will be making outbound phone calls and the data for these calls is stored on an access db. The people calling don't have MS Access so I've created a userform for these guys in Excel, which they have on their computers, and I want them to be able to click the button "Get Next" on the form and up pops the next customers information to call.

I have a userform with some text boxes where I want the info to appear on click.

I have customers name, their mobile handset type which the ordered recently and their phone number.

So I've started off with the following which seems OK:

Please Login or Register  to view this content.

At this point I'm unsure what to use next.......someone suggested a DLookup but that didn't quite work......

I'm also wondering if I'd need something to send to access to basically say that customer 001 has been pulled through already and to move onto the next because there will be 50 people using this (max) at one time.

Any help to set me in motion is much appreciated.


Thanks,
Scott.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Arkadi]

I suggest adding a field in your table to mark the customer as already contacted or not. Can just make it a yes/no field, and then select only those customers not already contacted. What I am putting as code is only to get the records loaded in your recordset, and assigns some values from table to variables. It would also mark the customer as contacted.
Hard to be exact as I don't know what database fields you have, what the table name is/are, etc. but basically:

Please Login or Register  to view this content.

[alansidman]

Have you considered putting Access RunTime (Free) on all your users computers? Splitting your db into a FE/BE and running everything in Access?

Scroll down on this link to learn about RunTime if you are not familiar.

http://www.hitechcoach.com/

[SCOTTY9]

Thanks Arkadi, I'll give this a go. I'll just edit the names for my database.


Alansidman, in an ideal world our IT dept. would allow us to install these things. Thanks for your help. I'll take a look at that for my own education


Thanks,
Scott