Re: Query Data on a Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK all in all a side, is there a way to populate a field on a form with a
query result?

"Rick B" wrote:

What do you mean you will need to enter it multiple times due to another
database? If you need to export it to another database with the address
repeated, then Crete a query that will show the address for each record.

In short, you are trying to build a spreadsheet with auto-complete turned
on. Access is NOT a spreadsheet. If you want a flat file, I would
recommend using Excel.

--
Rick B



"BarryC" <BarryC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52BB24BF-4AB2-4267-99A6-CBC7F641C22E@xxxxxxxxxxxxxxxx
Rick,
I will have a number of sites with only 1 data entry. I will also have a
number of sites with the same address data. Unfortunately I need to
re-enter
the address data due to the table structure (another database). Thanks
Rick

"Rick B" wrote:

If the address is always the same then you don't want to store it in the
table multiple times. What if the address changes? Do you want to
update
all the records?

You have a classic one-to-many relationship. You need two tables. One
to
store the Site information, and one to store the details.

TblSites
SiteNumber
SiteName
SiteAddr1
SiteAddr2
SiteCity
SiteState
SiteZIP
SitePhone
etc.

TblMain
SiteNumber
TransactionDate (or whatever your other fields are here.)
etc.


The address for each site would only be stored ONE time in your database.




--
Rick B



"BarryC" <BarryC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B467365-4A1F-4DED-87E6-3BDAAB28A37D@xxxxxxxxxxxxxxxx
I created a form bound to one table. Each entry is based on a site name
and
each site name will have multiple entrys but will have the same
address.
What
I need to do is run a query based on the site name entered on the form
and
if
the site name is found have the query auto populate the address data on
the
form. I have the query created but do not know how to get the data on
the
form. Your help is appreciated.






.

Relevant Pages

  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)
  • Re: Query Data on a Form
    ... The Northwind database does this in the Orders form. ... customer from a drop-down list, and it takes the customer shipping data and ... "Rick B" wrote: ... then Crete a query that will show the address for each record. ...
    (microsoft.public.access.forms)
  • Re: Querying MS SQL database in Access
    ... "Basically the problem is that when I run a query in Access against a SQL ... >> network and populate records in the local Access database. ... >> from the populated database, and despite upgrading the ODBC driver, ...
    (microsoft.public.access.queries)
  • Re: Table Field Auto Update?
    ... Export the data to your old databases from a query, ... build the concatenated field in a new column of your query, ... I would put all of this in ONE database and then let the various ... "Rick B" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Concatenating two fields in Make-Table query
    ... Well, yes Rick, you are right. ... If I wanted to upload an Excel file to the ... a Make Table query, which was what you were objecting to in previous posts. ... but do you think I uploaded my entire database to the US ...
    (microsoft.public.access.queries)