Recent content by Grumm

I am quite new to mysql and PHP so sorry if this is not clear. The employeeID is passed from another form any could have a numeric value for the EmployeeID (e.g. 147). I have only extracted the code that is giving the error. I have compared the whole code and it is exactly the same so it...

I have a strange problem where my code works on my hosted domain but not on my local machine and I cannot figure out why? It must be in the PHP.ini or my.ini files. This is the script that works on the domain but not on my local machine: - //Open Method @260-9D834628 function Open() {...

I have an application that has been written with a code generator and the script it has generated are hard to follow. Is there a tool/utility that I can run against my php scripts to insert or annotate the script to easier understand. Any advise would be great.

I am new to PHP and am sure this is an easy problem. I have an application that reads data and produces reports. When the report is viewed via IE5 tyhe logo MIME appears in the page. When I goto the print preview the image is lost and I get a box with a red cross in it. Am sure this is an...

Sorry - I wasgetting an eror message but I have now managed to fix the problem. Thanks

I have a script that used to run fine under my Win 2000 installation. I have now moved to XP Pro and IIS and have my application running in the following directory: - C:\Inetpub\wwwroot\tcmv30 The section of PHP that is failing is :- function PatchClassesPhp() {...

Paul, The problem I have with this one is that the form does not have any dates or weeks on it - it is basically just a screen with a load oflinks to reports that contain parameters. I will try and get round this by selecting the MAX Project week in the query. I know its not pretty but it...

Hi Paul - I have tried putting a text box in the header and entering Me!ToProjectWeek in the control and it asks me gor a further parameter. Your second comment is interesting as I am no expert in the report side and could have approached this the wrong way. What is the difference netween...

The windows box is called: Enter Parameter Value and the text is Me!ToProjectWeek with the entry box below. Cheers

Hi Paul - thanks for your help so far. I have the Me! embeded in the sql and the user is prompted via enter parameter value from the Query not the form - does this make a difference. I have a button on a form that fires up the query - it is only then that the query asks for the ToProjectWeek...

Hi - Given that a go but still cant seem to solve problem. This is the sql: SELECT Contract.ProjectID, First(Company.Logo) AS FirstOfLogo, Contract.ProjectName, ContractWorks.ItemNumber, ContractWorks.ItemDescription, LookUpDetail.Description, ContractWorks.ItemCost, Sum(Nz([TotalCost],0))...

I have a query that ask the user to enter Me!MaxWeek. The query correctly queries the data and brings bback dat Where Week <=Me!(MaxWeek). This information is held in the detail section. What I want to do is display the Max Week or the number the user entered in the header. I have tried a...

I have an application that is hosted and built using MySQL and PHP. The application is a transactional system with a number of 'standard reports' written in PHP. Is there a good server based report generator out there that I could load to the server and develop from there? I have had a look...

Hi, is it possible to hide values on a repory depending on a value entered by user. If they click to generate a repoty they will be prompted with a question 'Include Amount Y/N'. If they type N the report will be produced with the Amount hidden. I can do it on forms but cant see a way on...

Hi - I have an access application running on Win 2000 and Access 2000. The application has 28 tables and about 30 forms. The customers would like to web enable the application and want to go down the open source route. I am been asked to look into MySQL and PHP as the technologies of choice...