Search results for query: *

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

thanks lbass - that makes sense. I don't have much CR experience but I think I understand how that would work. However i like to be able to manipulate the look of a report as it's something we will use every day - I'll have to review the content and see how best to split it up.

no it's not a crosstab I created it as a standard report using the report expert there are no summary fields at the moment .... I'm literally just pulling info from a DB and trying to present it in the most sensible fashion ...

thanks fro input, just had a quick go but it displays 1 record at a time, then the next underneath. The report outputs as a table what I would like is something as follows Record 1 Record 2 Record 3 Record 4 Date 21.03.06 23.03.06 17.03.06 25.03.06...

Hi is it possible to put field headings down the first column (so the rows are labelled) rather than across the first row (so the columns are labelled) ? I have a report with about 30 fields - it would be great if the field names could run down the rows of the first column as it just wont...

Hello I have a set of recurring tasks - that basically form a daily and weekly etc 'To Do List' As the tasks are marked complete they recur again as planned. I would like to use the 'Task' window to enter information relevant to the task on a particular day. Unfortunately when the task...