Search results

Thank you so much. I have been working feverishly on my database with all of the info you have provided. Things are going great thanks to you. Thanks for the wonderful intro to normalization and continuous forms!

I have been playing around with your suggestions and have a few questions. When you refer to the 'Row Source' of the subform, do you mean the 'Record Source' or are you referring to the 'Row Source' of the combo box on the form? I assumed you meant the 'Record Source' of the subform. I used...

Well I believe I am in better shape than before. I would like a bit more of your guidance however. I am sure it has to do with the structure of the database. When you open FRM_customers and search for say 'Jane Doe' the goal would be to sign Ms. Doe up for a different class date for each of...

This all makes beautiful sense. Thank you so much for the direction! I will digest it all and put it to work. Thanks again for the great explanation my quality of life just improved!

I am obviously not approaching this properly and I am unsure of myself on this. I used the design view to build the query allowing Access to write the SQL. My goal here is to allow RPT_confirm to show which photography classes a customer is registered for. This report is being used as a...

I have a query [QRY_register] that pulls from a few different tables and my goal is to include Null fields in the query. Therefore I have used an Nz statement in the criteria of my query to convert the Null values to zero… but I cannot get it to work. The query is named QRY_register and it...