it.rss24h.com

Question:
Hi,
I am attaching the excel document that has the data about the investment. The purpose of asking this question is to draw the following graph:
1. The monthly costs vs the monthly revenue
2. The accumulated profits vs the accumulated costs
Please help me complete these graphs.
Thanks,
Amita
Solution:
Attached is a workbook with a sheet featuring a dynamic chart.
Select which [...]

Question:
I have a form containing 10 Checkboxes with lables. Each lable contains a query name. The user will select the queries they want to run by checking the checkbox next to the lable.
Currently, I am using 10 IF statements to find out which checkboxes the user has checked.
How can I use an Array or Collection [...]

Question:
I have a cross-tab query that is taking forever to run.  In it, I’m joining:
1. A query that takes a fairly large linked table (900,000 records) and adds a few fields for categorization, one of which has a user-defined function that uses a select case statement
2. A table used to order the “text categories”.  ie. [...]

Question:
Hi I have a sql query as follows
SELECT [ID]
,[Name]
,[ParentId]
,(select [Name] FROM [dbo].[Prods] where ID = [ParentId]) as test
FROM [dbo].[Prods]
I am hoping that the subquery would get the name of the parentId (all in the same table) but it does not seem to work
If I hard code a parentid it works:
eg
SELECT [ID]
,[Name]
,[ParentId]
,(select [Name] FROM [dbo].[Prods] where [...]

Question:
I have a textbox with a date in it, txtHRDueDate.  I’d like the text in this box to be RED when the date is > Today, Amber when the date is within the next 3 Months, and Green if the date is >3 months from Today.
I know where to enter the conditional formatting codes, but [...]

Question:
Hello experts.
I have one excel file Texttables and i want to import the Mytext table with columns:TextID,Text,LangID in the MS SQL Table with the same columns.
Any help?
Solution:
You can do any one of the approaches listed here:
http://support.microsoft.com/kb/321686
Or
SELECT * INTO XLImport4 FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′,
‘Excel 8.0;Database=C:\test\xl_file_name.xls’, [excel_sheet_name$])

Question:
Hello experts
I have one excel table with columns:
textid,text,langid.
In my text columns are big text files with more than 255 characters.
Now i’m trying using the import tool from MS SQL 2000 to copy this table to my MS SQL table.What type do i have to use?
Any help?
Solution:
Depending on how large your text fields are and whether [...]

Question:
I need to have the update stopped if the user has not completed the date when trying to update the country field I get the attached error message.  So, how do I stop in the before update event data entry and move the focus to another field?
Code Snippet:
Private Sub cboCountry_BeforeUpdate(Cancel As Integer)
If IsNull(Me.txtDate) Or Me.txtDate [...]

Question:
Good afternoon!
Kittenwhisky  (06/03/10 03:25 PM, ID: 25306343)wrote a code to conditionally format cells based on a formula. I now would like to apply that same code but to every alternate columns in a selcted range.
The selected range has headings which are either A, B, A, B, A, B etc…. I would like to apply the [...]

Question:
I have recently changed 2 things on my computer and something has affected the database.  Firstly my computer was stolen so I had to get another one and this has Windows 7 instead of Vista and secondly I had to load Access 2007 again (so it could be a default setting that I had changed [...]