Klos, Susan
Susan.Klos at fldoe.org
Mon Apr 19 14:39:49 CDT 2004
Robert, I need 71 identical tables because I am getting the same structure
Excel file from 71 districts. The structure is the same but the data is
different. I want to be able to loop through the tables and append their
records to one table.
Susan Klos
Senior Database Analyst
Evaluation and Reporting
Florida Department of Education
-----Original Message-----
From: accessd-request at databaseadvisors.com
[mailto:accessd-request at databaseadvisors.com]
Sent: Monday, April 19, 2004 1:00 PM
To: accessd at databaseadvisors.com
Subject: AccessD Digest, Vol 14, Issue 31
Send AccessD mailing list submissions to
accessd at databaseadvisors.com
To subscribe or unsubscribe via the World Wide Web, visit
http://databaseadvisors.com/mailman/listinfo/accessd
or, via email, send a message with subject or body 'help' to
accessd-request at databaseadvisors.com
You can reach the person managing the list at
accessd-owner at databaseadvisors.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of AccessD digest..."
Today's Topics:
1. Re: custom sorts/groups in a report (Gustav Brock)
2. Re: Calendar Controls -- just for discussion (William Hindman)
3. ODE HElp problem (Susan Harkins)
4. RE: custom sorts/groups in a report (Susan Harkins)
5. A summary of the great Open Source discussion
(Jim Lawrence (AccessD))
6. Re: Calendar Controls -- just for discussion
(Rocky Smolin - Beach Access Software)
7. Re: About Manuals for your databases X posted
(Rocky Smolin - Beach Access Software)
8. Re: Calendar Controls -- just for discussion (Bryan Carbonnell)
9. Re: Calendar Controls -- just for discussion
(Rocky Smolin - Beach Access Software)
10. Re: Calendar Controls -- just for discussion (Bryan Carbonnell)
11. RE: Calendar Controls -- just for discussion (Andy Lacey)
12. error in code (Pedro Janssen)
13. RE: error in code (Susan Harkins)
14. Re: error in code (Bryan Carbonnell)
15. Re: error in code (Stuart McLachlan)
16. RE: About Manuals for your databases X posted (Porter, Mark)
17. Error 3265. Item not found in this collection?!!? (S D)
18. Re: custom sorts/groups in a report (Gustav Brock)
19. Re: Error 3265. Item not found in this collection?!!?
<SOLVED> (S D)
20. Re: Calendar Controls -- just for discussion (Darren DICK)
21. Re: Changing the table in a query so I can loop through
thequery (Robert L. Stewart)
22. RE: About Manuals for your databases X posted (Dan Waters)
23. RE: custom sorts/groups in a report (Susan Harkins)
24. Re: custom sorts/groups in a report (Gustav Brock)
25. RE: Sorting and restricting ComboBox on ListBox content s
(DWUTKA at marlow.com)
26. RE: Calendar Controls -- just for discussion (DWUTKA at marlow.com)
27. RE: About Manuals for your databases X posted (Charlotte Foust)
28. RE: jpg Screen shot (O'Connor, Patricia )
----------------------------------------------------------------------
Message: 1
Date: Sun, 18 Apr 2004 18:59:33 +0200
From: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] custom sorts/groups in a report
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <1661080363.20040418185933 at cactus.dk>
Content-Type: text/plain; charset=us-ascii
Hi Susan
> I'm still not happy with the solution -- there's got to be an easier way.
:)
Maybe. What solution did you settle on?
/gustav
------------------------------
Message: 2
Date: Sun, 18 Apr 2004 13:11:53 -0400
From: "William Hindman" <wdhindman at bellsouth.net>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <002301c42568$3ec91ad0$6101a8c0 at dejpolsys>
Content-Type: text/plain; charset="iso-8859-1"
...I've not used the native cal for years ...but there was a period of time
with A95/97 that MS changed the way the calendar worked between a number of
versions and didn't maintain reverse compatibility ...depending upon which
version of the control your users had installed your app might or might not
work, a very common problem back then with all ActiveX controls (I don't use
any 3rd party ActiveX controls for the same reason) ...so I switched to a
vba based one and never looked back ...and no, I can't tell you the problems
have or have not been resolved ...I'm happy with my calendar ...its been
tweaked to work exactly the way I want it to :)
William Hindman
"Always code as if the person who is maintaining or testing your code is
a violent psychopath who knows where you live." William Silverstein
----- Original Message -----
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Sunday, April 18, 2004 12:48 PM
Subject: RE: [AccessD] Calendar Controls -- just for discussion
> ...first ...I don't use the ODE Calendar Control because of a long history
> of versioning problems
>
> ===========I'm limited -- I write about what they want. :) So, when you
> complain of versioning problems, what do you mean?
>
> Susan H.
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
------------------------------
Message: 3
Date: Sun, 18 Apr 2004 13:41:30 -0400
From: "Susan Harkins" <ssharkins at bellsouth.net>
Subject: [AccessD] ODE HElp problem
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID:
<20040418174130.YNQF1810.imf18aec.mail.bellsouth.net at SUSANONE>
Content-Type: text/plain; charset="us-ascii"
I just installed Office XP Developer and the Help files don't work -- the
interface is there and the toc is there -- but it isn't connecting and every
subject returns a page not found error.
I don't even know where to begin to start. Anyone else had this happen?
Susan H.
------------------------------
Message: 4
Date: Sun, 18 Apr 2004 13:52:24 -0400
From: "Susan Harkins" <ssharkins at bellsouth.net>
Subject: RE: [AccessD] custom sorts/groups in a report
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID:
<20040418175224.YQKA1810.imf18aec.mail.bellsouth.net at SUSANONE>
Content-Type: text/plain; charset="us-ascii"
Well, it's clunky --
1.) User selects the first day of the week from a list of Sunday through
Saturday.
2.) User clicks a command button that opens the report and sends the above
selected value via the OpenArgs argument.
3.) The report is based on a query that calls a function that uses the value
selected in #1 to return a weekday value for each date.
4.) The report's grouping is first set to year. The second level groups on
the weekday value returned by #3. And, a third sorting level simply sorts
the date values so it all comes out in the wash.
5.) The group header contains a value that uses the openargs value in a
DatePart expression to return the first day of the week for each group.
You can use the report without the form and it will default to a
firstdayoftheweek value of 1 -- to avoid errors and to make it easier to use
the report without going through the form -- that way you could set the
default to anything and the user could just open the report.
Seems like it ought to be easier than that though -- just too much going on.
#3's the one I don't really like. Seems like I ought to be able to get that
weekday number in the report, and although I can -- I can't sort by it.
Someone mentioned yesterday that you could group on a calculation, but I've
not figured that one out yet. I tried setting it using the GroupLevel and
GroupOn properties, but never got it to work -- not saying it won't, just I
wasn't successful. I didn't spend much time on it though. My understanding
of the GroupOn property is that it needs to refer to a specific integer
value that represents the built-in levels (Month, Year, Quarter, and so on).
I never could get it to accept a DatePart expression.
Susan H.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, April 18, 2004 1:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] custom sorts/groups in a report
Hi Susan
> I'm still not happy with the solution -- there's got to be an easier
> way. :)
Maybe. What solution did you settle on?
/gustav
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 5
Date: Sun, 18 Apr 2004 11:43:07 -0700
From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
Subject: [AccessD] A summary of the great Open Source discussion
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <FJEJLIPOMCGJALMGLLLIEEMFCBAA.accessd at shaw.ca>
Content-Type: text/plain; charset=iso-8859-1
Hi All:
A couple of weeks ago, there was an Open Source debate encapsulated much of
the points of view that have been argued for years. I was so impressed, with
the conciseness and objectiveness of the discussion that I decided to put
the results in a single page and post the summary to the DBA web site. You
can get access to the page through a link off the main page
www.databaseadvisors.com. (If your browser saves pages you may have to press
reset/reload to view the current layout.)
Thank you all for your contributions, Susan Harkin, who started the whole
thing, Stuart McLachlan, Bryan Carbonnell, Francisco H Tapia, Bruce Bruen,
Bob Hall, Drew Wutka, Marty Connelly and Arthur Fuller.
If there is anyone I overlooked or comments I missed, send me a note and you
will be appropriately accommodated.
Again, thanks to all.
Jim
------------------------------
Message: 6
Date: Sun, 18 Apr 2004 12:48:33 -0700
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <00df01c4257e$2230ff80$6601a8c0 at HAL9002>
Content-Type: text/plain; charset="iso-8859-1"
I use the ADH calendar and trigger it on the double-click of any date text
box. So they can still hand enter the date if they want. Users seem to
like the convention once they get used to it.
Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
>
> ----- Original Message -----
> From: "Susan Harkins" <ssharkins at bellsouth.net>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Sunday, April 18, 2004 12:48 PM
> Subject: RE: [AccessD] Calendar Controls -- just for discussion
>
>
> > ...first ...I don't use the ODE Calendar Control because of a long
history
> > of versioning problems
> >
> > ===========I'm limited -- I write about what they want. :) So, when you
> > complain of versioning problems, what do you mean?
> >
> > Susan H.
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
------------------------------
Message: 7
Date: Sun, 18 Apr 2004 12:53:29 -0700
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
Subject: Re: [AccessD] About Manuals for your databases X posted
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <00f701c4257e$d2a17480$6601a8c0 at HAL9002>
Content-Type: text/plain; charset="iso-8859-1"
Joe:
I wrote a manual for the manufacturing system last year. Just about
committed suicide but got it done. For a product I think you need one. But
for a one-shot app I never write them.
I tried to be consistent about the headings so that I could do an automatic
table of contents and that worked out pretty well. And a different style
for the figures and tables so I could auto-produce a list of figures as
well.
Haven't done an index, however.
I'd be glad to send you a copy off-line if it would be useful to you.
HTH
Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
----- Original Message -----
From: "Joe Hecht" <jmhla at earthlink.net>
To: "'ACCESS-L'" <ACCESS-L at PEACH.EASE.LSOFT.COM>; "AccessD"
<AccessD at databaseadvisors.com>
Sent: Saturday, April 17, 2004 11:44 PM
Subject: [AccessD] About Manuals for your databases X posted
> How many of you right them?
>
> Do you right users and developers manuals that explain your hows and
> whys?
>
> In my forms, I do things like make non-visible fields red and bold just
> so they are easier to see if they are buried under other controls.
>
> Just wondering
>
> JOE HECHT
> LOS ANGELES CA
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
------------------------------
Message: 8
Date: Sun, 18 Apr 2004 15:57:53 -0400
From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4082A581.7252.F87E02 at localhost>
Content-Type: text/plain; charset=US-ASCII
On 18 Apr 2004 at 12:48, Rocky Smolin - Beach Access S wrote:
> I use the ADH calendar and trigger it on the double-click of any date
> text box. So they can still hand enter the date if they want. Users
> seem to like the convention once they get used to it.
I use the ADH one too. I actually place a button right beside the
textbox so that the calendar can be opened without taking your hands
off the keyboard.
--
Bryan Carbonnell - carbonnb at sympatico.ca
Don't take life too seriously. You won't get out alive.
------------------------------
Message: 9
Date: Sun, 18 Apr 2004 14:11:22 -0700
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <015b01c42589$b3bde390$6601a8c0 at HAL9002>
Content-Type: text/plain; charset="iso-8859-1"
Bryan:
So is that button the next control in the tab sequence after the text box
which would contain a date so the user can then TAB to it and press Enter?
Rocky
----- Original Message -----
From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, April 18, 2004 12:57 PM
Subject: Re: [AccessD] Calendar Controls -- just for discussion
> On 18 Apr 2004 at 12:48, Rocky Smolin - Beach Access S wrote:
>
> > I use the ADH calendar and trigger it on the double-click of any date
> > text box. So they can still hand enter the date if they want. Users
> > seem to like the convention once they get used to it.
>
> I use the ADH one too. I actually place a button right beside the
> textbox so that the calendar can be opened without taking your hands
> off the keyboard.
>
> --
> Bryan Carbonnell - carbonnb at sympatico.ca
> Don't take life too seriously. You won't get out alive.
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
------------------------------
Message: 10
Date: Sun, 18 Apr 2004 17:27:00 -0400
From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4082BA64.21526.14A13BF at localhost>
Content-Type: text/plain; charset=US-ASCII
On 18 Apr 2004 at 14:11, Rocky Smolin - Beach Access S wrote:
> So is that button the next control in the tab sequence after the text
> box which would contain a date so the user can then TAB to it and
> press Enter?
I'm not sure if enter works, I always use the space bar to activate
the button, but yes that's the concept.
The button is the next item in the tab order. The user would press
space/enter and the calendar form opens, or they can just tab through
the button if they type the date manually.
--
Bryan Carbonnell - carbonnb at sympatico.ca
Normal people worry me.
------------------------------
Message: 11
Date: Sun, 18 Apr 2004 23:00:43 +0100
From: "Andy Lacey" <andy at minstersystems.co.uk>
Subject: RE: [AccessD] Calendar Controls -- just for discussion
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <000601c42590$98900470$b274d0d5 at minster33c3r25>
Content-Type: text/plain; charset="US-ASCII"
> I use a modified version of Drew's old mini-calendar which is all VBA,
dead reliable, and very fast.
Ditto (and thanks to Drew)
-- Andy Lacey
http://www.minstersystems.co.uk
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> William Hindman
> Sent: 18 April 2004 17:42
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Calendar Controls -- just for discussion
>
>
> ...first ...I don't use the ODE Calendar Control because of a
> long history of versioning problems ...even when you wrap it
> in a class you're app is still vulnerable ...besides it being
> slow ...I use a modified version of Drew's old mini-calendar
> which is all VBA, dead reliable, and very fast.
>
> ...second (this has been discussed here recently but under
> another thread
> topic) ...I much prefer data integrity over speed but its not
> necessary to sacrifice one for the other ...I always force
> user date entry from a pop-up calendar ...the calendar
> pops-up at the bottom right of the text box with the current
> date defaulted ...if the current date is what is required
> ...a dblclick gets the date entered and tabs to the next
> control ...if not, the cal responds to either mouse (slow) or
> keyboard (fast) for date selection.
>
> ...purists will try and tell you that such an approach slows
> keyboarders down and they won't accept it ...I disagree
> ...once the keyboarders get used to the keyboard strokes that
> control the cal it is in most cases just as fast as them
> entering it directly ...BUT ...big one ...the forced calendar
> usage eliminates most date errors from users who enter/read
> dates differently ...and the difference between error/dirty
> data correction time and getting it right the first time
> weighs heavily in favor of using a cal control over straight
> user date entry.
>
> William Hindman
> "Always code as if the person who is maintaining or testing
> your code is a violent psychopath who knows where you live."
> William Silverstein
>
>
> ----- Original Message -----
> From: "Susan Harkins" <ssharkins at bellsouth.net>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Sunday, April 18, 2004 11:44 AM
> Subject: [AccessD] Calendar Controls -- just for discussion
>
>
> > I'm writing about the ODE Calendar Control and I'm curious
> how many of
> > you use Calendar controls in your apps.
> >
> > I've had people complain about them -- they'd actually
> enter the dates
> > themselves because they find the break in their data entry routines
> annoying
> > -- from a data integrity point of view I can see the value of the
> > controls
> > -- but how do you convince people to use them?
> >
> > Susan H.
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
------------------------------
Message: 12
Date: Mon, 19 Apr 2004 00:17:55 +0200
From: "Pedro Janssen" <pedro at plex.nl>
Subject: [AccessD] error in code
To: <AccessD at databaseadvisors.com>
Message-ID: <000801c42593$219ec510$f4c581d5 at pedro>
Content-Type: text/plain; charset="iso-8859-1"
Hello Group,
why isn't this part of a code not working
for i = 1 To 9
If "chb" & i & "c31") = True Then
.Item("Code" & i).Value = "** geen code"
End If
Next i
the error is: Error 13, Description: Type Mismatch
TIA
Pedro Janssen
------------------------------
Message: 13
Date: Sun, 18 Apr 2004 18:41:41 -0400
From: "Susan Harkins" <ssharkins at bellsouth.net>
Subject: RE: [AccessD] error in code
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID:
<20040418224141.TSEN1714.imf16aec.mail.bellsouth.net at SUSANONE>
Content-Type: text/plain; charset="US-ASCII"
for i = 1 To 9
If "chb" & i & "c31") = True Then
Your condition is never going to equal true -- but rather a cancatenated
string. Although, I think the code's missing soemthing -- you've got a )
that doesn't make sense in its position, but I suspect that's just a typo
and probably isn't your actual error is it?
Susan H.
------------------------------
Message: 14
Date: Sun, 18 Apr 2004 18:46:46 -0400
From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
Subject: Re: [AccessD] error in code
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4082CD16.31909.1931CA1 at localhost>
Content-Type: text/plain; charset=US-ASCII
On 19 Apr 2004 at 0:17, Pedro Janssen wrote:
> why isn't this part of a code not working
>
> for i = 1 To 9
> If "chb" & i & "c31") = True Then
> .Item("Code" & i).Value = "** geen code"
> End If
> Next i
Pedro,
I am assuming that chb* are checkboxes. If so, try:
If me.controls("chb" & i & "c31") = True Then
You also have a closing ) on the ofiginal If Then line.
--
Bryan Carbonnell - carbonnb at sympatico.ca
I am a nobody, and nobody is perfect; therefore, I am perfect.
------------------------------
Message: 15
Date: Mon, 19 Apr 2004 09:52:42 +1000
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Subject: Re: [AccessD] error in code
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4083A16A.23848.32CE49 at localhost>
Content-Type: text/plain; charset=US-ASCII
On 19 Apr 2004 at 0:17, Pedro Janssen wrote:
> Hello Group,
>
> why isn't this part of a code not working
>
> for i = 1 To 9
> If "chb" & i & "c31") = True Then
> .Item("Code" & i).Value = "** geen code"
> End If
> Next i
>
> the error is: Error 13, Description: Type Mismatch
>
Apart from the problems mentioned by others (the missing "(", the
missing "me.controls" or "." before "chb1"), this will result in
spaces in your control names ie "chb 1c31" to "chb 9c31" and "Code 1"
to "Code 9"
UNless you do have spaces in the control names, you need to use
Format(i) or similar to get rid of the leading space.
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System
Support.
------------------------------
Message: 16
Date: Sun, 18 Apr 2004 15:42:33 -0800
From: "Porter, Mark" <MPorter at acsalaska.com>
Subject: RE: [AccessD] About Manuals for your databases X posted
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<BFBC9BAC6169D411890000508BAE2C5304246E84 at acsexch4.corp.acsalaska.com>
Content-Type: text/plain; charset="iso-8859-1"
I charge the same hourly rate for documentation as I do for coding.
Then I strongly suggest that they produce their own. I've never been asked
to produce documentation (user docs) yet.
Mark
-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net]
Sent: Saturday, April 17, 2004 10:44 PM
To: 'ACCESS-L'; AccessD
Subject: [AccessD] About Manuals for your databases X posted
How many of you right them?
Do you right users and developers manuals that explain your hows and
whys?
In my forms, I do things like make non-visible fields red and bold just
so they are easier to see if they are buried under other controls.
Just wondering
JOE HECHT
LOS ANGELES CA
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
****************************************************************************
*******
18/4/2004
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS
------------------------------
Message: 17
Date: Mon, 19 Apr 2004 01:44:05 -0700 (PDT)
From: S D <accessd667 at yahoo.com>
Subject: [AccessD] Error 3265. Item not found in this collection?!!?
To: accessd <accessd at databaseadvisors.com>
Message-ID: <20040419084405.36072.qmail at web61105.mail.yahoo.com>
Content-Type: text/plain; charset=us-ascii
Hi group,
a user reported an error. The error message displayed the following info:
Source: DAO.Fields
Number: 3265
Description: Item not found in this collection
Call Stack: Switchdatabase.Message_Check_GAS.Check1015
Switchdatabase.Form_frm_GAS_GENERATE.cmdGenerate_Click
The line that causes the error is (see code below for details):
rv = MsgBox("Duplicate value!! Delete original record?" & vbCr _
, vbYesNo, "Answer question")
WHY does this occur?
The user is using Win NT. The error does NOT occur on Win2000. We never had
this problem before, not on NT and not on Win2000.
Please advise!
TIA
Sander
This is the code that caused the problem:
Public Function Check_1015(msgtype As String) As String
Dim Status As String
Dim rs, rsb As Recordset
Dim db As Database
Dim teller, i As Long
Dim rv As String
On Error GoTo Check_1015_Error
Status = "Ok"
If msgtype = "I" Then
...
...
Set rsb = db.OpenRecordset("Select * from
V4_GAS_Bronbestand_Verhuizingen where connect_EAN = '" & rs!Connect_EAN &
"'", dbReadOnly)
If rsb.EOF = False Then
rv = MsgBox("Duplicate value!! Delete original record?" & vbCr _
, vbYesNo, "Answer question")
....
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
------------------------------
Message: 18
Date: Mon, 19 Apr 2004 11:11:01 +0200
From: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] custom sorts/groups in a report
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <1918237935.20040419111101 at cactus.dk>
Content-Type: text/plain; charset=us-ascii
Hi Susan
Your method looks longwinded but not weird. If it works fast and
well I would leave it, though I'm sure another method could be found
where you adjust the grouping in the report directly.
/gustav
> Well, it's clunky --
> 1.) User selects the first day of the week from a list of Sunday through
> Saturday.
> 2.) User clicks a command button that opens the report and sends the above
> selected value via the OpenArgs argument.
> 3.) The report is based on a query that calls a function that uses the
value
> selected in #1 to return a weekday value for each date.
> 4.) The report's grouping is first set to year. The second level groups on
> the weekday value returned by #3. And, a third sorting level simply sorts
> the date values so it all comes out in the wash.
> 5.) The group header contains a value that uses the openargs value in a
> DatePart expression to return the first day of the week for each group.
> You can use the report without the form and it will default to a
> firstdayoftheweek value of 1 -- to avoid errors and to make it easier to
use
> the report without going through the form -- that way you could set the
> default to anything and the user could just open the report.
> Seems like it ought to be easier than that though -- just too much going
on.
> #3's the one I don't really like. Seems like I ought to be able to get
that
> weekday number in the report, and although I can -- I can't sort by it.
> Someone mentioned yesterday that you could group on a calculation, but
I've
> not figured that one out yet. I tried setting it using the GroupLevel and
> GroupOn properties, but never got it to work -- not saying it won't, just
I
> wasn't successful. I didn't spend much time on it though. My understanding
> of the GroupOn property is that it needs to refer to a specific integer
> value that represents the built-in levels (Month, Year, Quarter, and so
on).
> I never could get it to accept a DatePart expression.
> Susan H.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Sunday, April 18, 2004 1:00 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] custom sorts/groups in a report
> Hi Susan
>> I'm still not happy with the solution -- there's got to be an easier
>> way. :)
> Maybe. What solution did you settle on?
> /gustav
------------------------------
Message: 19
Date: Mon, 19 Apr 2004 02:34:38 -0700 (PDT)
From: S D <accessd667 at yahoo.com>
Subject: Re: [AccessD] Error 3265. Item not found in this
collection?!!? <SOLVED>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <20040419093438.7994.qmail at web61102.mail.yahoo.com>
Content-Type: text/plain; charset=us-ascii
Hi group,
I found the freaking error. This app is sooooo buggy! There was a reference
(not displayed in the code below) to a field called Net_op_EAN...the
CORRECT field name is NetOp_Ean.
Question: "Has this functionality EVER worked before?" (this is a standard
question for this app :-(
User response: "Yes, we use this functionality on a daily basis!"
Yeah right: Tables are empty, log is empty and output directory is empty.
Grrrr. Anyway its job that pays the bills.
Sander
S D <accessd667 at yahoo.com> wrote:
Hi group,
a user reported an error. The error message displayed the following info:
Source: DAO.Fields
Number: 3265
Description: Item not found in this collection
Call Stack: Switchdatabase.Message_Check_GAS.Check1015
Switchdatabase.Form_frm_GAS_GENERATE.cmdGenerate_Click
The line that causes the error is (see code below for details):
rv = MsgBox("Duplicate value!! Delete original record?" & vbCr _
, vbYesNo, "Answer question")
WHY does this occur?
The user is using Win NT. The error does NOT occur on Win2000. We never had
this problem before, not on NT and not on Win2000.
Please advise!
TIA
Sander
This is the code that caused the problem:
Public Function Check_1015(msgtype As String) As String
Dim Status As String
Dim rs, rsb As Recordset
Dim db As Database
Dim teller, i As Long
Dim rv As String
On Error GoTo Check_1015_Error
Status = "Ok"
If msgtype = "I" Then
...
...
Set rsb = db.OpenRecordset("Select * from V4_GAS_Bronbestand_Verhuizingen
where connect_EAN = '" & rs!Connect_EAN & "'", dbReadOnly)
If rsb.EOF = False Then
rv = MsgBox("Duplicate value!! Delete original record?" & vbCr _
, vbYesNo, "Answer question")
....
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
------------------------------
Message: 20
Date: Mon, 19 Apr 2004 14:53:33 +1000
From: "Darren DICK" <d.dick at uws.edu.au>
Subject: Re: [AccessD] Calendar Controls -- just for discussion
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <00c001c42608$f7e59a70$0b669a89 at DDICK>
Content-Type: text/plain; charset="iso-8859-1"
I give 'em both. Both straight data entry and a calendar
They can do data entry straight into the control or double click to get a
VBA only calendar.
(Won't touch the OCX ones anymore)
I also have a small popup that provides some of the basic date ranges
IE 1st or 2nd or 3rd etc quarter of current or last year
All Year, all last year. This month, last month, Last week this week,
Next week, next month, today etc.
All available with checkboxes.
Click a check and the dates are determined and results put into
txtStartDate and txtEndDate controls
Works a treat
HTH
Darren
----- Original Message -----
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, April 19, 2004 1:44 AM
Subject: [AccessD] Calendar Controls -- just for discussion
> I'm writing about the ODE Calendar Control and I'm curious how many of you
> use Calendar controls in your apps.
>
> I've had people complain about them -- they'd actually enter the dates
> themselves because they find the break in their data entry routines
annoying
> -- from a data integrity point of view I can see the value of the controls
> -- but how do you convince people to use them?
>
> Susan H.
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
------------------------------
Message: 21
Date: Mon, 19 Apr 2004 08:20:00 -0500
From: "Robert L. Stewart" <rl_stewart at highstream.net>
Subject: [AccessD] Re: Changing the table in a query so I can loop
through thequery
To: accessd at databaseadvisors.com
Message-ID: <5.1.0.14.2.20040419081850.02b22e48 at pop3.highstream.net>
Content-Type: text/plain; charset="us-ascii"; format=flowed
Susan,
If you have 71 identical tables, you have a design problem. Why do you
need 71 tables with the same information?
Robert
At 12:00 PM 4/18/2004 -0500, you wrote:
>Date: Sat, 17 Apr 2004 16:59:29 -0400
>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Subject: RE: [AccessD] Changing the table in a query so I can loop
> through thequery
>To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
>Message-ID:
> <20040417205929.PLEB1773.imf19aec.mail.bellsouth.net at SUSANONE>
>Content-Type: text/plain; charset="US-ASCII"
>
>I'm sorry, not an UPDATE, but a SQL INSERT INTO
>
>Susan H.
>
>I have an append query that can work for 71 tables. I want to create a for
>next loop function that will substitute the table names (they are numbers)
>each time it loops. Can someone help me? I do not quite have the query
def
>thing down and I think I need to use it here. Each table has the same
>fields.
------------------------------
Message: 22
Date: Mon, 19 Apr 2004 08:31:36 -0500
From: "Dan Waters" <dwaters at usinternet.com>
Subject: RE: [AccessD] About Manuals for your databases X posted
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <001601c42612$a3831480$de1811d8 at danwaters>
Content-Type: text/plain; charset="us-ascii"
I write a manual for every process module. Managers want them available,
and I want to be able to refer to the manual instead of being told that they
can't figure it out. I write a Word document that contains all the detail a
user would need. The module contains a Manual hyperlink button so it can be
pulled up at any time. The manuals are typically 10 - 25 pages long.
I also use the manual as a QC tool for myself. As I write it, I double
check the system to be sure it does just what the manual says.
Dan Waters
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Sunday, April 18, 2004 1:44 AM
To: 'ACCESS-L'; AccessD
Subject: [AccessD] About Manuals for your databases X posted
How many of you right them?
Do you right users and developers manuals that explain your hows and
whys?
In my forms, I do things like make non-visible fields red and bold just
so they are easier to see if they are buried under other controls.
Just wondering
JOE HECHT
LOS ANGELES CA
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 23
Date: Mon, 19 Apr 2004 09:45:57 -0400
From: "Susan Harkins" <ssharkins at bellsouth.net>
Subject: RE: [AccessD] custom sorts/groups in a report
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID:
<20040419134556.DMSZ1832.imf22aec.mail.bellsouth.net at SUSANONE>
Content-Type: text/plain; charset="US-ASCII"
That's what I'd rather do, simply because it leaves fewer holes.
Susan H.
Hi Susan
Your method looks longwinded but not weird. If it works fast and well I
would leave it, though I'm sure another method could be found where you
adjust the grouping in the report directly.
/gustav
> Well, it's clunky --
> 1.) User selects the first day of the week from a list of Sunday
> through Saturday.
> 2.) User clicks a command button that opens the report and sends the
> above selected value via the OpenArgs argument.
> 3.) The report is based on a query that calls a function that uses the
> value selected in #1 to return a weekday value for each date.
> 4.) The report's grouping is first set to year. The second level
> groups on the weekday value returned by #3. And, a third sorting level
> simply sorts the date values so it all comes out in the wash.
> 5.) The group header contains a value that uses the openargs value in
> a DatePart expression to return the first day of the week for each group.
> You can use the report without the form and it will default to a
> firstdayoftheweek value of 1 -- to avoid errors and to make it easier
> to use the report without going through the form -- that way you could
> set the default to anything and the user could just open the report.
> Seems like it ought to be easier than that though -- just too much going
on.
> #3's the one I don't really like. Seems like I ought to be able to get
> that weekday number in the report, and although I can -- I can't sort by
it.
> Someone mentioned yesterday that you could group on a calculation, but
> I've not figured that one out yet. I tried setting it using the
> GroupLevel and GroupOn properties, but never got it to work -- not
> saying it won't, just I wasn't successful. I didn't spend much time on
> it though. My understanding of the GroupOn property is that it needs
> to refer to a specific integer value that represents the built-in levels
(Month, Year, Quarter, and so on).
> I never could get it to accept a DatePart expression.
> Susan H.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
> Brock
> Sent: Sunday, April 18, 2004 1:00 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] custom sorts/groups in a report
> Hi Susan
>> I'm still not happy with the solution -- there's got to be an easier
>> way. :)
> Maybe. What solution did you settle on?
> /gustav
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 24
Date: Mon, 19 Apr 2004 16:04:56 +0200
From: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] custom sorts/groups in a report
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <12825873634.20040419160456 at cactus.dk>
Content-Type: text/plain; charset=us-ascii
Hi Susan
Then, in the report, can't you sort and group by
=Weekday(YourDate, [YourSelectedFirstWeekday])
/gustav
> That's what I'd rather do, simply because it leaves fewer holes.
> Susan H.
> Hi Susan
> Your method looks longwinded but not weird. If it works fast and well I
> would leave it, though I'm sure another method could be found where you
> adjust the grouping in the report directly.
------------------------------
Message: 25
Date: Mon, 19 Apr 2004 09:42:19 -0500
From: DWUTKA at marlow.com
Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox
content s
To: accessd at databaseadvisors.com
Message-ID:
<2F8793082E00D4119A1700B0D0216BF802227ADF at main2.marlow.com>
Content-Type: text/plain; charset="iso-8859-1"
Did you try 'First'?
Again, it is going to be dependant on how Access actually 'sees' the data.
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
Sent: Friday, April 16, 2004 7:12 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox
contents
Thanks, Drew and Gustav for responding.
I tried Max, but sometimes the ID I need is in the middle of the IDs.
I didn't think about using Top, I'll try that.
thanks again.
Jim
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Friday, April 16, 2004 4:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sorting and restricting ComboBox on ListBox
contents
Hi Jim
> I have a list box with over 130 items all rows are distinct but a few
columns are duplicates. The ListBox is sorted on two text fields which puts
the ID number out of sequence. The ComboBox sorts
> and "Groups By" duplicate columns. What I want to do is use the ComboBox
to jump to the first instance of one of the duplicate columns.
> e.g.
> ID CourseName City
> 135 CCP EC
> 90 DIS EC
> 87 DIS MP
> 18 DOC CD
> 17 DOC SR
> 55 DSC M AL
> 57 DSC M EC
> 43 DSC M MP
> 28 DSC M SF
> 3 DSC M SR
> What I want is:
> 135 CCP EC
> 90 DIS EC
> 18 DOC CD
> 55 DSC M AL
> 3 DSC M SR
> What I get is:
> 135 CCP EC
> 87 DIS MP
> 17 DOC SR
> 3 DSC M SR
> What needs to be done to what the desired results?
As Drew notes, you'll have to pick the sorted values for ID and City
for each CourseName.
Two subqueries can be used for this:
<SQL>
SELECT
(SELECT
TOP 1 ID
FROM
tblCourses AS aliC
WHERE
aliC.CourseName = tblCourses.CourseName
ORDER BY
City,
ID DESC;) AS TopID,
CourseName,
(SELECT
TOP 1 City
FROM
tblCourses AS aliC
WHERE
aliC.CourseName = tblCourses.CourseName
ORDER BY
City,
ID DESC;) AS TopCity
FROM
tblCourses
GROUP BY
CourseName;
</SQL>
Have fun!
/gustav
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 26
Date: Mon, 19 Apr 2004 09:47:47 -0500
From: DWUTKA at marlow.com
Subject: RE: [AccessD] Calendar Controls -- just for discussion
To: accessd at databaseadvisors.com
Message-ID:
<2F8793082E00D4119A1700B0D0216BF802227AE0 at main2.marlow.com>
Content-Type: text/plain; charset="iso-8859-1"
You're quite welcome. As soon as life settles down, I'll finish up the new
version. Which is keyboard friendly too!
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Sunday, April 18, 2004 5:01 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Calendar Controls -- just for discussion
> I use a modified version of Drew's old mini-calendar which is all VBA,
dead reliable, and very fast.
Ditto (and thanks to Drew)
-- Andy Lacey
http://www.minstersystems.co.uk
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> William Hindman
> Sent: 18 April 2004 17:42
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Calendar Controls -- just for discussion
>
>
> ...first ...I don't use the ODE Calendar Control because of a
> long history of versioning problems ...even when you wrap it
> in a class you're app is still vulnerable ...besides it being
> slow ...I use a modified version of Drew's old mini-calendar
> which is all VBA, dead reliable, and very fast.
>
> ...second (this has been discussed here recently but under
> another thread
> topic) ...I much prefer data integrity over speed but its not
> necessary to sacrifice one for the other ...I always force
> user date entry from a pop-up calendar ...the calendar
> pops-up at the bottom right of the text box with the current
> date defaulted ...if the current date is what is required
> ...a dblclick gets the date entered and tabs to the next
> control ...if not, the cal responds to either mouse (slow) or
> keyboard (fast) for date selection.
>
> ...purists will try and tell you that such an approach slows
> keyboarders down and they won't accept it ...I disagree
> ...once the keyboarders get used to the keyboard strokes that
> control the cal it is in most cases just as fast as them
> entering it directly ...BUT ...big one ...the forced calendar
> usage eliminates most date errors from users who enter/read
> dates differently ...and the difference between error/dirty
> data correction time and getting it right the first time
> weighs heavily in favor of using a cal control over straight
> user date entry.
>
> William Hindman
> "Always code as if the person who is maintaining or testing
> your code is a violent psychopath who knows where you live."
> William Silverstein
>
>
> ----- Original Message -----
> From: "Susan Harkins" <ssharkins at bellsouth.net>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Sunday, April 18, 2004 11:44 AM
> Subject: [AccessD] Calendar Controls -- just for discussion
>
>
> > I'm writing about the ODE Calendar Control and I'm curious
> how many of
> > you use Calendar controls in your apps.
> >
> > I've had people complain about them -- they'd actually
> enter the dates
> > themselves because they find the break in their data entry routines
> annoying
> > -- from a data integrity point of view I can see the value of the
> > controls
> > -- but how do you convince people to use them?
> >
> > Susan H.
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 27
Date: Mon, 19 Apr 2004 08:50:40 -0700
From: "Charlotte Foust" <cfoust at infostatsystems.com>
Subject: RE: [AccessD] About Manuals for your databases X posted
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<E61FC1D4B1918244905B113C680BEA86312729 at infoserver01.infostat.local>
Content-Type: text/plain; charset="us-ascii"
I do NOT write developer manuals, although I do create user help files.
Any developer notes are in the comments in code, but those are for me,
not for other developers ... Unless I step in front of a bus. <VBG>
Charlotte Foust
-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net]
Sent: Saturday, April 17, 2004 10:44 PM
To: 'ACCESS-L'; AccessD
Subject: [AccessD] About Manuals for your databases X posted
How many of you right them?
Do you right users and developers manuals that explain your hows and
whys?
In my forms, I do things like make non-visible fields red and bold just
so they are easier to see if they are buried under other controls.
Just wondering
JOE HECHT
LOS ANGELES CA
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 28
Date: Mon, 19 Apr 2004 12:28:21 -0400
From: "O'Connor, Patricia " <Patricia.O'Connor at dfa.state.ny.us>
Subject: RE: [AccessD] jpg Screen shot
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<B94C79B465542042AB0748EAF37F9AC024A6BC at EXCNYSM0A1AB.nysemail.nyenet>
Content-Type: text/plain; charset="US-ASCII"
Rocky,
We use printkey 2000 (full). It allows us to print the entire screen,
the active window, crop, cut, then copy/paste stuff into word documents,
powerpoint, emails, etc.
Patti
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Rocky Smolin - Beach Access Software
> Sent: Thursday, April 15, 2004 04:31 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] jpg Screen shot
>
> Dear List:
>
> A magazine wants a screen shot from my software and they
> would like it to be 300dpi.
>
> What's the best way to get that off the screen and into a jpg?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
End of AccessD Digest, Vol 14, Issue 31
***************************************