Recent content by gtimmies

Hi, I'm trying to build an expression where the form can only be saved if the field supervisor approval is not null. Could you please let me know how I can do that? Thank you!

Hey guys, I'm working on a query input form that allows the user to enter information based on the make of the car and run a query based on the information they input. Currently, I have set it up so that the combo box gets the car make from the tCar which has VIN# as the primary key and has...

Hi, I am in the process of designing a database for a car sales company. The company sales cars and also buys cars back from its customers. How should I design my tables so that the database keeps track of each car as well as the sales and buy-backs of the car? (example: a customer purchased a...

Hi all, I would like to create a form that pulls out the record if the customer number entered exists and creates a new record if the customer number entered does not exist. I was wondering if this is possible. If yes, how would I go about creating this? Thank you in advance for your help. :)

Hi everyone, I am building a report and I need a little help. Below is what my report looks like currently. (I do not have permission to link yet so I will type it out) Roll Number: 19-000-000-00000-0000 Use: Commercial Roll Number: 19-000-000-00000-0000 Use: Residential Instead of...

Hi, First off, I'd like to say that I am new at using Microsoft Access so if my questions seem simple, please bear with me. I am creating a database for the properties I own using Microsoft Access. I have built a many-to-many relationship between the properties and it's use. Right now, the...