Search results

maybe u can create a shortcut with target section filled in "Access Installation Direcotry" & " MSaccess.exe" & "the mdb directory" & "/runtime". Just give a try, it works in my side

just wondering why use"Me!" instead of "Me." maybe, u can try to unlink and relink your reference library. sometimes, problem comes from the virtual dead link meaning the library is ticked, however, due to whatever reason the linkage is broken or damaged.

actually have a few solution. (a) you can assign different users of varies of capability by creating accounts. everytime, the user is trying to use the database, he/she has to login before getting the permissions and rights intended. (b) Just as somebody previously mentioned, actually u can...

through my understanding, instead of deleting the table each time and create tables, delete those records might be more effective. actually, u can put a timer inside ur source code, to check which way takes lesser time. hope it is useful

maybe u could explain bit more into detail

the thread absorb all the knowledge..? sorry, i am not quite sure how to find the sign or criteria when the thread was found out to absorb all the knowledge it needed. I just mean to discuss and share info (if anybody think useful) with all those keen and needed buddies. If you find info...

chr(34), em..... a new method, would try later :)

lost completely, pls let me know what u mean . reminder??????

also confused about the message above..????

I agree with tehNellie's points on difference bewteen array and recordset. but actually, there are also similarity . we could not tell which one is better in general, it really depends on the situation encountered. e.g only--- there is one table we have frequent comparision and manipulation...

when i have a lot of un-sorted or unlinked data to put into a more organized order for delivery or presentation of information ( such as report, or create a new table with specific format).. you have to put in more coding efforts to use array than use recordset, and of course, it would bring...

here it is, this function seems easy, but still require a bit of thinking to finish it, anyway, enjoy it

i also run XP. 10 cells takes about 10 seconds, that's really bit slow. this morning i test again , found out with 1 selected column of data (27 cells), it takes 0.2 seconds. I guess there should be some other computation-consuming functions involved or triggered without your notice. Anyway...

it's ok. I would suggest you declare one variable with string data type under the Onchange event of the listbox, and then proceed with the SQL statement. anyway, all those codes would be preferably implemented in VBA

acutually I have tried your code with some dummy data, found out the response is quite ok with out noticeable delay. is it because u have some other applications running background? btw, my pc is core 2duo with 1GB ram

a listbox would be heplful, actually the preview button might not be necessary. Guess you can adjust the "column count" and "Column width" property of listbox to get the effect u want. Another way is to : store the listbox selection value into a variable , lets say it lstItem in ur SQL...

my concern is about where to store those passwords securely... or just use hashed password and make the hash function not easy to find.. really confused, anybody could stand to voice out? thanks