Search results

  1. A

    Publishing access database on web, how and which way is the best?

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

    Publishing access database on web, how and which way is the best?

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

    Warning message when user accidently tries to enter same value in form, how?

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

    Warning message when user accidently tries to enter same value in form, how?

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

    Report crash (Fault Module Name: StackHash_5d56), why?

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

    Report crash (Fault Module Name: StackHash_5d56), why?

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

    Loop through a Table and return the one or more values

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

    How to make control when user clicks on Exit button of Form to warn user about...?

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

    How to make control when user clicks on Exit button of Form to warn user about...?

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

    Loop through a Table and return the one or more values

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

    Access database shared online between two users at no cost - possible?

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

    Access database shared online between two users at no cost - possible?

    @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...
  13. A

    Access + SQL Server: remote access

    Thanks for sharing this useful info bparkinson!
  14. A

    Access database shared online between two users at no cost - possible?

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

    Prevent more than one user/IP in adding/editing information in VPN

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

    Prevent more than one user/IP in adding/editing information in VPN

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

    Access + SQL Server: remote access

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

    Access + SQL Server: remote access

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

    Access + SQL Server: remote access

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

    After installing Access 2007, I can't see new-created table?

    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...
Back
Top Bottom