Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FoxGolfer
  • Order by date
  1. FoxGolfer

    Multiple Parameters in Record Selection

    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.)...
  2. FoxGolfer

    Excel as Data Source

    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. (??)...
  3. FoxGolfer

    Excel as Data Source

    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...
  4. FoxGolfer

    Dsum and dates

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

    Dsum and dates

    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)
  6. FoxGolfer

    Dsum and dates

    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#"...
  7. FoxGolfer

    Wild card in where clause

    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...
  8. FoxGolfer

    Wild card in where clause

    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.
  9. FoxGolfer

    Wild card in where clause

    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 "?
  10. FoxGolfer

    Wild card in where clause

    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...
  11. FoxGolfer

    Form/Subform Totals

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

    Form/Subform Totals

    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])...
  13. FoxGolfer

    Drop down limitations

    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...
  14. FoxGolfer

    Drop down limitations

    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...
  15. FoxGolfer

    Drop down limitations

    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
  16. FoxGolfer

    Drop down limitations

    Roy-Vidar, Your suggestion and the link to Allen Browne worked perfectly, with one exception. After I enter the first 3 characters, I am required to click on the down arrow of the combo box to view the selection. Is there a way to enter the first 3 characters and then hit the Enter key to view...
  17. FoxGolfer

    Drop down limitations

    Thanks, I'll check it out. Tom
  18. FoxGolfer

    Drop down limitations

    I have been asked to create a simple order app that will draw customer names, products, etc. from other tables. My question: Is there a "practical" limitation for the number of records for a list box/combo box? The one table I have seen has approximately 40,000 records. If there is a practical...
  19. FoxGolfer

    Including and displaying JPG files

    HarryB, Thanks, I've already done that. I have a "Pictures" sub directory for the jpg images and when I get the prototype working correctly, I will be adding another field that uniquely identifies the image with the specific project. Tom
  20. FoxGolfer

    Including and displaying JPG files

    Craig, Sorry it's so soon, but: I have a table, called test with 2 fields, filename (C100) and pictfile (M,b). Your first suggested line; lcImageFile = "c:\vfp70\pinpoint\pictures\kissimmee single-ply over edge.jpg" is ok, but when I get to the code; COPY MEMO pictfile TO (ADDBS(SYS(2023)) +...

Part and Inventory Search

Back
Top