Using MS Access/Expert Profile

Julie Misson

On Vacation
returns 12/31/2017

Follow me on:


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.

Experience in the area

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

This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Oleg09/30/16101010You are right! Thank you.
Oleg09/30/16101010Works great! Thank you so much.
Oleg09/19/16101010Thank you so much, Julie! It works .....
Maya06/04/151010Thank you Julie, I will try to .....
Sher05/17/15101010Thanks Julie, This is exactly what I .....

Recent Answers from Julie Misson

2016-10-11 MS Access Linked Tables:

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

2016-09-22 Linking main form and subform:

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

2016-09-13 Pass value from main form to subform:

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

2016-08-09 adding stock:

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

2016-08-09 Access - use of if command in code builder:

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] = "


Ask A Question

Using MS Access

All Answers

Answers by Expert:

Ask Experts


©2017 All rights reserved.