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 Mike Lewis 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: *

  1. Pedrowedro

    Truncated Memo Field during CSV import using DoCmd.transfertext

    Remou, Thanks for all your help. Everything is working now... The problem occured when another field had a key violation during the import routine... this must limit the memory allocated to holding the memo data... dome how. Thank you again
  2. Pedrowedro

    Truncated Memo Field during CSV import using DoCmd.transfertext

    I'm using access 2000, and it is likely that the latest version of jet is not installed. I have just requested this from our IT department... so may see something put inplace by next week... What version of jet and access do you have installed? Thanks
  3. Pedrowedro

    Truncated Memo Field during CSV import using DoCmd.transfertext

    Hi, I have been trying to find a work round to this all day. I am using the DoCmd.Transfertext method to import data from a csv file into a pre-defined table in access 2000 (SP1). Some of the data is over 255 characters and have appropriate memo fields in the access table for them to be...
  4. Pedrowedro

    Find string match from one table and pull in another attribute value

    Thank you very much for your help... works nicely. Hopefully in time I could convince the powers that be that a re-design would be a better option...but until then... Thanks again
  5. Pedrowedro

    Find string match from one table and pull in another attribute value

    Hi MajP, Table 2 contains approx 7000 building codes and there description for the construction industry. This is used as a look up for pulling the description in other areas of the system. I recieve a file that I import into the database that is already at third normal form. The problem is...
  6. Pedrowedro

    Find string match from one table and pull in another attribute value

    Thank you for your help PHV. But the problem I am coming up against is that table 1's multiple value field contains a string value composed of a concatination of several values. What I am trying to do is search each value in table 1's multiplevalue field in turn against table two and when...
  7. Pedrowedro

    Find string match from one table and pull in another attribute value

    Hi, Please could you help me out with this problem... I have the following set up: Table1 ====== Autonumber Field MultipleVAlue (this Field holds info such as "E012; G344; T66;") Description Field (This is currently empty) Table2 ====== Value (this Field holds information such as "E012;")...
  8. Pedrowedro

    Passing Primary and Foreign Key values through linked tables

    Thanks for your feed back Remou, The structure is tblContract inner joined ContractID to table tblKnowledgeReport which in turn is inner joined by field KnowledgeID to tblKnowledgeReport. What I have done is set up some none duplicate indexing, and created multiple update queries from...
  9. Pedrowedro

    Passing Primary and Foreign Key values through linked tables

    Hi, Please can some one help with this. I am trying to get my head round cascading foreign and primary key data values. I have three tables: -tblContract ContractID PK (autonumber) BoNumber -tblKnowledgeReport KnowledgeID PK (autonumber) ContractID FK TypeOfReport -tblMetricsReport...
  10. Pedrowedro

    How can I disable the close button on and Excel Form

    Thanks CBasicAsslember that worked a treat!
  11. Pedrowedro

    How can I disable the close button on and Excel Form

    Hi I have been trying to disable the close button in an excel form with no luck. If it is not possible to disable it, is it possible to catch the code as it runs upon the event of the close button being pressed. Thanks

Part and Inventory Search

Back
Top