|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2005, 04:31 AM
posted to microsoft.public.access.reports
|
|||
|
|||
How to insert text box which's text is from another table?
Hi there, I want to put a text box in a report that refers to the 1st
row in a specific column in another table. Any help? 
|
|
#2
November 17th, 2005, 04:33 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How to insert text box which's text is from another table?
Have you considered using DLookup()?
-- Duane Hookom MS Access MVP -- wrote in message ups.com... Hi there, I want to put a text box in a report that refers to the 1st row in a specific column in another table. Any help?
|
|
#3
November 17th, 2005, 06:48 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How to insert text box which's text is from another table?
Yes but I could not get it to work. It keeps asking me to enter in the
parameter? It was forcing me to use the expression builder.
|
|
#4
November 17th, 2005, 06:53 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How to insert text box which's text is from another table?
I should mention that the report is not based on the table I am trying
to pull data off of. And the table that I am trying to pull data off of only has one row.
|
|
#5
November 17th, 2005, 07:02 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How to insert text box which's text is from another table?
Alright, figured it out. I am new at VB programming specifically so I
was trying to find some information on how to use the syntax. Came upon a microsoft wbsite from msdn and bingo. =DLookUp("[LastName]", "Employees") I think my criteria was screwing it up.
|
|
#6
November 17th, 2005, 10:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How to insert text box which's text is from another table?
So you have
-only one employee or -all employees share the same last name or -you don't care which last name is returned -- Duane Hookom MS Access MVP -- "ida" wrote in message oups.com... Alright, figured it out. I am new at VB programming specifically so I was trying to find some information on how to use the syntax. Came upon a microsoft wbsite from msdn and bingo. =DLookUp("[LastName]", "Employees") I think my criteria was screwing it up.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
| Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
| Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
| Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
| Must # of fields in the 2 tables in an Append Query be equal? | CreativeImages | Running & Setting Up Queries | 3 | October 1st, 2004 05:16 PM |
Linear Mode
