Search results for query: *

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,

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

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

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

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

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

Hi, I'm doing this simple program which I don't know how to to. I have this form in it a employee txtbox, a masked date txtbox & a vacation hour txtbox, & a result lblbox, when the user puts the info in it, i need the calculate btn to calculate as follows: if the employee is hired 1 year ago...

Hi, I have randome numbers, not in sequence 10,000 of them, & I need to shuffle them randomly. How can i do that, I don't want to sort them, just shuffle them. Thank you Hokis

Hi guys, I have a table that has 10,000 field, with different 20 numbers in it, i want to randomize that column, but i can't seem to be able to. I don't want to sort (ascending or descending), i just want to randomize sorting. Is there a way??? Thank you Hokis

Hi, i have this table that has a field that has 3 different names in it Like AAA-BBB & CCC but i have 1000 records they all are repeated. What i need to do is in the query i need to select AAA but only 3 records (random) of it, i don't want 500 AAAs, i just need 3 records. I know how to put in...

Hi, i have this table that has a field that has 3 different names in it Like AAA-BBB & CCC but i have 1000 records they all are repeated. What i need to do is in the query i need to select AAA but only 3 records (random) of it, i don't want 500 AAAs, i just need 3 records. I know how to put in...

Hi, I'm using Fox Pro & I attach the file to PrintShop mail software, & my problem is that I have some charachters in FoxPro, Like "¢ or é" symbols, that is just fine in FoxP but when I attach it to PrintShop, it's giving me another charachter instead of the one I want, is there a solution for...

Hi, I have a check box on my form & i need a code on click it shows me a picture on my report that is attache dto my form.??? can i do that?? Thanks Hokis

Hi, the question might sound very simple but i'm very confused. I have a table that would have mulitple records, like 1000 or more or less, i have a report i need in that report to show me, how many records there is, in that specific table, how do i do that???? thank you Alice

I have a form wich is attached to table, so whenever i open it i see the data in the text boxes which i want, every time that i open it it shows me blank, even though it has data in it, i know that there was a way but i can't remember it. pls help. Thank you H.

Hi, I have a program in Access that i want to put a command button in the form to Open a window with .dbf files showing & let me get it. Can i do that or it won't let me. And if Yes I can do it, would you tell me how???? Thank you. Hokis

pls I need a code for a command button that opens a find for file window, so that i can search my pc for a .mdb file. How can i do that? thank u H.

Hi, I need a code for a command button, that on click it opens a search window for files, so that i can select any .dbf file from my C: or whatever drive i have. I don't know where to search for that code, I'm sorry if my question is too simple I'm very new in VB & I don't know much (anything...

Hi there, Is there a way to send an email from a form to a specific email address & i can attach the record that is open in the form? Thanks A.