Search results

Just wanted to say what a great website this is and how much it has helped me. I am learning so more and more and I am trying to help others as well!

Hello all, I have a quick combobox question. I am having a brain freeze :( right now and for the life of me can't figure this out. I have a combobox with SupplierID info. When this box is changed to a different supplier, a subform changes to list the items for that Supplier. Basically, what...

I am trying to get a Data Access Page up and running in Access 2003. I have the page up and all the data is there and looks nice. So, I find out that I can't update my data. Anyone know why that would be?? Second, if I get to the point of editing the data, is there a way to limit what can be...

Doc Man, I would love to but I think that this is a little out of my league. I do ok with coding but I am no expert by any means. Well, are you talking about doing a "On Error Goto ErrHandler" type thing. That I am familiar with but I don't know if that is the same thing as "trap handler"

ChrisO, Just wanted to let you know I found a workaround (this really only applies to me in my situation though). In conjunction with all what I was doing, I also created a custom menu. In this menu I have an exit button. Here is the part you will like...instead of writing my own code to...

I am so glad my pain and suffering could educate you :) I don't think I can do dialog mode because sometime these reports are run from a Outputto call and sometimes it is called from an open form call.

Rubish is right!!!!!!!!! Anything I can do except delete all button exits and force the users to use the X or file - exit?

At this point, it looks like there is a difference when I close out of Access through the "X" or "File -- Exit" vs. a self made Exit button. The code for the exit buttons are: docmd.quit I have tried application.quit acSaveAll but no luck So, I am now wondering what the "X" button does that...

Thanks for all your guys/gals input!!!! I think that I narrowed it down but I am not quite there. I figured out that when exiting the DB, if I exit with the "X" or go to file -- exit, code work perfectly. It add in the strLocation just fine. However, if I click on a self made Exit Button...

Thanks for the explanation Doc Man! I get the feeling you know way too much!!! :) Is there any downside to putting the strLocation = "ABC" in the Lost Focus event of my main form (i.e. form that is alway open)? So, it would update more often and even if it loses it, it might get it back? -Stoss

Err, I apologize, I made a mistake in my wording earlier. I put the call to the function I made in the Unload Event not the close event. Still doesn't make sense but I thought I should clarify. According to access, the order of events should be Unload - deactivate - close. -Stoss

Thanks Chris, I checked it out and that makes sense but I don't think I am having that issue because I can click on anything it the value stays. At this point, I put a watch on strLocation and it never changed (i.e. went blank). So, my thoughts at this point are it is causing some kind of...

I need the variable because I don't just use Open Form, I also use it in Outputto and with Outputto you can't pass openargs parameters. I have a watch on it now and I am doing everything I can to break it but it is holding steady.....err...just when you want something to break it won't. -Stoss

Thanks, great minds think alike (probably should have thought about it sooner though) I was just about to do that. Here is a question I just thought about. I am running the code in module1 for the automated reports which launches on the Form_Close event (i.e. when exiting the DB). Do to some...

vbaInet, this brings up a good question at this time. As posted earlier, I declare it Global strLocation as String in module1. I set it strLocation = "ABC". Is this correct or do I have to do something more "fancy" like -- Set strLocation = "ABC"? I am not that familiar with Set and Get...

Points replies... 1. I believe it is being initialized because sometimes it works. So I think this can be ruled out. 2. Unhandled error....I am not detecting anything but maybe I put "on error resume next" somewhere and there really is an error that I am not seeing. 3. I did a search and...

I set the var strLocation = "ABC" in the Form_Load event on the default form that opens. I declare the Global variable in Module1. This variable is used from another form "frmReports" using an docmd.OpenReport call or it is also used automatically using code in Module1 in an docmd.Outputto...

I have a access 2003 database. I have set up a global variable in Module1. The reason I set it was to indicate what location the access database is using. I have 3 access databases that are using the same DB structure. Oh, I used a global variable because different areas of the DB runs the...

Thanks for helping! I found that it was formatting code that I put in. I put it in report formatting and for some reason, it would hang up the printing (printing to printer or PDF). So, I moved it to the activate event and everything seems to work fine now. Still not sure why the hang up...

Hello all, I was wondering if someone could help me with this. I have some reports that won't print. If you send it to a printer or PDF it will just hang. The reports come up just fine, they look great just won't print. Thanks in advance, -Stoss