Search results

So i've built a simple database (that was working pretty well until i moved the file to a network drive so other employees could work with it - i think this COULD be the problem). In any case, i have a form that pulls its data from a few tables/queries and updates this "master table". I have...

yeah i'm using access 2003 - ill give this a shot within the next day or two and will definitely give it my best shot at explaining it! Though im sure you can see the relationsihps and youll be quite surprised how simple it is.. Thanks! --- apparently work jsut got very busy... so it may...

you seem to know your stuff - so... if this is what we wanted to do, could you give me the exact code (adn where to put it?) id like to have some sort of multi-select box that gives us the option to filter based on any field in our query/table where all the data comes from.. and then...

where im gettin a bit stuck is on the "create a new table" should the field on the table have "[Responsible Entity] = NY" written in the "cell" if you will? - is it possible to use the query itself that has this data in there.. since the reponsible party list may change? and the code you gave...

i'm going to give this a stab and let you know how it goes... fingers crossed

By using this method http://support.microsoft.com/kb/208548 i was able to filter my query and generate a report .. However it seems that i will have to run my filter multiple times to generate this query for each responsible party... so is there a way to automate this to automatically create a...

Great .. so bascially this is how my db is set up.. i have a form that populates a table/query... basically a user will select options from a combo box and it will populate the record, i need to be able to filter the fields (and only select certain ones to include in the report) and generate a...

Thanks for the reply - im not too familiar with this level of expertise in access so if possible could you give me detailed instructions on doing this? Best

I'm not sure if I'm explaining this correctly but an example would probably make it clearer. I'm looking to generate separate reports (with the same layouts) however the "filtered field" is different on each. For example, the 3 fields I want in the report are - "responsibility", "entity name"...

Ok so, since you guys know everything it seems, im looking for a few things here First - i have a calculated field in a query which is the combination of entity name and date. it works great as an identifier for us since we can see when this entity's details are from. (and we want to keep the...

worked perfectly

Another question (which i have half of the answer to), i have a bunch of entity codes which begin with E and some which begin with other letters. I would like another box (the location books held) box to automatically populate with a certain name if an entity with an E as the first character is...

scratch that - i got it, i was using column 2 instead of 0 (didnt knwo you could use 0, since i was wondering why it started with 1) fantastic Bob, cant thank you enough

you kind of lost me with the example - i see kind of how its working but i dont want to waste your time here since you answered my question. bascially in the most simplest of forms is it possible to have 2 combo boxes depend on eachother ie i pick e1 and entity 1 popps up or vis versa.. and of...

im confused... how does that work then? if i only will be showing these 2 fields on my form? why do i still need the text box?

yeah i'm having a bit of trouble undersatnding exactly what you are trying to do.. i convered the text box to a combo box, and was obviously able to get it to pull from column 2 (the names section) but not sure how to make the 2 boxes now interact with eachother as you had mentioned...

if you could show me how to do that it woudl be great.. here are the acutal field names and things so maybe i would undersatnd better Main entity table - there are the fields that need to be filled in "Parent_1_Code" "Parent_1_Name" Entity name table - lookup table per se...

all i know is your first way worked perfectly and you guys impress the hell out of me... but im going to give this thing a shot since im intrigued...

perfect... absolutely perfect.. you guys are good.. i acutally had a code like that with an =[Parent 2 Code].column(1) in the control section, but obviously that removed it from begin recorded now heres a brain teaser.. what iff... i want that a similar functionality right, but i wanted both...

for example.... my main tablle has the following fields Entity Number, Entity name, etc etc my entity table has entity number, entity name E1 Entity1 E2 Entity 2 in a sense we just need to be able to pull data results from the entity table and put...