Search results

How do I set a combo box that is based around a select query to by default display the highest date value possible as the default when the form is opening. I have a list of dates that are mmmm yy values and I just want it to popultae by default the combo box with the last month it detects in...

Is it something to do with the default value of the box being an * and then gets changed to a number field? The only reason I ask is because if I place * in the criteria section manually I get an error similar, but if I put a number in the criteria it chnages it to = 1 Just thinking aloud

Not sure whether this question should be in Sql or here but seen as it is sort of query related I will post here. I have an ADP application that contains a form. On this form is a number of combo boxes. I wish to pass the value of one of these boxes into a vw, sp or fn (pref vw) so that a...

sfreeman, I find it funny that your signature states that asking the right question is 90% of it when you consider that my original post stated "Literally nothing has changed apart from the fact I have installed and Epson printer since the last time I used it, No Windows updates, Office Updates...

Hi I deffo installed the correct drivers, however, thanks to System Restore I took the system back to the settings prior to installing it and all is well again Phew!!!! thank the maker Thanks for all your help on this one sfreeman, much appreciated Toni

Thanks for the suggestions, none of them worked though. I just don't get it. The fact taht I can't open the report in design mode says something to me but I don't quite know what I will be honest, I don't really know alot about error trapping etc so would not really know how to step through the...

I have been using a database that I constructed for a while now and all is well with it. Well all was well with it until I went to use it today, having changed nothing, and now when I click on the Run Report cmd btn, I get the The Openreport action was canceled everytime. Other people use this...

In a flash of inspiration, a solution came to me. I now have a count sub query that counts the results of the the src query and if it finds nothign in there it returns a value of 0 which is fine. I have added this to the report and all is now well and perfect. Thanks for all your support in...

I am totally confused by this now. I think I shall just cancel what I am trying to do and find another way. I appreciate all the efforts made by all but I can't get across what I am trying to do, or I can't find the right words to describe it. I thank you all for your help and look forward to...

This query is actually not fed off any previous query results. The SQL I pasted earlier in this thread is directly attacking the tables with no pre-reqs. I will look through what you have posted, my only concern is that what you have posted is based around the thought of previous queries...

I am really struggling to get this to work, does anybody have any suggestions of what I can do here. Regards

My sincerest thanks to you both :) Regards

I have a date field that contains the date in a format dd/mm/yyyy. I wish to write a query that only searches for mm/yyyy irelevant of the dd value. I can't change the format of the src table as there are other queries that require use of the full date value. Could some provide a simple syntax...

I have read this line over and over NewField:IIF([box_6] Is Null,0,[box_6]) and although I have placed this in the query, all I now get it two column headings with no rows. Have I done something wrong here? Regards

I have read your comments and I thank you for your prompt response. I shall re-read what you have said and try to implement the suggestions you have put forward. Thank You once again

Thanks for such a quick response. I have placed both query definitions below, could you assist in the insertion of the suggestions you have made please box_6_qry_1 SELECT src_tbl_act_eim.summary FROM src_tbl_act_eim WHERE (((src_tbl_act_eim.site_ref) Like...

I have a report that is based on approx 12 queries that completes a number of calculations based from an array of different tables. I appear to have two queries that if the result of either query is null, then none of the queries for the report run and the whole report comes out blank. If I...

Thanks for the suggestion, let me reword the question I have a report that runs 100 times. Each time it runs it is for different criteria. I want to be able to automatically create 100 different named PDF files, one for each page Regards

Many Thanks, all sorted Regards

I have two tables Table One property_name property_code Table Two property_name property_code ....and various other fields Table One contains information such as property_name property_code marble arch ma Table Two contains property_name marble arch but no value for the...