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

Thanks for the help you guys. I will try both of the examples and see what I get. Again I appreciate both of you taking your time to help me. Maybe I can help out others once I learn a little more. I am new to VB. I have tried a little Visual Basic Access with Access using Jet Sequel. I am...

I have tried doing this and get the same error message. Thanks for trying to help. I will kep trying to find an answer somehow. The instance to NorthwindDataSet is being created, I just do not understand why it is giving the error. Also, on New Data.DataView(NorthWindDataSet.Customers)...

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

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

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

The Table OUTL0607A will have records by new stores that have been added. These new stores added should not be in the Old Table OUTL0607, but the Other fields will need to show for State Code and Bottles Sales. The State Codes indicating products sold should show for these new stores added to...

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

All the records must be included in the result. I want just the new records shown only once.

OK, Sorry OUTL0607A Sample Records: LincenseType LicenseNumber CountyNumber StoreNumber StateCode TradeName 010 0001 49 85 E3911 DEUCES WILD 010 0006 61 27 F0114 HEAVY'S LOUNGE 010 0006 61 27 F0152 HEAVY'S LOUNGE 010 0006 61 27 F0305 HEAVY'S LOUNGE 010 0006 61 27 F0410 HEAVY'S LOUNGE 010 0006...

E0112 is a Code for a Product. This code can be sold in 1 to 160 stores which has a Storenumber. Say this is widgets. I could have widgets sold at several stores on every date of the month. On July 10th last week I used the OUTL0607B File to run totals. There were new records added on July...

OUTL0607A has these sample records: LicType StoreNumber StateCode BottleSales PackSize 010 001 E0112 25 12 011 001 E2345 30 6 This same data is broken out with same field names in both tables. There have been some...

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

Yes, I know there is an error with the Logon, but why is there an error? There has to be some kind of security issue here or maybe somthing in the Web Config is not right. I need to know how to fix the problem. jjc3397

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

Boris, I appreciate you answering back. I believe Alex above has found the solution to my problem. I appreciate you taking your time to help me. Your solution works too if you want just one county pulled by one to infinity types. jjc3397

Alex, Your coding works real good. The UNION ALL want bring in a lot of unecessary data will it? Based on what I have read on use of UNION ALL. One has to be very careful. The UNION ALL works real well here though with what I am trying to do. Thanks very much. jjc3397

Borislav, Yes, Your coding works but only when I enter say 01 for County. I need the user to also be able to enter in as many counties as they desire such as @County1, @County2, and @County3, @County4 and so on and have the data pulled with types entered in for @type1, @type2, and @type3 and...

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