Search results

  1. L

    Problem importing CSV file into Table

    Hi Pat, Thanks for the sarcastic and disappointing comments. Perhaps you need to read my replies a bit better as I have been providing detailed information that you seem to be having trouble interpreting. Thanks everybody for trying to help me but I'm signing off and will find a solution...
  2. L

    Problem importing CSV file into Table

    Everything has been working fine for a very long time. Hi Pat As I said it #19, without a Specification defined and outputting to a new table, ALL of the fields in the new table are defined as TEXT. If I then rerun the Import without a Specification and point the output to the existing...
  3. L

    Problem importing CSV file into Table

    Hi Pat, I re-ran the import via the External Data/text option with using a Specification and only specifying the "First Row Contains Field Names" and the text Qualifier. I then had it create a new table. All of the fields of the new table were TEXT. I then ran the import again without a...
  4. L

    Problem importing CSV file into Table

    It appears that the acImportDelim option needs a Specification otherwise you get the following error:
  5. L

    Problem importing CSV file into Table

    It appears that the acImportDelim option needs a Specification otherwise you get the following error:
  6. L

    Problem importing CSV file into Table

    Hi Pat, This is what I have just done: 1. The [AvailOrder} field in the Web_Parts table is defined as a YES/NO field. 2. I then ran an import (via the External Data/text option) using a single record without a Specification and it worked perfectly and the data from the AvailOrder field in the...
  7. L

    Problem importing CSV file into Table

    Thanks for this but I cannot open the file. I get the following error:
  8. L

    Problem importing CSV file into Table

    Thanks for all of the suggestions guys, I will get back onto this in a few days time and let you know the outcome. Cheers Greg
  9. L

    Problem importing CSV file into Table

    Hi Docman, I changed it to "-1" but still get the error message when using a Specification but not when I don't use a Specfication. This is driving me nuts................
  10. L

    Problem importing CSV file into Table

    I have tried "DoCmd.TransferText acImportDelim, , "Web_Parts", "C:\testmiport.csv", True, "" this and get the following error: If I don't use a Specification, how does it know what the Text Qualifier is?
  11. L

    Problem importing CSV file into Table

    Thanks doc man. I’ll try this tomorrow and let you know. cheers Greg
  12. L

    Problem importing CSV file into Table

    Hi Guys My Access 2007 application uses DoCmd.TransferText option to import numerous CSV files into various tables and has been working well for years. The want to change one of these Imports as there is an additional field in the CSV file that needs to be imported into the table. It is called...
  13. L

    How do I get the name of a subform that is part of a tabbed Main form?

    Thanks for the detailed explanation Doc Man1
  14. L

    How do I get the name of a subform that is part of a tabbed Main form?

    Thanks Pat, I'll have a play around. Cheers Greg
  15. L

    How do I get the name of a subform that is part of a tabbed Main form?

    Hi Pat Thanks for the reply. This works but it doesn't work if I am calling a module.
  16. L

    How do I get the name of a subform that is part of a tabbed Main form?

    This is the module that I use for creating the Audit Records..... It does not allow me to use the Me.Name instead of Screen.ActiveForm. Function LogChanges(lngID As Long, Optional strField As String = "") On Error GoTo Error_Problem Dim dbs As DAO.Database Dim rst As...
  17. L

    How do I get the name of a subform that is part of a tabbed Main form?

    Hi everyone, I have looked and looked and can't find the answer to this issue so I am posting here hoping for some help. I have developed a comprehensive Stock and Inventory system using Access 2007. Here is the issue I have. I have a main form called "BulkPartsMainForm" It has a number of...
  18. L

    How to Pass this parameter to this type of query - I'm struggling

    Thanks mate! It works great! I assume that SetParamter is not available in Access 2007 and this is a module that provides exactly the same functionality. Thanks again! Cheers Greg
Top Bottom