Recent content by Gnism

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...

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...

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.

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.

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

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...

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

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...

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...

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...

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...

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

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...

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...

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...