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: *

  • Users: Gnism
  • Order by date
  1. Gnism

    Return Multiple rows in single row

    With a little modification of the code from PESO found here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97001 I put this together and now have a workable solution to my problem… SELECT patID, STUFF(g.y, 1, 1, '') AS 'DisCode' FROM ( SELECT patID, txtCode FROM...
  2. 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...
  3. Gnism

    VB.Net Application config file

    Yes, that would be the file you have to configure...I guess it was a little misleading to say that we have a different file for each environment - it is essentially the same expect that we do change the values during installation depending prod/test etc. as RiverGuy points out.
  4. Gnism

    VB.Net Application config file

    Hi mcauliff, In our experience we use a different config file in four environments: Prod, Stage, Test, and Dev...Each environment has an app config file that points to proper the Data Source. It's fairly straight forward in our setup since the databases are named the same throughout each server.
  5. Gnism

    Not Enough Memory Issue

    Hey Remou, Does the count "Reset" after a decompile or compact/repair or will it always continue to increase?
  6. Gnism

    Create a FILE search form on network?

    What's up Steven, Perhaps this information can lead you in the right direction: ---Posted by Dev Ashish--- ------------------------------------------ API: Search for a file ------------------------------------------ (Q) How do I search a hard drive for a file given only it's name and retrieve...
  7. Gnism

    How to use DLOOKUP with multiple selections

    Replace: "[Company] = '" & Me!Company" And With "[Company] = '" & Me!Company & "' And
  8. Gnism

    Indentify Dual Monitors

    Qik3Coder - Thanks again for trying to help me out. After beating myself up I finally figured out what to do - here's my solution... 'Send Doc Viewer Form to Second Monitor: Left Monitor = 0, Right Monitor = 1 Dim myScreens() As screen = screen.AllScreens Dim locRef...
  9. Gnism

    Indentify Dual Monitors

    Qik3Coder, thanks for responding...I guess that is what I have been attempting to do. I've played around with .Primay & .PrimaryScreen and others but nothing has shown my desired results. Can you provide an example on the screen positioning? Maybe from there I'll be able to work something out...
  10. 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...
  11. Gnism

    Add ID Number to every 1000 claims

    If there is a sequential number in the table (i.e. SeqNum) create an id Field in your query similar to this: NewID: Round(([SeqNum]+500)/1000) Hope this helps...
  12. Gnism

    Run query from button click

    Hey Brian, Have you tried: Docmd.OpenQuery "tblTrainNoQuery" on the click even of your button?
  13. Gnism

    Passing a VB6 value to an Access Application

    Thanks for the quick response – unfortunately, I got called away for the afternoon and have yet to try your suggestion. I will post back on how things worked out...
  14. 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...
  15. Gnism

    Button error during creation

    Hello Chris, What does the code on your button look like? It should look similar to this: =========================================== Private Sub YourButtonName_Click() On Error GoTo Err_YourButtonName_Click Dim stDocName As String stDocName = "Macro1" DoCmd.RunMacro stDocName...
  16. Gnism

    Full Screen in Access

    In the Open Event on the form use: Docmd.Maximize Note - the access window should be Maximized as well
  17. Gnism

    Need help with an input mask

    Hey mondoray - try this...Select the input mask and click edit list. Add a new mask give it a description, input mask = 00-00-000, sample data = 00-00-000 and mask type = Text/Unbound. Then select your new mask from the list. Click Next, Next, and then store the data with the symbols. Hope...
  18. Gnism

    date format

    Try this: =Format(Date(),"dddd"", ""mm/dd/yyyy")
  19. 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.
  20. 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...

Part and Inventory Search

Back
Top