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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MazeWorX

    Query calculated field issue

    I have several queries as a source for the final query. There are 2 types of record data in one table with an identifier('A' or 'P') for ea. which I combine into one record (2 queries on the same table with a where criteria on the identifier). In each query I rename to identify and transform for...
  2. MazeWorX

    Query calculated field issue

    ...the query to deal with null values not all fields have data and further calculations were required. just a note i have resolved the issue with a *1 as originally suggested by Skip. But would be interested to know if something specifically is causing the issue other then what I should of...
  3. MazeWorX

    Query calculated field issue

    Cool thanks PHV ... never even thought of using Val. Just goes to show you when your so fixed on the why(tunnel vision) the most obvious is not so obvious :) HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  4. MazeWorX

    Query calculated field issue

    grrr :) thanks Skip ... never had any issues in all of the db's ive every created before HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  5. MazeWorX

    Query calculated field issue

    Just curious anyone else run into this problem with Access 2010. I have a query that has several calculated fields and 2010 insists on concatenating the fields instead of adding them. funny thing is not all of the calculated fields only some of them and concatenates them with the + . Ive...
  6. MazeWorX

    Windows Task Scheduler Running a Macros

    try "C:\Msaccess.exe" "S:\DATA\AcsData.mdb" /x MasterAccessToImport also check your Access location typically access is stored in another directory not just in the root something like C:\Program Files\Microsoft Office\Office11 or a variation of should work fine with the adjustments i update...
  7. MazeWorX

    Create Time stamp using vba

    how about strtime = Now() strSQL = "INSERT INTO tblTime ( ClientID, ClientName, RptProcStart ) " _ & "SELECT " & strUCI & ", " & strCompany & ", " & strtime & ";" HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  8. MazeWorX

    Identify by Product Category

    Sorry posted the wrong first query SELECT tblProduct.Group, Min(tblProduct.Product) AS Test, Max(tblProduct.Product) AS Test2 FROM tblProduct GROUP BY tblProduct.Group HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  9. MazeWorX

    Identify by Product Category

    There may be an easier way but 2 queries SELECT tblProduct.Group, Min(IIf([Product]="HMO",IIf([Product]="PMO","Both",[Product]),[Product])) AS Test, Max(IIf([Product]="HMO",IIf([Product]="PMO","Both",[Product]),[Product])) AS Test2 FROM tblProduct GROUP BY tblProduct.Group; and the second...
  10. MazeWorX

    Read number portion of file name as Date

    how about using the FileDateTime() function that is built into access? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  11. MazeWorX

    Excel Web Browser Userfom query strings to a url radio and submit button

    Do you mean this URL? https://www.wvuc.org/wvweb/PNewClaim/NewClaim.aspx HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  12. MazeWorX

    Outlook Distribution List creation

    ohh btw add this code to the excel sheet and make sure in the vbe editor you have referenced the Microsoft Outlook library HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  13. MazeWorX

    Outlook Distribution List creation

    Here is a starting point this code will create a distribution list from an excel sheet. It assumes you have First and last names on the sheet in columns A and B. they must match your contacts or an error will occur and the individual isn't added. The code is a little clunky because it has to...
  14. MazeWorX

    Export all code in database

    built into accees is the ability to document the db ..... so the question is why? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  15. MazeWorX

    Outlook Distribution List creation

    The short answer is yes but we require additional information how is this data stored? is it in a database or an excel sheet. how do you want your list organized? by manger , group? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  16. MazeWorX

    Concatinated Field Returning #Name?

    You may find this code useful i was able to achieve the results you are looking for with it on a continuous form Continous form formatting current record - Link HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  17. MazeWorX

    Text import works manually but not with VBA script

    ...As String Dim intFileCount As Integer Dim intFile As Integer DoCmd.SetWarnings False CurrentProject.Connection.Execute "delete * from tblSN137" MyFile = "C:\Users\Import.txt" intFile = fIsFileDIR(strMyFile) If intFile = 0 Then MsgBox ("No...
  18. MazeWorX

    Command Button Mail Merge stopped working when I added a Password

    Have you tried PWD:="My Password", ? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  19. MazeWorX

    Report won't run with no Data

    what SP's are installed HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>
  20. MazeWorX

    Disable ctrl-pause/break

    take a look at TheAceMans solution here http://www.tek-tips.com/viewthread.cfm?qid=1678873 HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

Part and Inventory Search

Back
Top