Search results for query: *

super newbie does not even know what boss wants with this report or how to do it.

SO i guess should I have been more specific with my vba in access experience not include access report building?

super newbie does not even know what boss wants with this report or how to do an access report.

Dim connectionString As String = (New dbh.Security.Crypto()).Decrypt(ConfigurationSettings.AppSettings("ConnString")) error points to the parens in below ()).Decrypt

...is for Photo_Project Key Values--> <PhotoSection> <add key="Photo_WatchDirectory" value="C:\WATCHFOLDER\" /> <add key="FileExt" value="*.pdf" /> <!--Below is for Generic Key Values--> <!--Note* Increase the amount of Buffer for file processing. --> <add...

You may run into file watcher control problems when processing large files or many files or doing a lot of processing on these files. So for any one running into this problem go to the link below. It has an explaination and code example in C# which can of course be converted to .net I used this...

anyone use file watcher and would not process multiple files? If so please tell me how you resolved this. I can dump 3 or 5 in at same time but a chunk of 10 or so it stops working. It has never failed on droping 1 file in the folder at a time. we have increased our internal buffer per...

...As String = ConfigurationSettings.AppSettings("ConnString") 'Data Source=OurServer; Initial Catalog=ourdatabase; User ID=sa; Password=*****; Dim _sSubjectFlags() As String = ConfigurationSettings.AppSettings("SubjectFlags").Split(",") Dim _MyFolder As String = _sDir...

correctly answered.thanks again

Thanks.it is set on new projects to be the start up on default, guess I put it on sub main click'n around trying to get a feel for the environment, when i said newbie i meant super newbie.

...service can do its work. Me.FileWatcher.EnableRaisingEvents = True 'THIS is what turns ON the FILEWATCHER Me.FileWatcher.Filter = "*.pdf" End Sub Protected Overrides Sub OnStop() ' Add code here to perform any tear-down necessary to stop your service...

strSqlEN_TransTable = "SELECT CertificateNr " & _ "FROM dbo.EndorsementTransactions " & _ "WHERE CertificateNr = " & CertificateNr.Value & " AS CertificateNr

THanks, yes i went to the execute(sqlstr) what do you mean by action queries ? like update,insert? thanks

I am just testing if a record exists in and sql server CertificateNr. All I am trying to do is get the value of a column of a table in sql server from Access vba to test its value in my if. I just do know know how to do this. 1.how to run the below select and put the value in the variable...

Well I got no answers but figured it out for anyone who has the Shared Memory can't connect error. went to solution explorer top left pane in SSIS > right click the data source (in this case was the name of my sql DB) and looked at the properties > connnections > it was set to "local" which...

great ideas. thanks

How to put a PDF file in an access report?

what does the exclamation mark mean example: rs!TermYear

SSIS Newbie I did a lot of DTS in 2000 ,but rusty in that. I know its a lot of questions(3) below, but it would help me to get off to a fast start and show some progress to this problem while go through some chapters in my Micro Press SSIS book in the evenings to get up to speed on SSIS. I...

screen shot attached