A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Authority Table



 
 
Thread Tools Display Modes
  #1  
Old January 30th, 2009, 01:01 AM posted to microsoft.public.access.tablesdbdesign
NotGood@All
external usenet poster
 
Posts: 34
Default Authority Table

I have a table with 5 memo fields. Each field has a very large description
of some info. What I would like to do is click a cmdbutton “next” or
“Previous” and have the next field populate the form as it relates to that
Judge’s authority. Is that possible ?
--
NotGood@All
  #2  
Old January 30th, 2009, 01:23 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Authority Table

On Thu, 29 Jan 2009 17:01:01 -0800, NotGood@All
wrote:

I have a table with 5 memo fields. Each field has a very large description
of some info. What I would like to do is click a cmdbutton next or
Previous and have the next field populate the form as it relates to that
Judges authority. Is that possible ?


Are you storing a different memo field for *each judge*? What should the
"next" button do - move to a different record, or a different field?
--

John W. Vinson [MVP]
  #3  
Old January 30th, 2009, 08:14 PM posted to microsoft.public.access.tablesdbdesign
NotGood@All
external usenet poster
 
Posts: 34
Default Authority Table

Hi John. I would like it to move to the field, same record
--
NotGood@All


"John W. Vinson" wrote:

On Thu, 29 Jan 2009 17:01:01 -0800, NotGood@All
wrote:

I have a table with 5 memo fields. Each field has a very large description
of some info. What I would like to do is click a cmdbutton “next” or
“Previous” and have the next field populate the form as it relates to that
Judge’s authority. Is that possible ?


Are you storing a different memo field for *each judge*? What should the
"next" button do - move to a different record, or a different field?
--

John W. Vinson [MVP]

  #4  
Old January 30th, 2009, 10:20 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Authority Table

On Fri, 30 Jan 2009 12:14:08 -0800, NotGood@All
wrote:

Hi John. I would like it to move to the field, same record


Use code like

Me.controlname.SetFocus

in the button's click event.

I still don't understand your table structure. What are these five memo
fields??
--

John W. Vinson [MVP]
  #5  
Old February 2nd, 2009, 07:08 PM posted to microsoft.public.access.tablesdbdesign
NotGood@All
external usenet poster
 
Posts: 34
Default Authority Table

The table is a normal table, the problem is that 5 fields are memo field,
each of the 5 has about 40 lines of text to be entered, so any form I come up
with looks bad, even making the form large looks bad. What I would like to
do is bring up 1 field at a time, enter the data, click a button and move to
the next field. I would like to use the same form just have the field show
up on demand
--
NotGood@All


"John W. Vinson" wrote:

On Fri, 30 Jan 2009 12:14:08 -0800, NotGood@All
wrote:

Hi John. I would like it to move to the field, same record


Use code like

Me.controlname.SetFocus

in the button's click event.

I still don't understand your table structure. What are these five memo
fields??
--

John W. Vinson [MVP]

  #6  
Old February 2nd, 2009, 09:25 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Authority Table

On Mon, 2 Feb 2009 11:08:01 -0800, NotGood@All
wrote:

The table is a normal table, the problem is that 5 fields are memo field,
each of the 5 has about 40 lines of text to be entered, so any form I come up
with looks bad, even making the form large looks bad. What I would like to
do is bring up 1 field at a time, enter the data, click a button and move to
the next field. I would like to use the same form just have the field show
up on demand


In that case put a Tab Control on the form, with five tab pages; one textbox
on each page.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.