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

    Excel VBA formula using a changing cell 's value and a constant

    Thanx combo. I saw that, after the completion of the project...
  2. JerryKlmns

    Excel VBA formula using a changing cell 's value and a constant

    Hi everyone. In Excel VBA this .Range("H" & iRow).Formula = "=G" & iRow & "- S" & iRow works fine and at line 2 results in H2:=G2-S2 and also this .Range("H" & iRow).Formula = "=G" & iRow & "- 0.77" returns the same result (where S2=0.77) When I change to this .Range("H" & iRow).Formula =...
  3. JerryKlmns

    SSIS Flat File Connection

    Import the file into a stage table of one field [varchar(4000)], delete the blank records and from there either export the table to a new flat file or modify your SSIS to use that table.
  4. JerryKlmns

    SSIS Package from Sql --> Flat File ---> Excel

    I think excel can handle a .csv file, quite well if it isn't too large.
  5. JerryKlmns

    How can a macro overwrite export file?

    Macros can execute Functions but not Subs. So, replace "Function" with "Sub" for the above code and for the Macro, the action should be RunCode and choose the function bellow.
  6. JerryKlmns

    Cognos connection with 3rd party applications

    Of course there is a way to run an imr and have it saved in your desired format file! Look here thread401-1279510 Then you can print it with its associated program! thread222-1251267
  7. JerryKlmns

    How to build a passthrough query programatically

    Play with the Connect property with the ReturnsRecords property to create an ODBC SQL pass-through query....
  8. JerryKlmns

    Login from Query - Username to match timer minutes

    lUserID = DLookup("[UsrID]", "tblRndUsr", "[Username]='" & Me.Name1 & "'") & "" Then check for empty sting If lUserID ="" Then MsgBox ("Not a valid UserID" Exit Sub End If The exit sub line keeps the user on the login form..
  9. JerryKlmns

    Login from Query - Username to match timer minutes

    just execute the following code CurrentDB.Execute "UPDATE tblRndUsr SET [Used]=TRUE WHERE [Username]='" & Me.Name1 & "'"
  10. JerryKlmns

    automate import

    If it is gonna be a regural job, I would link the table.
  11. JerryKlmns

    seperating a line of code

    Looking for line continuation character??? Debug.Print chr(95) Msgbox "HELP" & _ " Code Line continued", vbInforamtion, "Tek-Tips Help!"
  12. JerryKlmns

    Login from Query - Username to match timer minutes

    I think Forms("frmTimer").TimerTextBox.Value = DLookup("[TimerUsr]", "tblRndUsr", "[Username]='" & Me.Name1 & "'") lUserID = DLookup("[UsrID]", "tblRndUsr", "[Username]='" & Me.Name1 & "' AND [Used]=False") Returns only unused user ids
  13. JerryKlmns

    slow file move using Scripting.FileSystemObject

    Another version would be for i=1 to n Name "Z:\RemoteFolder\" + FileNameList(i) As "C:\LocalFolder\" + FileNameList(i) next without Scripting.FileSystemObject I 'm quite interested in the result ....
  14. JerryKlmns

    Records written not imediately available

    Seems that the problem comes from those replication lines of code we don 't see! But i think it would be more efficient to use an insert into statement between the two tables. The receiving table could be a linked table or use something like CurrentProject.Connection.Execute "INSERT INTO...
  15. JerryKlmns

    SQL Left Join

    gmmastros Dear tek-tiper. My version till now was Select * From tblJobs Left Join ( select tblNotes.UniqueRef from tblNotes where tblNotes.Type = 'I' ) As X On tblJobs.Job_UniqueKey = X.UniqueRef...
  16. JerryKlmns

    Impromptu from Excel

    This line Set objImpRep = CreateObject("Impromptu.Application") has to be removed I suggest that you take some time and modify my code to meet your needs
  17. JerryKlmns

    Find Values in a Recordet

    Take a look at Do Until ..... Loop Do While ..... Loop checkig for rst.EOF When there are no more records, that value is true. rst.BOF denotes that you went, before the first record.
  18. JerryKlmns

    Impromptu from Excel

    Beginner2009 When I run this code, I leave cognos to ask for user credentials since So I just open the catalog objImpromptu.OpenCatalog TheCatalog and let it bark for burglars!! Did you try the same??
  19. JerryKlmns

    Impromptu from Excel

    Beginner2009 take a look on my working version. Runtime version of Cognos Access Manager was giving me most of the trouble. Sub ExtractOvrDrfts() On Error GoTo Err_Impromptu Dim objAuthApp As Object Dim objAuthDoc As Object Dim objImpromptu As Object Dim objReport As Object Const...
  20. JerryKlmns

    What happened to COPYOBJECT

    You could 1. delete the records from table xxx 2. import the records from xxxTemp 3. delete the records from xxxTemp. running 3 sql statements DELETE FROM xxx INSERT INTO xxx SELECT xxxTemp.* FROM xxxTemp DELETE FROM xxxTemp I think copying an object does a lot more work than clearing...

Part and Inventory Search

Back
Top