I would like to use a macro to run a find command but I can't get it to work. I want it to bring up a pop up in which I type the item I am looking for (more or less like the find command button) can anyone help me with the proper coding of this?
There's a command in the macro designer "FindRecord." It's pretty much self explanatory. Bonnie http://www.dataplus-svc.com JenK wrote: >I would like to use a macro to run a find command but I can't get it to work. >I want it to bring up a pop up in which I type the item I am looking for >(more or less like the find command button) can anyone help me with the >proper coding of this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200808/1
Yeah, I found that, the problem I have with it is that I have to have the perameter set in the macro, I want to be able to type the value I am looking for when I hit the find button. I currently have the find macro set as such: GoToControl: TrackingNum FindRecord: Find What: *Blank* Not sure what to put in here Match: Any Part of Field Search: All Search as Formatted: No Only Current Field: Yes Find First: Yes "bhicks11 via AccessMonster.com" wrote: > There's a command in the macro designer "FindRecord." It's pretty much self > explanatory. > > Bonnie > http://www.dataplus-svc.com > > JenK wrote: > >I would like to use a macro to run a find command but I can't get it to work. > >I want it to bring up a pop up in which I type the item I am looking for > >(more or less like the find command button) can anyone help me with the > >proper coding of this? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200808/1 > >
Gotcha. How about: Put a command button on your form, follow the wizard and select "Record Navigation" and "Find Record", etc. This will pop up the Find Command from the command button. Bonnie http://www.dataplus-svc.com JenK wrote: >Yeah, I found that, the problem I have with it is that I have to have the >perameter set in the macro, I want to be able to type the value I am looking >for when I hit the find button. >I currently have the find macro set as such: >GoToControl: TrackingNum >FindRecord: Find What: *Blank* Not sure what to put in here > Match: Any Part of Field > Search: All > Search as Formatted: No > Only Current Field: Yes > Find First: Yes > > >> There's a command in the macro designer "FindRecord." It's pretty much self >> explanatory. >[quoted text clipped - 6 lines] >> >(more or less like the find command button) can anyone help me with the >> >proper coding of this? -- Message posted via http://www.accessmonster.com
