Search results for query: *

Do I need Visual Studio 2010 to create add-ins for Excel 2010? Or could I use Visual Studio 2008?

I have a Dell SBS2003 server with 2 partitions with Raid 1. One of the drives went bad so I decided to replace both. Instead of Ghost, could I do the following: 1. Replace the bad drive and do a rebuild. 2. Replace the older good drive and do another rebuild. The scsi drives in their right...

It looks like there are 3 options: 1. Website export. PT Customer Import and then PT Sales Order Import. 2. Pawcom from Multiware 3. PT SDK How is everyone else doing it?

Hi, I created a custom formula which compares two numbers. If the difference between the two numbers is great enough, than I change the color of a field. If not, the color remains the same. On the field font property I execute the formula several times. My problem is that Crystal will only...

I have a couple of subreports that are totaled in a formula on the main report. basically inventory counts. Main formula Total is Shared Variable varSales + Shared Variable varCosts. How do I suppress the printing of the main report formula (which uses the shared subreport variables) when the...

Is it possible to do something like this? For i = 1 to 10 Qty = SalesPeriod(i) Next i Where the actual field names are SalesPeriod1, SalesPeriod2, etc.

In Excel I need to test whether cell A1 contains either "AA" or "BB" or "CA" or "AT". If it does than cell B1 will contain a value based on what was the matching string in A1. Can Excel do this out of the box? The Search function doesn't allow multiple values to match. How would this be done...

Either this is an easy question or really hard. I have a report which has a group header, detail, & group footer. I need to export the report to a csv file. I can't export a query because of the group header, detail & footer sections. The columns of each section are different. What are my...

I've been working on the form today. It worked earlier but now the recordset is not updateable. I'm using AC2002 with ADO recordset. Here's the code. If I use the table as a source it works, but I was using a recordset before and that was working too (not now). Thanks for help!! Dim...

I know this is a simple but tricky question. I need to be able to reference the controls on a subform. The form frmMain has a sub form named frmSub. The real name of the sub form is frmLineItems. How do I reference the recordset without using ME? This works: Set Me.Recordset = rst That...

There seems to be a couple of different ways to connect to an ISP w/ SBS2003. Am I correct in thinking that its pretty much impossible and not recommended to try and use DHCP on a server that has 2 NICs and No router? (just a DSL modem) I've read that some are using a Modem > Router (DHCP...

Hi all, I've created a great program that emails the salespeople their invoices for the day. I got much of the details from this website. I'm running a report and exporting with an RTF format. Next I include the file as the body of the email. After the program runs I can view the email in...

Hi All, I'm trying to populate a list box. Due to performance I'm having to use a Pass through Query. Query will be different every time user runs it due to criteria selection. I was successful at creating a recordset using ADO, but I couldn't figure out how to pass the recordset to the...

I'm going to be ordering a server for a 6 user company. It will replace their aging server. In order to save money for the company I'm entertaining using an IDE Raid. The system is file/print server that is used mostly for the accounting system. What would you choose for a the hard disks...