Hi,
i have a icon the access wizard created that lets a user click on and the Find dialog pops up, with certain options such as search, match, etc...
i want to set the options to Search = all and Match = any part of field.
i have found this code in vba
DoCmd.FindRecord findwhat[, match][, matchcase][, search][, searchasformatted][, onlycurrentfield][, findfirst]
but this does not pop up the Access box for the user to choose, it's hardcoded or can be passed thru from a msgbox but i want the original look & feel.
i also used:
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
but the defaults can't be set that i see.
anyone know of any other ways or ideas? thx.
i have a icon the access wizard created that lets a user click on and the Find dialog pops up, with certain options such as search, match, etc...
i want to set the options to Search = all and Match = any part of field.
i have found this code in vba
DoCmd.FindRecord findwhat[, match][, matchcase][, search][, searchasformatted][, onlycurrentfield][, findfirst]
but this does not pop up the Access box for the user to choose, it's hardcoded or can be passed thru from a msgbox but i want the original look & feel.
i also used:
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
but the defaults can't be set that i see.
anyone know of any other ways or ideas? thx.