Recent content by tobypsl

Hi I am using the Matt Kruse table utilities plugin to set up filters on an HTML table. The filters work but the script is also supposed to set up an auto zebra striping function. This doesn't work. My website is a Joomla site so I use the Jumi plugin to execute relevant code for the content...

Hi I have the following pieces of code which I use in a Joomla application to create a sortng function for tables in articles, the first is a Javascript File the second is the code for the table. I use a component called Jumi to include the JS file in an article. The javascript file seems to...

the problem turned out to be that, when testing the code, I did not append filetypes to the filenames I used in the test table. When the filetype is appended eg. file1.doc OR file2.rtf they open fine with both methods tested. I think the filenames referred to in the actual DB have different...

Hi fneily, Remou and PHV - thanks for your inputs. I have tried the suggestions by Remou and PHV so far. The unbound OLE contraol does not generate an error but the control disappears leaving a blank space on the form as soon as I open the form. This looked like the most promising method as it...

Hi - I am using Office 2003 and would like to know how to display MS Word files in MS Access forms. One of my forms is based on a table that has, as one of it's fields, the filepaths to MS word documents. Each record in the table has a unique MS Word file related to it. What I would like to...

I have saved this code as a public function. I use the above piece of code to change records that have a status of R to a status of B. If I wanted to also use the code to change records that have a status of, say, G to a status of N is there a means of defining this in the () part of the...

Hey AceMan - you're a genius, this seems to be working when I just tested it. Need to try it on the full DB where the J000nnn tables are linked rather than local, but I don't see any problems. I had to insert an addition to the WHERE clause into the code as it was changing the status of all...

Hi Golom I want to update the data in the tables J000nnn. The data I am querying is not held in those tables though. The J000nnn tables (which all have an identical structure) have been joined into one bigger Temporary table - using the code I posted. The point I am making is that an...

I am tryting to update a field that appears in multiple tables within my DB. These tables all share an identical structure (which I gather is less than ideal DB design). The DB is a commercial product and I use MS Access Linked Tables to generate the reports I use. I cannot change the...

thanks earthandfire I made ammendments as suggested - I got an error 424 - Object Expected. Also the layout would allow me to see one record at a time when what I am really looking for is a continuous list - like a datasheet view. What I tried previously was to create an append query which...

hi earthandfire thanks for the input. I've entered this code, attached it to the onclick for a command button on a simple form, and the expression it creates seems to be fine - now the stupid question - how do I actually get a query to execute ie. how do I get the results of the query into a...

Hello I am wondering if it is possible to construct a union query for tables selected by the user in a drop down list box ? I currently have about 200 tables, all with the same data types, but only 10 or so of them are relevant at any given time - relevance decided by the user. Any ideas...

simultaneous posting :) ... thanks synapsevampire, will give that a go ...

I just replaced teh formula with the following; if isnull({RJOBUD.Date1}) and isnull({RJOBUD.Date3}) and isnull({RJOBUD.Date4}) then 'FIRST' else if CurrentDate-({RJOBUD.Date1}) > 7 and CurrentDate-({RJOBUD.Date3}) > 7 and CurrentDate-({RJOBUD.Date4}) > 7 then'REPEAT' else ' ' it places a...

Hi Using CR8.5 I have teh following expression in the formula for a report field; if isnull ({RJOBUD.Date1} and {RJOBUD.Date3}and{RJOBUD.Date4}) then ('FIRST') else if CurrentDate-({RJOBUD.Date1}or{RJOBUD.Date3}or{RJOBUD.Date4}) > 7 then ('REPEAT') else {RJOBUD.Date1} basically I have 3...