Search results for query: *

Can I use a DataRelation to find out which parent records in Table A do not have a child record in Table B? Or is there some other way to do this?

In SSIS, I have an incoming flat file which I use to populate a dataset. If I run a script against the dataset, how do I connect to the exising dataset using vb.net. I'm new to SSIS and vb.net. Any help would be appreciated. Thanks.

Newbie needs some help with case statments. In the code below I want to see if today's day is less than 26. I get an error with my case statment saying I can't implicitly convert a bool to an int. How would I accomplish this? int dateOfDay = DateTime.Now.Day; switch(dateOfDay) { case...

I want to delete a range of rows from an excel spreadsheet. I don't want to just clear the cells but actually remove the rows and have the rows below shift up. How would I do this through my C# application. Thanks.

Would a large memo field (1.4GB) cause "Not enough memory to complete this operation" error during a replace of multiple fields. The DBF itself is only 3.1MB. Thanks for you help.

I have a query where I am selecting fields a, b, and c. I am grouping by a. I want to get a count of b and c. The problem is there are duplicates in b. Column c has no duplicates. How can I count all of column c, only the unique records in column b and group by a. Thanks in advance. Devin

I know I am connected because I can log onto msn messenger but if I click on the emails, the page is loaded with "page cannot be displayed" Some background, I used Hijack this to get rid of msoffice.hta, I also used spybot search and destroy. I think through Hijack I might have...

I am looking for an easy way to find out how much time, hours, minutes, seconds are left until some future date and time? Is there a simple commmand? Thanks in advance. devin

Does anyone know if the font helvetica compressed is supported by VF6? Thanks in advance.

I have a field city_state which holds the city and state together. The state is always the last two characters, but the city is variable in length. Is there command or combination of commands I can use to parse out the state. Thanks in advance. Devin

How do I keep the cursor in the current text box when the input mask limit is reached, rather than having the cursor jump to the next textbox automatically? Thanks

I am using the ShellExecute command to run a self extracting executable. When the executable is finished another folder is created with the same name as the executable with a couple of text files inside. I am then trying to append these text files to a foxpro table. The problem is that when I...

Response.Redirect("ams_zip.asp?action=Next") I am new to ASP/VBscript. I understand the response.redirect and the ams_zip.asp is the the web page, but I don't understand the ?action=Next. Thanks in advance.

When I send a report to the printer the printer switches to the manual tray(tray 1) waiting for paper to be inserted. How do I make sure it prints from tray 2? Thanks.

Table A has records. Table B is blank. I want to append from table A to table B the records which satisfy a statment. SELECT B APPEND FROM A FOR A.NUMBER = 8034 There are 12 records in table A, I should be appending 3 records to table B. I am getting 0 records. If I change the NUMBER field...

I have six detail records that I want printed at the top of a report and the same six records I would like to repeat at the bottom of the report. In between these records I would like to print an entirely different set of detail records. Is this possible? Is it possible to have mulitple...

I am trying to use two fields in footer that have been summed and divide one by the other to get a percentage. However the percentage is always off. I know its not a rounding error. What am i doing wrong? Thanks in advance.

Is there a way to make text blink on a form? Thanks

Anybody know a way of retrieving source code from an .FXP? Is it possible? Thanks in advance.

Is it possible to have a combo drop down box which the user cannot type into and only select the available items in the list? Should I use a list box for this purpose? I only have room for one line so I would need the list box to be scrollable by one line at a time. Is this possible? Thanks...