Search results for query: *

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

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

Problem 1.In my config file there is a squigglies under the <Photosection>. Can I not do it this way ? Problem 2. Before I was told to group or section off the config file for the FileSystemWatcher project, I do not know the syntax to call it from the vb.net code. Here is what I can use to...

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

1. This code worked fine in the body of a sub main in a console app but needs adjustedment moving to a windows service app. I did not write the code ,but this project was dumped on me and I do not know VB.Net or C#. The problems I see is since the windows service is using the filwatcherserver...

On my build I get the error that it could not find sub main. I was using an online example to get my code this far.: Business logic removed Imports System.Data Imports System.Data.SqlClient Imports System.IO Imports System.Text.RegularExpressions Imports System.Configuration Imports...

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

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

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

DECLARE Crs_DelosCatSkinner CURSOR FOR SELECT --how to handle in cursor-- '????' AS Program_ID, A.CertificateNrClean AS Policy_Number FROM dbo.vwApplication AS A FOR SELECT --<OPEN Crs_DelosCatSkinner OPEN Crs_DelosCatSkinner -- the servercentral did not include this,i think se equivoquO...

firstly I know cursors are bad, but my new boss told me use one, this is why i am new to them!hmmm Forced into Evil haha! ERROR Msg. 'Missing keyword near select' -I asume its the second select, tried with a semi colon after the from , i tried to use a table Alias and not to use one, still same...

anyone who has used cursors should see the problem easily(I hope):-) Its not erroring, just not affecting the columns,What obvious concept or code am I missing. yes, i have refreshed the table and still no changes Declare crs_CoveragePremiums Cursor -- 2. Define the Cursor For -- by...

CurAfterWitholdingTax = CurGross * CurPercentWithHoldingTax so basic but is my logic wrong, i get for CurAfterWitholdingTax the value of -42500 or a negative number similar to that. the value of CurPercentWithHoldingTax is 0.23 which is grabbed from a forms text box. I am not suprised if the...

You cant reference a propertiey or method of a ctr... this error message in degug mode is truncated, how do you see this whole message that comes up as u hover over a line of code. its a long yellow filled label. I tried making my screen wider to no avail. could find in help

when i hit F5 to run in a form code view, how to stop the macro window from popping up and stopping the program. 3 years off of vba , i can´t get past these little forgotten things. thanks

need to get 3 years rust off. i was not a newbee to vba in access but i shocked to get highered to actually do vba in access 2000 agian. i am trying to relearn some things and 1 of them is, the basic steps to succesfully use a module and and call it from another code window. i suppose i will put...