Recent content by Alleyopp

No other event happends after the click event.. I wonder if you can create and event using the WithEvents?? Alley

That did it.. I put some DoEvents between each major processing section in the procedure Print_Quad_Chart_FY05 and that lessed the amount of processing between when the cmdCancel_click event was triggered.. You can also see the button is depressed. I also ended up having to disable all the...

Someone wrote on this topic at microsoft.com Access group.. http://www.microsoft.com/office/community/en-us/default.mspx?query=limit&dg=microsoft.public.access.gettingstarted&cat=en-us-office-access&lang=en&cr=US&pt=327f343d-f0d6-4e07-aa53-9656edb98ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us...

In my cmdPrint_click code I put in a DoEvent to allow the user to click on the Cancel button.. This works find but.... You visually can not tell the button was depressed. It also takes a while to trigger the cmdCancel_click and since you can't tell you depressed the button you tend to sit there...

New issue.. The DoEvent works great.. but you can not tell if the cancel button is clicked.. When a button is clicked the shadowing goes to the botton so it appears different and looks like it was depressed. However when you click the button it does nothing.. so the user can not tell if they...

Thanks much that does it.. I will have to do some reading on DoEvents.. It looks like it is very useful.. Thanks Alley

This is what we do so the user can leave the generated exel doc open but close out the exel resources.. objExcel.Visible = True Set objExcel = Nothing Set gwb = Nothing Set gws = Nothing Here is the code to set up the excel doc.. Private Sub setup_print(Optional fname As String, Optional...

I need to be able to allow the user to cancel a print job. The form allows the user to click a print button to print out multiple reports. Actually it gets the data from the DB and puts into the word form then prints it out.. It continues thru the recordset until all the Reports are printed. I...

I have created a query in Access that gets data from a table and also adds a blank colomn. I want to put this info into a recordset and then populate the blank column for the specific rows.. Its a totals column.. I dont want that info put back to the db. I am attempting to do this by creating a...

I have created a querry in access and I have added a blank column.. What I want to do is create a recordset with the query then disconnect the recordset and update the blank field with data.. Then at the end I have to display all the info in the recordset.. I do not need the database but to...

I already have.. It does not explain about the DSN and TNSNames file and how they fit into the picture..

Ok, this is probably a stupid question but bear with me.. I have a VB6 front end with an Access back end and I also connect to an Oracle DB.. It is time to do the build and right now we are building the Oracle ADO connection string using DSN.. Is there a way to not have to worry about puting...

You could also create the form as a MDI form.. Then you can open as many copies of the form as you with.. I just clones the parent form. Alley

Thanks Much..

Thanks appnair for the info. It looks like you sent the info about the same time I ran across it in the doc.. Yup, been doing LiveLink for about 3 days now and my code was due yesterday.. Dont ask.. So, right now I am attempting to assimulate it as fast as I can. It would have been nice if in...