Search results

Ahhh ok now i understand what you mean, thanks a lot!

This one seems a little weird..? what if i want to display related tables in my form...hmm not sure i get thats direct a "bad" thing...do you mind explaining just a tad more? thx

Sometimes i take the long way to get there...changed the fields in the popup that were used to update the main table to the actual related fields from the main table so when i change the values in the fields in popup no need to run any SQL at all...the fields update automatically in the main...

hi ya'll, im working away on my db and its going quite ok, spent the day trying to sort my popup problem. I have a popup based on a related table to the main forms table. opening the popup and changing some values from the popup table in the popup then clicking on a button to update a few...

Ahh ...sorry once again.. The redmarked missing items in the previous graphics pertain to the new DB structure attached here... I wanted to design the new DB as much i could after the old one form wise..but that didnt work out really...as changing squad, Classification and Status etc meant...

:D Yes i am, this is my second version of the DB first one was kinda done then "someone" showed me the light about DB design/structure so i started this one. The need the jail has had, hasn't really been about long search string, more about some basic stats and input/reading single inmate...

Thanks ill be looking into that

Sorry but I ran into a problem i hope its just quick solution...Now as i have changed the recordset to a query of combined queries...my recordset is not updable and thats a huge problem...is there a quick fix or do i have to remake it all somehow? *Update I understand it has to do that the...

ok thx ill try that, Im testing out some append and update queries..but its messy...

hmm..problem is that my related tables share a key and already have a relationship so..i cant create a new one..if i was importing to a new db i would do so easily...

Hi Is there any guide on how to split a table that has information relating to multiple tables (related)... Example Imported table: name, position, salary Existing structure of DB tblEmployee: name tblSalary: salary tblPosition: Position they are related through an autonumber key ...thats...

Ahhhh yes you are absolutely right! I havent gotten around to those yet. They are way down on my priority list :) I had all my tables with lookups before and removed them on I think it was yours or Gemmathehusks advice. But i havent started working on those tables/forms yet i left them as they...

sorry for the confusion... I removed the relation between the max_date and its all well, at least that part. What i wanted from the start was to integrate two queries into my main query. I had managed to integrate one the ClassificationID Query into my main Query and was now trying to...

Different amount of records...the combination makes 13 records but each query by itself makes 18 records...a little strange. I saw i had some missing data fixed that but it didn't fix the record missmatch...attached a new DB ... qryMainCombine 13 records qryMain_dev 18 records qryScuad 18...

HAHA yeah that works and it isnt that hard to understand...i might need to add other "History" tables the same way makes that process easier...:D But for my peace of mind ill still try to integrate the one in the other..i have to learn :p **UPDATE Im getting different amount of records in the...

Sorry for that...i wrote a long post but it was so confusing trying to explain the relations etc so please download the attached DB and just run it. I have written an explanation in it and i think it will make it a lot clearer running it at the same time.

I have managed to integrate the max_date function for one field classificationID into the query but how do i repeat the exact process for the squadID according to the most recent changeSquadDate? just as i have done for the classificationID...im doing all this by testing one line at a time...

Hi Guys, The Query below finds the most recent record in a table according to a date field, my problem is i don't know how to integrate this Query into the Query below this Query to replace the "Last" function SELECT a.inmateID, a.classificationID, b.max_date FROM ( SELECT...

I have a Form with a Query record source and all is fine :) adding an attachment field to the Query and then opening the form works fine but running a filter on the form i get. "search key was not found in any records" I've debugged it down to: I have two of my fields in the Query with a...

This is the answer if anybody is interested... SELECT a.inmateID, a.classificationID, b.max_date FROM ( SELECT tblClassificationHistory.inmateID, tblClassificationHistory.classificationID...