Search results for query: *

Didn't mean to set you off, I'm sorry. When I hear "your code", I think of code I actually wrote. ShowCase is a user-friendly tool that writes all the SQL as you select to fields/tables/data to pull from the system. Thank for taking the time to view and help troubleshoot my problem, though! I am...

No. We use a tool called ShowCase query here. In the tool, you name the file it outputs to. ShowCase names the file and the tab name.

When I hover the mouse over rCount, 42 appears in the box. However... I found the issue. It was a 2003 to 2007 upgrade issue. The query tool I use names the tab to the queries name. In 2003, it could be as long as it wanted. In 2007, it was cutting the name of the tab in half. I put in some...

That was something I added, when trying to see why this bombed. It made/makes no difference. It actually isn't in my code at the moment.

The same error will reappear.

Yes. When the error comes up, I hit debug and that is the line it takes me to. I just don't understand why, all of a sudden, it quit working? I haven't changed a thing, except the MS Office upgrade (2003 to 2007).

42

I run a weekly report each Friday. I was on vacation last week. When I try to run the macro, I get the error. This has worked for years, but now crashed for some reason. During my vacation, I was upgarded to MS Office 2007, could that be the issue? With PolicyD.Sheets(1)...

Hey PHV... Building Macros and Forms isn't as bad as I thought. I was able to use Macros and Forms to do everything I needed! Thanks

I just made a form that runs the queries... Can I auto import tables upon opening access?

Hello... I am very new to Access VBA, VERY NEW. I do well with Excel so I have a little background, but Access is a different monster! I have 15-20 queries that I would like to auto run with a press of a button. I have (just a partial testing code): Sub Run_Queries() DoCmd.OpenQuery...

Thanks, Skip... I'll check it out!

OK... so I figured this out: Sub Run_Queries() DoCmd.OpenQuery "01_PIF Counts" DoCmd.Save acQuery, "01_PIF Counts" DoCmd.Close acQuery, "01_PIF Counts" End Sub Is there a place, where an end user could just press a button and make the code go? I'm sorry... I'm very new to...

I have never coded in Access' VBA (just Excel). Is it possible to create a macro that will run all of the queries I have set up? If so, how? Some query names are: 01_PIF Counts, 01_V12 Disc & 01_V12 Unique Pol Thanks! Josh

Thank you!

Ah... My 2nd machine doesn't have Access. How do I go about installing it independently?

I have two computers at my desk. 1 uses Excel 2003, the other uses 2007. I created a UserForm calendar using the following websites method. http://www.fontstuff.com/vba/vbatut07.htm When I try to run the macro that used this form in Excel 2007, the VBA is bombing out. I tried to follow the...

Hey Skip... Thanks for the bump in the right direction. If I run into any problems, I'll post. Thanks, Josh

Hey Skip... I guess I could have been a little more clear. Yes, I created the calendar's but the 'Names' sheet is not mine to adjust. It is a file from my dad's work, and they need to see it in the calendar format. I told him I will see what I can do, but if I can't figure it out, he was OK...

I created it.