i have tried the code you sent me ZmrAbdulla thank you very much for that. Now when i try to make a change on a record i get a confirmation message about editing if i say yes and move to the next record i get a write conflict error with 3 options (save the change, cancel change, copy to...
Yes there is a reason for using vba. My first goal was to display to the user certain fields of my form depending on the value of one drop down list. So i use a sub for the current form and visible true- false on some fields. The next goal was to update the database depending on the changes the...
yes you are right about dbsNorthwind that was wrong, i had the correct one in my code is actually Mydbs. i am still having problems. There is no update in my table here is the code again:
Private Sub thema_AfterUpdate()
Dim dbsNorthwind As DAO.Database
Dim rsMyRS As DAO.Recordset
Set...
Your reply is not very encouraging for me. I am new in programming vb but new in programming generaly.
i am posting you a code sample:
Private Sub thema_AfterUpdate()
Dim Mydbs As DAO.Database
Dim rstMyRS As DAO.Recordset
Set Mydbs = CurrentDb
Set rstMyRS =...
Hi eneryone,
i am new in programming visual basic (the last couple of days), i can get as much help as you can give me!
I have a database in Microsoft Access 2007. I display my data in a form. My problem is that when i change a value in a drop down box on the form i want to update the table with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.