Search results for query: *

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...

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...

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...

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,

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

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.

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

through another software called postalsoft, for mailing.

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

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...

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.

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

yes, exactly that's what i mean.

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...

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...

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...

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...

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

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

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