Search results

Hello Pat, Thank you very much for detailed post as it very helpeful and I understant it much better. I agree that third option is the best and I will definitely go with that. Can you tell me what are the disadvantages of this method? Which are the main differences in compare with...

Hello, I have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel...

Hello, Thank you for quick reply! I have already tried that but I get this error message http://img826.imageshack.us/img826/5323/06012013170525.jpg What am I doing wrong and is there any other solution perhaps? Thank you, Adi

Hello, I would like to prevent user, on new form I made, that when he enters same value more then once, with some warning message "You can't add same value again, please try again." For easy explanation I have made screenshot I think I could create some code for "After update" event of...

Any suggestions? I still can't solve this issue.. The only temporary solution I have found is to make copy of problematic report and then I can awoid the issue but not for long because it happens again! Your help woud be greatly appreciated. All the best, Adi

Hello, I have recently copied some simple table from Excel to Access report which worked great for few minutes and then it stop working and it shows this error: Problem signature: Problem Event Name: APPCRASH Application Name: MSACCESS.EXE Application Version: 12.0.4518.1014...

Hello Rx, Thannk you very much for your reply, it helped a lot. Please note that I am still searching through database examples in this forum but I still can't find something solid. Your post helped a lot and I will try to make something on my own based on your suggestions.. In the...

Hello, It is for adding new records and your post helped a lot! Thanks man! Happy hollydays and all the best. Adi

Hello, I really hope someone can help me with this, please see screen first as it explains a lot: If user didn't fill any record on form named "Test form" you see on picture I would like to sett warning message, and If user did fill one or more record, then user can exit without any warning...

Hello, In my access database I have one simple table called "Transactions" like this with example data and all that data will be pulled on specific way through one simple form called "Test form". It should all work similar to this This is detailed explanation.. When user clicks on combo...

p.s. This how I came up with idea to conver Microsoft Access to hosted MySQL database using ODBC to allow remote connections: http://www.utteraccess.com/forum/Ms-Access-Cloud-Computin-t1962593.html

@jonathanchye I like this possibilitie via Amazon Cloud but I really have no idea to connect table stored in Amazon Cloud with front-end in Access and I am not sure if that is possible:confused: @spikepl I know for remote desktop solution because I use TeamViewer all the time but I this is...

Thanks for sharing this useful info bparkinson!

Hello, I plan to set little program I made for client in Microsoft Access online so it could be accessed from two different geographic locations. Unfortunatly I don't own server or can afford any at the momment. My plan is to share Access database online via VPN and for this I tried using...

Thank you very much for your help, I found the solution and it's working great;) For anyone who will have the same problem, here is the link that helped me solve part of my problem: http://www.databasedev.co.uk/login.html All the best, Adi

Hello, I have just setup Access database on VPN so it could be shared in VPN (using Hamachi) between to different geographic locations. It is basically one user in database. My client wanted to access program from two different sale places. This is what I don't know how to solve: I would like...

Thanks again pbaldy for your help, link you send me was very useful and I understand it much better now. Greetings, Adnan

Thank you very much for prompt reply pbaldy. It looks like that VPN is best solution for me, same as your solution. When you say Remote desktop do you mean applications like TeamViewer? In case of larger professional business solutions where centralized database is located in one city and...

Hi folks, I have a small program built-in Access in which you now want to connect to SQL Server 2008 R2 database using upsize wizard which I have already done but I would also like to enable remote access to this program. For example, a client who is using my program can access a database from...

Hello, I have recently switched from Access 2003 to Access 2007 and I tryed to create new table but after I save the table with some name for example "Test_table" I can't find that table among list of my other tables, not sure why? I tried to create few more tables but none of them is visible...