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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Hokis

  1. Hokis

    Getting dynamic data.

    Hi, Thank u guys for answering my post, I'm trying to do the datagrid fileds, but it doesn't let me add more fields in it, it's just 2 field. So how can i add more fields? ANd one more question, if the data bases will change (will vary) can i make like 20 fileds, then whatever i'm going to...
  2. Hokis

    Getting dynamic data.

    Yes I agree, but how, I need the following: the user will pick a database (.dbf) then click a button & all that button will do is replace a field with another field within that database. Like in FoxPro, you say (Replace Field1 with Field2 all) for example, that's what i want to do within VB...
  3. Hokis

    Getting dynamic data.

    Hi,I'm trying to do a simple program, in VB6, which has a button to grab an only .dbf files, i put the CommonDialog in the form to do that, & it's working, I have also a text box which it shows the path of the file name that i grabed. Now i have another button that supposadly has to manipulate...
  4. Hokis

    Delete Duplicate records

    Hi,Is there a way to delete the duplicate records within a table, or a query without doing that copy the query to a table & do the distinct thing, there must be an easier way, like in the query design view or in SQL command, please Help. Thank you,
  5. Hokis

    Index on uniq 2 Examples

    thank you for the update, i'll try it.
  6. Hokis

    Index on uniq 2 Examples

    ok i found out a better solution, I'de like to share with everyone. Index on FieldName+STR(MOD(RECNO(),2)) To S1 uniq. This will do the trick. H.
  7. Hokis

    Index on uniq 2 Examples

    Hi I need to index on a field, but need 2 of each,( not just one of each) so is there a way to do that? thanks H
  8. Hokis

    Sequence number change.

    through another software called postalsoft, for mailing.
  9. Hokis

    Sequence number change.

    i have one table that has a seq. field, which property is charachter. Some of the records from 64000 to 64040 was cut & copied after 88 then after 64040 the seq was 89 & until the end. DO u have any ideas how this could happen. ??? thanks H
  10. Hokis

    Sequence Number changing

    actually i needed it to be in order when i import it without me going in & re-index it. But u know what i got it. in the Tools-Options, Table/Queries, there is an option that when u import it is indexing on specific key names, like ID, Num, Key, so it is reindexing the file accordingly. So once...
  11. Hokis

    Sequence Number changing

    No lespaul, it I didn't get what you said, but yes the order is very important as it is a mailing list that has sequence number in it, & to sort the mail you have to put it in order. so i need my numbers to stay AS IS.
  12. Hokis

    Sequence Number changing

    it is really random , like 4- 5 - 7 - 10-25...etc
  13. Hokis

    Sequence Number changing

    yes, exactly that's what i mean.
  14. Hokis

    Sequence Number changing

    HI, I have a huge problem & I don't know where it comes from. I have a dbf file that has a text property field, which has a sequence number 1 to 60000 in it. when i import that file in Access, it rearange that sequence nuymbers randomely, it's not changing the properties or anything but it is...
  15. Hokis

    Uniq Records question

    ok here is my table ACCOUNT FIRST LAST COMPANY code 88888 ABY LastName ABC AAA 88888 ABY LastName ABC AAA 88888 ABY LastName ABC BBB 88888 ABY LastName ABC BBB 88888 ABY LastName ABC CCC 88888 ABY LastName ABC DDD 88888 ABY LastName ABC CCC 88888 ABY LastName ABC BBB 88888 ABY LastName ABC DDD...

Part and Inventory Search

Back
Top