Drew Wutka
DWUTKA at marlow.com
Mon Jun 16 17:45:09 CDT 2003
You might find this link useful: http://mvps.org/access/datetime/date0009.htm Drew -----Original Message----- From: Robert Gracie [mailto:Subscriptions at servicexp.com] Sent: Monday, June 16, 2003 5:28 PM To: accessd at databaseadvisors.com Subject: [AccessD] adding Time A2K I have 7 unbound text boxes that have time amounts listed in HH:MM (8:27) format. How do I go about adding up the time? Everything I try, I get a data mismatch error... Thanks Robert Gracie -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Monday, June 16, 2003 6:20 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] OpenArgs question And in the report's events, it can't see the OpenArgs string value? Is the listbox value a string in the first place? I notice you're delimiting it with chr(34)s, but you don't need them if it's not a date or numeric value. Charlotte Foust -----Original Message----- From: Susan Harkins [mailto:harkins at iglou.com] Sent: Monday, June 16, 2003 1:51 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] OpenArgs question OK, I'm using AXP. I'm selecting a single item from a list box and trying to pass that value (a string) to the report via the report's OpenArgs value. Susan H. > Susan, > > I'm getting confused. Where are you trying to recognize it, and where > does a form come into the equation? Only A2002 has an OpenArgs > argument for reports. Earlier versions didn't have it. We use it in > reports without problems, so what are you trying to do that isn't > succeeding? > > Charlotte Foust > > -----Original Message----- > From: Susan Harkins [mailto:harkins at iglou.com] > Sent: Monday, June 16, 2003 12:50 PM > To: AccessD at databaseadvisors.com > Subject: [AccessD] OpenArgs question > > > This should be an easy one. The following event procedure opens a > report and passes the list box' value as th OpenArgs setting. > > Private Sub lstCategories_DblClick(Cancel As Integer) > Dim str As String > str = Chr(34) & Me.lstCategories.Value & Chr(34) > Debug.Print str > DoCmd.OpenReport ReportName:="Catalog", _ > View:=acViewPreview, _ > OpenArgs:=str > End Sub > > Problem is, I can't get the report to recognize it -- in any report > event. > > Reports!reportname.OpenArgs > Me.OpenArgs > rpt.OpenArgs > > I've tried all three in most of the report's events after opening it > via the form and the setting isn't making it to the form. Any clue > what I'm doing wrong? > > 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 _______________________________________________ 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