Search results

  1. A

    Macro "Where" Clause

    Mr. Folley? I don't get the joke... When I click on the link I get this: Sorry - no matches. Please try some different terms
  2. A

    Macro "Where" Clause

    Well...the result I want happens...but it's accompanied by an extra prompt that I don't want. I want it to be all form driven so people don't have to go hunt through tables and queries and all that. I just want something people can click on buttons to navigate (ex: the search by location...
  3. A

    Macro "Where" Clause

    I'm trying to implement a search function. For example...I want all the records by X location which is prompted for. After the prompt is entered, I want all the records that fit that criteria to show up in a form (browsable a record at a time). Heh. I'll grumble how Access sucks...that's just...
  4. A

    Macro "Where" Clause

    Hm...so in that case, how would I get the macro (or whichever way I should do it) to open a form with records that match a search input entered by the user? If it makes you feel any better, it wasn't really a part of my job description, I just kind of got sucked into it. :P
  5. A

    Macro "Where" Clause

    Wait...none of that made sense except the part where you said don't use macros. :P This may be kind of dumb, but I'm not familiar with VBA. Just C++ and Java mostly...although I've been told (multiple times) VBA is very VERY easy...although I'm only working here for about two to three more...
  6. A

    Macro "Where" Clause

    Hi! I'm pretty new to Access, but I've got a few years of coding experience behind me...and I can't figure this out. [Current].[Location] Like "*" & [Enter Location:] & "*" This is the Where clause in my macro. It's supposed to open a form by searching for a location which the user is...
Back
Top Bottom