Search results for query: *

Are ddladmin role users allowed to schedule jobs ? rl

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

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

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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.

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 ?

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

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