Search results

Coming in much later How dyou add a foating form to open on top of report? Thanks

Rather than open each report and paste I thought it would be neater to have one code that does the job That way I don't need to remember to add the code to future reports that are created BUT if there is no other way then...... Thanks anyway

18 views and no replies???

I have a toolbar I want displayed whenever a report is opened , and hidden when the report is closed I have many reports. rather than put the code into each report is there nothing global that could read: Whenever any report is opened docmd.showtoolbar "TB" true whenever all report are closed...

Help still required please! I thought it may help to solve my problem if I post the code of the calendar form that takes the openargs part of it openform and then puts the date back into it by setting the focus to it Private Sub Form_Close() 'if passed parameter then set date on control...

Thanks Pat for your reply I copied this code from elsewhere and it has always worked fine for me. It basically opens a calendar or clock form where I can select a date or time and then when I close that form, the arguement if that is the right word for it, is passed back to the textbox which...

No reply in 24 hours!!! Whats going on!! Just pushing this to the top as I need it solved Briefly: My form is continuous, and controls allow editions of records. But when I use the form as a subform the controls don't seem to gather the info to edit the relevant record Anyone come across a...

I have code which fills in a textbox based on a value in another (popup)form. This works fine but if I have this form open as a subform then although the textbox receives the focus , it does not allow the value to be filled in Code: Dim stDocName As String Dim stLinkCriteria As String...

Now thats what I was waiting for Rich! You mean make the tab part invisible and have my own set of option buttons down the side! It was worth persisting on the forum! Thanks again

Good but disadvantage in not having all controls on one form etc Thanks

Thanks Rich What I really meant was Has anyone done that yet to save me the bother? Or where could I search for such a control? Thanks again Happy YN

Does anyone know if its possible to have a tab control but where the tabs are vertically placed down the left of the control rather than horizontally across the top? I want the text on each tab to read horizontally though, not from top to bottom. Can this be done? Thanks

Thanks for reply.... Agreed but once I have the recordset in the form why can't it take the report recordsource from there. After posting I checked something. I removed page x of y on the report and it now does it in a fraction of the time. reason is that it needs to run thru it twice. once to...

A button on my form uses code to build sql with criteria based on other tetboxes etc. The resulting recordset is passed to a subform and sometimes takes a while to run but I am happy with it. Another button previews a report which opens with code specifying that the report recordsource = subform...

Try this http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=189918&page=0&view=collapsed&sb=5&o=&fpart=1

Try this http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=189918&page=0&view=collapsed&sb=5&o=&fpart=1

Good News! Thanks Fornation for your code. However it didn't work . I received the error message Module not found since it just does not recognise that form HOWEVER I was clicking around in desperation in the project explorer and when I right clicked on the formname I recieved an option show...

Alls well that ends well! Hooray its working! bjackson thanks for your samples they really helped me put the right code in the right places Chriso thanks also for your comments I tried whay you said building up the sql bit by bit and eliminated the error It just goes to show that this forum is...

Thanks alot I'll try it! You''ve been a great help & source of support

am attaching doc which shows error when I try to open report using sql as recordsource