Search results

As far as I remember, the "solutions9" database dowloadable from micro$oft has a module for adding a rectangle around reports

Thats good and works! Is there any way to run the deployment wizard straight from the operating system without opening access? Thanks

cosmos - How d'you wrap up your mde into runtime? I thought it needs to be initiated from vba but with mde one can't get into vba? Thanks

Chris I am not insulted. I did not expect any full solutions. I am quite happy playing around and modifying any code. I am merely informing you that when I opened your db in access 2000 whether I converted it fully or whether I opened it 'as is', it came up with an error saying the macro...

Hi Chris Downloaded your db (I am using access 2000) but the autoexec gets stuck. do you mind to check it please thanks

Thanks Pat I don't think i will need to isolate the path if I put the be in the same dir as fe. I could just say it is in the same directory I will try and extract the rest of the code from the solutions db thanks again for all the help A Happier YN!

Yes Pat I am also mighty glad to see you although Jack has been helpful Yes I was looking for someone to show me how to exract the path from the ini and teach access to link to it. However your wise words have shown me a seemingly simpler solution and that is to always have front and back end...

the ini file would be a small file unique to each user. The user mustn't move his backend! He musn't even know it exists!!!

No!!! That won't work because that pathis different for every user and when the program loads up it will not know who is the user unless I tell it (e.g. by reading information on the BE) and it cannot read the information before it knows where the backend is! so wer'e going round in circles...

Thanks for bothyour replies. I downloaded and scrutinised the MS example in solutions.mdb. This requires user intervention in pointing to the correct location of backend. I would like to write a small ini file which resides on each users pc. It would contain the users backend address. As access...

Some of my clients have their BE on a local directory & some on a server. Can I code the VB on startup to look for the BE in a different location depending on who they are? Thanks

I can't seem to format my listbox so that the field which is true/false should show as a checkbox either with a tick inside or not. Even if I format the source of the listbox to a on/off field, it still insists on showing true or false Any ideas? Also anyone know how to format a listbox so every...

More information Thankx for replies Pat No -To my knowledge I have no such code. What I do is select a value from a combo. on update I do a dlookup in a table to obtain a value of a field which gets placed in this textbox so I can edit it. As I said , before I invoke any SQL , as soon as I move...

An unbound textbox on my form has text typed in e.g Tivi'i As soon as I tab away from the form I discover the i (last one) has become capital I. Without the aposrtophe it does not change. It only changes for the letter i Whats going on? Thanks

Sorry for delay in reply Rich All the access toolbars are disabled (not shown) while my file runs. I have one custom toolbar which I want to turn on i.e make visible when any report runs and turn off if all reports are closed I am therefore looking for code to run when any report is opened...

Hi David & thanks for your interest I read thru both the links. I already have a combobox in my report launcher form to preview/print reports working fine & I could set the open event from there but that would still entail adding the close event to each report unless I run it as a macro off the...

Thanks rich thats nice and clear but I notice you 'ignored' the first part of my last post?! Is API too difficult for an amateur like me or could I dare ask for your code? Thanks

So Rich are you saying after all this that I can' have a code applying when any report is opened?:( and how do you get to a button on a toolbar to put code behind it? Thanks

So where do I put this function? Surely not in each open event of a report, I wanted to avoid this?

Thanks rich Thats what I needed Does this open & close the toolbar or do I need to create a function for opening & a similar one for closing? Thanks again