Recent content by SetanPutih

Hi guys, Some help would be much appreciated. I've created a database containing client details. Amongst the client details is a photo of the client attached. Why does Access sometimes rotate the photo? How do i prevent this from happening so that all photos appear as portrait? Thanks

It works! Thank you arnelgp. I'm very grateful.

Hi arnelpgp, please can you help me ressolve this issue https://www.access-programmers.co.uk/forums/showthread.php?t=305954&page=2 I'm so close to finishing this database but i can't progress beyond this issue. Thank you so much as always.

So the way the database works is once the database is opened the login window "frmlogin" appears (Picture 3). Once a member of staff matches their name and password they are direct to "Form1" which is a control window where the member of staff can access reports and apply for annual leave etc...

Thanks @Gasman, Unfortunately, I have no idea why it doesn't direct me to "frmPCSManager" once I press the login button but it does when I exit the login window. Even after I've gone through the code line by line. I'm learning a lot about Access every day but I'm just not at the point of being...

Thank you both for your input. The database is very nearly finished but I'm still having problem with the Admin login. This is the code for the timer event (picture 1) This is the code for the login form (picture 2) The problem is now when I login as admin, nothing happens. The screen just...

Hi arnelgp, Thank you for your input again. I have just tried what you suggested. 1) Add an unbound textbox to Form1, name it txhHidden. Set it's Visible Property to No. (Picture 1) 2)Add code to Timer Event: (Picture 2) 3) On the login form, add this change (Picture 3) As you can see from...

The database in built around the database you sent me (Picture 1). The Login form appears as soon as the database opens. Once the Login form is completed correctly, it directs you to Form1. Currently, if I enter the correct name and password the Login form remains and nothing happens (Picture 2)...

Once I put in any login details and password the login screen remains inactive. Once I exit the programme it tells be there's an error. If i got to Debug it pops up with this another error (Please see picture). Thanks again for your time.

Thanks for your reply. Unfortunately it still doesn't work. When I'm on the Login screen I put the name and password it and it doesn't do anything. It just stays on the login screen.

I'm sorry Arnel. It's still not working. I appreciate the help as always.

Hi Arnel GP, Thanks for your help. Unfortunately it didn't work. Please see image below. Thanks

Hi, Hope someone can help with this. I want Admin to be directed to a different form after login. Currently all Employees are directed to Form1. I want Admin to be directed to Main. The login code can be seen below. Can anybody help please? Private Sub cmdLogin_Click() Dim strID As String...

Hi, Hope someone can help. I've built an employee database with a login system. What I'm trying to do is, when someone logs in with the name Admin a button becomes visible on the window which the login window leads too which would not be visible to everyone else. The button will be called...

it Worked! You legend! If I could buy you a pint I'd buy you two. Thank you