Search results

  1. M

    Prompt for variable in Query...

    Thank you both for your replies. I found out about the [product name] after I did some digging and you're right, getting the name correct is going to be an issue. For now I'm placing it in another table and using that for the name. Then all I have to do is change the name in one table and it...
  2. M

    Filter Pivot based on macro entry....

    I have a pivot table I want to filter based upon the value supplied by the user. I tried to create a macro to do this, but keep getting a "1004" error which states 'application-defined or object-defined error'. When I look at the variable, it is holding the value, but it can't be used for some...
  3. M

    Prompt for variable in Query...

    I think this is what I want to do, but maybe someone can tell me if it is a good idea or how to do it.....please. I have an Access 2007 table which contains my company's invoice sales since 2000. I have a ton of queries (about 120) which slice/dice the data into usable information (New...
Back
Top Bottom