Search results

Sendobject - resolution! What I gave you was not a macro but rather code for an event . Pleased it worked & your welcome... CarolW CarolW

Sendobject If Blank Yes- in the reports 'Design View'. Click the box in the very top left corner and go into the Events tab. In between Private Sub and End Sub paste the following code: MsgBox "There is no data for this report. Canceling report...", vbInformation Cancel = True Regards CarolW

Sendobject if report is blank Hello, Try putting this code in the No Data part of the reports Events tab Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no data for this report. Canceling report...", vbInformation Cancel = True End Sub Hopefully it'll work - it does for me...

Amend Top Values - Dynamic SQL Moniker, Once again many thanks for your prompt response and pointer in the right direction. Have not had a good chance to experiment in the area of dynamic SQL but i'll give it a go very shortly. Apologies for not responding sooner... Thanks CarolW

Is there a way whereby I, or another user, can amend the ‘TOP’ value of a query via a Combo or Text box entry on a form? I have searched this Forum for a solution to this very problem but have had no success. I understand how to achieve this via the queries ‘SQL’ view but cant figure out a way...

Random Exam Answer Paper - Problem resolved.. Thanks Moniker, Your help is gratefully appreciated. I have managed to achieve exactly what I set out to do..... I learn more and more on each occasion that I visit this excellent forum.. Your timely support is most welcome and extremely...

Report - Random Exam Paper Many thanks Moniker, What you said makes sense. What I'll probably do is create a cmd button that will trigger my original union query to make a table as you suggested. I'll then follow your instructions about creating the two reports but what i'd also like to do is...

Hello Everybody, I have a burning question; one that I hope might be answered, concerning a DB that I have. Dare I say it; my project ‘successfully’ generates ‘random’ examination questions for me. If I speak to loud it'll certainly crash ...ha! ha! The control source of my report is based upon...

Code Window - Problem Resolution (Big Thanks) Thanks for all of your previous help RG.... I have learned so much from these forums in such a small amount of time! The excellent advice I have received, on all occasions, coupled with the members patience for new comers like myself is...

Code Window - Problem Resolved (I think) Thanks Oldsoftboss, I managed to resolve the problem, much to my surprise, by re-naming the modules by adding a 1(or some other figure/text) to the end of each respective one. When I started up my DB the problem with the code window had miraculously...

Code Window - Problem Still Persisting Thanks RuralGuy, I'll try what you have just suggested and hopefully that will sort it out?? Failing that I will post it onto you at the earliest opportunity. Once again many thanks for your help, time and assistance on this matter. Regards CarolW

Code Window - Still Having Problems Hi RuralGuy, As you rightly guessed it, I do indeed have an AutoExec macro and have tried to rename it to something else?? However, if I rename it to something other than autoexec then it refuses to act automatically and in the manner that it was originally...

RuralGuy, Thanks for such a quick reply - very much appreciated. I am using an Autoexec macro....?? When I use the <SHIFT> key there isn't a problem and this annoying window is not present. Do you think it could be this AutoExec macro that could be to blame. I would really appreciate any...

Good Afternoon, Could some kind person please point me in the right direction as to how to stop the 'VB code' window appearing and remaining on my task bar when I initially open up my DB. When I look at whats in the window there seems nothing untoward, but I would simply like to get rid of it as...

jfgambit, Many thanks for your quick response - sorry I couldnt reply as quickly? One question for you and that is, exactly where and what do I do with that code.I have a command button on the form but Im still a learner at this kind of stuff and so haven't got a clue as to how to use your code...

Good Evening , Could somebody kind person out there please tell me whether or not it is possible to automatically re-size a bound OLE object frame in a report so that it grows or shrinks in size to accommodate pictures of varying sizes. I have managed to incorporate a similar feature in a form...

Good Evening, Could some kind person out there in the world please tell me whether or not it is possible to automatically re-size a bound OLE object frame in a report, so that it grows or shrinks in size to accommodate pictures of varying sizes. I have managed to incorporate a similar feature...

Good Evening, I wonder if anyone could help me please......... I have found Ghudsons attached ‘Browsing2’ example to be of enormous benefit/use to me when I have been creating various Databases, however I was wondering whether Ghudson or any other kind person(s) would either show or point me in...

Hello Everyone, I have encountered a problem at work wherein I have tried to create a DB that genereates a random exam paper based on X amount of question. So far everything has been just fine..........!! Recently however, and to be short, I have received an error that relates to a missing...

Select Equal Type - Based On Random Query (Grateful Resolution) ejstefl, Perfect - Thank you ever so much... Now that I have seen what you have done using my incomplete attachment I can now begin to recognise what is required, and the thought processes that actually occur behind the...