Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2007

Tip: Looking for answers? Try searching our database.

2 forms to one table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cranky - 08 May 2007 12:16 GMT
(Sorry if this seems a repeat of something else - I appear to have
submitted a post with nearly no content)

Hi

Please can someone advise the best way of doing this...

I'm trying to set up a database where two of the text fields are
'recommendation for improvement' and 'recommendations implemented'.
Because the number of characters is restrictive, I wanted
'recommendation2' and 'implemented2' fields as well. However, I didn't
want those visible all the time.

The only ways I could think of to do this were to either have a button
which makes the additional fields appear (... except I wouldn't know
how to do this), or a second form which opens on a button click, where
the information can be input. The problem with the second option is
that it seems to want to create a new dataset.

Does anyone have any suggestions on how to overcome this?

Thanks in advance

S:)
SusanV - 08 May 2007 12:35 GMT
Restrictive? As in you can' enter enough characters? Make them memo fields
rather than text.
Signature

hth,
SusanV

> (Sorry if this seems a repeat of something else - I appear to have
> submitted a post with nearly no content)
[quoted text clipped - 20 lines]
>
> S:)
Cranky - 08 May 2007 13:10 GMT
> Restrictive? As in you can' enter enough characters? Make them memo fields
> rather than text.

Obviously you can't see it, but I'm cringing at how basic that was.

Thanks for the answer, and helping me feel a complete idiot.  :)

Steve
SusanV - 08 May 2007 13:19 GMT
Idiot? No, not at all! Simply something you've learned today! I learn stuff
here every time I visit!

;-D

SusanV

>> Restrictive? As in you can' enter enough characters? Make them memo
>> fields
[quoted text clipped - 5 lines]
>
> Steve
SteveS - 09 May 2007 18:31 GMT
Also, the *default* field size of a text field in a table is 50 chars. You
can change this to a max of 255 chars.

:)

Signature

Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

> Idiot? No, not at all! Simply something you've learned today! I learn stuff
> here every time I visit!
[quoted text clipped - 12 lines]
> >
> > Steve
Cranky - 11 May 2007 16:24 GMT
> Also, the *default* field size of a text field in a table is 50 chars. You
> can change this to a max of 255 chars.

Heh, thanks, but no, it needs more - it's for recording
recommendations following complaints about government offices. 255
characters doesn't get _close_.   ;)

Steve
John W. Vinson - 11 May 2007 19:54 GMT
>> Also, the *default* field size of a text field in a table is 50 chars. You
>> can change this to a max of 255 chars.
>
>Heh, thanks, but no, it needs more - it's for recording
>recommendations following complaints about government offices. 255
>characters doesn't get _close_.   ;)

You can use a Memo field - that gives you 65536 characters (or two billion, if
you fill the field programmatically). That should give you a couple of weeks
worth of complaints about government offices... of course you'll need
SQL/Server and a BIG disk farm to hold all complaints about all offices!!

            John W. Vinson [MVP]
SteveS - 12 May 2007 08:54 GMT
Sad.........very True, but sad...

(I will not rant, I will not rant, ...)

Signature

Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

> >> Also, the *default* field size of a text field in a table is 50 chars. You
> >> can change this to a max of 255 chars.
[quoted text clipped - 9 lines]
>
>              John W. Vinson [MVP]
Cranky - 14 May 2007 23:02 GMT
> You can use a Memo field - that gives you 65536 characters (or two billion, if
> you fill the field programmatically). That should give you a couple of weeks
> worth of complaints about government offices... of course you'll need
> SQL/Server and a BIG disk farm to hold all complaints about all offices!!

Well... it's local government, so not _quite_ as bad...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.