Recent content by JerryKlmns

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

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

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.

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

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.

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

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

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

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

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

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

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

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

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

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