Recent content by dbuuch

Thanks Tsuji for coming to my aid. Option 2 works alright but it is out of sync with the other links that appear on the menu. It shows itself as an odd one out even though the hyperlink takes me to where i want to be. Option 1, however, doesn't quite take me to where I wanted to be - it somehow...

Hi, I am trying to put a hyperlink on my website to take me to a particular forum page but cannot get the link to work correctly. i sense I need to escape some characters but have tried all combination and cannot get the link to work. The ff is the code...

Thanks PHV. You are wonderful. it worked perfectly. You are the man indeed. thanks, Daniel "To educate a man is to educate an individual; to educate a woman is to educate a nation" Dr. Aggrey, Ghana.

PH, Thanks but it didn't work when i tried it. your suggestion seems to be looking for the string "any text" but this isn't what i actually meant. Supposing i didn't know the actual text string, how could i get it to find a cell that contains anything at all (in other words, a cell which is...

The following code searches for the word "attachments" within a range and then display the cell address of that particular cell where it is found. I would like to amend this code so that instead of looking for a particular text it looks for any text at all. Often this whole range would have one...

Thanks Kev. The script does not give any errors. In have it is suppose to print a message if it doesn't find any directories and it seems to do that correctly. Also, i have schecked the $BBS_DIR and it seems ok (to my uninitiated eye). I did not post the entire code but below is it...

I have this bulletin board script which used to work very well until i changed my site hosting company about two weeks ago. I then transferred all my files onto my new server as they were before. The BB creates directories for each of the forums I have set up. Can anyone help me please? The...

Thanks guys, much appreciated. I know Access and Oracle dbs but new to MySQL. i am using a webdatabase tool to create a simple database for my club members. This tool is supplied by my hosting company and i was trying to use one of their templates to create the database. The tool requires the...

Hi there, I am trying to create a CSV file with a semi colon (;) delimiter instead of the usual commas but don't know how. My original file is an Excel spreadsheet and when i use the 'save as' option it uses commas as the delimiter and does not give me the option to change to semi colons. i...

I have a form which i would like to use to update multiple records. This for has an underlying query which populates it. I also have two buttons at the bottom of the form to update the records and close form without updating records respectively. Unfortunately whenever i change any field on my...

Thanks Brad but this doesn't solve the problem. There are other text field that are also prefixed with the single quotes, besides the number and date fields. when the data is imported using the "import External Data" functionality in Excel, however, there are no single quotes and the data look...

I have used both the DoCmd.OutputTo and the DoCmd.TransferSpreadsheet methods to export data from an Access DB into Excel. the following is an example of the code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sQueryName, strPath The problem i have is that, in Excel, all cell...

As always, thank you all for your excellent help. I will play with the DoCmd.TransferSpreadsheet later but in the mean time I used Da0tH's suggestion, using "Get External Data" option from excel and it works perfectly well too. I have even managed to save the query and it works from any Excel...

i am now using MS Excel 2002 and Access 2002 SP3. You've gotten me thinking - My pc was upgraded to XP and MSOffice 2002 some time last year. Also this code was written by a colleague some 2 or 3 years back with an earlier version of ms office. if this is the problem, is there anyway to fix...

The following VBA code is used to output the results of a query from an access db into Excel: DoCmd.OutputTo acOutputQuery, sQueryName, "MicrosoftExcel(*.xls)", strPath sQueryName, when run, has some 17,000 lines of records in it and this number will continue to grow but at a slow pace. In...