Search results for query: *

i used additional control to add Dialog control to toolbox, but not able to drag the dialog control from toolbox to userform, why? do i have to set other thing first for it? thanks very much for any help!

I've added in the The Microsoft Common Dialog Control to tool box through additional control, and when i was trying to put the common dialog to userform, there's warning says the control could not be created because it is not properly licensed. why?

thanks pgk, but i don't think i'm gonna go for it, cos the owner of the database still want to have the ability to change stucture of database or other things. and thank Francescina as well, i've turned on the security by user-level security wizard, two types of user, owner or not owner. but...

thanks, but, i have to set up the use to full data users who r supposed only use userform to update table. otherwise she's not able to run the userform, and once she is set up as full data users, she is still able to go into the database to delete or add some data in the tables. (with...

sorry, Francescina, i'm still not very clear. i'm going to set up two types of users, one type of users just like full mission of users, they can do anything as they want. and the other type of users r only allowed to use the user-form provided to input data, and update table. they r not...

is there a way of hidding the built-in menu on tool bar when the database is opened? and that menu is hidden for all the user forms. (what i'm trying to do is prevent user to unhide the databasewindos which is hidden, so i want to make menu 'window' in menu bar invisible). thanks million!!

thanks a lot, but there's another thing, is there a way of preventing some certain users to unhide the database, they r not supposed to see, to change or update anything which is hidden. thank u!

is there a way to hide database when it is logged in by some certain people, they can only see and use the userform that i've written, nothing else can be see, like tables , macros, neither of code behide of userform. thanks million if anyone could give me a hint!

i simply put all the queries in a macro, i set action echo to No, and set rest all the queries, last action is set echo back to Yes. did i do it right?

thanks, but it doesn't work.

i've written a bunch of queries, with will compare other database with my one and update my database in certain way, and which is ran everytime the database is openned, but i don't want user to see what is happening behind, is there a way of closing the view of a query? thanks a lot!

thanks million!!! i moved the file to the shared drive, and works perfectly, thank u!

thanks million, it works!

i just finished a vba program on access database, quite long, and i'm supposed to set up security for different level of people, and i did simply for testing,(only assigned myself as fully user), and now program is nearly finished, it will be tested by other people, and the database is on my own...

thanks, but it still picks up No 3. isnt' really working.

thanks for ur reply, but what is 'WITH OWNERACCESS OPTION;'? i had syntax error on it.

i'm trying to select distinct number from a table, i think sql can do that, but don't know how, TableA: No. Status 1 Y 1 Y 1 Y 2 N 2 N 3 Y 3 N 3 Y i want to get distinct number which have all 'Y' status, the result should be 1, No. 3...

great, it works! thanks million!

i wrote a query and ran the sql, i tried to use rs.recordcount to find out how many record there r, but i always got 1, i checked the query, it difinitely returns more than 2 records, why this function doesn't work? any body could help me to have a look my code? thanks a lot! ..... Set db =...

i've turned on database security by user-level security wizard, is there any way of turning it off? (i set up myself as adminstering.) cos i want to get several copies of that database, or is there any way of copying the database without turning that off? thanks million!