DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Aug 17 15:49:08 CDT 2004
Public is the default (isn't it?). Kathryn named the module the same as the function, which is what was throughing the query off. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence (AccessD) Sent: Tuesday, August 17, 2004 2:49 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] update qry to deconstructe place Hi Kathryn: If you are calling a function from a query that function must be set to PUBLIC. Example: Public Function SplitDeathPlace(strPlace As String, .... HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens Sent: Tuesday, August 17, 2004 10:01 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] update qry to deconstructe place I'm doing something wrong. I clicked on Modules and then on New. I pasted in the Function code. Named the module SplitDeathPlace. Compiled it. Saved it. First indication something not right is that when I'm back at Modules, the SplitDeathPlace doesn't show up. But when I click on new again, it is there. http://www.babcockancestry.com/storage/accessmodulesplitdeathplace.jpg Thinking that there is a reason it's not showing, I go on to next step and make an (update) query. http://www.babcockancestry.com/storage/accessquerysplitdeathplace.jpg When I try to run it, I get: Undefined function 'SplitDeathPlace' in expression Does not showing on the main screen right panel when clicking on modules on main screen left panel have anything to do with this? This is the first module I've made, so maybe how I did it was wrong? -- Kathryn Bassett (at work address) kathrynatgwens at socal.rr.com kathryn at bassett.net (home) > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of > DWUTKA at marlow.com > Sent: Tuesday, August 17, 2004 8:04 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] update qry to deconstructe place > > > Then put this in a module: > > Function SplitDeathPlace(strPlace As String, intPos As Long) AS String > Dim strArray() As String > strArray=Split(strPlace,", ") > SplitDeathPlace=strArray(intPos) > End Function > > And in your query, put the following for DeathCity: > > SplitDeathPlace([DeathPlace],0) > > Replace the 0 with 1 for deathcounty, and 2 for deathstate > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kathryn > Bassett > Sent: Monday, August 16, 2004 7:57 PM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] update qry to deconstructe place > > > Yes > > -- > Kathryn Rhinehart Bassett (Pasadena CA) > "Genealogy is my bag" "GH is my soap" > kathryn at bassett.net > http://bassett.net > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > > DWUTKA at marlow.com > > Sent: 16 Aug 2004 1:32 pm > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] update qry to deconstructe place > > > > I forgot, are you using Access 2000? > > > > Drew > > -- > _______________________________________________ > 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