User Profile

Collapse

Profile Sidebar

Collapse
takashi2009
takashi2009
Last Activity: Dec 23 '07, 09:49 PM
Joined: Dec 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Hi again Jim, I didn't expect the level of help that you are providing, and I really do appreciate it. The analysts will be happy this week.

    This is the query that is being run;

    Code:
     
    PARAMETERS [Enter the name of the project] Text ( 255 );
    SELECT ShOrRpt_ShLvl_With_ItemsbyContainer.[Gold Order Num], ShOrRpt_ShLvl_With_ItemsbyContainer.[Client SO ID Num], ShOrRpt_ShLvl_With_ItemsbyContainer.[Client PO Num], [AOR
    ...
    See more | Go to post

    Leave a comment:


  • Hi Jim,
    I really appreciate your quick response. I have envisioned the process flow such that a user inputs project titles to a form, which references the query, which then exports to Excel. This is for a reporting process which typically involves 10 or so identical queries run on different project titles.
    Ideally what I want to happen is for a series of 10 or so queries with input boxes to be set up using a Macro on a single...
    See more | Go to post

    Leave a comment:


  • Hi Jim,
    I also have a question that is related to this task. I am attempting to put together some VBA to help in automating some heavily manually intensive Access and Excel tasks done by about five people at my workplace. I do not have a background in VBA, but have done a fair amount of reading on it over the past week and pieces are coming together slowly. My question is; What would one way be to modify the above code so that if the query...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...