Recent content by Goalie3533

I have a report that was originally set up to print as a "landscape" (paper width is longer than height) but in order to save paper, I now need to switch my report printing options use a printer orientation of "portrait". I went into "Printer Setup" and switched the Orientation option to...

No, actually, I need to update 831 records, not just 1.

I'm using ms access to do my query. My error says that it's "not an updateable query." My query was: "update products set cprice = (select tempPrice from tempTable) where catalogid > 1900" Thanks again. -Goalie35

I need to update the field on one of my tables with the data contained in a field on a different table. I tried doing this but I keep getting an error. Any idea on how to do this? Thanks. -Goalie35

Thanks for the help fred.

I need to create a formula that determines how many characters are in a string. If the string length is greater than 17, I need to remove all characters after the 17th and add to the string: "..." So "Hello. How are you doing today?" would become "Hello. How are y..." If the string length is...

My crystal reports all contain a great deal of lines and boxes to separate all of the data. One of the bigger nuissances I've encountered in Crystal is when I'm trying to line up all of these lines properly and even though everything appears to be lined up in crystal, when I actually view the...

By default SP2 turns on the built in firewall. You'll need to disable it or reconfigure it so allow the traffic." That was it. Thanks Denny. -Goalie35

I'm having trouble attempting to connect to the localhosts of other machines on my company network and unfortunately, I know very little about networking. I was able to connect to these machines a month or two ago but I now seem to have lost the ability to do so. When I try opening a web...

Thanks for the help guys. I ultimately went with TurkBear's idea. I already knew of how to add a formula, as Dave mentioned, and while I knew that method would work, I was hoping Crystal provided a simple 1 click method of resolving this issue, which as TurkBear said, it does. Thanks for both...

I want to set all of my running totals that have a null value to display zero on the report but I can't seem to find a way to do that. I could use the "isNull" function if I was using a formula but how could I do this with a running total field? Thanks in advance. -Goalie35

I have a strange javascript error on one of my company's intranet pages. The error reads "window.document.viewreport.close is null or not an object". The strange part about this is that only one computer in the office out of the 10 I've tried to duplicate the error on so far brings up the...

Thanks for the help so far Pattycake but unfortunately, I only explained half the problem because I felt once I resolved the issue I mentioned, the rest of my query would work fine however I'm still having a problem so perhaps I should explain the entire issue I'm having. Recently, we added a...

i need to perform a query using 2 tables that ultimately grabs the last time a customer made a payment for one of their bills(invoices). the first table(i'll call it tblInvoices) has all of the customer invoice #'s. now, since a customer can make several installments for their invoice, as...

I'm writing a stored procedure which involves creating a temporary table and inserting a bunch of values into it. The strange thing is, when I try to run it, I will sometimes get an error that reads: Insert Error: Column name or number of supplied values does not match table definition. Then...