ACCESS FEED: Re: [MS_AccessPros] Split Database Issue 1- search not working in accde

I make changes to the master.accdb file on the server. I use this file to make the .accde file, also on the server. I move the .accde file to the local pc. The search fails to work in the .accde files, both on the server and locally.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Amanda-
>
> You didn't answer my question about where you test your master file and on
> which machine is the error occurring.
>
> Try my suggestion about adding a MsgBox just to see if the event is even
> firing.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Amanda B
> Sent: Thursday, June 20, 2013 7:45 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Split Database Issue 1- search not working in
> accde
>
> I'm saying that the user types their search term in the textbox, then uses
> the dropdown arrow to see the results of the search. When they select an
> item in the search, the form should repopulate with the data for that animal
> (the dropdown is bound to the Animal ID). When I say it doesn't work in the
> FE, I mean that when you select a name, nothing happens, the form remains on
> the record it had before the update.
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas wrote:
> >
> > Amanda-
> >
> > If all you want to have happen is the Row Source of the combo box gets
> > updated when the user types in a search, then you need do nothing
> more.
> >
> > Are you saying that when you select something in the filtered combo
> that the
> > AfterUpdate is not working? I see no reason why it shouldn't work
> except
> > that the FindFirst is redundant if you are also applying a filter.
> >
> > By "not working," do you mean nothing happens?
> >
> > You could try putting a MsgBox in the After Update event temporarily -
> > something simple like
> >
> > MsgBox "Filter applied!"
> >
> > .. just to see if the code is even getting called.
> >
> > When you test the "master" file, is it running on the same machine as
> the
> > one having the problems with the .accde? If not, try running the
> master
> > file from the offending machine.
> >
> > John Viescas, Author
> > Microsoft Access 2010 Inside Out
> > Microsoft Access 2007 Inside Out
> > Microsoft Access 2003 Inside Out
> > Building Microsoft Access Applications SQL Queries for Mere Mortals
> > http://www.viescas.com/ (Paris, France)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Amanda B
> > Sent: Thursday, June 20, 2013 2:51 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Split Database Issue 1- search not
> working in
> > accde
> >
> > Hmmm, what I want to do is change the filter for the form based on the
> name
> > the user selects from the ComboSearchNames choices (so not necessarily
> the
> > first one).
> >
> > I suppose that makes the purpose of the code below for
> > ComboSearchNames.AfterUpdate ambiguous/useless.
> > Me.Recordset.FindFirst "[Animal ID] =" & Me.ComboSearchNames
> >
> > When I comment this line out, the Master file still works, but when I
> make a
> > new FE with the changes, it does not.
> >
> > I'm unclear when you say "do the call". I assume you mean call the
> > ComboSearchNames AfterUpdate routine. All the VB I've done in Access
> has
> > been a little tinkering with Event Procedures as aspects of a form
> object's
> > properties- so each of those is a subroutine waiting to be called- I
> don't
> > really follow an idea of "running a program" when I open the form
> (although
> > I suppose that is what happens)
> >
> > Could you be a little more specific?
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas JohnV@
> > wrote:
> > >
> > > Amanda-
> > >
> > > After you update the Row Source of the combo box, it will acquire
> the
> > > value of the first row. If you want to filter on that value, do the
> > > call to the combo AfterUpdate after you set the Row Source.
> > >
> > > John Viescas, Author
> > > Microsoft Access 2010 Inside Out
> > > Microsoft Access 2007 Inside Out
> > > Microsoft Access 2003 Inside Out
> > > Building Microsoft Access Applications SQL Queries for Mere Mortals
> > > http://www.viescas.com/ (Paris, France)
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Amanda
> B
> > > Sent: Wednesday, June 19, 2013 7:10 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] Split Database Issue 1- search not
> > > working in accde
> > >
> > > Thanks John!
> > >
> > > Where exactly are you suggesting to add the
> ComboSearchNames_AfterUpdate?
> > > To the AfterUpdate of the form?
> > >
> > > As far as the Requery and Refresh- I have no training in VB, just
> some
> > > experience from a decade ago writing VBScript for websites- so
> > > everything I do in Access is pretty piecemeal. I probably copied
> that
> > > code from somewhere else and never realized it wasn't necessary to
> > > update the value of the form.
> > >
> > > ~ Amanda
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, John Viescas
> > > wrote:
> > > >
> > > > Amanda-
> > > >
> > > > Changing the value of a control (in this case, your combo box)
> won't
> > > > fire the AfterUpdate event of the control. If you want to fire it
> > > > from the AfterUpdate of the combo box, you need to add:
> > > >
> > > > ComboSearchNames_AfterUpdate
> > > > .. to fire the event from code and apply the filter to the form.
> > > >
> > > > By the way, you don't need to Requery the combo box. Resetting
> the
> > > > Row Source does an automatic Requery. I'm also wondering why you
> > > > have included Me.Refresh.
> > > >
> > > > John Viescas, Author
> > > > Microsoft Access 2010 Inside Out
> > > > Microsoft Access 2007 Inside Out
> > > > Microsoft Access 2003 Inside Out
> > > > Building Microsoft Access Applications SQL Queries for Mere
> Mortals
> > > > http://www.viescas.com/ (Paris, France)
> > > >
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> Amanda
> > > > B
> > > > Sent: Wednesday, June 19, 2013 5:40 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] Split Database Issue 1- search not
> working
> > > > in accde
> > > >
> > > > I posted a couple of weeks ago- we started having corruption
> > > > problems with our Access database, so I followed recommended
> > > > procedures for creating a front end file on the local pcs, and a
> > > > table file on the shared
> > > server.
> > > >
> > > > The setup now consists of 3 files: a file on the server with the
> > > > backend of the database, a "master" file on the server that is
> still
> > > > combined- with forms and linked tables (linked to the same backend
> > > > file, used to make design changes), and a copy of a front end file
> > > > on each
> > > user pc.
> > > >
> > > > I'm continuing to have three problems since this split. All three
> > > > problems are not issues with the master file. The first is
> > > > described below (I'll write up the others in separate posts)
> > > >
> > > > 1. Search functionality on the primary search form is not working.
> > > > It did work temporarily, but we had a glitch. I restored a backup
> > > > of the file and modified it several times- each time the search
> > > > worked fine in the master, but failed in the front end file.
> > > >
> > > > The search works with an Unbound text box to enter text for the
> search.
> > > > This box has an "AfterUpdate" event with the following code:
> > > >
> > > > Private Sub txtString_AfterUpdate() Me.ComboSearchNames.Requery
> > > > Dim strQuery As String strQuery = "SELECT [Animal Records].[Animal
> > > > ID], [Animal Records].[House Name], [Animal Records].[Aliases]
> > > > FROM [Animal Records] WHERE ([Animal Records].[House Name] LIKE
> > > > '*" & Me!txtString.Value & "*'OR [Animal Records].[Aliases] LIKE
> > > > '*" & Me!txtString.Value & "*') ORDER BY [Animal Records].[House
> > > > Name];"
> > > > Me!ComboSearchNames.RowSource = strQuery
> Me!ComboSearchNames.Visible
> > > > = True Form.Refresh End Sub
> > > >
> > > > There is a Dropdown next to the Searchbox that populates with the
> > > > results of the search so the user can select the appropriate one.
> > > >
> > > > Private Sub ComboSearchNames_AfterUpdate()
> > > > Me.Recordset.FindFirst "[Animal ID] =" & Me.ComboSearchNames
> > > > Form.Filter = "[Animal ID] =" & Me.ComboSearchNames
> > > > Form.FilterOn = True
> > > > Form.Refresh
> > > > Me.txtString = Null
> > > > End Sub
> > > >
> > > > When using the front end file to access the database, the dropdown
> > > > populates correctly, but the form does not refresh to the
> appropiate
> > > > record. When using the Master file, the form goes to the correct
> > > > record
> > > just fine.
> > > >
> > > > I have decompiled and recompiled, but this did not help.
> > > >
> > > > Any suggestions about changes to the code that might work more
> > > consistently?
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>