Search results

Hi i think you have cracked it, it works with all demolition ones now and also if it si another criteria then just is blank...... many thanks for your brilliant help... Can I be really cheeky now or if you prefer me to open another posting I can. My intention is now to have 3 reports one...

Hi Yes it does show all the ones in the query with the filter. There are about 6 to 7 quotes and any that as demolition I am testing with in the survey type list. It is run from the form formquote and the button is Preview Report and the event proccedure is behined this of course. There...

Hi Yes that is correct..... ok so now I click the button and the report comes up, but with no data at all...... my code is now as below Private Sub Command98_Click() On Error GoTo Err_Command98_Click Dim stDocName As String stDocName = "testquote" DoCmd.OpenReport stDocName, acPreview, ...

Hi I have made the changes as you suggested.... this is my code now Private Sub Command98_Click() On Error GoTo Err_Command98_Click Dim stDocName As String stDocName = "testquote" DoCmd.OpenReport stDocName, acPreview, , "surveytype = '" & Combo38 & "' AND IDquote = " & idquote...

Hi It si giving a Microsoft Visusal Bacis Application error message say "Compile Errror... Arguement not Optional" If I click Yes it goes to the code and highlights Private Sub Command98_Click() (in Yellow) and .... then highlights in bold the line DoCmd.OpenReport , acPreview, ...

Hi Bob Thanks fo this it worked more or less perfect and I really appreciate all your help. My last thing on this, not so important, but I think can be a little annoying for a user though If the User as put an entry into the client field in the quote and the YES/NO comes up because it is...

Great this one is solved thanks for everyones input.... many thanks

Hi Not sure if you mean Tabs or fields.. If its fields then in each property of the field is a section called Tab Index.... You can set these in the order you want them to be accessed so 1 first then 2 second etc.... no matter where they are placed on your form they will jump to the next...

Hi Sorry I am just not getting it..... not sure what you mean by my survey type need 's I think you meant add ' around combo38 which I have, but I get a compile error on that line of code any more ideas please and thanks as always.... Private Sub Command98_Click() On Error GoTo...

Hi I have added the code and adjusted to my field names etc... but I get an debug on the lione I added... any ideas..... Private Sub Command98_Click() On Error GoTo Err_Command98_Click Dim stDocName As String stDocName = "testquote" DoCmd.OpenReport , acPreview, , "surveytype = "...

Hi Ok I have a form called formquote. In this form I enter quotes. If I ahve Quote Number 5 up, this is the current quote I want to print. It as a Surveytype of Demoltion..... Becuase our reportsd have different headings depending what type of survey it is. Therefore I have a query that...

Hi Not 100% what you mean.... If I create a button called Print with the wizard, I then go in and put the line you mentioned will this work Docmd.openreport demoquote, acpreview, , "surveytype = " Combo38 (badly named combo I know), How does this alos get the current record? I assume the...

Hi What I was really wanting to ahcieve is basing the reports on 3 exisiting names in an existing combo box Demolition Management Cobination. So if I Quote number 3 which is a demolition quote then when i click Print it looks at the surveytype = demolition, Then runs a query called...

Hi I am creating a query that will bring many tables toghether. the tables are from Mysql, but I ahve created input forms etc.... with no problems with data etc..... So when i came to create the query I added the tables like this tblequote tblwsurveytype I ran these two and no problems...

Hi A couple of questions I hope someone can help me with. I intend to create a set or reports and depending on what the combo box says on the quoatation survey type status will depend on what report is selected. So if in the combo box it says "Demolition" I would like it to print the...

Hi CBrighton I out in the new code as suggested in the ONclose for subformclient and it still does not work (the combo box name as changed but shouldnt make a difference) Forms!formquote!cboQclientid.requery Same message as above Microsoft Access cannot find the object...

Hi Bob Sorry about this I realsied I had changed the combo box name so of course the event was looking at the old combo box name. I have reapplied the correct name and this is ok..... However and this is part of another Post I have on here but dont seem to get anywhere, perhaps you could...

Hi Bob I ahve applied it to the main DB, but it appears to ahve knocked out my notinlist event proceudre. Basically if I typed in any name and it was not in the list I YES/NO message box that came up and asked if I wanted to add a new one or not, then it went to anothe form... Any ideas...

Hi Bob I just tested your copy and it looks perfect. I will apply this to my main one tomorrow and see how it works, should be ok so long as I put the details in correct. Many many thanks

opps sorry posted to soon Hi Cbrighton I have added this to the OnClose event on the form subformclient. Forms!formquote!subformclient.requery When i try and run the routine OR go into the design of the subforclient I am getting this error message Microsoft Access cannot find the...