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?

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!!

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'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!

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...

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...

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!

i was trying set row source by sql string in vba code for a list box, why when i open it, there is nothing, i use the same way to set up row source for combo box, it works fine, or the list box is different with combo box? the code is: Me!lstResult.RowSource = "SELECT Invoice.ID " &...

is there a way to write a macro which can be runed to find all the worksheets in a workbook, then i am able to run other things to do with those worksheets. thanks for any help!

this array contains a set of ID number where those records will be updated and it is result from user input on form A, and updating things will be done on form B, therefore i have to pass that array from form A to form B, how can i do that? really appreciate for any help!

i'm thinking of create a form which will provide a list of records that is select from a table under certain condition, and each record is present in optional box format, and let user to choose, once records on the form are choosed by clicking and ADD command button is clicked, those records...

i've created a bunch of queries which will update all the tables in certain way(no result return), but there r just too many, even myself can't remember which one is for which, is there a way to put all the queries in order into one query, then when i open this query, it will run query each by...

i thought this query should be working, but when i double click that query, there is a warning msg says 'Operation must use an updateable query'. that's the sql for that query, what's wrong with that? UPDATE Acc, [CpyAccTbSun] SET Acc.Suspend = (SELECT [CpyAccTbSun].Suspend FROM...

i've set up several queries and one macro, which will open all the queries i've done, and then i have to write another macro to copy each queries result to each table, but i have no idea of how to copy from query result to table, would be really grateful if anybody could give me a clue!

i've created a form which allow user input data, those data will be saved in to several tables by clicking 'add record' buttom, but once the button is clicked, a message box from access always appears, says "You are about to append 1 row(s) once you cliked yes you can not ...", and let...

i'm doing a userform which is in a datasheet form, that allow user to in put data as much as they can and save into table1, after they click the bottun OK, then i'll copy all those block of data to table2, all i can do is select each in each field and each record from table1 and insert into...

i'm pretty new with access vba, i've written this small piece of code, but got Type mismatch error on this sentence, "Set rs = dbs.OpenRecordset(sql)", couldn't figure out why this is happening. that's the code below sub query Dim sql As String Dim rs As Recordset Dim dbs As Database...

i am doing a database which has been set up security for a group of user, very time, one user is logged in, when he/she add records or update records, his/her name is supposed to be saved automatically in the table where they add data in or update data. how do i get their user name? thanks a lot!