Search results for query: *

I'm a real beginner with mysql/php but I've managed to put together a basic (1 table)mysql database and a web based search form which returns the relevant information. I've used a fulltext index (which includes most of the fields in the table) and this is what is now causing me some problems...

Hi all, I'm working on a sheet in excel and I've come up against a problem I can't seem to solve, any help would be gratefully received... Essentially, the sheet is 2 columns and what I want to do is move data from one column to another based on the value of the cell. I think I'm ok with...

Might be a bit of a longshot this... I have a 4D database file, and I have no idea how to manipulate it. Does anyone know if it is possible to convert the database to either access or mysql? Excuse my newbieness here, my only experience of databases is relativelt simple access and mysql...

Can anyone shed any light on this? When I add the circular reference icons to my toolbar, (View|Toolbar|customise|circular reference) they appear as required. BUT, as soon as I touch anything in the sheet, they disappear. I'm confused.

Does anyone know how to tell whether a cell is an inputted value or a formula? The spreadsheet I'm looking at predicts future values which should be replaced with final values by the user once the data is available. I want to be able to check whether the final values have been input. I'm not...

I have a table that looks a bit like this: Jan Feb Mar Small red 1 2 5 Medium red 4 3 1 small blue 3 2 1 medium blue 2 4 1 Can I return the value at the intersection of the ranges 'Jan' and 'small red'...

My system 'was' running using a single serial ATA HD. (Asus A7V600 and Maxtor 160G serial ATA.) Happily, the WinXP Pro registry has managed to become corrupt (the typical Windows\System32\Config\System shenanigans). Now, I'm familiar with this problem and the subsequent recovery when using...

Does anyone know if it is possible to do this? What I am actually trying to do is choose a random name from an array and then pass that name into a shell command like this: dim Names as Variant varData = Array("name1", "name2", "name3") shell "net send [randomnamehere]...

I sometimes have to import data nito excel from other apps, and they often produce columns of things that look like numbers but aren't. So I can't sum them etc. I know that I can go to each individual cell and press F2 and this converts it to something I can use but this is more than a little...

I have an excel sheet in which one of the columns was sorted into alphabetical order (independently of other columns) and then saved. Consequently, the information is now useless. Is there any way to get back to the way the sheet was?

I have a cell whose contents are: 17/03/2003 18:13:51 What I want to be able to do is lose the date part of the information, leaving just the time. Obviuosly it's simple to display just the time, but I want to be able to sort by time and at the moment I can't. Anyone have any ideas?

I have a macro that looks like this: Workbooks.Open FileName:= _ "C:\blah_blah.xls", _ UpdateLinks:=3 Application.Run "blah_blah.xls!DDSCPTUpload" ActiveWorkbook.Save ActiveWindow.Close The application DDSCPTupload requires a password in order to...

I have a macro that looks like this: Workbooks.Open FileName:= _ "C:\blah_blah.xls", _ UpdateLinks:=3 Application.Run "blah_blah.xls!DDSCPTUpload" ActiveWorkbook.Save ActiveWindow.Close The application DDSCPTupload requires a password in order to...

Whenever I am editing a chart in powerpoint, if I use the scroll wheel, it's game over. Powerpoint just freezes and th onl option is to force closure, thereby losing any unsaved work. This is beginning to drive me uts and I can't find any reference to it anywhere. Does anyone have any clues...

I have developed a collection of interlinking workbooks on my local machine. Now that I am happy with the way they work, I want to put them on the network but I have run into a problem, the path lengths are now longer and as aresult, some formulas are too long! Does anyone know a simple way...

I have 3 interlinked workbooks A, B & C, the values in C are calculated from inputs in A & B. Now, whenever another workbook (unrelated to this set of 3) links to workbook C, the values will be out of date up until such time as workbook C is opened and therefore updates itself. Is there a neat...

I have been provided with an excel sheet that allows me to upload to a database. It's very useful and I thought I could adapt it to upload other pieces of information. So I took a look at the code that was doing this and I cannot fathom it at all. Can anyone give me any pointers here? 2...

This one has me stumped. 3 cells (which are merged cells) don't print along with the rest of the sheet. They aren't hidden, autofilter is not involved and the colours/ fonts are the same as other cells that do print. The only difference is that they are merged. Any ideas?

I have data from several spreadsheets that I want ot combine. One of the columns in each sheet is a list of companies. I want to combine all the companies into one column on a new sheet and remove any duplicates. Any ideas how I do this?

Below is my code to automatically update a file when users open this workbook. What I want to know is, can I prevent the dialogue asking whether to replace the existing file and just automatically replace it? Thanks Sub Auto_Open() 'Routine to automatically update the reccydata file in the...