Search results for query: *

This is doing my brain in. I need to be able to delete rows on an entire sheet that contain specific words eg a row/s containing the words 'Mat' & 'Delta' regardless what cell it is in. It could be in some instances more than 2 words. I'm curretly only able to delete according to one word...

Hi, Could someone help write a batch file that will look into a particular folder (including sub folders)on my pc and delete any files that are 0kb in size. much appreciated

I've installed an adaptec 39320-R controller card. It has two internal channels. When connecting my boot drive (maxtor 36GB 15K) to channel A I get this error: 39320 A at Slot 03, 03:0A:00 - SCSI controller configuration error:03 Connecting in Channel B works fine. The PC boots up. I updated...

In other words I want a form to always stay on top and no other apps or actions can be run until this form is closed. I'm using this in my 'about' menu which I noticed is very common on apps. Thanks, Jayz

Ok, I've created this combobox which displays a list of excel spreadsheets within a specified directory. see combobox post here: thread102-515425 Now, what I want is a refresh button which will refresh this combobox whenever a new excel spreadsheet is added to that directory. At the moment I...

Basically I just wanted to open an application that was stored within the same directory as my main application. This was my original code: procedure TForm1.Button1Click(Sender: TObject); begin ShellExecute(Handle, 'open','c:\lazy\calc.exe' ,nil, nil, SW_SHOWNORMAL) end; which simply runs...

Hello Experts of the realm, I need to display in a combobox, a list of filenames (including extension) of a certain type, eg spreadsheets with the extension '.xls' that is in a set directory. I hope this is clear. So, as a simple example: I have a form with only a combobox displayed, that...

Is there a way to text wrap the message that is in a messageDlg box?. Much more pleasing to the eye than having this one one long box. The only other option I can think of is to open my message in another form.

I would of thought a simple command like the below would work? DeleteFile('C:\temp\*.*);

Ok, I know this sounds simple but I'm new to Delphi and I hope this will be easy to understand. I currently have 2 combo boxes with the values 60, 120, 240 in cmbox1 and 0, 10, 12 in cmbox2. I want to be able to open a txt file and replace certain text in that file with the value from the...

Hello all, I've just started learning delphi 6.0 and now my head is full of ideas. I apologies if this sounds like a simple question. I've created a form with a button, when on the click action it will open notepad. But I'd also like to have this form minimise when notepad opens. And then...

Ok, I'm obviously doing something wrong here, I can't get this to work. I have a query named [qryBacklog] and a field name [Code] which displays letters A-F depending on days elapsed for the total days an order is overdue. eg >100 days =A, >80days=C and so on... I created my continuous form...

Hi All, I just created a query in the query design grid that calculates the working days between 2 dates and then filters out anything less that 4 days by entering >4 in the criteria. Days_Since_rej: deltadays([Date_Advised],Date()) The problem is when I run the query it takes about a minute...

Ok, I'm almost there. I created a continuous form based on a query and then created some code that would export the results to Excel on a click of a button. The problem is, when I filter the data on the form using the right click option "filter by selection", and then export it to...

I got this code from the FAQ to calculate the days btwn two dates excluding holidays & weekends. I created my table named tblHolidays with exact same field names. On my Form I have 3 textboxes [StartDate] and [EndDate] and [numdays]. In the control source property of [numdays] I entered...

Hi, Using VBA, On a button click, How can I detect if a Certain Excel Spreadsheet is open, before exporting data to this particular file. I'd like it to bring up a msgbox to "close the spreadsheet" before exporting. Any help would be much appreciated, Jay

Can someone please show me how to create a search form that will open another form with the results. Here's the scenario: I have one form which contains the data [dataform] with the following fields: [sub_date] [company] [product] [Country] I have a search form [searchfrm] with the following...

I need to create a timer that counts down from 5 minutes in the format mm:ss on a form when it opens. I'm unsure how to do this. Someone please help Rgrds Jay

In continous form view, I'd like to be able to click on a record and have a popup floating form that displays the infomation that was entered into a particular field in that record i clicked. And when Scrolling across the continuos form, always have the popup form visable. Reason being is I...

In continous form view, I'd like to be able to click on a record and have a popup floating form that displays the infomation that was entered into a particular field in that record i clicked. And when Scrolling across the continuos form, always have the popup form visable. Reason being is I...