Search results

thank you for your help I was on the verge of giving up and just running a regualr query on all records and then copying and pasting the ones I wanted into MS word for a report

the uploaded one was a quickie sample version that I through together this morning to show what I wanted to accomplish, because I don't think I know enough about Access to explain it in a meanful way to experienced users, not my actual database - and I didn't take the time to name everything...

I made a small version of the database I need to know how to code it so that the user can pick the site from the form combo box, and click the button to get a list of the records with just that one site and not have it return all records and change the site to the selected site

the combo box on the form points to the Site table and the field with the city (field 3) when I pointed to the AIMS.Sit Code - it only picked up the index number (field 1 from SITE)

the ID field in the site table is a meaningless autonumber the file size is 2 GB - there's 3 embedded MS Word docs in each record in the table for detailed rent, sublease and narrative history the query code is: SELECT AIMS.[Customer Legal Name], AIMS.[Rent - Annual], AIMS.[Site...

when I point the form's combo box to the agreement table, the drop down list shows only the ID number from the table with the list of sites when I point the combo box to the site table - and used the code to tell the query to use the combo box data as the query parameter, they both return...

no, but thank you I'll explore that site more and see if I can find an answer I don't want to return all 370 records, I only want the records that match the city selection mostly I want to know if Access treats fields where the information is typed differently than if the information is...

I have a follow up question all the examples I've seen of these QBF are pointing to fields where the data is typed I've been working on creating one, where the field "City" is filled by selecting from a list from 150 drawn from another table in the database even a simple straightforward...

thank you I am getting closer to having this puppy work

I'm doing the QBF and trying to program the form's pick list to select records based on the city (Site Code) the code is: SELECT AIMS.[HQ Doc #], AIMS.[Regional Doc #], AIMS.[Site Codes], AIMS.[Reg File #], AIMS.[Customer Legal Name], AIMS.Lease, AIMS.[Document Type], AIMS.[Purpose/Use]...

Okay, I made the form, wrote the macro, wrote the query and connected them as per the example I am wondering if it's not working because the feild I am trying to base the query around is not entered (meaning typed uniquely each field) data, but data that is selected from a pick list and...

THANKS that's amazing

I even went into the table that contains the codes and copied a city ran the query, pasted the city into the prompt and got 1 empty record it's weird that the Between Date And Date queries work and not the site ones. I'll have to think of a work around to getting the records...

I probably should have mentioned that I am using Access 2000 I checked the typing twice before running, and before that, made sure the city I was searching for was listed in the database that the field in the table is a look up to another table shouldn't matter, right? it should act the...

I copied and pasted into SLQ view, saved and ran it Yes, typos are a hazard - I keep a cheat sheet of the codes and city names on my wall I am getting the prompt now, but am getting the empty return table as a result of the query I am not sure how to use the form to get query results I...

I copied and pasted that over the code in the SLQ view and saved it but when I ran it, it didn't prompt me for the city and it returned a table with an empty record did I do that wrong? the database is only going to be used by 2 people, so not as worried about preventing mucking up by...

SELECT AIMS.[Customer Legal Name], AIMS.[Rent - Annual] FROM AIMS WHERE (((AIMS.[Site Codes])=[Enter Site Code and Name]));

oooo the field in the database that's the lookup contains the site code and name, the field would say V100 Vancouver and that's what you enter in the prompt

Hi I have a table for a list of legal documents - one of the feilds is for the city the document pertains to. this field is filled in as a drop down where the city names are in another table. I have several queries that I need to do that I want to obtain a list of records for specific...