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!

  • Congratulations strongm 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. hniessen

    Get username of who owns the record lock

    I am working on a database application which exists out of a back-end and front-end part. The data in the back-end database will thus be edited by different users. Now I want to add following feature: When someone wants to edit certain data, but someone else is already editing this data. I want...
  2. hniessen

    change size field in vba

    The first field of a table that is imported is a number with field size double. But the field size has to be a long integer. All the numbers in this field look like ##.0000000. How is this done in VBA? Greatings, Hans
  3. hniessen

    Generic query

    I know it is a bad design. It is my job to redesign this bad design. Greatings, Hans
  4. hniessen

    Generic query

    I'm wondering if it is possible to design a generic query. So I have one query that can be used on several tables with the same properties but with different names. The query has to ask for the tablename on which it has to be performed. Best Regards, Hans
  5. hniessen

    Import specific data from file

    Thanks, But there is one problem. I know to use the command grep in linux and unix. But how does it work in Windows NT???? Greatings, Hans
  6. hniessen

    Import specific data from file

    Thanks for the support. Greatings, Hans
  7. hniessen

    Import specific data from file

    Herman, Thanks for your help. I have tryed it and it worked. But the file I want to import consists of up to 12,000 lines and only up to 300 lines contain the code '117'. Therefore I am looking for a way to import the data more efficient since the data has to be imported every time the file is...
  8. hniessen

    Import specific data from file

    Dear experts, I'm trying to import data from a file Epl_asc.exf. This file is generated by another programm and is ascii compatible. Within this file I am looking for lines that start with code '117' (at the end of this message I added a fragment of such a file). As you can see the data is not...
  9. hniessen

    scan .exf file for desired data

    Dear experts, I'm trying to import data from a file Epl_asc.exf. This file is generated by another programm and is ascii compatible. Within this file I am looking for lines that start with code '117' (at the end of this message I added a fragment if the file). As you can see the data is not...
  10. hniessen

    How to Import Data Without Headers

    When you come up with something better please let us (read: me) know. I have a comparable problem with a file that has the extention .exf. Ofcourse I let you know when I come up with a solution myself. Greatings, Hans "there is never time to do it right but there is always to do it...
  11. hniessen

    Importing text-file into Access97 database

    Okay, that i thought of as one of the possible solutions. But how do i import the text file into the database. I can't figger it out using help. Most of the tutorials i use are in english but the version of access i use is german and i am dutch. Very confusing all together. Greatings, Hans
  12. hniessen

    Importing text-file into Access97 database

    As a not-so-experienced Access user I ran into an interesting problem. Namely, I want to search for data in a txt-file, which is generated by another tool. This txt-file contains 25 columns each separated by a comma. When the second column contains a value that satisfies a certain condition the...

Part and Inventory Search

Back
Top