Search results for query: *

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

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

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

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

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

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

i have a code that is used to zap a table before another one is called to populate it. this is the portion of the code: Set rst = dbs.OpenRecordset("R100", dbOpenDynaset) Do Until rst.EOF With rst rst.Delete rst.MoveNext End With Loop rst.Close In recent times, however, i keep...