Most Wanted 2/MostWantedII.iso/windows/access/access_l.exe/ACC9309.TXT

Text File | 1994-01-07 | 178.7 KB | 3,984 lines

=========================================================================
Date:         Tue, 31 Aug 1993 11:21:40 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders, Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Automatic field updates

> For example:  I enter John Doe into the database.  When I get to the
> Country field, I enter "Japan," since that's where he lives.  Access should,
> in the best of all possible worlds, then look in Table 2 for the entry
> for Japan, which holds (in named fields, of course) the French name
> and the telephone code.  Access places these bits of data into the
> appropriate fields in the original table so I don't have to do it, and
> Bob's your uncle.

I believe you've had some replies about displaying these fields on
your form. What worries me a little bit is that you say you want to
place the data into the appropriate fields in the original table. The
whole idea of a relational database is that you DON'T duplicate data
in different tables.
=========================================================================
Date:         Tue, 31 Aug 1993 12:48:47 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders, Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Maximize the form before opening form

>
> Does anyone know how to maximize the form before the form is opened ?
> Normally Macro - openform & then maximize.
>
> It is so UGLY to see the "small" form being enlarge when you execute the macro
 .
> Is there a way to see the maximized form on the screen once you execute the ma
 cr
>    o ?

You could use ECHO to hide screen activity before you open and
maximize the screen; then ECHO again to revert to normal. It
looks a bit tidier that way.
=========================================================================
Date:         Wed, 1 Sep 1993 08:54:07 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Organization: PictureTel Corporation
Subject:      Re: Maximize the form before opening form

>
> >
> > Does anyone know how to maximize the form before the form is opened ?
> > Normally Macro - openform & then maximize.
> >
> > It is so UGLY to see the "small" form being enlarge when you execute the
>  macro.
> > Is there a way to see the maximized form on the screen once you execute the
>  macr
> >    o ?
> >
> > Chor Ling
> > [e-mail]
> >
>
> I've never tried it, but, you might be able to set the form's visible
> property to false, maximize it, and then set the visible property to
> true.  You might also just want to store the forms with visible set to
> false, open them, maximize them, set the visible property to true.  You
> probably want to set visible back to false when you close the form.
>
> John
>

This works unless the form is a pop-up form. For a pop-up form, you need
to assign a macro or function to the forms "On Open" property that will do
the maximize.

--
+-------------------------------------------------------+
| Steve Miller                   PictureTel Corporation |
| email: [e-mail]       One Corporation Way    |
| phone: [phone]          Peabody, MA 01960      |
+-------------------------------------------------------+
=========================================================================
Date:         Wed, 1 Sep 1993 09:56:33 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Chet Farmer <[e-mail]>
Organization: Project IDEALS -- The University of Alabama
Subject:      Re: Automatic field updates
In-Reply-To:  Message of Tue,
              31 Aug 1993 11:21:40 GMT from <[e-mail]>

On Tue, 31 Aug 1993 11:21:40 GMT Richard Saunders, Computer Centre said:
>I believe you've had some replies about displaying these fields on
>your form. What worries me a little bit is that you say you want to
>place the data into the appropriate fields in the original table. The
>whole idea of a relational database is that you DON'T duplicate data
>in different tables.

Regardless of the "whole idea of relational databases," what we want
to do is automate data entry for the two fields in question.  Period.
It seems the simplest approach, and one that simplifies further work
(ie, reports & such done later).

Of course, if you have an easier way in mind to accomplish the same
thing with a minimum of complexity, that's great.  Please share it with
us.

It's kind of a "make the program do what we want" issue, not a "proper
behavior in relational databases" one.


+----------------------------------------------------------------+
| Chet Farmer, Assistant Director |   tel [phone]           |
| Project IDEALS                  |   [e-mail]      |
| The University of Alabama       |   [e-mail] |
|----------------------------------------------------------------|
|   C is for Cookie, and that's good enough for me.  -- C. M.    |
+----------------------------------------------------------------+
=========================================================================
Date:         Wed, 1 Sep 1993 08:59:54 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Monty Kingsley <[e-mail]>
Subject:      Retrieving Info from the DB on what-number row out of how many is
              displayed

I'm a new developer in MSAccess which i think is a great product.
But there are a couple of rather simple-minded things i'm trying to do
which i haven't had any trouble with in other DB environments.
Let me illustrate with an example: say you have a payroll table for employees.

What you want to do is display on a single form salary payment info for an em-
ployee which has been sorted in ascending order by time.  B U T you also want
to display info on how many such payments there are for the employee A N D the
number (in the sequence order) for the payment info now displayed.

Now, i confess i might be embarressed by a few two line replies showing how.
I'm not completely stupid to the extent i can use a SQL count(*) query to
display the total number of payments for an employee; even though i'm still
having trouble getting this number to change when my form focuses on another
employee.

But with respect to showing which number is being displayed in the sequence,
i haven't a clue, after tryinq queries with count(*), Dcount and a few other
odds and ends.  i called the Microsoft hotline and they just confirmed the
difficulty of doing this, saying it's best done in Basic.  Somehow this made
me feel better!

Well, any help wld sure be appreciated, despite how stupid it makes me look.

Regards/ Monty
=========================================================================
Date:         Wed, 1 Sep 1993 14:01:08 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Dahne <[e-mail]>
Subject:      hot keys?

     Does anyone know if there are hot keys for Access?
=========================================================================
Date:         Wed, 1 Sep 1993 14:35:11 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Dahne <[e-mail]>
Subject:      comand buttons on reports

     You can put a command button on a report but the properties box
     doesn't include a field to attach an action to the button.  Does
     anyone know how to attach a macro to a command button on a report?



     Scott Dahne
     Research Fellow
     Logistics Management Institute
     Bethesda, MD  USA
     [e-mail]
=========================================================================
Date:         Wed, 1 Sep 1993 18:58:58 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      Suggestion for Monty

Seeing as how you are not stupid I will not insult your intelligence by posting
2 lines of basic code :-).....


    You might want to try REFRESH QUERY.  Maybe hook it to a button.  You could
also attach a macro to the "focus" of the list box.  In other words, when the
user clicks on an employee a new salary payments and number come up.

    Also, form/ subform comes to mind.


Good luck,
          Greg
=========================================================================
Date:         Thu, 2 Sep 1993 08:18:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      "New Line"Code?

I heard that there are four lines of code
that can entered into the "before update"
section of a memo field that will allow
one to enter carriage returns "new lines"
without advancing to the next field.
Thanks
==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Thu, 2 Sep 1993 10:09:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff Frost <[e-mail]>
Subject:      Multiple Changes

     Hi, I'm looking for a way to make changes to multiple fields on a
     report.  For example, I have 15 text boxes that display numbers and I
     would like to select them all and make them the same size, format,
     etc..  Currently I'm selecting each individually and changing it.  Is
     there a better way?

     Thanks, Jeff
=========================================================================
Date:         Thu, 2 Sep 1993 09:35:21 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Shannon Burgin <##[e-mail]>
Subject:      references to controls, etc.

Is there a method of identifying all of the places a fieldname, or for
that matter filename, controlname, etc., are being used in an Access
Database Application? Example:

fieldname ABCD appears:
  Tablename xxxx
  Formname  yyyy
  Formname  zzzz
  Query     wwww
  Macro     mmmm


************************************************************************
*                                *                                     *
* Shannon Burgin                 *    University of Tennessee/Martin   *
* Bitnet: ##[e-mail]    *    Computer Center                  *
* Phone: [phone]            *    102 Cooper Hall                  *
* Senior Systems Analyst         *    Martin, TN 38238                 *
* VM/VSE/CICS/VSAM/DLI/SQLDS     *                                     *
************************************************************************
=========================================================================
Date:         Thu, 2 Sep 1993 09:59:00 LCL
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         mkro <[e-mail]>
Subject:      Printing from ACCESS BASIC

Hello All!

   I am relatively new at "PC" programming, I been in the Mainframe
environment.  Can anyone show me
  or send me some SAMPLE ACCESS BASIC code that prints directly to LPT1 or
LPT2, etc..?
  I need to be able to send printer escape sequences and control characters.
 I am trying to print
  AIRBORN airbill labels using data stored in ACCESS tables.

 Any help or point of reference would be greatly appreciated.

Thanks in advance,
Mike Kroeger
                                                                Standard Disclaimer Applies
