VBA Entry and Verification Form

[Asevens]

VBA Scripting is NOT my strong suit. (VERY BASIC USER HERE)

I have a data set of users due for a PC refresh.
My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs.
Wondering if someone can assist me in creating a simple userform that I can hide the data set in, have the tech input a username, receive confirmation of equipment to be received and then select date equipment given and the name of the technician who gave this equipment out which is then recorded in the dataset viewable to myself or my manager but not techs.

Thanks in advance

 

[Paul Ked]

Don't understand this

My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs.

If the Techs are filling out the data sheet they'll know all the details.

Also would need the categories/details/layout/where it's stored etc.

 

[Asevens]

Sorry, I always get kinda slow here and forget to include data.
I have on Sheet one (which I will hide against tech view) the following headers (A through F)
Username, Full Name, Alert Email Sent, Scheduled Pickup Date, Actual Pickup Date, Technician

I have built a userform, what I would like is for the tech to input the username, click commandone, the rest of the form fills out the above information, the tech then selects the proper date and their name (text box for date and combo for tech name) then clicks commandtwo and the missing information is added to the dataset without the techs seeing the back end and the form is reloaded for use again. There is other data held in the backend that is sensitive and has to be included for reporting purposes but not available to techs.

Is that any clearer?

OH I'd also like the Userform to be the only thing Techs have access to, IE they cant close it or move to another sheet to view data.

 

[Paul Ked]

Can you post a link to the file? I'll help you out on that rather than duplicate your efforts.

 

[Asevens]

Unfortunately due to the sensitive nature of the data and sharing restrictions in place by the Org, I cannot upload the file anywhere.

 

[Paul Ked]

OK, leave it with me for a bit and I'll post something for you to have a look at.

 

[Paul Ked]

Try this https://1drv.ms/x/s!Av8oW8_xzD3EqygqtsAJo-wA16vT?e=q7jaC7

The password to get out of the form is 123456 although it's very easy to get out if you know a bit about VBA

 

[Paul Ked]

Sorry, I missed the Tech from Combobox bit! Added here https://drive.google.com/open?id=1_4qRlDvfaWAB4SaQnsebFWH9w6qfTxi6

 

[Asevens]

Alright, so looking at yours, it is a bit off from what I am trying to do. I will try to upload my userform this weekend since it is not necessarily connected to data. It may be easier to see what I am trying to accomplish that way.

IDEAL work, Userform loads, tech enters username, clicks commandbutton1. Full name, scheduled date, and actual date auto populate, based on dataset and actual date event occurs, Tech then enters their Name (drop down, combo) and Serial # of device (new requirement) clicks on commandbutton2 and information is written to appropriate row in dataset, form is reloaded and good for re-use.

I may just be dreaming of course.

 

[Paul Ked]

Ok, try this one.

https://drive.google.com/open?id=1DVZ_AOIIyesSihnBGgF36hDtQQCsCyYT

I have left the 1st button out as why select then click? That's an extra step that is not needed, just select username and the form fills automatically.