Didsi
asked on
Visual Basic Help
Hi,
I posted a question a few weeks ago which was answered brilliantly by 'VipulKadia'.
I have created a visitor signing in/out system form that information, however it has slight problem before i can declare it finished.
The basics are, you sign in using the userform, this fills in values on sheet2, when you sign out a list of people who have signed in on the current date and have the value 'TRUE' are shown. selecting one and clicking sign out changes their value to false.
However, in order for this to work the userform needs to 'end' rather than 'endsub'. If i use the command 'end' then the 'userformstart' needs to be opened again.
i need it to go back to userformstart after the user signsout.
Hope that makes sense, Many Thanks
I posted a question a few weeks ago which was answered brilliantly by 'VipulKadia'.
I have created a visitor signing in/out system form that information, however it has slight problem before i can declare it finished.
The basics are, you sign in using the userform, this fills in values on sheet2, when you sign out a list of people who have signed in on the current date and have the value 'TRUE' are shown. selecting one and clicking sign out changes their value to false.
However, in order for this to work the userform needs to 'end' rather than 'endsub'. If i use the command 'end' then the 'userformstart' needs to be opened again.
i need it to go back to userformstart after the user signsout.
Hope that makes sense, Many Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that shows the form, applies signout, but does not close the userformsignout
It should do. The code in the button click hides it, returning control to the calling routine, which then unloads it. Is that not happening for you? If not, please upload the file as you have implemented my code.
Regards,
Rory
Regards,
Rory
ASKER
Sorry, i had missed a bit!
That has worked, could you please briefly explain what that code does!!
I didnt realise there would be an issue with same surnames, would you mind suggesting a solution!, if you would like i will post a new question with points availbel.
That has worked, could you please briefly explain what that code does!!
I didnt realise there would be an issue with same surnames, would you mind suggesting a solution!, if you would like i will post a new question with points availbel.
I thought I just had explained what it did - can you specify which bit you need clarifying? :)
ASKER
so you did, sorry! not on top form today!!! Thanks, I have posted a new question regarding the problem you found. https://www.experts-exchange.com/questions/25017543/Visual-Basic-visitor-system.html
Just responded there! ;)
ASKER
Visitor-System-V6.xls