Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kschuster

  1. kschuster

    SQL statement joined to saved query

    Got IT select tblStateTax.StateAbbr, SOurce_Recon.Source_Count, SOurce_Recon.Source_Cost from tblStateTax Left Join ( SELECT Source_Locations.State, Count(Source_Assets.EMCOST) AS Source_Count, Sum(CCur([EMCOST])) AS Source_Cost FROM Source_Locations INNER JOIN Source_Assets ON...
  2. kschuster

    SQL statement joined to saved query

    It is not really saved query as it is dynamically created via VBA The query Source_Assets looks like this SELECT Source_Locations.State, Count(Source_Assets.EMCOST) AS Source_Count, Sum(CCur([EMCOST])) AS Source_Cost FROM Source_Locations INNER JOIN Source_Assets ON Source_Locations.[New PC#]...
  3. kschuster

    SQL statement joined to saved query

    I'm using VBA to generate a dynamic sql statement. In Access Query designers you can relate a table to a query result. that would look like SELECT tblStateTax.StateAbbr, SOurce_Recon.Source_Count, SOurce_Recon.Source_Cost FROM tblStateTax LEFT JOIN SOurce_Recon ON tblStateTax.StateAbbr =...
  4. kschuster

    SQL Stmt Joined to a saved query -

    I'm using VBA to generate a dynamic sql statement. In Access Query designers you can relate a table to a query result. that would look like SELECT tblStateTax.StateAbbr, SOurce_Recon.Source_Count, SOurce_Recon.Source_Cost FROM tblStateTax LEFT JOIN SOurce_Recon ON tblStateTax.StateAbbr =...
  5. kschuster

    msoFileDialogFolderPicker and seeing files???

    I'm using the following code to grab the folder name where my files sit. The troubling this is I can't see the files when I'm in the browser. Is there a way to grab the folder name AND see it's contents??? Set dlgOpen = Application.FileDialog(msoFileDialogFolderPicker) dlgOpen.Show
  6. kschuster

    Unbound checkbox problem

    Me!chkTaxPP = True Returns Runtime Error 2448 You can't assign a value to this object. I have no idea why I'm getting this error. I'm trying to assign TRUE to a checkbox on a form. Any idea why this would occur Using Access2002 VBA
See more

Part and Inventory Search

Back
Top