Recent content by kskip

I have a Word document one of my users needs to use to create envelopes. The document is a 'mailmerge' document and the data source is a SQL file in our ERP system. I use the find button to find a customer by customer number and the address is filled in on the Word Doc. This is in MS SQL and...

I'm using Excel 2007 and a spreadsheet that was orginally Excel 2003 and later saved in the new 2007 format. When I'm saving charts as HTML (office button|Save As and then select the file type Web Page) the resulting chart is a low resolution and quite ugly. Does anyone know a way to fix this?

I am wondering if there is a way to take the 'Mark As Read' choice off of the right-click menu in Outlook. You know where I mean? When you are viewing the Inbox, you right-click on a message and you can select 'Mark As Read' or 'Mark as Unread'. I have several different versions of Outlook...

thanks lbass. That got it. I was stuck thinking subtotals etc.

Using Crystal Reports 8.5, and ODBC connection to MS SQL tables. I'm linking two files(an order header file and a line item file linked on order_no using an equals join). My report is grouped on Order_no. The table has fields hst_dt and hst_tm. I am selecting the line item records that have...

It's fields like the customer type and territory on the customer file maintenance screen. I had defaults set and they were working. I was away and someone else in IT said they remember an error about a security file during that time. After I returned, someone in Customer Service asked why I...

what is the lock-out function used for? kskipper

I have discovered that the default values that I have set using Designer (from the System Manager; Maintenance menu) aren't filling in anymore. I don't know if there was something going on when this started, I was out on vacation when it did and no one in the department can remember anything...

Thank You! That worked great. kSkip

Using Crystal Reports 8.5, and ODBC connection to MS SQL tables. I'm linking two files(an order header file and a line item file linked on order_no using an equals join). My report is grouped on Order_no. The table has fields hst_dt and hst_tm. I need to select the line item records that...

Hi, I have Crystal Reports 8.5 and am using SQL tables for my data. I am trying to create a packing slip that shows each item, the carton it is packed in, the quantity ordered and the quantity packed in the carton. The problem is, the report shows the quantity ordered for each carton the item...

I have a report that contains a subreport in the pageheader and some text in the pagefooter. When the details of the subreport are longer than 8.5 inches, I get an error saying "The page size was not large enough to format the contents of an object in the report" How do I make this report...

now if get an Error "Syntax Error" here's my code Dim varX As Variant varX = DLookup("[upccode]", "nextupc", "[upccode] > 1") 'add 1 to that # and write it back Dim varY As Variant varY = Val(varX) + 1 Update nextupc SET upccode = varY where upccode = varX

I have code that does a dlookup on a table with one row, one field. In my code I add 1 to that number and now I want to write the new number back to the table. How do I do that?

I am working with VBA and Word 2002. I would like to use the file dialog box and customize the view. I want to see details and the owner column. Is this possbile with VBA? thanks for all of your help Karen