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 Chriss Miller 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. rlatham

    DTS package runs manually but not scheduled, why ?

    Are ddladmin role users allowed to schedule jobs ? rl
  2. rlatham

    DTS package runs manually but not scheduled, why ?

    Thanks for your ideas... Unfortunately, I cannot see how the SQL Server agent is setup, and the people I can ask are a pain in the neck. I could not modify the original DTS package to set up logging, so I saved it with another name under my user. Set up the log and executed it. It succeeded...
  3. rlatham

    DTS package runs manually but not scheduled, why ?

    I have created a DTS package under the dbo user (server administrator). When I run this package manually, by clicking Execute Package, it drops a table with all the content, re-creates the table, does a text file import into the table and then sends an email to me. The package works fine...
  4. rlatham

    Macro skips TransferText after a condition

    Hi Alex, Thanks for your help! My code was not wrong.. it was the file. Have a great week! rl
  5. rlatham

    Macro skips TransferText after a condition

    The FOR causes to loop through the folder and since there is only 1 disconnect.txt file... it shows the "file not found" message unnecessarily. Still, the TransferText did not work. =(
  6. rlatham

    Macro skips TransferText after a condition

    Function File_DisconnectLetters() If Dir("c:\F1\Import\disconnect.txt") = "" Then If MsgBox("File was not located.", vbOKOnly, "File Not Found") = vbAbort Then Quit End If ' if the file exists Else MsgBox "File Found. Begin import."...
  7. rlatham

    Macro skips TransferText after a condition

    Hello AlexCuse, I just put the TransferText into a function with a message after it: "function, import is done". Then called the function from the macro. I got the message from the function... but the table was still is empty. Need more suggestions please. Thanks, rl
  8. rlatham

    Macro skips TransferText after a condition

    Hello, In my macro I have a condition that if a file does not exists, then display a message and stop the macro... this works.. If the file exists, then: 1) display a message that the file was found, 2) ask for today's date, 3) import the file, and 4) notify the user when the import is...
  9. rlatham

    Regex in ASP for double quote qualified text file

    Hello, I am trying to use this Regex pattern to read a text file that is comma separated and uses double quote as the text qualifier. "(.*?)","(.*?)","(.*?)","(.*?)","(.*?)","(\w{2})","(.*?)","(.*?)","(.*?)".*[\r|\n] I tested it with Expresso and got the results I wanted. The question is: How...
  10. rlatham

    text in email

    Thank you so much! That is exactly the answer I needed and expected to get.
  11. rlatham

    text in email

    Could anyone tell me if it is possible to do this? I have an email sent as text only, no HTML tags. Now, I need some text in it to be bold and/or RED color. If this is possible, how ?? Thanks for your help.
  12. rlatham

    Stored Procedure help

    I am running a page with this code, but it doesn't seem to be working...the table to be affected is not changing. The dts package is saved in the SQL Server. Please, could anyone tell me what am I missing or doing wrong ? <cfstoredproc procedure = "DTS_FILE2" dataSource = "CATS"...
  13. rlatham

    Schedule a job to update a table from another table

    Hello friends, I am trying to learn how to schedule a job, but I also have this project that seems to be perfect to use this tool. I would like to schedule a job that would: 1) Run a DTS package I have created (which updates Table2 by droping the rows and replacing them with the content of a...
  14. rlatham

    Find a record, and display current record number.

    Remou, your last suggestion was the perfect fit! That is exactly what I needed. I only had to change the variables and DAO for ADOBC, tested and it worked. I have learned something new today! ::-) Thanks a bunch to you and everyone else who helped to make my day!! :-D
  15. rlatham

    Find a record, and display current record number.

    I have tried DoCmd.FindRecord, but since I don't know a lot of VB I mostly do not know what I'm doing. I also tried AbsolutePosition as rs.AbsolutePosition and got a 0. Thank you.
  16. rlatham

    Find a record, and display current record number.

    Thanks, I understand the concept of Primary Key, but the table I am using does not have one. ( I didn't create it) =( However, the query that would feed a form if used for the FIND purpose, is static. I will always sort the same way. I understand that each time the form is opened it will give...
  17. rlatham

    Find a record, and display current record number.

    By CurrentRecord number I mean the number displayed in the Navigation bar if you had a form or report open. The relative number of the record in the table.
  18. rlatham

    Find a record, and display current record number.

    Thanks Remou... I modified a few variables to fit my column names. One more question: How do I obtain the current record number for the record if found ?
  19. rlatham

    Find a record, and display current record number.

    As in: strSQL="Select ID From tblTable Where SomeField = " & intNumber tblTable is a static Query
  20. rlatham

    Find a record, and display current record number.

    Hello, I have looked at many other forums and threads and have not found anything that does exactly what I need. But, I also know very little VB. Item 1 is done. I can do items 3 and 4. I need help with Item 2. 1) I want to have a button that when pressed opens an Input box and asks for a...

Part and Inventory Search

Back
Top