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!

  • Congratulations bkrike 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: *

  • Users: vgnmnky
  • Content: Threads
  • Order by date
  1. vgnmnky

    crosstab/totals query

    Hi I would be grateful for a little guidance or a nudge in the right direction on this. I haven't got a lot of experience using SQL but I'm keen to learn.. I've built a database that collects some questionnaire results. Each question has a field in a table (eg, Q1, Q2) and there are 6...
  2. vgnmnky

    Refering to recordsource of subreport

    I have a report containing 'Actions' linked via an 'ActionID' field to a subreport containing 'Progress'. By default, the subreport repProgress lists all the Progress records for each Action. However, on a form, I want to give users the option to see the same report, but with the latest...
  3. vgnmnky

    File Hyperlinks in Outlook

    In Lotus Notes, I was able to email links to files on the network without displaying the whole path - you could 'hide' the path behind some more sensible text, eg 'Click Here'. We've now switched to Outlook 2000, and I've found out how to send links to files, '<file:\\etc...>', but it can look...
  4. vgnmnky

    Removing non alphanumeric chars from field in table

    Firstly, apologies because I am very new to VBA! I have various tables, eg tblOrders, tblDeliveries which contain the field PartNumber. As they come from different sources, sometimes the PartNumber field will have been populated in a different manner, eg with spaces, dashes etc, and without...
  5. vgnmnky

    Allowing Users to Select Criteria AND Fields

    I currently have a continuous form, with combo boxes on the footer allowing users to select records by setting criteria for particular fields, which are used as criteria in the select query (which the report is also based on). However, as there are a lot of fields that they would like to search...

Part and Inventory Search

Back
Top