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 derfloh 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: AHJ1
  • Order by date
  1. AHJ1

    Why does this query return a 3265 error?

    You were right. Thanks. Have a star! I made the mistake of grabbing code from a different project without totally proofing it. In this snippet I have a datDue I changed it to a zero. Set rst = qdf.OpenRecordset() If Not rst.EOF Then If Not IsNull(rst(strFieldName)) Then...
  2. AHJ1

    Why does this query return a 3265 error?

    Lameid, Thanks for your response. Here's the code to that function. I do have a workaround, but I'd prefer not to use it. Function ReturnSingleFieldData(strQueryName As String, strFieldName As String, _ Optional strParameterName1 As String, Optional varParmValue1 As Variant, _ Optional...
  3. AHJ1

    Why does this query return a 3265 error?

    Can someone explain to me why this code works, but it does not work when I uncomment Function GetCountOfRecs() As Integer On Error GoTo err_GetCount Dim strSQL As String Dim intCount As Integer intCount = ReturnSingleFieldData("qryCountOfMyDataAggregated", "CountOfID") 'intCount =...
  4. AHJ1

    #error when running query

    Simple. Thank you.
  5. AHJ1

    #error when running query

    Yes. That works. Thank you. I realize that a zero-length string is not the same as a Null. Do you happen to have the code for checking for zero-length strings?
  6. AHJ1

    #error when running query

    I'm running a query that calls a function. SELECT MyDataAggregated.ID, PutAppealsToNotes1([Appeal_Not_Heard_1],[Appeal_Not_Heard_2],[Exemption_Description]) AS Notes1, PutAppealsToNotes1([Appeal_Not_Heard_1],[Appeal_Not_Heard_2]) AS Notes2, [Notes1] & [Notes2] AS Notes FROM MyDataAggregated...
  7. AHJ1

    Parsing XML Document

    Ben, Thanks for the alternative. I tried the code and it works.
  8. AHJ1

    Parsing XML Document

    I knew there had to be a simple solution. Here it is: Sub TestXMLImport() Application.ImportXML _ DataSource:="C:\Data\ImportSBE\HDTestAlan_data.xml", _ ImportOptions:=acStructureAndData End Sub This creates a table called "topmostSubform". I'm not sure why it does this. Now, it...
  9. AHJ1

    Parsing XML Document

    Hello, I am using Access 2002 and I have about 5,000 forms that were created using Adobe Life Cycle. When someone fills out the form it creates an XML file like this: <?xml version="1.0" encoding="UTF-8" ?> - <topmostSubform> <Name_of_Petitioner>Alan</Name_of_Petitioner>...
  10. AHJ1

    TransferSpreadsheet Not working consistently

    Skip, That's quite true. mMogul, why not sort the data, and examine it. Perhaps we really don't have a problem. Alan
  11. AHJ1

    TransferSpreadsheet Not working consistently

    I could be wrong, but it seems to me as if you are sorting numbers in text order sometimes. 01 sorts differently than 1 in text. I would try using an import spec, with everything going to a table that is all text fields, and then coercing the fields that contain numbers to numbers. (The...
  12. AHJ1

    application.filesearch vista problem

    Hmmm. What would happen if you forced a type conversion? Maybe forcing the number to a long integer. Something like this? [Code] With Application.FileSearch .NewSearch .LookIn = PicPath .FileName = [SOCIAL_SEC] & ".jpg" .Execute Found =...
  13. AHJ1

    Query or Regular Expressions to find similar names

    For other people's reference: http://smallwhitecube.com/php/dokuwiki/doku.php?id=code:vbasoundex
  14. AHJ1

    Query or Regular Expressions to find similar names

    Thanks.
  15. AHJ1

    TransferSpreadsheet Not working consistently

    May I suggest that you save the file as a comma separated variable. This allows you to import the data and create an Import Specification. The import spec lets you define the types of data you are importing. Importing certain data as text, double, etc. may be helpful. Good luck.
  16. AHJ1

    Query or Regular Expressions to find similar names

    PHV, Thanks for your suggestion. That may work well, but I can't tell, because my comprehension of French is limited. http://arkham46.developpez.com/articles/office/clgdiplus/tuto/tutoclgdiplusexif/ Do you know if there is an English site?
  17. AHJ1

    Query or Regular Expressions to find similar names

    Yes. Thank you. I am also considering an associative table. The problem is one of manual entry in the future. I know that people will continue to make typos and "human appropriate" name entries for Excel, which just won't work when we start to slice-and-dice in a database.
  18. AHJ1

    application.filesearch vista problem

    Could you post the code?
  19. AHJ1

    Query or Regular Expressions to find similar names

    A program that I am writing works from Extracts from several Excel Worksheets. I can import the data but because the Excel worksheets require manual input of the names of companies. Therefore, there are errors like this A J MULLINS AJ MULLINS BARRICK GOLDSTRIKE MINE INC BARRICK GOLDSTRIKE...
  20. AHJ1

    Modular Level Array Issue

    It's definitely a scoping issue. When I take the code and put it in the same procedure, it runs. The trouble is that I don't need it there. I'll play with it a little while. If I run out of time, I'll write it to a temporary table. There's not that much data, and though it will be slower, I...

Part and Inventory Search

Back
Top