Search results

Sorry for the late response. Thanks a ton!

Hello I am trying to connect a database search form to a query I made. I have put in some code in the criteria sections of the fields that I want to search. Of course these fields are referenced to their respective text boxes and submit button. It works perfectly unless one of the fields with in...

Yes thats exactly it! thanks!

Is there anyway to auto populate a field in one table to a field in another table?

Galaxiom: I did some reading and I think I understand normalization now. Thanks for the pointer!

Actually nevermind, now I am getting an error saying the primary key can not be null. Sorry for the over posts. I know what the problem is I just have no Idea how to fix it. On my data entry form the "Case ID" box pertains to my main table and when the data entry person puts a number in it they...

ahhh just figured it out. It was my joins again..

I checked out the site with Venn Diagrams and I think I understand now. I am having another problem now. I'm sorry for the many questions but I keep getting a msgbox that says "The Microsoft Access Database Engine cannot find a record in the table 'Home Bio' with key matching field(s) 'Case ID'...

I figured it out guys. I went and added one table at a time like dpw said and I also added one relationship at a time in my table relationships window. In addition I also added one table at a time to my query to see which table was causing the problem. All tables worked fine untill I got to my...

No I have not, I am not to positive on how join types work.

Ok guys sorry for that rant I just had... I think I drank too much of my protein shake. Here is the link to my database. If anyone is willing to help out a fellow programmer in training it would be friggen amazing. Thanks http://www.megaupload.com/?d=ECTES0Y0

My name is George, I'm pretty new to Access and VBA and thus have stumbled upon this forum. Due to my background in C# I have been asked to be head dev at my job at creating databases. We are currently working on some software for a local police department. I will probably be needing some help...

As you can see Brian I have taken your advice. hahahahahah!

Once I get the 10 posts I will post my database link on here.

Damn I wish I would have thought of that!

I have troubleshooted the query problem I am having. I got it to work only if it gathers information from the primary table when all my relationships have been deleted. If I establish a relationship then the query goes back to pulling just the labels of the colums.

Hello, thanks for the quick response. This is my table structure. Table 1: Basic Bio (Case ID(Primary Key), Last Name, First Name, Middle Initial, Nick Name, Age, Birthdate, Sex, Gang Affiliation, Place of Birth.) Table 2: Home Bio(Case ID(Primary Key), Mother, Mother's Adress, Mother's...

Hello everyone, I am trying to create a database for juvenile processing in a local police station. I am having trouble trying to make a query that pulls together all the info from 5 tables that I have and using that query as the source for a main dataEntry form. The guy working on this database...

Roger that! thanks again

You are right, no need to make it more complicated than it needs to be. Thanks Brian for that link. Since I am not too familiar with VBA it helps to have different pieces of code that are similar so I can better decipher exactly how the syntax for VBA works. If you or anyone else does have the...