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: Hokis
  • Order by date
  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.

    ...going to browse for a table it is going to be a different .dbf file (table). Can someone help me. This is my code so far: Private Sub cmdBrowse_Click() dlgCommon.Filter = "Database Files(*.dbf)|*.dbf|All Files(*.*)|*.*" dlgCommon.ShowOpen txtFileName.Text = dlgCommon.FileName End Sub Thank...
  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...
  16. Hokis

    DBF TO MDF sequence mess

    Hi, I have a file dbf that I'm importing in access, it has a field name sequence, which has seq number in it. When i'm importing the file the sequence is changing so i have 49-50-51...then 1-2-3... Could you tell me why. The properties is Text. then when i'm converting the properties to number...
  17. Hokis

    Uniq Records question

    what i mean is i have a table with name address city st & zip & code field, which couple of the rows have the same codes, like AA, then another rows have different codes like BB, so I need to pull out one name per code (like grab the hole row), but index it on code, so I'll have one name (with...
  18. Hokis

    Uniq Records question

    I have this table that has codes in it like FF & AA & BB. All i need to do is get the uniq record for each, I mean index on the uniq record & export it as a table. How can i do that. Thanks
  19. Hokis

    Simple Problem with date

    That's the only code i have. I need the Date slected & today's date's difference to see if it is more then then one year or not. How can i do that? Thanks
  20. Hokis

    Simple Problem with date

    i did but i couldn't figure it out, I'm sorry as I'm new in Visual basic, so Pls can u help. Thanks

Part and Inventory Search

Back
Top