Search results

Thank you all very much for the advice. The descriptions and scenarios that you guys have used made it much easier for me to understand how to separate everything into different tables. I'm going to play around with it a bit and see if I can come up with a better structure for my tables, and...

Ok, here's the tables I currently have.

The db I'm working on currently has 6 tables; tblAssets, tblManufacturers, tblModels, tblSites, tblStaff, tblTypes. This is my first db and I'm slowly learning how to properly use Access. Right now I have all my information in tblAssets and only 1 column in each of my other tables except...

this is actually my first database. i'm still very new to access. for the search on my database i came across 2 different search methods that i liked and just combined the 2 to make the one i have now. could you explain a bit more in detail of what you mean by storing the query as a querydef...

works perfect :D thank you very much for the help.

i have a tab control set up on my main form and on one tab i have it set up to add records, on another tab i have a subform on it linked to my search form, and another tab with a subform linked to my edit form. previously i just had all the forms separate and i was able to set up an edit button...

thank you very much. didn't realize there was an option to compact it when it closes. :)

I'm having a problem with my database filesize getting larger with the more searches i do. At first i couldn't figure out how it was getting so big, but then i tried a few things and came to the conclusion that every time i do a search it increases its filezile. what made me notice this at...

i wasn't understanding why it wanted to report details for each record when i specified what i wanted it to display since my other reports only display a few records depending on how i filter them through the report. but this; will solve my problem. thank you :)

changing the "keep together" to no make it go down to 481 pages, so it's going in the right direction, but i have no idea where the extra 480 pages are coming from. each page displays the same information. here is a pic of what my detail section looks like. if it will help, i can probably...

the only thing i have for header/footer is the report header/footer and the detail section in between, and the detail section is about 6" long and it's filled with a ton of text boxes, but they all fit on one page.

the problem i'm having with one of my reports is that it's 721 pages, and it's only supposed to be 1 page. i have 721 records and for some reason it seems to think it needs a page for each one, but i have all the information i need on one page. i've been looking at my other reports to try and...

i have another question on the same topic. i took the "On Not in List" event data from the Site combo box, which is; ------------------------------------------------------------------------- Private Sub cboSite_NotInList(NewData As String, Response As Integer) Dim lngAns Response =...

that's exactly what i want it to do. thank you very much :)

my appologies. here's the file with both formats.

thank you for the quick responses. here is my db so you can see what i'm talking about.

here is what i have: tables - tblAssets, tblSites, tblManufacturers, tblModels i have 1-to-many relationships set up as follows; tblManufacturers --> tblAssets, tblManufacturers --> tblModels, tblModels --> tblAssets, tblSites --> tblAssets. what i would like to happen is if i add a new site...

ok, thanks for the help.

thanks, that pointed me more in the right direction. but all the topics that i've read about cascading combos have forms invovled, which has a spot where you can modify "after update", and i'm not seeing this option in table/query design. do i have to involve forms if i want to be able to do this?

first of all, i'm new to access. the only experience i have with it is reading the "microsoft office inside out", access section, and doing some research on the web. i work for a school district and my boss has asked me to make a database with all our assets. i used to have everything in...