Recent content by manovice

Re: John Big Booty Or ANYONE INTERESTED Okay, I have finally gotten a chance to look at what you sent and it looks good. I also read up on the normalization link that you sent and that made sense. First Question: Shouldn't all of the tables somehow be linked together? As I was going through...

Thank you John Big Booty for your assistance. I will look in to your suggestions and let you know how things work out. And SOS, I am very familiar with forums and understand that it is a group effort, but I had posted at least four posts this week and had gotten extremely minimal responses...

I actually have to leave the computer for a while so I am going to post what I have. With juggling kids and work, it is time to pick them up. So here is where I am at right now. My main problem at the moment is that when you open the form AllReviewInfo and you enter a record and click save...

I am not sure what you mean by a cut down version. I have only populated about 7 rows in two tables with fake data. Then I have a few queries with little info and also three forms. Can I just post the whole thing? I am sorry I seem so stupid, but I think I used the correct user name with...

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

I don't believe that the query is read only. I am able to go in and add data to the query and it saves fine. My problem lies in that when I open the form to input a record, the computer beeps at me when I attempt to insert the information. Thanks

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