Single line table

  • Thread starter Thread starter Peter Smith
  • Start date Start date
P

Peter Smith

Hi

I have a small MSAccess app that I will be installing at several sites. I
need to rewrite it slightly to include a storage of details local to each
site.
Eg: Site name+address, Site Manager, etc

I think a single-record table would do the trick. How would I refer to
this data in forms since there is no ID number like in the other linked
tables??

Any help appreciated.

- Peter
 
Peter

Why would you need an ID# to refer to a record in a tblSiteInfo table?
Wouldn't a "SELECT * FROM .." query/statement work?
 
Jeff Boyce said:
Peter

Why would you need an ID# to refer to a record in a tblSiteInfo table?
Wouldn't a "SELECT * FROM .." query/statement work?
Click to expand...

I havent used sql yet. Does anybody have a link to a tutorial page on a
tblSiteInfo single-record-file its use and maintenance?

- Peter
 
Peter said:
I havent used sql yet. Does anybody have a link to a tutorial page on a
tblSiteInfo single-record-file its use and maintenance?

- Peter
Click to expand...

Check help file for DLookup() function.
 
Peter

No need for SQL, either! If you open a new query in design mode, add the
(one-row) table, and drag the "*" down to the field, the SQL statement looks
like:

SELECT * FROM ...

!
 
Hi

I have a small MSAccess app that I will be installing at several sites. I
need to rewrite it slightly to include a storage of details local to each
site.
Eg: Site name+address, Site Manager, etc

I think a single-record table would do the trick. How would I refer to
this data in forms since there is no ID number like in the other linked
tables??
Click to expand...

If you don't care which record you want to look up (and you don't,
since there are no choices!) simply use DLookUp with no criteria. I.e.
if you have a field SiteName, you can set the control source of a
textbox to

=DLookUp("[SiteName]", "[OneRowTableName]")

Or, you can base each Form on a Query adding this local-data table
without any join line. This would be the method of choice for Reports,
but DLookUp might be simpler for Forms.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top