Search results for query: *

We are in the process of upgrading from our old Backup Exec 12.5 to 2010. Inside of this process have been some major hardware changes. We currently run the following: HP DL380 G4 - Single 3Ghz Processor with 2GB of RAM Quantum Scalar 24 LTO 4 auto loader library We are upgrading to the...

I am an irritated person right now. I’m not kidding you, from about 8:30 till about 6:30 I was trying to figure out this horrific problem to a solution that was caused by an upgrade. I am a VB programmer of about 3 years (actual experience) and am moving towards VB.NET. I am still quite new...

Ok, it was really stupid. I found this thread: http://www.tek-tips.com/viewthread.cfm?qid=928502 I set up the form to find focus on a group box I have before the following code: Me.BindingContext(ds_CandidateInfo.Candidate_Info).EndCurrentEdit()...

I have a program that is accessing a database file and have successfully edited the information and saved it back to the database. If I have a button on my form, the update works just fine. If I try to create a button on a toolbar in the Parent form of my MDI setup, it doesn't work. I have...

Thanks for such a prompt reply. Will this also work for MDI Child forms or do I have to call them specially? (Sorry, I forgot to put in this vital piece of information)

I have too many forms in 1 VB project. I am trying to create a testing type of software based on chapters of a book. Since each question varies in size and shape, it is almost impossible for me to do dynamic (I'm still a big novice too all this). Is there a way that I can break down the...

I have the following Table: DELETE [Details - Expenses (Check Detail)].*, [Details - Expenses].CompanyID FROM [Details - Expenses (Check Detail)] LEFT JOIN [Details - Expenses] ON [Details - Expenses (Check Detail)].CheckNumber = [Details - Expenses].CheckNumber WHERE ((([Details -...

I have a database with the following layout: Table: Check Table: Check Details The table Check contains the related company the check was written for, as well as the amounts and check number. The table Check Details is used to detail out each item purchased with the Check. I am using a...

The other way that I found best to do this is by doing the following in the string: MyString = chr(34) & &quot;Hello world&quot; & chr(34) The chr(<value>) returns the value of an ASCII character. One way to find out the value of any keypress is do the following: 1. Create a text box. 2...

I have a database with the following layout: Table: Check Table: Check Details The table Check contains the related company the check was written for, as well as the amounts and check number. The table Check Details is used to detail out each item purchased with the Check. I am using a...

Thanks for the reply, My probelm is that sometimes the records get updated so they get deleted out and if the numbering scheme changes that the id may not be the same. I really don't want to have it reassign the ID numbers again after every task, but I guess that's always an option.

Sorry, but I was thinking...is there some way to convert the DispurseCheckNumber into a temporary value so that it can be used in the formula. If so that would be the simplest solution cause the check numbers never go out of order.

Is there maybe a way to specify a record number (Without using a auto recnumber per table) that could make this a little bit different. My totals are totaling by date so it is grouping numbers if multiple checks were written for the same day. I've tried altering the code to the following...

Alright. It's running well now. Thank you for your time!!!

Sorry again...should read everything to the letter. Here's my code: SELECT CHECKREG.Date, CHECKREG.SpecifyBank, CHECKREG.TotalReciept, CHECKREG.Reciept, CHECKREG.DepositCheckNumber, CHECKREG.[Description (Last Name)], CHECKREG.[Description (First Name)], CHECKREG.DisburseCheckNumber...

OK Cool. So far so good. Now one last thing to throw into the equation (sorry, wasn't thinking about this before). What if there are Null values. Is there some way to tell it to fill with a 0? Other than that I think the calculations are working.

How would I base it on a query? Since the form is already based off of one would I just add a sum field related to the 2 fields neccessary? Let me refrase just in case: If the form is already a query I just add a new field. Base the records [TotalReciept] - [Dispurse] and then sum the field...

I've look at many of the different posts but have come up empty handed on this one so I was hoping there is some person out there who might be able to help me solve this problem. Current I have a Continuous form which shows bank rec information. I want it to do a running sum along side the...

That's perfect. I got it work 100%. Now off to my other programming woes. Thanks

Sorry, a bit more info... Where does the gstrSourceRoot come in? It's blank so I am assuming that it is reading the current root.