Recent content by Yu2008

hey thanks much Bob. I'll try.

Thank you Bob. * Yeah, I need user level security, only *.mdb work with it, right? * This is how I do: 1. Open a Main Form 2. The user types a Customer Name in and then 3. If it is a new customer, Access asks "do you want to edit the items in the list" (see attachment), click yes...

Oop, that is not fun though. I have to use .mdb for multi-user to access. Is there a code that can realize this humble function in .mdb? I mean when the user type a new customer name in the Main Form, the Customer Form that called from there can show the new customer name automatically and...

Fantastic. Thanks!

Thanks Bob! oh... I see. that would be another big job for me though 8-) .

Hi, I have a Customer Form that is used as the 'List Items Edit Form' in the customer field of a Main Form, and I embed SetTempVar at Customer Form. In access 2007, If the customer name that I typed in Main Form is new to the customer data, the Customer Form will be called, and the name of...

Code: hide access ribbon but show refresh button ? Hi, I am wondering is there a code that can hide the ribbon but the refresh button? Thanks, Yu

I took off the default Admin from Admins group, and set myself as administrator, then log in, create new users and groups. But after I log out and try to use the user name to log in ( leave the password place blank as the book said), the Access just doesn't allow and pop up the message saying...

Still very very confused at Access security set up ........ but found a way which is just delete the system.mdw, and then open again any database file, by this way, Access will create a brand new system.mdw. and I won't be bothered by password key in on all files and add user/group button comes...

Sorry have to bother you again, Bob. Access just doesn't work with me, same asking password problem comes up again. So I Run again Docmd.RunCommand acCmdWorkgroupAdministrator at VB, and then Join, enter. But this time even after doing so, Access still ask me password?! And even worse, I...

That works! Thanks a lot Bob!

Hi thanks Bob! But now Access2007 force me to log in password for whatever file I open, any clue how to resolve it? and How do I clear them all and start over on the security set up?

I am using Access 2007, but most people in our office use Office 2003. So I saved my dabase as 2003 version to share data with them. ** However, after struggling hours try to figure out how to set security in Access. I am surprised to find that on my computer, when I open the database in old...

Got it, thanks! I'll try!

Hi Bob, thank youuuuuu. Q1 : But vbCrlf doesn't work to me. When I run the report, Access asking me to enter parameter value for the vbCrlf. ?! below is how I code: ="Criteria Selected were: & vbCrLf & Select Model - " &[Forms]![Inventory Balance Inquiry Form]![cboSelectModel] & vbCrLf & "...