+----------------------------------------------------------------------------
------------------------------------------------------------------------+
+          T E X A S  I N S T R U M E N T S     C O N S U M E R  P R O D U C T
S       D I V I S I O N              +
+----------------------------------------------------------------------------
------------------------------------------------------------------------+
+  Phone: [phone]        Fax: [phone]         e-Mail:
[e-mail]      +
+----------------------------------------------------------------------------
------------------------------------------------------------------------+
*** uuencoded BINARY enclosure ***
The section below this line contains an MHS attachment.  To extract it,
copy this message to a file and use the program UUDECODE.  For information
on using UUDECODE on UNIX systems, type the command 'man uudecode'.  The
attachment name was originally: ATTRIBS.BND
---------------
begin 644 attribs.bnd
M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``9O)FIK*```````4')I;G1I;F<@
M9G)O;2!!0T-%4U,@0D%324,`````````````````````````````````````
M````````````````````````````````````````````````````````````
M`&UK<F\`````````````````````````````````````````````````````
M```````````````````````````````````Q-CE&.#4R0S`Q0SE!,44P````
M````````0F5Y;VYD(%!R;W!R:65T87)Y($1A=&$:``````0`````````!``%
M````````````````````````````1F]R;01-96UO`0`````````5``,`````
M``````````````````````!5<V4@4')O<&]R=&EO;F%L($9O;G0!``$1````
M``````0`@@0``````````````````````````%1E>'1\!$AE;&QO($%L;"$*
M(`H@("!)(&%M(')E;&%T:79E;'D@;F5W(&%T(")00R(@<')O9W)A;6UI;F<L
M($D@8F5E;B!I;B!T:&4@36%I;F9R86UE(&5N=FER;VYM96YT+B`@0V%N(&%N
M>6]N92!S:&]W(&UE(`H@(&]R('-E;F0@;64@<V]M92!304U03$4@04-#15-3
M($)!4TE#(&-O9&4@=&AA="!P<FEN=',@9&ER96-T;'D@=&\@3%!4,2!O<B!,
M4%0R+"!E=&,N+C\*("!)(&YE960@=&\@8F4@86)L92!T;R!S96YD('!R:6YT
M97(@97-C87!E('-E<75E;F-E<R!A;F0@8V]N=')O;"!C:&%R86-T97)S+B`@
M22!A;2!T<GEI;F<@=&\@<')I;G0@"B`@04E20D]23B!A:7)B:6QL(&QA8F5L
M<R!U<VEN9R!D871A('-T;W)E9"!I;B!!0T-%4U,@=&%B;&5S+@H*($%N>2!H
M96QP(&]R('!O:6YT(&]F(')E9F5R96YC92!W;W5L9"!B92!G<F5A=&QY(&%P
M<')E8VEA=&5D+@H*5&AA;FMS(&EN(&%D=F%N8V4L"DUI:V4@2W)O96=E<@H)
M"0D)"0D)"5-T86YD87)D($1I<V-L86EM97(@07!P;&EE<PHK+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2L**PD@("!4($4@6"!!(%,@($D@3B!3(%0@4B!5($T@12!.(%0@4PE#
M($\@3B!3(%4@32!%(%(@(%`@4B!/($0@52!#(%0@4PE$($D@5B!)(%,@22!/
M($X)("`@("`@("`@("`@("L**RTM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TK"BL@(%!H;VYE.B`H
M,C$T*2`Y,3<M,34Y,0E&87@Z("@R,30I(#DQ-RTQ-3`U("`@("`@("`@92U-
M86EL.B!-2U)/+D1)4RU00T!"34%)3$E.+DE41RY422Y#3TT)("`@("L**RTM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TK````````````````$``&````````````````````````
9````071T86-H;65N="!#;W5N=`0````````&
`
end
=========================================================================
Date:         Thu, 2 Sep 1993 16:52:30 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: references to controls, etc.
In-Reply-To:  <[e-mail]>

>DATE:   Thu, 2 Sep 1993 09:35:21 EDT
>FROM:   Shannon Burgin <##[e-mail]>
>
>Is there a method of identifying all of the places a fieldname, or for
>that matter filename, controlname, etc., are being used in an Access
>Database Application?

I am fairly sure there is not.  If there is, I would sure like to know
about it.  There are was to determine all those things, but not to
cross reference them.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Thu, 2 Sep 1993 16:57:39 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: Multiple Changes
In-Reply-To:  <[e-mail]>

>DATE:   Thu, 2 Sep 1993 10:09:06 EST
>FROM:   Jeff Frost <[e-mail]>
>
>     Hi, I'm looking for a way to make changes to multiple fields on a
>     report.  For example, I have 15 text boxes that display numbers and I
>     would like to select them all and make them the same size, format,
>     etc..  Currently I'm selecting each individually and changing it.  Is
>     there a better way?

You can select them all easily enough. Either use the mouse to draw a
box around them or hold down the shift key when you select them.  It is
nice for aligning controls and moving groups of them around.  But there
is no way to change a group of properties at once and change them.

You could write code to to it in most cases, but it would likely take
longer than changing them individually.

It would be nice to be able to do it.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Thu, 2 Sep 1993 17:15:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      strange report print bug

I have one report in a database that used to work fine.  Suddenly it will
print the first two pages fine, then start to choke on the third page
and make a complete mess of the fourth page altogether.  The kicker is
that I can get pages three and four to print without a problem if I
print them individually (i.e., print range 3 to 3 or 4 to 4).  I'm printing
to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my
computer via a Buffalo SLmkII peripheral sharing device.  Any thoughts?
I think the report is corrupt somehow but even running Repair Database
didn't help.  I'd hate to re-do it from scratch but that's what I'm
looking at.

I do NOT have this problem with any other report.

TIA,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 2 Sep 1993 18:19:12 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      cross references to controls, etc.

From:   "John M. King", INTERNET:[e-mail]
% >FROM:   Shannon Burgin <##[e-mail]>
% >
% >Is there a method of identifying all of the places a fieldname, or for
% >that matter filename, controlname, etc., are being used in an Access
% >Database Application?
%
% I am fairly sure there is not.  If there is, I would sure like to know
% about it.  There are was to determine all those things, but not to
% cross reference them.

I would suggest one look at how the Access Analyzer works -- if it doesn't do
 what you want, there
are plenty of clues there for determining how to do your own.  The big "trick"
 is knowing to go
into the "View" option, select "Options", and change "Show System Objects" to
 "Yes".  You'll
see plenty of little interesting things show up in the container class window
 then...

I have a (pedantic) cursiosity question:  if you can determine the information,
 why can you not
cross-reference it?  One would think it would be like saying "I know what the
 batter did each time at the
plate, but I can't figure out his batting average" -- wouldn't it? I'm not
 intending this as a flame, just trying to
understand the reasoning.
=========================================================================
Date:         Thu, 2 Sep 1993 15:41:38 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jonathan Lavigne <[e-mail]>
Subject:      Re: Multiple Changes

REPLY TO 09/02/93 14:30 FROM [e-mail] "Microsoft Access Database
Discussion List": Re: Multiple Changes

>From:         "John M. King" <[e-mail]>
>Organization: KING Systems
>Subject:      Re: Multiple Changes
>To:           Multiple recipients of list ACCESS-L <[e-mail]>
>In-Reply-To:  <[e-mail]>
>
>>DATE:   Thu, 2 Sep 1993 10:09:06 EST
>>FROM:   Jeff Frost <[e-mail]>
>>
>>     Hi, I'm looking for a way to make changes to multiple fields on a
>>     report.  For example, I have 15 text boxes that display numbers and I
>>     would like to select them all and make them the same size, format,
>>     etc..  Currently I'm selecting each individually and changing it.  Is
>>     there a better way?
>
>You can select them all easily enough. Either use the mouse to draw a
>box around them or hold down the shift key when you select them.  It is
>nice for aligning controls and moving groups of them around.  But there
>is no way to change a group of properties at once and change them.
>
>You could write code to to it in most cases, but it would likely take
>longer than changing them individually.
>
>It would be nice to be able to do it.
John,

It's true that you can't change properties (such as Can Grow, Can
Shrink, etc.) for a group of controls.  At least, if you can do
it, I don't know how.  But Jeff's original post asked about resizing
and reformatting multiple controls at the same time.  I just
discovered how to do that today, though I guess if I had bothered to
look at all the menu options, I would have noticed much earlier. It
would have saved me a lot of trouble fiddling around with command
buttons to get them all the same size.  Here's the proceudre.

1. In design view for a report (or a form), define the size, borders
   etc. for one control and select that control.

2. Choose Layout/Change Default to save the layout options for the
   selected control as the default.

3. Select the other controls to which you want to apply the default.

4. Choose Layout/Apply Default to apply the default characteristics
   to all the selected controls.

Jonathan Lavigne
Research Libraries Group/Stanford University

To:  [e-mail]
=========================================================================
Date:         Fri, 3 Sep 1993 06:04:42 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: cross references to controls, etc.
In-Reply-To:  <[e-mail]>

>DATE:   Thu, 2 Sep 1993 18:19:12 EDT
>FROM:   Phil Paxton <[e-mail]>
>
>From:   "John M. King", INTERNET:[e-mail]
>% >FROM:   Shannon Burgin <##[e-mail]>
>% >
>% >Is there a method of identifying all of the places a fieldname, or for
>% >that matter filename, controlname, etc., are being used in an Access
>% >Database Application?
>%
>% I am fairly sure there is not.  If there is, I would sure like to know
>% about it.  There are was to determine all those things, but not to
>% cross reference them.
>
>
>I have a (pedantic) cursiosity question:  if you can determine the information,
> why can you not
>cross-reference it?  One would think it would be like saying "I know what the
> batter did each time at the
>plate, but I can't figure out his batting average" -- wouldn't it? I'm not
> intending this as a flame, just trying to
>understand the reasoning.

The reasoning is this.  It is easy, as you indicate, to use the
analyzer to produce a report, for example, of field names and all the
tables they are used in.  It is an easy reportto produce and I have
made good use of it.  It is not as easy, and may not be possible, to
produce a report showing everywhere in an application a given control
or field is referenced--in macros, functions, etc.

There is a product called "Total Access" which produces a vast amount
of documentation.  We are ordering it, but I have not used it yet.  I
believe that I read that it does not include such a cross reference.

I would be very interested in seeing the details, if you have produced
such a report.  That was the main reason for my response.  I do not
believe it is a trivial task and would be interested in seeing how it
is done.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Fri, 3 Sep 1993 09:50:23 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: strange report print bug
In-Reply-To:  Message of Thu, 2 Sep 1993 17:15:00 EST from <NBRINDLE@INDYCMS>

On Thu, 2 Sep 1993 17:15:00 EST Nathan Brindle said:
>I have one report in a database that used to work fine.  Suddenly it will
>print the first two pages fine, then start to choke on the third page
>and make a complete mess of the fourth page altogether.  The kicker is
>that I can get pages three and four to print without a problem if I
>print them individually (i.e., print range 3 to 3 or 4 to 4).  I'm printing
>to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my
>computer via a Buffalo SLmkII peripheral sharing device.  Any thoughts?
>I think the report is corrupt somehow but even running Repair Database
>didn't help.  I'd hate to re-do it from scratch but that's what I'm
>looking at.

I've sort of had a very similar problem -- but the computer says "buffer
full" and then you have to start all over.  Have you checked using
another printer, or a dump to disc (ascii would be best so you can
check)?  If there's no problem there, look at the computer.  But waht
you say below seems to indicated it might well be your report got
glitched up (so to speak).  Good luck, David

>I do NOT have this problem with any other report.
=========================================================================
Date:         Fri, 3 Sep 1993 09:54:28 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: Multiple Changes
In-Reply-To:  Message of Thu, 2 Sep 1993 15:41:38 PDT from <BL.JPL@RLG>

Thanks, Jonathan, for the multiple sizing tip.
Terrific.  Best, David
=========================================================================
Date:         Fri, 3 Sep 1993 10:12:39 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: cross references to controls, etc.
In-Reply-To:  Message of Fri,
              3 Sep 1993 06:04:42 -0400 from <[e-mail]>

Please would you provide complete information on
Total Access -- esp. an 800 number.  Many thanks, David
=========================================================================
Date:         Fri, 3 Sep 1993 10:06:03 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: strange report print bug
In-Reply-To:  Message of Fri, 3 Sep 1993 09:50:23 CDT from <CROOKALL@UA1VM>

David, I don't have a buffer problem because I don't use the &#^#! print
manager.  I need stuff faster than the PM can give it to me.  But it is
possible that it is the printer (and it also <may> have something to do
with the context-sensitive printer language switcher that runs as a TSR
and determines whether the document is PS or PCL and informs the printer
accordingly.  I'll do some checking and report what I find back to the
list.

BTW, MS was supposed to be marketing some super-duper print accellerator
some time back.  Did anyone ever see it?  There was a splash in one of the
slick magazine/ads I got in the mail but no ordering information and then
it seemed to disappear.  Then I heard something about a lawsuit.  ???

Thanks,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 3 Sep 1993 08:25:57 MST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dan Eklund <[e-mail]>
Subject:      Re[2]: cross references to controls, etc.

Please would you provide complete information on
Total Access -- esp. an 800 number.  Many thanks, David

From Aug/Sep 93 ACCESS ADVISOR Mag page 9
Special Intro Price $145 + $5 S&H
FMS, Inc.
8027 Leesburg Pike, Suite 410
Vienna, VA 22182
[phone], FAX: [phone]

Good Luck
Dan
=========================================================================
Date:         Fri, 3 Sep 1993 11:50:02 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: strange report print bug
In-Reply-To:  Message of Fri, 3 Sep 1993 10:06:03 EST from <NBRINDLE@INDYCMS>

Thanks, Nathan.  Your problem seems too complex for me.
Good luck -- would like to know how you solve it.
Best, david
=========================================================================
Date:         Fri, 3 Sep 1993 11:57:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon Diercks <[e-mail]>
Subject:      Re: strange report print bug
In-Reply-To:  from "Nathan Brindle" at Sep 2, 93 5:15 pm

> ...to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my
> computer via a Buffalo SLmkII peripheral sharing device.  Any thoughts?

If either of the buffalo connections (PC<->buf or buf<->printer) are
serial, make sure you have flow control set up correctly on both
sides.  We set the buffalo for both hardware and software flow control.

--
 \on \                         [e-mail]          Administrative Systems
\_\ <_\iercks                                               Anderson University
   >                                                               Anderson, IN
  ---  ...Life is too important to be taken seriously.
=========================================================================
Date:         Fri, 3 Sep 1993 12:15:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: strange report print bug
In-Reply-To:  Message of Fri, 3 Sep 1993 11:57:38 EST from <[e-mail]>

Thanks, Jon, I'll check that.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 3 Sep 1993 15:02:47 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Total Access

% From: Dan Eklund, INTERNET:[e-mail]
% From Aug/Sep 93 ACCESS ADVISOR Mag page 9
% Special Intro Price $145 + $5 S&H

*snicker* it's always funny to see supporting products costing more than the
 product itself!
=========================================================================
Date:         Fri, 3 Sep 1993 09:29:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      Counter Number

I'm trying to set a field with a data type of counter, to
start with a specified number. My problem is that I have
two separate databases being inputed with like information.
When I go to append the data from one to the other then I have
clashing record numbers. Is it possible to get around this
problem? Any information would be appreciated.

==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Fri, 3 Sep 1993 16:59:26 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Merging "Unique" Counter Numbers / was Counter Numbers

% From: David Long <[e-mail]>

% I'm trying to set a field with a data type of counter, to
% start with a specified number. My problem is that I have
% two separate databases being inputed with like information.
% When I go to append the data from one to the other then I have
% clashing record numbers. Is it possible to get around this
% problem? Any information would be appreciated.

A similar problem was posed on this list recently.  The request was for unique
 values to be established such
[that] a merged set of tables would ensure the primary key would remain unique.
 My suggestions (the latter
is probably better) with a twist for your situation are:

1) Assign a unique identifier to each PC and use it as part of the primary key
 with a counter field.  But this
means monitoring and maintaining extra information.

2) Make the primary key a combination of a counter field and the entry time.
 When you merge/append the
individual tables into the master table, the counter field of the "real" table
 could be used rather than the
one assigned at the individual machines.

Hope this helps.
=========================================================================
Date:         Fri, 3 Sep 1993 17:00:24 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Chet Farmer <[e-mail]>
Organization: Project IDEALS -- The University of Alabama
Subject:      Re: Automatic field updates
In-Reply-To:  Message of Tue, 31 Aug 1993 09:32:12 +0200 from <[e-mail]>

On Tue, 31 Aug 1993 09:32:12 +0200 Stefan Focke said:
>>I've experimented with the DLookUp function to a point; I've even managed
>>to get a non-interactive version of this working for the French name (ie,
>>I've an action query that runs through the database and supplies the
>>French name for every record).  What I want still eludes me.
>
>DLookUp should work for you. I did something simular and it worked. Prehaps
>you should post the code you use.

Thanks, Stefan -- if I can't get it to go after a good try, I'll
post some code.  Have a good weekend -- actually, at this writing, it
appears you're probably already having one, time zones being what they
are.

>Stefan Focke                  Tel. [phone]
>GMD-ISA                       e-mail: [e-mail]
>Rathausalle 10
>D-W 5205 Sankt Augustin 1
>    ********** MS-Word: From the guys who brought us EDLIN ********

There are those who claim that EDLIN is MS-DOS' only real claim to
being a "real" operating system -- the basis being that all "real"
operating systems come with an impossible-to-use, user-hostile,
irritating editor.  See Unix (vi), VM/XA (Xedit), etc.


+----------------------------------------------------------------+
| Chet Farmer, Assistant Director |   tel [phone]           |
| Project IDEALS                  |   [e-mail]      |
| The University of Alabama       |   [e-mail] |
|----------------------------------------------------------------|
|   C is for Cookie, and that's good enough for me.  -- C. M.    |
+----------------------------------------------------------------+
=========================================================================
Date:         Fri, 3 Sep 1993 17:03:36 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: cross references to controls, etc.
In-Reply-To:  <[e-mail]>

>DATE:   Fri, 3 Sep 1993 10:12:39 CDT
>FROM:   David Crookall <[e-mail]>
>
>Please would you provide complete information on
>Total Access -- esp. an 800 number.  Many thanks, David

Total Access is a product of FMS, Inc
                             8027 Leesburg Pike
                             Suite 410, Dept. 322
                             Vienna, VA 22182
703-356-4700 ext 322
703-448-3861 (fax)
Compuserve 73710,463 also 75160,3375

no 800 # given
Add says includes a "Field Cross-Reference" as one of 40 built-in reports.
I have not used the product.
********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Fri, 3 Sep 1993 14:33:00 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Miguel Rivera <[e-mail]>
Subject:      Help with lots of records in Combo Box

Hi everybody,

My brother is developing an application using access and he ran into
a performance problem. Here is the problem:

The system he is developing is a Point of Sale system. There are basically
3 tables involved in this problem. The first table is called "Products"
and this table holds all the products available in the store keyed by BarCode.
The second table is the "Inventory" table which holds the inventory information
keyed by BarCode. Some of the inventory information are lot number,
expiration date, and so on. The relationship between "Products" and "Inventory"
is a one to many relationship. Ok so far, the third table has the actual sale
information which holds information about who bought the product, how
much was paid for it, and so on.

The sale form is a continuous form with the following fields:
        BarCode
        Units
        PricePerUnit
        Total (Calculated field)
        QtyOnInventory (Calculated field)

The BarCode field is a ComboBox and it is using a Query as a source.
The Query generates a table with the following fields:
        ProductDescription
        BarCode

The bounded field in the combo box is the BarCode, but the user
choose the product by the description.

Now, here is the problem. First the combo box shows only the items on inventory
using the UNIQUE option of the query. This means that the number of items
in the combo box is less or equal to the number of items in the "Products"
table. The problem is that the product table has over 8000 records and Access
become very slow handling the combo box to the point that become unusable
running on a 386 33MGZ with 8 Megs of RAM and 12ms HD.

I like his design because it is easy to use for the salesperson but
it is trading off performance. Does anybody has a suggestion on
how to balance the performance with the usability of the program?

Any reply is greatly appreciated.

Thank you,
Miguel Rivera
[e-mail]
=========================================================================
Date:         Fri, 3 Sep 1993 21:35:57 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phillip Paxton <[e-mail]>
Subject:      Help with lots of records in Combo Box

% From: Miguel Rivera, INTERNET:[e-mail]

% My brother is developing an application using access and he ran into
% a performance problem. Here is the problem:

% Now, here is the problem. First the combo box shows only the items on
 inventory
% using the UNIQUE option of the query. This means that the number of items
% in the combo box is less or equal to the number of items in the "Products"
% table. The problem is that the product table has over 8000 records and Access
% become very slow handling the combo box to the point that become unusable
% running on a 386 33MGZ with 8 Megs of RAM and 12ms HD.

% I like his design because it is easy to use for the salesperson but
% it is trading off performance. Does anybody has a suggestion on
% how to balance the performance with the usability of the program?

In a nutshell, the problem isn't in the design or in the hardware capacity
 (you'd probably
see similar numbers on a 486).

The problem is in overloading (not C++ overloading) your combo box.  Access
 Combo Boxes
are not built for allowing you to select every word in a dictionary.  In terms
 of performance,
those combo boxes are like spoons -- nice to eat soup with, but not to be used
 in place of
a bucket or a bilge pump.

Compu$erve is littered with many, many stories of people who design elegant
 applications
only to see them wither away in support with their users once the database
 accumulates
enough records to bog down the combo box.

Perhaps a slight change would help -- I modified (actually, rewrote) the address
 book portion of
the PIM which is supplied with Access and instead of the push buttons for A-Z
 taking you to
a name immediately, it begins spelling out the name (you could substitute the
 keyboard) until
you hit the ! (go) button and then use a combo box to select from the list of
 hits.

Phil Paxton
Development, Eidetic, and 7-ball juggler
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Sat, 4 Sep 1993 08:45:29 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: Counter Number
In-Reply-To:  <[e-mail]>

>DATE:   Fri, 3 Sep 1993 09:29:00 EDT
>FROM:   David Long <[e-mail]>
>
>I'm trying to set a field with a data type of counter, to
>start with a specified number. My problem is that I have
>two separate databases being inputed with like information.
>When I go to append the data from one to the other then I have
>clashing record numbers. Is it possible to get around this
>problem? Any information would be appreciated.
>

It is possible to seed a table using a counter key, so that it starts
at a particular number.  You need a second table which has a long
number field with the same name as the counter field of the first
table, that would be the only field in the second table. Enter a value
in the second table's field which is one less than the first key value
you desire.

Append the row from the second table to you first table.  You can
delete that row immediatlely afterward.  Rows added to your first table
will have a key one greater than the "seeded" row.  Do not compact the
table before adding the first row of "real" data or the counter will be
reset to 1.

This technique come from the Microsoft Knowledge Base article # Q94821.
You can adopt varriations on this technique.  The key is that you can
append rows to a table with whatever key value you want to seed you tables.
I don't know if this fits your situation, but I hope it is of some use.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Sat, 4 Sep 1993 10:44:23 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phillip Paxton <[e-mail]>
Subject:      Re: Counter Number

% From: "John M. King", INTERNET:[e-mail]
>
>I'm trying to set a field with a data type of counter, to
>start with a specified number. My problem is that I have
>two separate databases being inputed with like information.
>When I go to append the data from one to the other then I have
>clashing record numbers. Is it possible to get around this
>problem? Any information would be appreciated.
>

% It is possible to seed a table using a counter key, so that it starts
% at a particular number.  You need a second table which has a long
% number field with the same name as the counter field of the first
% table, that would be the only field in the second table. Enter a value
% in the second table's field which is one less than the first key value
% you desire.

% I don't know if this fits your situation, but I hope it is of some use.

Based upon the original premise, I'm not sure how this fits in -- for multiple
collection sites, it would seem to cause extra overhead in the merging process
since the data would have to be preprocessed.
=========================================================================
Date:         Sat, 4 Sep 1993 13:29:32 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: Total Access
In-Reply-To:  Message of Fri,
              3 Sep 1993 15:02:47 EDT from <[e-mail]>

On Fri, 3 Sep 1993 15:02:47 EDT Phil Paxton said:
>% From: Dan Eklund, INTERNET:[e-mail]
>% From Aug/Sep 93 ACCESS ADVISOR Mag page 9
>% Special Intro Price $145 + $5 S&H
>
>*snicker* it's always funny to see supporting products costing more than the
> product itself!

Could some of you please let us know what Total Access is like.  Is it
worth it? (even if it's more than Access itself).  Does it actually
help one a lot to build efficient data bases?  Thanks, David
=========================================================================
Date:         Sat, 4 Sep 1993 13:33:31 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: cross references to controls, etc.
In-Reply-To:  Message of Fri,
              3 Sep 1993 17:03:36 -0400 from <[e-mail]>

Thanks, John, for the info.  Do you think that Total Access
is worth the money?  Does it help a lot in developing a
db?  Could people out there let us know what they think
of Total Access.  Thanks, David.

John, do you market any products that help with developing
databases?  Best, David
=========================================================================
Date:         Sat, 4 Sep 1993 14:01:04 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      field: date_last_modified: how to do it?

I wonder if any of you can tell me how to do the following:
I have a date field in my data-base which defaults to the
current date on data entry to the record.  I would like
to have ANOTHER field which automatically updates to the
current date every time the record is modified (not simply
looked at).  Initially, both field will contgain the same
date, but when the record is modified, the "entry date"
will remain and the "date last modified" will change.
I hope that is clear.  Is this complicated?
Thanks, David
=========================================================================
Date:         Sat, 4 Sep 1993 14:07:29 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      one report / several queries

I have another problem.  Is there any way one can have reports
separate from quesries?  Let me try to explain.  I have a report
which outputs data in a specified way to the printer.  I would
like to be able to tell it to output only subsets of all the data.
For example, instead of printout out all the addresses, I would
like to print out address in Germany, or Germany and France, or
in Germany and entered after 15 Aug 93, or ... .
In other words, can a have a set of queries separate from a report?
Or, can I use different queries for the same report?
And more importantly !, how does one do that?
Or am I asking a rediculously simple question?
And if I am, I'd still like to know.
Many thanks for any help you can provide.
Best wishes, David
=========================================================================
Date:         Sat, 4 Sep 1993 14:01:29 -0700
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Robert Reed <[e-mail]>
Subject:      Re: one report / several queries
In-Reply-To:  Your message of Sat,
              04 Sep 93 14:07:29 -0500. <[e-mail]>

David Crookall <[e-mail]> writes:
| I have another problem.  Is there any way one can have reports
| separate from quesries?  Let me try to explain.  I have a report
| which outputs data in a specified way to the printer.  I would
| like to be able to tell it to output only subsets of all the data.
| For example, instead of printout out all the addresses, I would
| like to print out address in Germany, or Germany and France, ...

Simple.  Build your report from a derived table (i.e., one that only contains
data derived from other tables).  Then use your various queries to fill that
table and print it as a report.  It's real simple to create a macro to delete
the current contents of the derived table, append new records, and run the
report.  That's how I turn our address database into personalized printed
phonebooks, either for my wife or me.
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
home: [e-mail]  5686 First Court, West Linn, OR 97068
work: [e-mail]                                        503-690-1550

Your kids are going to do to you exactly what you did to your parents.  I
know my son is going to do this to me.  Sixteen years from now, he's going
to walk up to me and say, "God, Dad, you're fucked!"  And my father will be
standing right behind him going, "Yeaaayes!  Ahahaha, revenge is Mine!"
And you have dreams that one day your kid will be standing up there going,
"I'd like to thank the Nobel Academy."  But you have this other dream he'll
be saying, "You want fries with this?"
--Robin Williams
________________________________________________________________________________
=========================================================================
Date:         Sat, 4 Sep 1993 18:28:43 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: Counter Number
In-Reply-To:  <[e-mail]>

>DATE:   Sat, 4 Sep 1993 10:44:23 EDT
>FROM:   Phillip Paxton <[e-mail]>
>
>% From: "John M. King", INTERNET:[e-mail]
>>
>>I'm trying to set a field with a data type of counter, to
>>start with a specified number. My problem is that I have
>>two separate databases being inputed with like information.
>>When I go to append the data from one to the other then I have
>>clashing record numbers. Is it possible to get around this
>>problem? Any information would be appreciated.
>>
>
>% It is possible to seed a table using a counter key, so that it starts
>% at a particular number.  You need a second table which has a long
>% number field with the same name as the counter field of the first
>% table, that would be the only field in the second table. Enter a value
>% in the second table's field which is one less than the first key value
>% you desire.
>
>% I don't know if this fits your situation, but I hope it is of some use.
>-
>Based upon the original premise, I'm not sure how this fits in -- for multiple
>collection sites, it would seem to cause extra overhead in the merging process
>since the data would have to be preprocessed.

It may in practice not fit in at all.  It might, however, fit in this
way.  One of the tables would be initialized with a starting counter
number relatively high, e.g., 50000, or whatever. The other table would
start with 1.  This would prevent the clash of counter numbers.  The
"overhead" is minimal. The extra processing is only done once, when the
table is initialized.

It, or some variation of it, appears to be the only way to start a
counter field at some particular value.  Please let me know, if there
is another way.

One can, of course, use a multi-field key, as was suggested, with some
indicator to distinguish the tables or something else.  The technique I
described may not be the preferable one in this situation. But, it does
seem to "fit in" as it answered a part of the original request--namely
how to start a counter field with a specific number.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Sat, 4 Sep 1993 18:40:39 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: cross references to controls, etc.
In-Reply-To:  <[e-mail]>

>DATE:   Sat, 4 Sep 1993 13:33:31 CDT
>FROM:   David Crookall <[e-mail]>
>
>Thanks, John, for the info.  Do you think that Total Access
>is worth the money?  Does it help a lot in developing a
>db?  Could people out there let us know what they think
>of Total Access.  Thanks, David.
>
>John, do you market any products that help with developing
>databases?  Best, David

You are welcome.  I don't know if Total Access is worth the money or
not. We are planning on getting it, but have not done so yet.  I have
seen one or two magazine reviews which were favorable, but they usually are.

I can say that documentation is an area where MS Access is somewhat
weak. This is particularly true with macros.

I don't market any products to help in database development.  I am
currently involved in the development of an application using MS Access
which may be marketed.

Good Luck.
********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Sat, 4 Sep 1993 18:54:17 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  <[e-mail]>

>DATE:   Sat, 4 Sep 1993 14:01:04 CDT
>FROM:   David Crookall <[e-mail]>
>
>I wonder if any of you can tell me how to do the following:
>I have a date field in my data-base which defaults to the
>current date on data entry to the record.  I would like
>to have ANOTHER field which automatically updates to the
>current date every time the record is modified (not simply
>looked at).  Initially, both field will contgain the same
>date, but when the record is modified, the "entry date"
>will remain and the "date last modified" will change.
>I hope that is clear.  Is this complicated?
>Thanks, David

David,

It can be done using Access Basic code.  Bound controls on forms have a
property called OldValue.  You can write a function to cycle through
the controls on a form and determine if any have changed.  You would
then write a new date to the field "date last modified."  This is only
useful if you are using a form to update your records.

I don't think there is a record level property to tell if a record
has changed.  If this is of use, I can post a copy of a function to
determine if a record has changed.  I got it from Compuserve.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Sun, 5 Sep 1993 09:35:23 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  Message of Sat,
              4 Sep 1993 18:54:17 -0400 from <[e-mail]>

Thanks, John, I'm not sure if we are talking about
exactly the same thing, so let me respond to your
very helpful reply.

On Sat, 4 Sep 1993 18:54:17 -0400 John M. King said:
>>DATE:   Sat, 4 Sep 1993 14:01:04 CDT
>>FROM:   David Crookall <[e-mail]>

>>I have a date field in my data-base which defaults to the
>>current date on data entry to the record.  I would like
>>to have ANOTHER field which automatically updates to the
>>current date every time the record is modified (not simply
>>looked at).  Initially, both field will contgain the same
>>date, but when the record is modified, the "entry date"
>>will remain and the "date last modified" will change.

>It can be done using Access Basic code.  Bound controls on forms have a
>property called OldValue.  You can write a function to cycle through
>the controls on a form and determine if any have changed.  You would
>then write a new date to the field "date last modified."  This is only
>useful if you are using a form to update your records.

Yes, I will be using a form to update records.

>I don't think there is a record level property to tell if a record
>has changed.  If this is of use, I can post a copy of a function to
>determine if a record has changed.  I got it from Compuserve.

That would be very useful.  Thanks.  Is there a useful area in
Compuserve devoted to Access?  Is it worth joining for that?

The problem I still don't know how to deal with is to have the current
date (today) automatically enter itself into the "date last modified"
field.  I was thinking that there might be some function that would
do this automatically if one of the other fields had been modified.
Presumably this would happen as one moved to another record or closed
the file (ie moved away from the current record).  Would the cursor
actually have to move "through" the field for anything to happen?  The
best would be to have the field update simply if some other field
had been changed.

I'm learning!  Also learning the limitations of Access (is that unfair?).
Thanks again for all your help.  Best, David.
=========================================================================
Date:         Sun, 5 Sep 1993 15:05:33 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      ACC-KB on CICA

The ACC-KB has been moved to the /pub/pc/win3/access directory on
FTP.CICA.INDIANA.EDU.  The problem is that they renamed it during the
move and it looks like a plain .ZIP file.  I have notified the CICA
administrators and hope they'll do something about it.

In the meantime, should you ftp ACC-KB.ZIP from CICA, rename it to
ACC-KB.EXE and run it from the DOS prompt.  You will not be able to
unzip it with PKUNZIP 1.10 because I archived it with 2.04g.  That's
why it was put on CICA as a self-dissolving archive.

BTW, this is NOT a new version of the ACC-KB.  It's still the February
1993 copy.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 6 Sep 1993 10:33:16 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders, Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Automatic field updates

> On Tue, 31 Aug 1993 11:21:40 GMT Richard Saunders, Computer Centre said:
> >I believe you've had some replies about displaying these fields on
> >your form. What worries me a little bit is that you say you want to
> >place the data into the appropriate fields in the original table. The
> >whole idea of a relational database is that you DON'T duplicate data
> >in different tables.
>
> Regardless of the "whole idea of relational databases," what we want
> to do is automate data entry for the two fields in question.  Period.
> It seems the simplest approach, and one that simplifies further work
> (ie, reports & such done later).
>
> Of course, if you have an easier way in mind to accomplish the same
> thing with a minimum of complexity, that's great.  Please share it with
> us.
>
> It's kind of a "make the program do what we want" issue, not a "proper
> behavior in relational databases" one.

Ouch! I should have phrased my reply a little differently to
make it clear that I'm still a beginner where databases and Access
are concerned. As such I doubt if I can improve on anything you've
come up with, so I'll leave it to the experts.
=========================================================================
Date:         Mon, 6 Sep 1993 07:52:20 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  <[e-mail]>

>DATE:   Sun, 5 Sep 1993 09:35:23 CDT
>FROM:   David Crookall <[e-mail]>
>
 [ much deleted to save space]
>
>>I don't think there is a record level property to tell if a record
>>has changed.  If this is of use, I can post a copy of a function to
>>determine if a record has changed.  I got it from Compuserve.
>
>That would be very useful.  Thanks.  Is there a useful area in
>Compuserve devoted to Access?  Is it worth joining for that?
>
>The problem I still don't know how to deal with is to have the current
>date (today) automatically enter itself into the "date last modified"
>field.  I was thinking that there might be some function that would
>do this automatically if one of the other fields had been modified.
>Presumably this would happen as one moved to another record or closed
>the file (ie moved away from the current record).  Would the cursor
>actually have to move "through" the field for anything to happen?  The
>best would be to have the field update simply if some other field
>had been changed.
>
>I'm learning!  Also learning the limitations of Access (is that unfair?).
>Thanks again for all your help.  Best, David.

Here is the function:
--------------------------------------------------------------------------
Function IsRecordChanged (F As Form)
  Dim i As Integer
  Dim Changed As Integer
  Dim temp As Integer

  'Handle non-bound controls
  On Error GoTo RIC_Err
  Changed = False
  For i = 0 To F.Count - 1
        ' Reset the error trapper first
        Err = 0
        temp = False
        If (IsNull(F(i)) Or IsNull(F(i).OldValue)) Then
          temp = temp Or (IsNull(F(i).OldValue) And Not IsNull(F(i)))
          temp = temp Or (IsNull(F(i)) And Not IsNull(F(i).OldValue))
        Else
          temp = (F(i) <> F(i).OldValue)
        End If

        If Err = 0 Then
          Changed = Changed Or temp
        End If
  LoopBottom
        Next i
        ISRecordChanged = Changed
        Exit Function
  RIC_Err:
        Resume LoopBottom
  End Function
-----------------------------------------------------------------------
Credit for this belongs to Ken Getz 76137,3650.  Any obvious errors are
likely due to my lack of typing skills.

I have not used the function.  I would think you would put it in the
OnClose property of the form, with modifications to update the "last
update" field in the table if the record changed.  If you put it in the
field itself, it would not get executed unless you "moved" through the field.
In any case, it will not all be automatic until you code it that way.

I can't really say if it will be worth it to you to join CompuServe or not?
If you use one of the automated aids to accessing it the costis not too
high, but it is not free.  The MSACCESS forum is very active and is
supported by Microsoft and by very knowledgeable users.  You can get
official answers there.  Try it, you can always stop. Cost is on a
connect time basis primarily.

Hope this helps.
********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Mon, 6 Sep 1993 12:07:53 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: ACC-KB on CICA
In-Reply-To:  Message of Sun, 5 Sep 1993 15:05:33 EST from <NBRINDLE@INDYCMS>

Thanks, Nathan, for the info about the file.
Best, David
=========================================================================
Date:         Mon, 6 Sep 1993 12:17:10 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  Message of Mon,
              6 Sep 1993 07:52:20 -0400 from <[e-mail]>

Many thinks indeed to John King for your help.
Best, David
=========================================================================
Date:         Mon, 6 Sep 1993 12:46:34 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Chet Farmer <[e-mail]>
Organization: Project IDEALS -- The University of Alabama
Subject:      Re: Automatic field updates
In-Reply-To:  Message of Mon,
              6 Sep 1993 10:33:16 GMT from <[e-mail]>

On Mon, 6 Sep 1993 10:33:16 GMT Richard Saunders, Computer Centre said:
>Ouch! I should have phrased my reply a little differently to
>make it clear that I'm still a beginner where databases and Access
>are concerned. As such I doubt if I can improve on anything you've
>come up with, so I'll leave it to the experts.

Not a problem -- in retrospect, I may have fired my reply a bit hastily,
so we'll chalk it up to experience.  Thanks for your help, at any rate.

We're all beginners at my end!


+----------------------------------------------------------------+
| Chet Farmer, Assistant Director |   tel [phone]           |
| Project IDEALS                  |   [e-mail]      |
| The University of Alabama       |   [e-mail] |
|----------------------------------------------------------------|
|   C is for Cookie, and that's good enough for me.  -- C. M.    |
+----------------------------------------------------------------+
=========================================================================
Date:         Mon, 6 Sep 1993 10:31:00 LCL
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         RH <[e-mail]>
Subject:      "New line"Code?

I heard that there are four lines of code
that can entered into the "before update"
section of a memo field that will allow
one to enter carriage returns "new lines"
without advancing to the next field.
Thanks
==============================================================================

  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================



The following extract from Microsoft's Technet CD ROM should provide an
answer
to your question:

---------------------------------------------------------------------
Text boxes in Microsoft Access do not support using the ENTER key to
add lines within a field. When ENTER is pressed in a text box, the
focus is placed on the next field or control. This article explains
how to change the functionality of pressing ENTER in text boxes so
that it adds lines instead of changing the focus.

The following function changes the behavior of the ENTER key in text
boxes to allow adding lines instead of changing the focus to a
different field or control. This code should be attached to the
BeforeUpdate event of the text box.

NOTE: There must be some change to the text box before this code will
work because Microsoft Access evaluates controls only after they have
been changed (dirtied).

In the Declarations section of a Module, type the following:

   Declare Function GetKeyState% Lib "user.exe" (ByVal nKey%)
   Const VK_RETURN = &HD

The following is the actual code:

   Function MakeEnterWork()
      If GetKeyState(VK_RETURN) < 0 Then
         DoCmd CancelEvent
         SendKeys "^{ENTER}"
      End If
   End Function

Regards,
Bob Hanschke
Texas Instruments, Inc.
Dallas, TX
=========================================================================
Date:         Tue, 7 Sep 1993 09:37:00 LCL
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         mkro <[e-mail]>
Subject:      RSCode39 Font for ACCESS

Does anyone know where I could FTP a copy of the TrueType font called
RSCode39?
This is a bar code font for use with windows.


Regards,
Mike Kroeger
*** uuencoded BINARY enclosure ***
The section below this line contains an MHS attachment.  To extract it,
copy this message to a file and use the program UUDECODE.  For information
on using UUDECODE on UNIX systems, type the command 'man uudecode'.  The
attachment name was originally: ATTRIBS.BND
---------------
begin 644 attribs.bnd
M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``8G)6IK*```````4E-#;V1E,SD@
M1F]N="!F;W(@04-#15-3````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`&UK<F\`````````````````````````````````````````````````````
M```````````````````````````````````Q,#4V.$,R0S`Q0SE!,44P````
M````````0F5Y;VYD(%!R;W!R:65T87)Y($1A=&$:``````0`````````!``%
M````````````````````````````1F]R;01-96UO`0`````````5``,`````
M``````````````````````!5<V4@4')O<&]R=&EO;F%L($9O;G0!``$1````
M``````0`2@$``````````````````````````%1E>'25`$1O97,@86YY;VYE
M(&MN;W<@=VAE<F4@22!C;W5L9"!&5%`@82!C;W!Y(&]F('1H92!4<G5E5'EP
M92!F;VYT(&-A;&QE9"!24T-O9&4S.3\*5&AI<R!I<R!A(&)A<B!C;V1E(&9O
M;G0@9F]R('5S92!W:71H('=I;F1O=W,N"@H*4F5G87)D<RP*36EK92!+<F]E
M9V5RKP`#`)4`J``!``$````&``$``0`!`)4`````````./\```````"0`0``
M````````35,@4V%N<R!397)I9@```````````````````````````````0`!
M`%```0!1`'X``0!_`'\``0"``(```0"!`(D``0"*`)8`````````````````
M9``!T@`!I`$!=@(!2`,!&@0![`0!O@4!D`8!8@<!-`@!!@D!V`D!J@H!?`L`
M`````````````!``!@```````````````````````````$%T=&%C:&UE;G0@
+0V]U;G0$````````
`
end
=========================================================================
Date:         Tue, 7 Sep 1993 11:16:38 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      macro documentation

% I can say that documentation is an area where MS Access is somewhat
% weak. This is particularly true with macros.

% I don't market any products to help in database development.  I am
% currently involved in the development of an application using MS Access
% which may be marketed.

With the previous paragraph in mind, why focus on macros for a marketed product?
  Since
you can't perform error-trapping in macros, it would be a death wish to rely
 upon them...
(unless you are converting macros to ABC and working from there)
=========================================================================
Date:         Tue, 7 Sep 1993 09:06:17 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Richardson <[e-mail]>
Subject:      Re: "New Line"Code?

There is a much simpler way of doing what you want.  Just hold down the <CTRL>
key then hit <ENTER> this will move the cursor to the Next Line.

************************************************************************
* James Richardson             *           Normal Disclaimer           *
* - Tech Extraordinary  ;}  US *  My opinions belong to my Left Brain  *
* Canon Information Systems  S * Those of my  Right Brain might differ *
* 4009 Miranda Avenue        N *      CIS can speak for itself         *
* Palo Alto CA  94304        A *****************************************
* 415-852-2090 VOICE         I *  [e-mail]      -- EMAIL   *
* 415-852-2070 FAX           L *  WTMR52B                   -- PRODIGY *
************************************************************************


______________________________ Reply Separator _________________________________
Subject: "New Line"Code?
Author:  [e-mail] at cis-ccsmtp
Date:    9/2/93 8:18 AM


I heard that there are four lines of code
that can entered into the "before update"
section of a memo field that will allow
one to enter carriage returns "new lines"
without advancing to the next field.
Thanks
==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Tue, 7 Sep 1993 11:08:00 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Miguel Rivera <[e-mail]>
Subject:      Bar Code Reader

Does anybody have any recomendation for a Bar Code reader
to use with windows and Access 1.1?

Any infomation is greatly appreciated.

Thank you,

Miguel Rivera
[e-mail]
=========================================================================
Date:         Tue, 7 Sep 1993 11:01:03 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: "New Line"Code?

I needed this function too. Although I know about the <CTRL> <ENTER>
combination (and use it), it is much harder to re-train users that
are used to using Enter, alone.

>
> There is a much simpler way of doing what you want.  Just hold down the <CTRL>
> key then hit <ENTER> this will move the cursor to the Next Line.
>
> ************************************************************************
> * James Richardson             *           Normal Disclaimer           *
> * - Tech Extraordinary  ;}  US *  My opinions belong to my Left Brain  *
> * Canon Information Systems  S * Those of my  Right Brain might differ *
> * 4009 Miranda Avenue        N *      CIS can speak for itself         *
> * Palo Alto CA  94304        A *****************************************
> * 415-852-2090 VOICE         I *  [e-mail]      -- EMAIL   *
> * 415-852-2070 FAX           L *  WTMR52B                   -- PRODIGY *
> ************************************************************************
>
>
> ______________________________ Reply Separator _______________________________
__
> Subject: "New Line"Code?
> Author:  [e-mail] at cis-ccsmtp
> Date:    9/2/93 8:18 AM
>
>
> I heard that there are four lines of code
> that can entered into the "before update"
> section of a memo field that will allow
> one to enter carriage returns "new lines"
> without advancing to the next field.
> Thanks
> ==============================================================================
>   David B. Long                         E-Mail=> [e-mail]
>   AT&T Network Systems                      or=> [e-mail]
>   Quality Engineering                     Tele=> 508-960-3683
> ==============================================================================
>



-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Tue, 7 Sep 1993 11:06:55 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Bar Code Reader

There are lots available these days. I know of some from
Worthington that works well. They supply laser and wand readers.
Nowadays they interface between the keyboard and computer so that
you see the code as though the user typed it in themself.

If you can afford the hand-laser, I would get it. It is much
more accurate than the wands. You can also scan at a distance
with the hand-lasers.


>
> Does anybody have any recomendation for a Bar Code reader
> to use with windows and Access 1.1?
>
> Any infomation is greatly appreciated.
>
> Thank you,
>
> Miguel Rivera
> [e-mail]
>



-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Tue, 7 Sep 1993 13:46:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      Counter Number

>>I'm trying to set a field with a data type of counter, to
>>start with a specified number. My problem is that I have
>>two separate databases being inputed with like information.
>>When I go to append the data from one to the other then I have
>>clashing record numbers. Is it possible to get around this
>>problem? Any information would be appreciated.
>>
>% It is possible to seed a table using a counter key, so that it starts
>% at a particular number.  You need a second table which has a long
>% number field with the same name as the counter field of the first
>% table, that would be the only field in the second table. Enter a value
>% in the second table's field which is one less than the first key value
>% you desire.

Thanks John, this works just fine! It's to bad one has to "seed" the table
by importing another...should be able to specify the starting number in the
begining.....maybe in some future version.


==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Tue, 7 Sep 1993 13:56:51 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Shannon Burgin <##[e-mail]>
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  In reply to your message of SUN 05 SEP 1993 10:35:23 EDT

> Thanks, John, I'm not sure if we are talking about
> exactly the same thing, so let me respond to your
> very helpful reply.
>
> On Sat, 4 Sep 1993 18:54:17 -0400 John M. King said:
> >>DATE:   Sat, 4 Sep 1993 14:01:04 CDT
> >>FROM:   David Crookall <[e-mail]>
>
> >>I have a date field in my data-base which defaults to the
> >>current date on data entry to the record.  I would like
> >>to have ANOTHER field which automatically updates to the
> >>current date every time the record is modified (not simply
> >>looked at).  Initially, both field will contgain the same
> >>date, but when the record is modified, the "entry date"
> >>will remain and the "date last modified" will change.
>
> >It can be done using Access Basic code.  Bound controls on forms have a
> >property called OldValue.  You can write a function to cycle through
> >the controls on a form and determine if any have changed.  You would
> >then write a new date to the field "date last modified."  This is only
> >useful if you are using a form to update your records.
>
> Yes, I will be using a form to update records.
>
> >I don't think there is a record level property to tell if a record
> >has changed.  If this is of use, I can post a copy of a function to
> >determine if a record has changed.  I got it from Compuserve.
>
> That would be very useful.  Thanks.  Is there a useful area in
> Compuserve devoted to Access?  Is it worth joining for that?
>
> The problem I still don't know how to deal with is to have the current
> date (today) automatically enter itself into the "date last modified"
> field.  I was thinking that there might be some function that would
> do this automatically if one of the other fields had been modified.
> Presumably this would happen as one moved to another record or closed
> the file (ie moved away from the current record).  Would the cursor
> actually have to move "through" the field for anything to happen?  The
> best would be to have the field update simply if some other field
> had been changed.
>
> I'm learning!  Also learning the limitations of Access (is that unfair?).
> Thanks again for all your help.  Best, David.

If you are using a form, you can just modify the form's before update
properties box to call a macro that does a set  value on the field that
you want to update. This will only update the updated date, if the
record is being modified.


************************************************************************
*                                *                                     *
* Shannon Burgin                 *    University of Tennessee/Martin   *
* Bitnet: ##[e-mail]    *    Computer Center                  *
* Phone: [phone]            *    102 Cooper Hall                  *
* Senior Systems Analyst         *    Martin, TN 38238                 *
* VM/VSE/CICS/VSAM/DLI/SQLDS     *                                     *
************************************************************************
=========================================================================
Date:         Tue, 7 Sep 1993 14:54:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      Re: "New Line"Code?

I heard that there are four lines of code
that can entered into the "before update"
section of a memo field that will allow
one to enter carriage returns "new lines"
without advancing to the next field.
Thanks
==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================

>
> There is a much simpler way of doing what you want.  Just hold down the <CTRL>
> key then hit <ENTER> this will move the cursor to the Next Line.
>
Thanks Jim, sometimes the simplest solutions are the hardest to find.
I'll try the code also, and ask my users what they prefer.


==============================================================================
  David B. Long                         E-Mail=> [e-mail]
  AT&T Network Systems                      or=> [e-mail]
  Quality Engineering                     Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Tue, 7 Sep 1993 17:36:56 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>
Organization: KING Systems
Subject:      Re: macro documentation
In-Reply-To:  <[e-mail]>

>DATE:   Tue, 7 Sep 1993 11:16:38 EDT
>FROM:   Phil Paxton <[e-mail]>
>
>% I can say that documentation is an area where MS Access is somewhat
>% weak. This is particularly true with macros.
>
>% I don't market any products to help in database development.  I am
>% currently involved in the development of an application using MS Access
>% which may be marketed.
>
>With the previous paragraph in mind, why focus on macros for a marketed product
?
>  Since
>you can't perform error-trapping in macros, it would be a death wish to rely
> upon them...
>(unless you are converting macros to ABC and working from there)

A good point.  Actually, my role does involve converting macros to
code. I don't believe, however, that you can avoid them completely.
You cannot do menus in code, macros seem to be the only way in Access
to create custom menus.

********************************************************************************
*         John King                                 KING Systems               *
*     CompuServe 72060,3706                     Internet [e-mail]    *
*     MCI Mail   553-0074                       Fax      [phone]          *
********************************************************************************
=========================================================================
Date:         Tue, 7 Sep 1993 15:42:20 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon D Gardner <[e-mail]>
Subject:      Re: one report / several queries

>I have another problem.  Is there any way one can have reports
>separate from quesries?  Let me try to explain.  I have a report
>which outputs data in a specified way to the printer.  I would
>like to be able to tell it to output only subsets of all the data.
>For example, instead of printout out all the addresses, I would
>like to print out address in Germany, or Germany and France, or
>in Germany and entered after 15 Aug 93, or ... .
>In other words, can a have a set of queries separate from a report?
>Or, can I use different queries for the same report?
>And more importantly !, how does one do that?
>Or am I asking a rediculously simple question?
>And if I am, I'd still like to know.
>Many thanks for any help you can provide.
>Best wishes, David



David -
When you open a report, you can specify the name of a filter, or you
can stipulate a "where condition". Just enter Country="Germany" or an
expression that will provide the filter that you want.

... Jon ...
[e-mail]
=========================================================================
Date:         Wed, 8 Sep 1993 11:47:07 GMT+1200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Daniel Bar-Even <[e-mail]>
Organization: National Library of New Zealand
Subject:      Query criteria

Access' Order Entry database has this function...

Function ConvertNulls (v As Variant, subs As Variant) As Variant
    If (IsNull(v)) Then
        ConvertNulls = subs
    Else
        ConvertNulls = v
    End If
End Function

...which is neat for listing all records with data in a table if no
criteria is entered. Eg Like ConvertNulls([EnterCriteriaHere],"*")

My problem is that I want to able to list all records with or without
data if no criteria is entered.  Someone else must have found a
solution to this problem.  Any suggestions?

TIA
**********************************************************
Daniel Bar-Even   ([e-mail])
Client Support Analyst
National Library of New Zealand
Te Puna Matauranga o Aotearoa
P.O. Box 1467
Wellington
New Zealand         Ph: [phone]  Fax: [phone]
**********************************************************
=========================================================================
Date:         Wed, 8 Sep 1993 08:34:00 +01
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Nilsson Jimmy, HK/R IDE" <[e-mail]>
Subject:      Integra

Hi!
 ----

Is there anyone who have tested Integra's (am I using the right name of the
product?) form- and report-builder together with VB 3.0? Was it good? Better
than the form- and report-builder in Access? Do you use Integra rather than
VB 3.0 on it own?

Thanks in forward
Jimmy Nilsson, University College of Karlskrona/Ronneby, Sweden
[e-mail]
###
=========================================================================
Date:         Wed, 8 Sep 1993 09:52:33 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stefan Focke <[e-mail]>
Subject:      How to get the archived messages

Hello!

I remember, that it is possible to find the messages that were posted to
this list. My problem is, that I do not remember how to do it.

Could someone send me a description?

Thank you

Stefan Focke
----------------------------------------------------------------------

Stefan Focke                  Tel. [phone]
GMD-ISA                       e-mail: [e-mail]
Postfach 1316
D - 53731 Sankt Augustin

    ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Wed, 8 Sep 1993 08:40:28 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Arman Rivard <[e-mail]>
Subject:      Re: Query criteria
In-Reply-To:  Daniel Bar-Even <[e-mail]> "Query criteria"
              (Sep  8, 11:47am)

On Sep 8, 11:47am, Daniel Bar-Even wrote:
> Subject: Query criteria
> Access' Order Entry database has this function...
>
> Function ConvertNulls (v As Variant, subs As Variant) As Variant
>     If (IsNull(v)) Then
>         ConvertNulls = subs
>     Else
>         ConvertNulls = v
>     End If
> End Function
>
> ...which is neat for listing all records with data in a table if no
> criteria is entered. Eg Like ConvertNulls([EnterCriteriaHere],"*")
>
> My problem is that I want to able to list all records with or without
> data if no criteria is entered.  Someone else must have found a
> solution to this problem.  Any suggestions?

 You can add an Or is Null  in the Criteria section of your query.
 ConvertNulls([EnterCriteriaHere],"*") Or is Null

  Hope that helps.

>
> TIA
> **********************************************************
> Daniel Bar-Even   ([e-mail])
> Client Support Analyst
> National Library of New Zealand
> Te Puna Matauranga o Aotearoa
> P.O. Box 1467
> Wellington
> New Zealand         Ph: [phone]  Fax: [phone]
> **********************************************************
>-- End of excerpt from Daniel Bar-Even



--

Arman Rivard         How do Peabody and Sherman get back ?
<[e-mail]>
=========================================================================
Date:         Wed, 8 Sep 1993 07:48:18 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: How to get the archived messages
In-Reply-To:  Message of Wed, 8 Sep 1993 09:52:33 +0200 from <[e-mail]>

To index the archives, send the command

IND ACCESS-L

to [e-mail]
or [e-mail]

Find the log file you want (they are divided by month) and then send the
command

GET ACCESS-L LOGYYMM  (where YYMM is Year/Month, i.e., LOG9309 for Sept. 93)

to the LISTSERV address.
Note that these commands should NOT be sent to the list but to LISTSERV.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Sep 1993 12:20:57 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Searching Archives / Was:: Re: How to get the archived messages

% To index the archives, send the command

% Find the log file you want (they are divided by month) and then send the
% command

% to the LISTSERV address.
% Note that these commands should NOT be sent to the list but to LISTSERV.


I'd like to add one of my favourites (pardon the UK spelling):

Searching LISTSERV archives.  This is one of the most underused processes
 available.

I keep the following available instead of crafting one from scratch.

The search mechanisms for LISTSERV are extremely powerful, but this is the
 simple form
and will usually get what you want.

-------------------------------------------------------cut
 here-------------------------------------------------------
//Looking JOB Echo=YES,Reply-via=MAIL
Database search DD=Mine
//Mine DD *
Search NEEDLE in HAYSTACK
index
PRINT ALL
-------------------------------------------------------cut
 here-------------------------------------------------------

Substitute the keywords you are looking for in place of NEEDLE and the name
of the list in place of HAYSTACK.  You must always perform an index before you
 can
print any messages from a search.  If you are afraid there are a bazillion [sic]
 messages,
omit the PRINT ALL and you'll receive just an index of the messages along with
 the
summary for each message.  PRINT ALL will print those messages qualifying for
 the
search specifications.

You'll receive at least one message which is the command file log, then a second
 file
if the search was successful.

Hope this helps.

Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
=========================================================================
Date:         Wed, 8 Sep 1993 11:41:30 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Searching Archives / Was:: Re: How to get the archived
              message s
In-Reply-To:  Message of Wed,
              8 Sep 1993 12:20:57 EDT from <72410.2162@COMPUSERV E.COM>

Absolutely correct, Phil, and I should have mentioned that.

For those on VM systems, there is a utility called LDBASE that allows
you to do interactive searches on list archives.  Check with your local
consultant as to where to get it...it should be available from LISTSERV
as a $PACKAGE.  (I got it so long ago I can't remember the file name.)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Sep 1993 12:37:47 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: field: date_last_modified: how to do it?
In-Reply-To:  Message of Tue, 7 Sep 1993 13:56:51 EDT from <##06@UTMARTN>

Many thanks to Shannon Burgin for your help.
Best wishes, david crookall
=========================================================================
Date:         Wed, 8 Sep 1993 12:46:08 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: one report / several queries
In-Reply-To:  Message of Tue,
              7 Sep 1993 15:42:20 PST from <[e-mail]>

Thanks, Jon, for your help.  One doesn't always see the
obvious -- at least I don't.  Best, David
=========================================================================
Date:         Wed, 8 Sep 1993 13:47:33 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Shannon Burgin <##[e-mail]>
Subject:      Help! This file is already in use!

I am trying to open an access database. I receive the message box, "This
file is already in use." It is not in use. I tried repair and received
the same message. First, how can I fix this? Second, how did this
happen? (Additional notes: there was no power failure, etc. and my
backup copy with the same date and time works.)


************************************************************************
*                                *                                     *
* Shannon Burgin                 *    University of Tennessee/Martin   *
* Bitnet: ##[e-mail]    *    Computer Center                  *
* Phone: [phone]            *    102 Cooper Hall                  *
* Senior Systems Analyst         *    Martin, TN 38238                 *
* VM/VSE/CICS/VSAM/DLI/SQLDS     *                                     *
************************************************************************
=========================================================================
Date:         Wed, 8 Sep 1993 15:03:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      Security Lock-out

Help!
I decided that it was time to work on the "security" of
my database. Well I did something wrong, and now I'm
locked out of the "Users" and "Groups" under the security menu.
I'm still called the "admin", but have restricted access.
I backed up the database before I made changes, but it seems
that it doesn't matter, I'm still locked out after a restore.
What should I do next?
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Wed, 8 Sep 1993 14:12:20 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Security Lock-out
In-Reply-To:  Message of Wed, 8 Sep 1993 15:03:00 EDT from <[e-mail]>

You will need to reinstall SYSTEM.MDA in your ACCESS subdirectory from
the installation disks.  Whenever you get the urge to mess with security,
good practice seems to be "back up SYSTEM.MDA!" so you can restore it
if something untoward happens.

Read the security white paper before you do any more security changes.
Send the command GET SECURE TEXT to [e-mail] and the
listserver will return a copy to you.

HTH,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Sep 1993 14:14:37 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Help! This file is already in use!
In-Reply-To:  Message of Wed, 8 Sep 1993 13:47:33 EDT from <##06@UTMARTN>

This happened to me once and the only thing I tried that worked was to
exit Access and reboot the machine.  ?  Don't ask me why it worked, it
just did.

:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 9 Sep 1993 09:17:25 GMT+1200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Daniel Bar-Even <[e-mail]>
Organization: National Library of New Zealand
Subject:      Re: Query criteria

> From:          Arman Rivard <[e-mail]>

> On Sep 8, 11:47am, Daniel Bar-Even wrote:
> > Subject: Query criteria
> > Access' Order Entry database has this function...
> >
> > Function ConvertNulls (v As Variant, subs As Variant) As Variant
> >     If (IsNull(v)) Then
> >         ConvertNulls = subs
> >     Else
> >         ConvertNulls = v
> >     End If
> > End Function
> >
> > ...which is neat for listing all records with data in a table if
> > no criteria is entered. Eg Like
> > ConvertNulls([EnterCriteriaHere],"*")
> >
> > My problem is that I want to able to list all records with or
> > without data if no criteria is entered.  Someone else must have
> > found a solution to this problem.  Any suggestions?
> >
> You can add an Or is Null  in the Criteria section of your query.
> ConvertNulls([EnterCriteriaHere],"*") Or is Null
>
>   Hope that helps.
>
Sorry I should have been more specific (but thank you anyway Arman).
I want to be able to list ONLY the records that match the criteria if
it is entered and ALL the records including Nulls if no criteria is
entered.
**********************************************************
Daniel Bar-Even   ([e-mail])
Client Support Analyst
National Library of New Zealand
Te Puna Matauranga o Aotearoa
P.O. Box 1467
Wellington
New Zealand         Ph: [phone]  Fax: [phone]
**********************************************************
=========================================================================
Date:         Wed, 8 Sep 1993 11:14:00 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "OOPS-EXT.-2104 WHERE ARE WE TODAY?" <[e-mail]>
Subject:      Help on getting around...

Could someone please tell me how to get lists of lists on other subjects on
the internet.  Sorry to post this to the Access digest but I don't have an
active connection to the internet and no other way of getting information
about how to find my way around.  Thanks in advance....


sean
=========================================================================
Date:         Thu, 9 Sep 1993 15:12:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Briganti, Joe" <[e-mail]>
Subject:      attaching to Paradox for Windows tables

Greetings,

recently, I asked this list about security violations I was experiencing
when attempting
to read Paradox for Windows tables form MS-Access. The answer was that P4W
v1.0
is really Paradox 4.0 and hence Access cant read them causing the
password/security pop-ups.

P4W does not have any retro-conversions from v4.0 to v3.5 (as I believe does
the dos version) however there is something you can do trick Access and
indeed Paradox. Convert P4W tables v4.0 to a dbase (.dbf) file and then
attach or import to it
from Access. This will work until they change the dbase table format :-)

 --
Joe Briganti ([e-mail])
=========================================================================
Date:         Thu, 9 Sep 1993 08:09:40 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from OVVM to RFC822 format by PUMP V2.2
From:         Michael Blankenstein <[e-mail]>
Subject:      Re: Help! This file is already in use!
In-Reply-To:  note of 09/08/93 15:15

Assuming that the db file has the a filename extension associated with Access,
double-click on the database file from the filemanager. I also am not sure
why this works. My access denied problems usually arise after compacting.

Good Luck.

Michael Blankenstein

[e-mail] (e-mail)
=========================================================================
Date:         Thu, 9 Sep 1993 10:21:10 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: Help! This file is already in use!

% From: Nathan Brindle, INTERNET:[e-mail]

% This happened to me once and the only thing I tried that worked was to
% exit Access and reboot the machine.  ?  Don't ask me why it worked, it
% just did.

I don't think one actually needs to reboot.  I've always been able to exit &
 restart Windows
and the problem has been corrected.

Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 9 Sep 1993 10:31:59 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      ABC vs. Ctrl-Enter

I thought I'd post a follow-up regarding the use of ABC (Access Basic Code)
vs. Ctrl-Enter.  When the original poster mentioned seeing which the
end-users preferred, that triggered a line of thinking on my part which I
felt best to post/share:

Remember, that by adding the ABC feature such [that] the user is able to
use the Enter/Return key, you are almost promising them this will be there
in the future.  This means it should be on your list of things to test with
future releases of the Access software as well as all revisions to your
applications.  It also means anyone following your path there will need to
know this as you are destined to make some enemies (in retrospect) by being
fancy now but if the need changes, it's not always fun to force users to
change their habits "just because" (which is how it might seem to them)...

Just some food for thought.


Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Fri, 10 Sep 1993 16:23:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      SUB ACCESS-L <[e-mail]>

SUB ACCESS -L <[e-mail]>

I hope this gets me on the ACCESS-L list.
=========================================================================
Date:         Fri, 10 Sep 1993 16:35:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      ACCESS-L

This is my first time really and will you respect me in the morning?

If any one actually receives this could you please email me so I can send
my real problem.

Thanking you in advance

Kevin

Email  [e-mail]
=========================================================================
Date:         Fri, 10 Sep 1993 16:41:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Update Master File from Details form

I hope this works..

I am a new user of Access (yes another one).

I have taught myself over the last week as I am evaluating packages
and there are a number of functions I want any D/B package to do.

The one I would like an answer to is:

        I want to update a control-total field in a master record
        based on the values in it's detail records.

        I can use a subform within the form but the detail file
        contains too much data. How can I update the master control total
        from the detail form?? I tried a function, but I cannot seem
        to send the control total value back to the macro/form.

        Please help..

Kevin (Klatu Barada Nicto Gort Klau Barada Nicto)
Email [e-mail]
=========================================================================
Date:         Fri, 10 Sep 1993 16:45:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      IND ACCESS-L

IND ACCESS-L
=========================================================================
Date:         Fri, 10 Sep 1993 08:14:00 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Access-L Listserv

Greetings,
What listserver is this list on?  I would like to change options, but the
listserver doesn't seem to think I'm on the list (LISTSERV@INDYCMS is what
I tried).
Thanks,
Jim Pejsa  [e-mail]
=========================================================================
Date:         Fri, 10 Sep 1993 08:49:56 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Scanning documents for Access database...

I'm wanting to create an Access data-base to store and track
scanned images of documents. What I'm looking for are techniques,
software, etc... that will get the images in the smallest, ledgible
format possible. I don't want to use OCR but only store the graphic
image of the documents. The documents are transcripts (some are
from foreign countrys and are handwritten), letters, test score
reports, etc...

What I'm hoping is to find an OLE-supporting application for the
scanner so it can be used directly from the Access application to input
the images to the database. However, a big consideration is the size of
the image so maybe I'll need another application to manipulate the images
into the best possible format.

The application will need to handle a large volume of documents so, to
make it functional, speed is also important.

Presently, I have a Pentax IQ-Scan and the only software I have is an
old version of WordScan. I've used it to scan documents but, thus far,
the best I've been able to do for a letter-sized document is to put it
in .pcx format and it's using 35 to 50K for a one-page document.

Any suggestion will be highly appreciated.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|                         o__                                          |
| Steve Bratten          _.>/^_      BITNET < GE0793@SIUCVMB >         |
| Graduate School       (_) \(_)   INTERNET < [e-mail] > |
| Southern Illinois University                                         |
| Carbondale IL 62901-4716   \o  \o  \o   Graduate School              |
| Voice: [phone]       |>  |>  |>  Southern Illinois University |
|   Fax: [phone]      < \ < \ < \  Carbondale, IL  62901-4716   |
|                                                                      |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date:         Fri, 10 Sep 1993 08:51:37 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Scanning documents for Access database...
In-Reply-To:  Message of Fri, 10 Sep 1993 08:49:56 -0500 from <GE0793@SIUCVMB>

WOW...that sounds like a LARGE .MDB...and while it would probably work,
have you considered keeping each graphic <individually> on your hard
drive and using an OLE link in a form to display the graphic image?  That
would keep your .MDB to a reasonable size and would also facilitate
being able to retrieve each graphic individually outside of Access.

Just a thought, I haven't actually tried this myself.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 10 Sep 1993 09:25:58 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Scanning images for storage...

>
>WOW...that sounds like a LARGE .MDB...and while it would probably work,
>have you considered keeping each graphic <individually> on your hard
>drive and using an OLE link in a form to display graphic image?  That
>would keep your .MDB to a reasonable size and would also facilitate
>being able to retrieve each graphic individually outside of Access.
>
Quite likely, you're exactly right about the method for storing the
images. However, right now, my problem is getting them scanned and
in a small file in a timely manner; I believe I'll need to have
at least 3000 to 5000 images retrievable at one time so, no matter
where they are stored, I need them to be as small as possible.

>Just a thought, I haven't actually tried this myself.

I've just set up a database to store and track OLE objects; spe-
cifically, I'm embedding one graph from a Lotus Improv model (spread-
sheet;) and it appears to be a good way (only embeds one graph in
the Access table but provides access to all the other graphs and work-
sheets in the Improv model with a double-click on the object frame. I
like it and will probably try a similar method with the image-storing
application. But, again, what I need first is a viable method of
scanning the documents and getting them into a small file format, pre-
ferrably using something that supports OLE.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|                         o__                                          |
| Steve Bratten          _.>/^_      BITNET < GE0793@SIUCVMB >         |
| Graduate School       (_) \(_)   INTERNET < [e-mail] > |
| Southern Illinois University                                         |
| Carbondale IL 62901-4716   \o  \o  \o   Graduate School              |
| Voice: [phone]       |>  |>  |>  Southern Illinois University |
|   Fax: [phone]      < \ < \ < \  Carbondale, IL  62901-4716   |
|                                                                      |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date:         Fri, 10 Sep 1993 09:26:04 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         "Brian Keeler (403) - 471-8623" <[e-mail]>
Subject:      ACCESS-L
In-Reply-To:  note of 93-09-10 02:57

You made it to the net, I read your message.. have a good day..

Brian Keeler (403) - 471-8623     ..What is a CD-ROM ??
Application Services Coordinator   3 billion pits arranged
Information Services Division      in a 3 mile spiral...
domain: [e-mail]
=========================================================================
Date:         Fri, 10 Sep 1993 13:48:23 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      ACC-KB--again...

Sorry all--between the CICA folks and myself it has been determined that
the ACC-KB.ZIP file residing on CICA in pub/pc/win3/access is NOT the
ACC-KB.EXE file which <I> uploaded some time back (and which is still
on CICA in pub/pc/win3/uploads/JUN93).

The ACC-KB.ZIP file in the access directory seems to be from late June
and is much larger than the file I uploaded (which was from February).
It appears that it was zipped with PKZIP 2.04g as the copy of 1.10 I
have here at work reports an unknown compression method.  ACC-KB.ZIP
is nearly a megabyte in size and the .HLP file it contains is 1.2mb
uncompressed.  I will try to unzip it tonight at home and let the list
know how it goes.

Again, sorry for the mixup.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 10 Sep 1993 15:54:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Rick.Klingensmith" <[e-mail]>
Subject:      ACC-KB.ZIP

I successflly unzipped ACC-KB.ZIP file residing on CICA in pub/pc/win3/access
using PKZIP 2.04. After I renamed it and got the nasty error message I tried
to unzip it and all worked.

Rick
=========================================================================
Date:         Fri, 10 Sep 1993 15:26:40 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Rick Huff <[e-mail]>
Subject:      Join with Two Fields

Is it possible to join two tables using two fields?  For example I want two
tables joined on customer number and purchase order number.

I have tried doing this graphically by dragging the additional field from one
table to the other, but this creates another join (instead of a further
qualified single join).

The next try was to modify the SQL for the query.

I think I want something like this:

SELECT *

FROM CUSTOMER, SUMMARY LEFT JOIN CUSTOMER ON CUSTOMER.CustNum = SUMMARY.CustNum
AND CUSTOMER.PONum = SUMMARY.PONum;

However, when I attempt such a join, I get the following message:

"Can't create join: CUSTOMER.CustNum = SUMMARY.CustNum AND CUSTOMER.PONum =
SUMMARY.PONum".

The on-line help gives three reasons why this message is displayed none of
which are true.


Has anybody done this successfully?  Thanks.

Rick Huff, Senior Systems Analyst [phone] ([e-mail])
CIS, Computing and Information Services, Texas A&M University
=========================================================================
Date:         Fri, 10 Sep 1993 15:56:01 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark Paskill <[e-mail]>
Subject:      Re: Join with Two Fields
In-Reply-To:  Message of Fri,
              10 Sep 1993 15:26:40 -0500 from <[e-mail]>

I hope I understand your question - if so why not make both fields key fields??
=========================================================================
Date:         Sat, 11 Sep 1993 17:30:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Anderson <[e-mail]>
Subject:      Requery of a subform

Hi to everyone,

Background
===========

I have a main form with a sub-form. The sub-form is based on a query
that returns totals from a details file to the main form. The subform
is readonly and is never entered from the main form.

On entry the subform works fine. Whenever I read another record forward
or backward on the main form the subform totals reset and recalculate
....terrific.

But,

Problem
=======

When I use a button from the main form to go to another form,
add values to the detail records on which the query based subform
is based, and return to the original form via a "close button"
the totals are not updated.

Is there a way of "re-querying" the sub-form on return to the main
form. I have tried using the requery command from a macro using the
"control name" of the subform but no joy.

I would be most grateful for a soultion to what I am sure is a very
simple problem.

In anticipation, a warm thank you.

Kevin

Internet Address:       [e-mail]

(Klatu Barada Nicto GORT Klatu Barada Nicto)
=========================================================================
Date:         Sun, 12 Sep 1993 12:26:21 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Rick Huff <[e-mail]>
Subject:      Re: Join with Two Fields
In-Reply-To:  <[e-mail]>

I can make them a multiple field index, but I cannot make them a multiple
field key because one of the fields is blank in some of the records.

Rick Huff, Senior Systems Analyst [phone] ([e-mail])
CIS, Computing and Information Services, Texas A&M University


On Fri, 10 Sep 1993, Mark Paskill wrote:

> I hope I understand your question - if so why not make both fields key fields?
?
=========================================================================
Date:         Mon, 13 Sep 1993 09:47:15 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stefan Focke <[e-mail]>
Subject:      Re: Requery of a subform

>Is there a way of "re-querying" the sub-form on return to the main
>form. I have tried using the requery command from a macro using the
>"control name" of the subform but no joy.
>

  DoCmd Requery Forms!<form name>!<subform name>.ControlName

Hope that helps
Stefan
----------------------------------------------------------------------

Stefan Focke                  Tel. [phone]
GMD-ISA                       e-mail: [e-mail]
Postfach 1316
D - 53731 Sankt Augustin

    ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Mon, 13 Sep 1993 15:11:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <[e-mail]>
Subject:      Automatic Encryption

I would like to have my database automatically encrypt itself
whenever a user closes out of the database. I've looked around
for a command before completely "exiting" but have failed
to see anything. Is it possible to automatically encrypt?...or
do I have to instruct my users to do it manually?

Thanks
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Mon, 13 Sep 1993 15:13:19 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Internal Database Error

I have some Access Basic code that checks to see if a variable
(defined as Variant, by default) contains null data. For example:

        If IsNull(Country) then
                ...
        Endif

This has always worked for me before. Today, code that has been
working for a long time suddenly died when I called it with a
Null value (the table was empty in which a field was referenced).

Anyway, I get the following message now whenever I reference the
variable containing the Null:

        Internal Database Error (-1603).

This message pops up when I try to reference the variable
from within the immediate window as well.

I don't find this error documented anywhere. Does anyone have
an idea what this means? I just found this and have not had time
to try this code with other routines and data.


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Mon, 13 Sep 1993 15:19:24 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Record selectors

Has anyone found a way to determine in Access Basic which records
in a form (continuous detail section) have been selected in the
left hand Record Selector area. You know, this is the area that if
selected, you can delete records by just hitting the delete key.

I want to have a routine determine which records the user selected
so I can do some special processing on them.

I get the feeling that this is going to require that I open my
VB 3.0 box so that I can get access (no pun intended) to the
list structure of the form and handle the mouse down and drag
events.

Any thoughts???


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Tue, 14 Sep 1993 17:31:31 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Eric Laverdiere <[e-mail]>
Organization: Ecole des Hautes Etudes Commerciales de Montreal
Subject:      subscribe to access-l@indycms Eric Laverdiere

Subscription for access discussion group
=========================================================================
Date:         Fri, 17 Sep 1993 09:23:09 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Stacer <[e-mail]>
Subject:      Report name in reports

Is there a way to get the report name in a report similary to a
=now() for the date and time?
=========================================================================
Date:         Fri, 17 Sep 1993 11:40:09 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Using Access on Pathworks network.

Has anyone on the list used Access under DEC Pathworks? It is not listed
as an "officially-supported network" in the Access documentation, but the
MS Knowledge base implies that you can run Access under Pathworks.
=========================================================================
Date:         Fri, 17 Sep 1993 16:06:26 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]

SUBSCRIBE Jeff Schmitz
=========================================================================
Date:         Fri, 17 Sep 1993 16:59:23 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]

SUBSCRIBE faccess-l Chris Mowry
=========================================================================
Date:         Mon, 20 Sep 1993 08:48:00 +0100
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Sent using PMDF-822 , routing is done by ECNICE
From:         Bart Schaap <[e-mail]>
Subject:      Re: Using Access on Pathworks network.

Hello David,

Yes, we use Access (1.0) under Pathworks version 4.1. We have installed it re-
cently and it seems to work well. The securety features of Access are however
a bit tricky, but we are working on that. Installation of Access is not very
elegant but after some trial and error we managed to set it up.

Bart  Schaap
Energy research foundation of the Netherlands (ECN)
Holland
=========================================================================
Date:         Mon, 20 Sep 1993 13:10:27 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      Re: Using Access on Pathworks network.
In-Reply-To:  Message of Fri, 17 Sep 1993 11:40:09 EDT from <[e-mail]>

Pathworks is really Lan_Manager under neath.
=========================================================================
Date:         Mon, 20 Sep 1993 13:40:14 CDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim Tow <[e-mail]>
Subject:      Re: Report name in reports

> Date:    Fri, 17 Sep 1993 09:23:09 -0500
> From:    David Stacer <[e-mail]>
> Subject: Report name in reports
>
> Is there a way to get the report name in a report similary to a
> =now() for the date and time?

Not quite that simple...    :-)

First, write an Access Basic function to get the reportname (that has focus):

        Function ActiveReport () As String
        Dim ObjActiveReport As Report

        Set ObjActiveReport = screen.ActiveReport
        ActiveReport = ObjActiveReport.formname

        End Function

Then, define a text box on your report and call the function as the Control
Source:

        =ActiveReport()

 ----------------------------------------------------------------------------
 Tim Tow, CPA                           Phone:      [phone]
 Intergraph Corporation                 Fax:        [phone]
 Mailstop: HQ011                        Mailpath:   [e-mail]
 Huntsville, AL  35894-0001
=========================================================================
Date:         Tue, 21 Sep 1993 10:38:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Determine Add Mode on Before Update

Hello,
     Has anyone figured out how to determine that you are in ADD mode on a
form thru a before update property.  I need to input data in some fields
only during an ADD.  Any help appreciated.

Bob Ellington
[e-mail]
=========================================================================
Date:         Tue, 21 Sep 1993 11:48:35 -0600
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         "John A. Olson" <[e-mail]>
Subject:      Line Continuation in AB Module

Does anyone know how I can continue a line of code on the next physical
line?  What I mean is, if a line of code is too long to be displayed
continuously on the screen, can it be "broken" and spill onto the next line?
I know this can be done in 'C', but can it be done in Access Basic?

Any help would be much appreciated.

Thanks!

John A. Olson
[e-mail]
Computing Devices International
Bloomington, MN
=========================================================================
Date:         Wed, 22 Sep 1993 13:22:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Replace field value w/ previous

On a form I would like a particular field to retain the
value from the previous record. This will facilitate
data input where a field will contain like info for
x number of records.
I know that pressing Ctrl+" will return the value from the
previous record, but I would prefer it to automatically
default to that value.
I,ve been searching for a solution...even trying the sendkey
to that control...but with no success.
Any help in pointing me in the right direction will be
appreciated.
Thanks
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Thu, 23 Sep 1993 08:13:30 -0600
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         "John A. Olson" <[e-mail]>
Subject:      Code Editing

I apologize in advance if this message has been received by the list
already.  I got a strange message when I sent it the first time which
indicated that it never was distributed.  If it was, please forgive this
repeat.

Subject: Line Continuation in AB Module

Does anyone know how I can continue a line of code on the next physical
line?  What I mean is, if a line of code is too long to be displayed
continuously on the screen, can it be "broken" and spill onto the next line?
I know this can be done in 'C', but can it be done in Access Basic?

Any help would be much appreciated.

Thanks!

John A. Olson
[e-mail]
Computing Devices International
Bloomington, MN
=========================================================================
Date:         Thu, 23 Sep 1993 15:43:41 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stefan Focke <[e-mail]>
Subject:      Re: Replace field value w/ previous

>On a form I would like a particular field to retain the
>value from the previous record. This will facilitate
>data input where a field will contain like info for
>x number of records.
>I know that pressing Ctrl+" will return the value from the
>previous record, but I would prefer it to automatically
>default to that value.

In the help-file that is available from cica they say, that you have to
store the values from the last form (on exit) and write the values in the
new form (on enter).

Greetings
Stefan Focke
--
Stefan Focke,   GMD-I8,    D-53731 Sankt Augustin,     [e-mail]

  ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Thu, 23 Sep 1993 09:15:44 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim Mackay <[e-mail]>
Subject:      Re: Replace field value w/ previous

>On a form I would like a particular field to retain the
>value from the previous record. This will facilitate
>data input where a field will contain like info for
>x number of records.
>I know that pressing Ctrl+" will return the value from the
>previous record, but I would prefer it to automatically
>default to that value.
>I,ve been searching for a solution...even trying the sendkey
>to that control...but with no success.
>Any help in pointing me in the right direction will be
>appreciated.
>Thanks
>==============================================================================
>  David B. Long                             E-Mail=> [e-mail]
>  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
>  Quality Engineering                       Tele=> 508-960-3683
>==============================================================================

I had the same problem.  My solution was to use a DLast(...) function for
the default value.


Tim Mackay                       |paper-net:Marquette Electronics, Inc
internet: [e-mail]        |          8200 W Tower Ave
voice-net:[phone]         |          Milwaukee, WI 53223
=========================================================================
Date:         Thu, 23 Sep 1993 11:33:35 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Roger Lurie <[e-mail]>
Subject:      Attached Sybase Tables

Has anyone worked with large remote Sybase SQL Server tables attached to
an Access database? I have some Sybase tables with up to 5 million records and
am experiencing some difficulties using ODBC drivers included with Access 1.1
to query and retrieve records from the Sybase database. The response time
seems to worsen with each additional query run during an Access session.

Has anyone else experienced these problems? If so, what have you done to
correct them? Are there more reliable ODBC drivers available from Sybase or
QE Software than the ones provided by Microsoft?

-------------------------------------------------------------------------
Roger Lurie
Arizona State University, Administrative Information Technology
Tempe, Arizona  85287-0101
Telephone: [phone]             Fax:    [phone]
Internet:  [e-mail]  Bitnet: icsral@asuacad
-------------------------------------------------------------------------
=========================================================================
Date:         Thu, 23 Sep 1993 16:27:00 LCL
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         mkro <[e-mail]>
Subject:      Re: Code Editing

DISREGARD IF THIS HAS ALREADY BEEN ANSWERED....OUR GATEWAY IS SLOW TODAY!

FROM WHAT I WAS TOLD IN AN Microsoft University Access Programming Class,
NO!

Sorry, I guess that's asking to much!

Cheers,
Mike Kroeger
[e-mail]
-------------
Original Text
From JAOLSON @ SMTP (John A. Olson) {[e-mail]}, on
9/23/93 8:13 AM:
I apologize in advance if this message has been received by the list
already.  I got a strange message when I sent it the first time which
indicated that it never was distributed.  If it was, please forgive this
repeat.

Subject: Line Continuation in AB Module

Does anyone know how I can continue a line of code on the next physical
line?  What I mean is, if a line of code is too long to be displayed
continuously on the screen, can it be "broken" and spill onto the next line?
I know this can be done in 'C', but can it be done in Access Basic?

Any help would be much appreciated.

Thanks!

John A. Olson
[e-mail]
Computing Devices International
Bloomington, MN
*** uuencoded BINARY enclosure ***
The section below this line contains an MHS attachment.  To extract it,
copy this message to a file and use the program UUDECODE.  For information
on using UUDECODE on UNIX systems, type the command 'man uudecode'.  The
attachment name was originally: ATTRIBS.BND
---------------
begin 644 attribs.bnd
M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``87+&IK*```````<F4Z($-O9&4@
M161I=&EN9P``````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`&UK<F\`````````````````````````````````````````````````````
M``````````````````````````````````!",3`P03(R0S`Q0SE!,44P````
M````````0F5Y;VYD(%!R;W!R:65T87)Y($1A=&$:``````0`````````!``&
M````````````````````````````1F]R;05297!L>0$`````````%0`#````
M````````````````````````57-E(%!R;W!O<G1I;VYA;"!&;VYT`0`!"0``
M```````-`$(```````````````````````````!0<F5V:6]U<R!&<F]M04I!
M3TQ33TX@0"!33510("A*;VAN($$N($]L<V]N*2![;W=N97(M86-C97-S+6Q`
M24Y$64--4RY)55!522Y%1%5]#0`````````+`'$`````````````````````
M``````!0<F5V:6]U<R!4;V\`0A`!``D`__]@`````F``7TU214-)4$E%($`@
M4TU44"`H375L=&EP;&4@<F5C:7!I96YT<R!O9B!L:7-T($%#0T534RU,*2![
M04-#15-3+4PE24Y$64--4RY"251.151`=6=A+F-C+G5G82YE9'5]#0``````
M```+`'$```````````````````````````!/<FEG:6YA;"!T;V\`0A`!``D`
M__]@`````F``7TU214-)4$E%($`@4TU44"`H375L=&EP;&4@<F5C:7!I96YT
M<R!O9B!L:7-T($%#0T534RU,*2![04-#15-3+4PE24Y$64--4RY"251.151`
M=6=A+F-C+G5G82YE9'5]$0`````````-`)0$````````````````````````
M``!/<FEG:6YA;"!T97AT!@-&<F]M($I!3TQ33TX@0"!33510("A*;VAN($$N
M($]L<V]N*2![;W=N97(M86-C97-S+6Q`24Y$64--4RY)55!522Y%1%5]+"!O
M;B`Y+S(S+SDS(#@Z,3,@04TZ"DD@87!O;&]G:7IE(&EN(&%D=F%N8V4@:68@
M=&AI<R!M97-S86=E(&AA<R!B965N(')E8V5I=F5D(&)Y('1H92!L:7-T"F%L
M<F5A9'DN("!)(&=O="!A('-T<F%N9V4@;65S<V%G92!W:&5N($D@<V5N="!I
M="!T:&4@9FER<W0@=&EM92!W:&EC:`II;F1I8V%T960@=&AA="!I="!N979E
M<B!W87,@9&ES=')I8G5T960N("!)9B!I="!W87,L('!L96%S92!F;W)G:79E
M('1H:7,*<F5P96%T+@H*4W5B:F5C=#H@3&EN92!#;VYT:6YU871I;VX@:6X@
M04(@36]D=6QE"@I$;V5S(&%N>6]N92!K;F]W(&AO=R!)(&-A;B!C;VYT:6YU
M92!A(&QI;F4@;V8@8V]D92!O;B!T:&4@;F5X="!P:'ES:6-A;`IL:6YE/R`@
M5VAA="!)(&UE86X@:7,L(&EF(&$@;&EN92!O9B!C;V1E(&ES('1O;R!L;VYG
M('1O(&)E(&1I<W!L87EE9`IC;VYT:6YU;W5S;'D@;VX@=&AE('-C<F5E;BP@
M8V%N(&ET(&)E(")B<F]K96XB(&%N9"!S<&EL;"!O;G1O('1H92!N97AT(&QI
M;F4_"DD@:VYO=R!T:&ES(&-A;B!B92!D;VYE(&EN("=#)RP@8G5T(&-A;B!I
M="!B92!D;VYE(&EN($%C8V5S<R!"87-I8S\*"D%N>2!H96QP('=O=6QD(&)E
M(&UU8V@@87!P<F5C:6%T960N"@I4:&%N:W,A"@I*;VAN($$N($]L<V]N"FIA
M;SEW,C8U0&%U<F]R82YC9&5V+F-O;0I#;VUP=71I;F<@1&5V:6-E<R!);G1E
M<FYA=&EO;F%L"D)L;V]M:6YG=&]N+"!-3@J(`0,`!@."`0(``@```!8``@`!
M``$`7``````````"`%T`J@(````````X_P```````)`!``````````!-4R!3
M86YS(%-E<FEF```````````````````````````````X_P```````)`!````
M``````!-4R!386YS(%-E<FEF```````````````````````````````!``$`
M70`"`%T`]W\"`*(`]W\"`.@`]W\"`#$!]W\"`#D!]W\"`#H!]W\"`&(!]W\"
M`&,!]W\"`*L!]W\"`/`!]W\"`#T"]W\"`($"]W\"`(("]W\"`*8"]W\"`*<"
M]W\"`*\"]W\"`+`"]W\"`+X"]W\"`-<"]W\"`/<"]W\"``<#]W\`````````
M``````!D``&D`0%(`P'L!`&0!@$T"`'8"0%\"P$@#0'$#@%H$`$,$@&P$P%4
M%0'X%@```````````````&0``=(``:0!`78"`4@#`1H$`>P$`;X%`9`&`6('
M`30(`08)`=@)`:H*`7P+```1``````````0`NP$`````````````````````
M`````%1E>'3T`$1)4U)%1T%21"!)1B!42$E3($A!4R!!3%)%0419($)%14X@
M04Y35T52140N+BXN3U52($=!5$5705D@25,@4TQ/5R!43T1!62$*"D923TT@
M5TA!5"!)(%=!4R!43TQ$($E.($%.($UI8W)O<V]F="!5;FEV97)S:71Y($%C
M8V5S<R!0<F]G<F%M;6EN9R!#;&%S<RP@3D\A"@I3;W)R>2P@22!G=65S<R!T
M:&%T)W,@87-K:6YG('1O(&UU8V@A"@I#:&5E<G,L"DUI:V4@2W)O96=E<@IM
M:W)O+F1I<RUP8T!B;6%I;&EN+FET9RYT:2YC;VW!``,`]`"Z``$``0````D`
M`0`!``$`]``````````X_P```````)`!``````````!-4R!397)I9@``````
M```````````````````````````````!``$`2@`!`$L`2P`!`$P`F0`!`)H`
MF@`!`)L`P``!`,$`P0`!`,(`R0`!`,H`U@`!`-<`]0````````````````!D
M``&T``%H`0$<`@'0`@&$`P$X!`'L!`&@!0%4!@$(!P&\!P%P"`$D"0'8"0H`
M````````````$``&````````````````````````````071T86-H;65N="!#
*;W5N=`0````````&
`
end
=========================================================================
Date:         Fri, 24 Sep 1993 10:59:00 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders,
              Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Snaking column headers

I'm printing a report in 3 vertical columns and I'd like an identical
heading at the top of each column. I'd be grateful if anyone can tell
me a way to do it. Thanks.
=========================================================================
Date:         Fri, 24 Sep 1993 08:45:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Replace field value w/ previous

Thanks to Ron Apland
In your confirmation of my method of using a macro in which I use
sendkey...you showed me that the characters should be ^(').
I was using ^"
I saw in the book where I was supposed to place the quote in
parentheses (LRpg.435) and saw how I was misled by User Guide,
pg. 353 says to use a double quote...it should read single.

I call the macro in the "On Enter" field for the control, and it
works just fine!
Thanks again
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Fri, 24 Sep 1993 10:41:00 LCL
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         mkro <[e-mail]>
Subject:      MSA Database Window Size

This may be a dumb question....

   When you first pull up a database when you enter MSA, the Database
windows is the first thing to come up(in my case).

    How do you get MSA to remember SIZE changes to this window?
   I have several tables in the database, and it is would be nice to see
them all, or as many as possible, without having to use the scroll bars!
    Whenever I resize this window, and exit out, the next time I open the
window to go to table view, it is shrunk back to the original size!

*** uuencoded BINARY enclosure ***
The section below this line contains an MHS attachment.  To extract it,
copy this message to a file and use the program UUDECODE.  For information
on using UUDECODE on UNIX systems, type the command 'man uudecode'.  The
attachment name was originally: ATTRIBS.BND
---------------
begin 644 attribs.bnd
M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``;O&VIK*```````35-!($1A=&%B
M87-E(%=I;F1O=R!3:7IE````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`&UK<F\`````````````````````````````````````````````````````
M```````````````````````````````````U,$-&03(R0S`Q0SE!,44P````
M````````0F5Y;VYD(%!R;W!R:65T87)Y($1A=&$:``````0`````````!``%
M````````````````````````````1F]R;01-96UO`0`````````5``,`````
M``````````````````````!5<V4@4')O<&]R=&EO;F%L($9O;G0!``$1````
M``````0`QP(``````````````````````````%1E>'0``E1H:7,@;6%Y(&)E
M(&$@9'5M8B!Q=65S=&EO;BXN+BX*("`*("`@5VAE;B!Y;W4@9FER<W0@<'5L
M;"!U<"!A(&1A=&%B87-E('=H96X@>6]U(&5N=&5R($U302P@=&AE($1A=&%B
M87-E('=I;F1O=W,@:7,@=&AE(&9I<G-T('1H:6YG('1O(&-O;64@=7`H:6X@
M;7D@8V%S92DN"B`@"B`@("!(;W<@9&\@>6]U(&=E="!-4T$@=&\@<F5M96UB
M97(@4TE:12!C:&%N9V5S('1O('1H:7,@=VEN9&]W/PH@("!)(&AA=F4@<V5V
M97)A;"!T86)L97,@:6X@=&AE(&1A=&%B87-E+"!A;F0@:70@:7,@=V]U;&0@
M8F4@;FEC92!T;R!S964@=&AE;2!A;&PL(&]R(&%S(&UA;GD@87,@<&]S<VEB
M;&4L('=I=&AO=70@:&%V:6YG('1O('5S92!T:&4@<V-R;VQL(&)A<G,A"B`@
M("!7:&5N979E<B!)(')E<VEZ92!T:&ES('=I;F1O=RP@86YD(&5X:70@;W5T
M+"!T:&4@;F5X="!T:6UE($D@;W!E;B!T:&4@=VEN9&]W('1O(&=O('1O('1A
M8FQE('9I97<L(&ET(&ES('-H<G5N:R!B86-K('1O('1H92!O<FEG:6YA;"!S
M:7IE(0H*P0`#```"N@`!``$````)``$``0`!```"````````8/\```````"0
M`0``````````35,@4V5R:68`````````````````````````````````````
M`0`!`"```0`A`",``0`D`)P``0"=`)\``0"@`-\``0#@`'$!`0!R`?\!`0``
M`@`"`0`!`@$"````````````````9``!E@`!+`$!P@$!6`(![@(!A`,!&@0!
ML`0!1@4!W`4!<@8!"`<!G@<!-`AT`````````````!``!@``````````````
@`````````````$%T=&%C:&UE;G0@0V]U;G0$````````
`
end
=========================================================================
Date:         Fri, 24 Sep 1993 09:07:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Incrementing numeric field

I'm developing a database that stores survey information.
Each survey has 30 questions.
I have chosen to store each question response as a record.
To facilitate data input, I would prefer the data input field
which designates the question # to increment itself after every
record input (1-30) and then cycle back to question #1.
This will eliminate the need for the data input person from
typing in the question number.

I've thought on various ways I could approach this issue.
One is to write some code (new to me...could take some time) that
will increment and return a value to the field after every record input.
or
Increment through a series of subforms, related specifically to the
question being inputed....so the default value can be set for the particular
question.

Any Ideas on these or alternative approaches would be greatly
appreciated.

Thanks
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Sat, 25 Sep 1993 12:42:46 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Incrementing numeric field
In-Reply-To:  <[e-mail]>; from "David Long" at Sep 24,
              93 9:07 am

>
> I'm developing a database that stores survey information.
> Each survey has 30 questions.
> I have chosen to store each question response as a record.
> To facilitate data input, I would prefer the data input field
> which designates the question # to increment itself after every
> record input (1-30) and then cycle back to question #1.
> This will eliminate the need for the data input person from
> typing in the question number.
>
> I've thought on various ways I could approach this issue.
> One is to write some code (new to me...could take some time) that
> will increment and return a value to the field after every record input.
> or
> Increment through a series of subforms, related specifically to the
> question being inputed....so the default value can be set for the particular
> question.
>
> Any Ideas on these or alternative approaches would be greatly
> appreciated.
>

I'd create these records:

t_Response -- one for each responder

  id_RESPONSE -- a counter field
  nm_name -- or some identifier to label the responder
  ...

t_Response_Detail -- one for each question answered by a responder

  id_RESPONSE_DETAIL - counter
  id_response  -- from the Response record
  id_question_num -- the question number

t_Question -- one for each question

  id_QUESTION -- the question number
  nm_question -- the question

Your main form would just be the t_Response table


  the subform would be a query link t_Question
  to t_RESPONSE_DETAIL with an outer join?
   and the criteria of id_response equal to id_response on
  the mainform

I haven't tried, but some variation shoukld work
and you wouldn't need code.

When you went to the next record on the main form,
you should get full or empty records on the subform,
one for each question.
=========================================================================
Date:         Sat, 25 Sep 1993 17:05:25 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Harry Yeatts <[e-mail]>
Subject:      Re: Incrementing numeric field
In-Reply-To:  Message of Fri,
              24 Sep 1993 09:07:00 EDT from <mvgsd![e-mail]>

On Fri, 24 Sep 1993 09:07:00 EDT David Long said:
>I'm developing a database that stores survey information.
>Each survey has 30 questions.
>I have chosen to store each question response as a record.
>To facilitate data input, I would prefer the data input field
>which designates the question # to increment itself after every
>record input (1-30) and then cycle back to question #1.
>This will eliminate the need for the data input person from
>typing in the question number.
>
>[stuff deleted]

David:

I've just finished designing a database to handle three surveys and
I worked it a little differently than you propose.

I designed a data entry form using option groups (with check boxes
that register a numerical value for a response [i.e., 4 for "read
all," 3 for "read most," 2 for "read some," 1 for "browse," and 0
for "read none]) and text boxes for subjective answers (as memos).

To get to what you wanted, I set the form for continuous. This way
the data entry person can head on to the next set of responses
without doing anything special. (I put the index number for the
form in the upper-right-hand corner so they can write on the paper
form which ones they've done.)

This has worked extremely well so far. Our date entry people have
little experience with data entry or databases, but they've found
it easy to use. They don't mind tabbing between questions and use
the page down button with ease. I made the data entry form look
as much like the paper form as possible so it's easy for them to
keep their places.

I know this isn't exactly what you asked, but I thought I'd pass on
my experiences with surveys.

If you have any questions about this...or want more info, just ask.

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Sun, 26 Sep 1993 16:09:37 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      dynaset as a source of a form

I am looking for a few suggestions:

If I process a query and it is successful I have a found set of data.
Is there an easy way to connect the foundset to a forms property?
In essence, when I run a query, ("select * from people where height > 5"),
from form A, form B would show me all found set records.
I would like to use a form to see the person's name and address.
How do I do this?  Can I connect a dynaset to form B's  rowsource property?

Any ideas appreciated,

regards,

Greg
=========================================================================
Date:         Sun, 26 Sep 1993 15:05:37 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: dynaset as a source of a form
In-Reply-To:  <[e-mail]>; from "Greg Fairnak" at Sep
              26, 93 4:09 pm

>
> I am looking for a few suggestions:
>
> If I process a query and it is successful I have a found set of data.
> Is there an easy way to connect the foundset to a forms property?
> In essence, when I run a query, ("select * from people where height > 5"),
> from form A, form B would show me all found set records.
> I would like to use a form to see the person's name and address.
> How do I do this?  Can I connect a dynaset to form B's  rowsource property?
>
> Any ideas appreciated,
>
> regards,
>
> Greg

Greg, you can assign a table, query, or SQL statement as the source of
any form or list/combo-box. Dynasets are a construct for use in BASIC only,
as are snapshots. In forms, you are dealing with only tables, queries, or
SQL statements. SQL statements, I have found, _can_ be dynamic for list
and combo boxes.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Tue, 28 Sep 1993 15:19:21 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Arman Rivard <[e-mail]>
Subject:      Oncurrent Controls

  I have a subform which attempts to modify the data on its main form.
  This all works fine when the main form is opened , yet when I first open
  the main form it seems the subform opens first, executes the oncurrent
  and can't find the control. Access support says thats how it works |-(
  Has anyone found a workaround ?? I really need to use the record selectors
  on the subform and the oncurrent rather than onenter.

   Too much to ask ?

  Thanks for any help.

--

Arman Rivard         How do Peabody and Sherman get back ?
<[e-mail]>
=========================================================================
Date:         Wed, 29 Sep 1993 12:40:15 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         taha alesayi <[e-mail]>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      registration

"ok"
=========================================================================
Date:         Wed, 29 Sep 1993 11:30:00 +01
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Nilsson Jimmy, HK/R IDE" <[e-mail]>
Subject:      Notebooks with databases

Hi!
 ----

I am in big trouble and I hope someone out there perhaps can help me!!!

I am supposed to build an application which is going to be used by people
who has notebooks. They would like to take the database with them when they
go home at night and when they travel. When they are back at the office they
log on to their database-server and the database in the notebook get the new
information and puts it new information. This is what is called replication
of databases.

This functionality is found in Lotus Notes but I would like to use MS Access
as the database. I could build it myself, but the more you think about it,
the more complex it seems. I rather would buy a product but I can't find
any.

Do anybody out there know about a product which give me the replication of
database-functionality???

Please help me!

Regards,
Jimmy Nilsson
[e-mail]
###