Recent content by mrgreen

I posted another thread about importing but I thought I'd just try to export the data from Access into Excel. It doesn't happen all the time but I am randomly get a 1004 error "Method 'Rows' of object'_Global Failed" It doesn't happen every time and when it doesn't happen all is good with the...

Howdy, I have written a Function to calculate the Monday of any date that is entered into my db. This works great and life is/was good until I tried building a front end in Exel for graphing purposes. When I try and run my code I get a Runtime Error saying Excel doesn't recognize the...

I apogize if this isn't the correct spot for this post. I have a program that was written in Access 2003 then went to 2007. For some reason on some users computers I can't utiilize the "Microsoft ListView Control version 6.0" My pc is fine but with others I get "There was a problem accessing...

Hi Nick, I know this is an older thread and I'm sorry for not getting back to you but thanks for the reply and yes what you gave me really helped. Thanks a bunch!!

Howdy, Haven't posted in a while so I thought I'd drive someone crazy (hope not). My company recently moved into Office 2007 so I need a little assistance. I created my customized ribbon but I'm quite confused on how the callback works for getVisible or getEnabled. When I open the database the...

I'm somewhat new to Access 2007 and I have a large form that is not a popup and no border. When I open the form I HAVE to scroll just a bit to get my form so it's viewable. I've never had this issue in 2003. I do have DoComd.Maximize in the Open Module. I do have a Function that resizes the...

When I open my application I simply hide my Menu Bar then when I close my form I make it visible. This works when I step through the code but in real time I lose my Menu Bar when I hold the shift button and open my file. So now when I open every other Access database or even go to create a new...

I took out one of the .Repaint commands and it seems to be a bit more consistent. If anyone has any other suggestions I'd be happy to hear 'em. :)

I know this ? is form related but I'll start here. I'm writing approximately 2700+ records from Excel 2003 to Access 2003 using an ADO connection and I have created a status bar. When about 30 - 40% of the records are recorded the status bar quits updating but the records get sent up...

First, my disclaimer, I haven't seen this in person but am told it keeps happening. I created an Excel Add-In and it works really well. I then gave it to some colleagues and it worked/works really well. I then hear that when they have given to others they get an error stating it can't find...

Attached is the front end of the db. Let me know if this isn'twhat you need. Thanks Again!

Sorry, not sure what exactly you need to see? I've attached (I think) a screen shot of my Start Up Screen. Thanks for the reply.

All, Not sure if this should go in the VBA section but I have some code that restores the Menu Bar during the Unload Event but when I hold the Shift Key to view tables and stuff I have no Toolbars. I have all the checkboxes marked under the Startup option and am not seeing the issue. Thoughts...

Outlook doesn't have a DisplayAlerts. I'll check it out but from my research I need to install 3rd party material to remove the popup. I was just hoping Access had a Windows function similar to Excel. Oh Well. Thanks for the help.

Hopefully this is the right section. I have some code that automatically generates an email in Outlook and I'm not smart enough to get around having to click the "Yes" button notifying the user he/she is going to send an email so whats the best way to put the focus back on my Access form? After...