Search results

John Big Booty or ANYONE who can assist You seem extremely knowledgeable about access :cool:so hopefully you will be willing to help me. I have been thrown in to the world of database building and I am barely treading above water here. I have posted twice today to no avail as of yet. My main...

I just went back and looked at my query and something is terribly wrong. When I open my form to enter new information... I use the combo box to choose a facility. Each facility has an ID but I choose the facility name since the ID would be too difficult to remember for over 200 facilities...

Hello there. I have been able to work many of my kinks out through web surfing, but was hoping you could possibly help me out here. I have a main form that has a field for a report number. Not all reports require a letter, but when they do, I have a subform that will come up that contains...

Okay. I think I got my main form figured out. It is pulling from one query that is built off of two tables. What I want is the following: Open the form and it is blank. I choose the facility name from the combo box and the combo box, facility ID, and address information self-populate. Then I...

I have a database with two tables. One table with all of my facility information. The other table has all of the data relating to the visits of those facilities. I need a form to go in to where I can add visit information. There are like 5 different possible types of visit informations, so I...

I am new to the forum here and am trying to create a database for my work. Here is my data: We have a unspecified number of facilities (they can be added and dropped at any time) Each facility will have an unspecified number of visits to them every year (some more, some less) Each visit will...