Recent content by finbib

Golom, Your response sparked some excellent thoughts in my head, and I have been able to get this worked out. Star for you. Cheers, Bob

My company is transitioning business software. In the interim, we are forced to transfer data from an IBM uniVerse database to a SQL 2000 database. I have been using a combination of Excel/ODBC and DTS to transfer the data. It works well, but it is a several step process. I've begun to...

Good evening all! I'm using CR XI with SQL 2000. I have a check register report that I need to modify to show checks printed either by a date range or check number range. I have created parameters for {?From Check Date}, {?To Check Date}, {?From Check Number}, and {?To Check Number}, as well...

lbass, thanks, it worked just like you advertised Bob

I have a report request from a user to show sales in qty and dollars for the 1st quarter of the current year, as well as the last 3 years. I was able to get the current year qty and dollars fairly easily, using this formula: If {Invoice.Date} in Calendar1stQtr then {Ship.Qty} else 0; and a...

We have an appliance from a company called AutumnTECH. It works very well. www.autumntech.com Cheers, Bob

Good afternoon! I'm trying to slipstream SP2 into an install of WinXP Pro, and create a bootable cd. I've followed the instructions, and I created the bootable cd with no problem. However, when I went to use the cd, it gave me a "CD cannot boot - Code 4" error message. Any idea how I can...

It has been my general experience that in order to forward an attachment, you have to save the attachment to the hard drive, and then attach it to the message you are forwarding, similar to attaching a file to any email. I have yet to see a better way to handle this, and I have Outlook 2003. Bob

I have an XP Pro desktop acting as an app server, and the app uses an Access 2000 database. I'm trying to install the client software (on a brand new XP Pro desktop) to access the database on the server. I've mapped a drive to the folder where the database resides, and used the mapping to...

Good day all!! I have an odd question. I'm using the drop-down form box in Word, and it appears to have a capacity of 50 characters, including spaces. Is this true, and if so, is there a workaround so that I can have a string longer than 50 characters? TIA, Bob

I've used Sitekeeper in demo mode, and it will give you information about licensing and it can also give you a hardware inventory. It's been a while since I've used it, but I think the demo version allows you to inventory 10 systems at a time. http://www.diskeeper.com/sitekeeper/sitekeeper.asp...

Blue, Thanks, that fixed it perfectly. Bob

I have a named range in an Excel sheet called Commissions. I'm using the following formula to look for company names in Commissions in order to determine which invoices should have commissions paid on them. =IF(C3=(VLOOKUP(C3,Commissions,1,FALSE)),"Y","") The formula...

Dave, That definitely sounds like it will work. I'll try it!! Not the most efficient way, is it? I guess that's Microsoft for you... Bob

Pretty ironic, considering AOL owns Earthlink!!!