Recent content by FoxGolfer

I have a CR10 report (SQL Server tables)that needs to report on managers with goals, without goals or all managers. The goals table is linked to the emp table by the EmpID with a left outer join. I have determined that if I have EmpID = EmpID I get all managers with goals. (Makes sense so far.)...

I got it to work. There's a specific MS KB article that addresses this issue # 283881. It turns out when I upgraded to Office 2003, the registry was revised incorrectly. To use Excel files in CR or Access, the registry must be pointed to msexcl40.dll. Mine had been revised to msaesp30.dll. (??)...

I have an CR9.0 report that I've been using for almost a year that has an Excel 2003 spreadsheet as the data source. When I tried to run the report today, I kept getting the following error message: Logon Failed Details: DAO error code: 0xc62 Source: DAO workspace Description: Could not find...

Thanks guys, they BOTH worked fine. It's me, can't figure out how to place literals in code.

Nope, didn't do it. I got the total of EVERYTHING, not just for 2005. Here's what I tried: =DSum("Paid_amt","Invoices",[Paid_date]>=1/1/2005 And [Paid_date]<=12/31/2005)

I'm trying to sum invoices for a specific date range. I've started with: = Dsum("Paid_date","Invoices", .....) and many variations for the criteria, all with no success. What I want is every thing between 1/1/2005 and 12/31/2005. I tried "Having [Paid_date] between #1/1/2005# and #12/31/2005#"...

Remou, ListPrice.PN is text. Lillibeth, The field name is PN. What I want is *PN but I can't figure out how to write it. I did get it to work differently; I added the trim() to the code: "SELECT Trim([ListPrice.PN]) AS P, ....... ...."WHERE Trim([ListPrice.PN]) = '" & strPartNo & "'" This...

I'm sorry, I don't understand your response. The Where clause I posted is a copy/paste from the code. Are you saying to add the * between the ' and "? I tried that and it didn't work.

I'm sorry, I don't understand your response. The Where clause I posted is a copy/paste from the code. Are you saying to add the * between the ' and "?

I need to have a wild card in a where clause. I'm looking for part numbers that have a leading blank at the beginning of the field. (Most, not all; it's main frame data, and it's not going to change.) Currently, I have a SQL statement that ends with the following where: ..."WHERE ListPrice.PN...

That was the first thing I tried; with no luck. But I was contacted by someone else who had a solution. Thanks.

I have a subform that has a control "ExtendedPrice" with the ControlSource, =([ListPrice]*[Multiplier])*[Qty]. This correctly calculates the ExtendedPrice. To create a SubTotal value, I have a control "QTotal" in the subform Footer with a ControlSource, = Sum(([ListPrice]*[Multiplier])*[Qty])...

PHV, Ok, I incorporated the CrossRef and obtained our PartNo. That required a simple change to the CompPN RowSource. The PartNo gets filled in but I need to do more. When I select the PartNo, I was hoping that the SQL could obtain fields from a different table. Existing: Private Sub...

Here's hoping you may have an answer for this one too. It's similar but different. (??) I have a combo box to identify different competitors. After selecting the competitor, the selected result creates the RecordSource for another combo box to identify the PartNo. I have this working to this...

Thanks. I've added text AND a tool-tip to enter three characters and Alt DownArrow (didn't know about that). We'll see if they like that. Seems simple to use. If not, I can always use the other option. Tom