Search results

hi NigelShaw, that's exactly what i want, greatly appreciate you help. thanks.

hi dfenton, can i store my data in my own server(i have a window server 2003 pc) and share my data through WAN?

thanks a lot, will look through it.

hi Banana, sorry for the confusing question, i just learned from you what is LAN and WAN. what i mean is accessing data through WAN. one of the options you mentioned is using SQL Server, how could i do it. i will greatly appreciate if you could further explain or provide some relative website or...

i mean to use access07 program to access data from 1 place to another place through internet, is this called fr.end(1 place) and back end(another place)?

i am not sure if access07 is able to be used in internet?

i use ribbon toggle instead of form's toggle button because is much simpler and more standardized to create (no need to set the size, location, font...) i want this button to run things automatically when it is true or false by the form timer. if there is no way to detect the ribbon value then i...

can we know how many users are accessing a database in the same time in vba? something like count(currentuser)...

if i use form's toggle button, that should be ok but for ribbon toggle button, it doesn't work. the vba will not read the ribbon toggle button value. that must be something i'm missing..

Hi all, need some help here, i have created 1 ribbon toggle button and i want my form's timer to detect the toggle button value(true or false) in every 30 sec. how can i do it correctly? thanks.

DCrake, thanks for you help, but i've never done the front end back end configuration, and i am not able to catch you idea. can you share with me step by step on how to do it? by the way, i am using m/access 2007. will truly appreciate you help.

thanks boblarson, works well.

how to run a code which will automatically convert to uppercase letter when key in lowercase letter? anyone can help? thanks.

i am currently running a database which is more on information sharing. how do i run a code when i update my data on my PC and the other PC will also be updated automatically at the same time (they don't have to refresh their PC). can anyone help? thanks.

odoyle81, now i am using the 'compact on close' function to compact my database, and this function will automatically compact it when the last user closes the database. it works well for me till today.

Actually i want to learn and use it in VB 08 not access. perhaps i should post in vb08 forum. thanks alot for you advice.

I just wonder how the codes run and want to learn more from vba. would appreciate it you could share.

How to do this by vba code?

Boblason, thanks for your help, but i can only run your code when the allow full menu in access options is set to true. to protect my design, i have set it to false and disabled the bypasskey. how can i run the compact & repair by clicking a button if the allow full-menu in access options is...

I just want to create a button, and do it whenever needed. thanks.