My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.
I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.
Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.
|Oleg||09/30/16||10||10||10||You are right! Thank you.|
|Oleg||09/30/16||10||10||10||Works great! Thank you so much.|
|Oleg||09/19/16||10||10||10||Thank you so much, Julie! It works .....|
|Maya||06/04/15||10||9||10||Thank you Julie, I will try to .....|
|Sher||05/17/15||10||10||10||Thanks Julie, This is exactly what I .....|
Hi Sam, Thanks for the question. I have only had to do this once or twice. I had no luck with directly linking to the table that accesses the SQL via the OBDC, I had to create an Append query, to
Hi Oleg, Have you set up Relationships? Can be found under Database Tools. If not: Open the relationships window and drag in your tables. Set them up as I have in the attached pictures. Note
Hi Oleg, Many thanks for the question. To do what you ask you will need to write a bit of code. I am not sure of your level of expertise in VBA so I will step you through it. You also have
Hi Hilde, Thank you for the question. It seems you have your drop box and text box sorted, so I will not delve into these. To achieve what you are asking you will need to write some code. I will
Hi Pankaj, Many thanks for the question. See if this works for you. Private Sub DiaryNo_AfterUpdate() On Error GoTo ErrorHandler Dim strCriteria As String strCriteria = "[DiaryNo] = "
Answers by Expert: