Recent content by lilywong

any thread to describe this in detail? thanks

how am i enable the main form to be auto populate when i click the access database? e.g. the main form is the login page, so when i click the access database, the login page will auto prompt (i do not need to click any form). and also, the tables will be hide from the system . pls advise, thanks.

if i create a shortcut on each individual user, and user login to the database by clicking the shortcut on their desktop, will this works?

I have a tracking access system written in access 2007. however, the system only allow one user to login to the same system at one time. the system is being locked once a user has login to the system. how do i allow multiple users to access to the same system at the same time? pls advise.

If Status = "Y" Then CDNo.Locked = True Else CDNo.Locked = False End If i try this but it is not working. both record also can be updated regardless of Y or N. what i want is, if status = "Y" --> allow update record if status = "N" --> not allow update record thanks.

i have a search database created in access. i want to have a checkbox, so when i tick the checkbox (checkbox is checked), it can log the database so no one can change the database after the checkbox is checked. if the checkbox is uncheck, then we can update the record. any idea? thanks.