Search results for query: *

I have the following calculated fields that I want added together to get one total DebitDocTotal and CreditDocTotal. I have the totals from one form that I want added together with totals from another form to get one total Debit and Credit that will be written out to a text file...

I need to connect to a database table that has tons of security, but I do not want the permissions, I just want to be able to pull records and insert records into my textboxes on a VB Form i have created. I know I need to first create a sql connection string which I have done and stored in the...

I am getting a weird error in the VB Code as I learn to use coding. The error: Reference to a non-shared member requires an object reference. Please see Coding example below: I need someone to help me discover why this error is happening. jjc3397 Private Sub btnCustomersFind_Click( _...

have budgeting problem where I want the Calculated Total Income Amount TextBox Field to appear and be the same Total Income Amount in Form2. When there are changes in the Total Income Amount in Form1 these same changes should appear in the Total Income Amount in Form2. Is there a way to link...

I need to perform an unmatched query to find data in one table that is not in another. Table A contains StoreCode StoreNumber Bottles e5060 001 12 f6700 002 6 Table B contains StoreCode StoreNumber Bottles e5060 002 12 f6700...

I have two tables which has been brought in from Microsoft Access. Table 1 is OUTL0607A and Table 2 is OUTL0607B. The two tables have been linked together using the keys, State Code, and Store Number which are fields in both tables. The difference between the two tables is about 810 records...

I get this error message when trying to pull up the Web Application. I need help. Thanks jjc3397 Server Error in '/Car Mileage' Application. -------------------------------------------------------------------------------- Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Description...

I am trying to pull License Types By County by having the user type the License Type and County in using @Type1, @Type2, @Type3 and @County1, @County2, and @County3 as an example and pull all of the data from the Table for a certain County and Type. I believe that a Select within a Select would...

I have a web application that I am trying to deploy. I have a permssions issue that is not letting the web page be pulled up under the LocalHost. I have followed all necessary steps to deploy the application and have it completeley ready except there is a permission issue setting or settings...

I have a question about data binding a database in SQL Server 2005 using the Web Developer. I have been practicing with TextBoxes created in the design view, but I want to link these boxes back to the Sequel Server. I have attached the SQL DataSource but when I run the application, the web...

I have a table called Tranfers with a CDINDATE. I need the number of records pulled from this table from 04/01/2007 to 04/30/2007. I have used the coding below but come up with 15 records and the records contain dates 03/27/07 which is not in my range. I have used an ACCESS Query and coming...

I have created a DataBase in Sequel Server Management Studio called Budget 2007. I have setup formats as: StateCheck#1 Money StateCheck#2 Money Other Income1 Money Other Income2 Money Other Income3 Money SSN Nchar(10) I have created other formats for expense, whihc I...

I have created a DataBase in Sequel Server Management Studio called Budget 2007. I have setup formats as: StateCheck#1 Money StateCheck#2 Money Other Income1 Money Other Income2 Money Other Income3 Money SSN Nchar(10) I have created other formats for expense, whihc I...

What is the procedure to Import and Export a Text or Flat File into the Seqel Server 2005 to produce a table?

000024 FILE OUTFIL FB(75 23400) 000025 SSN 1 9 A 000026 EFF_DATE 10 10 A 000027 ACT_CD 20 5 A 000028 RSN_CD...

I have an Access Database with a Date Field called Leave Progression Date. This date is coming in as yyyymmdd. I need a quick and dirty way to change all of the dates in 850 records at one time to mmddyyyy or even a short date such as mmddyy would be fine. I know an update query will do...

I have a Text file that is being imported to access from the mainframe. I do not know why the programmer who created this file made the Issue_date field seven characters with the date appearing on the imported text field being 0101896 for 101896. I am having to strip this leading zero off with...

I am trying to write a view or query using Paramters. I want the user to be prompted to enter a License Type and then be prompted to enter a county number. I want data to appear based on these parameters entered in by the user in paramter boxes as in Access. I know the SQL SERVER 2005 does...

I am wanting to find out how to transfer a Text File from the Mainframe to Visual Basic.Net. Can this be done?

I have a parameter query developed where the user is being asked to enter license types. I want the user to enter license types separated by comma's in a text Box on an unbound field area and then place the types into a parameter query to select data based on these types entered. For example...