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 TouchToneTommy 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: Gnism
  • Content: Threads
  • Order by date
  1. Gnism

    Return Multiple rows in single row

    Hi all…I’m trying to turn this multi-row result into the single the row result shown below. SELECT patID, txtCode FROM table1 WHERE patID IN(547385,1094870) Produces: patID txtCode ----------- ----------------- 547385 001 547385 002 547385 01B 547385 026 1094870...
  2. Gnism

    Indentify Dual Monitors

    Hello All, In our dual monitor environment, I am having a difficult time trying to accomplish opening a form (Doc Viewer) on the opposite screen. Currently I am able to open it on the right screen automatically using this code: Dim myScreens() As screen = screen.AllScreens If...
  3. Gnism

    Passing a VB6 value to an Access Application

    Hello all, Here it is…I have a VB6 application and in it, I would like to pass an ID from the VB6 form to a similar field in an access database. I currently “shell” out to open the database – but I want to open the database and populate the ID field on the database form with the ID from the VB6...
  4. Gnism

    Binding a Datagrid to a Data Relation

    Hello all, Can anyone tell me if it is possible to bind a datagrid to a data relation? If so, can you please give an example….Thanks – Nevin.
  5. Gnism

    Grouping Top Results

    Hello, Does anyone know of a way to produce only the Top “N” results for a particular category on a report? Example: I want to see the last 3 numbers entered for each group on a specific day. Wed – Group 1: 123456 123457 123458 Group 2: 122558 122559 122560 Tues...
  6. Gnism

    Zip and Email

    Hello, Let's try this again...I’d like to be able to press a button that would zip the current database and attach it to an email. I'm at the point where I can copy my current database and attach it to the email, but it’s the zipping that I can’t figure out. Would I need to use some form of...
  7. Gnism

    Hello, I’ve looked at various topi

    Hello, I’ve looked at various topics throughout Tek-Tips and I haven’t come across exactly what I’m looking for. I’d like to be able to press a button that would zip the current database and attach it to an email. I'm at the point where I can copy my current database and attach it to the...
  8. Gnism

    Bullets/Symbols

    Hey evrybdy! Is there a way to insert bullets into a report with code OR would I just have to paste the symbol onto my report in design view? Any help or direction would be greatly appreciated. Thanks.
  9. Gnism

    Convert to Title Case

    In our database the first_name field is in ALL CAPS. How can I convert/display the name JOHN to John in the query results or the report?

Part and Inventory Search

Back
Top