Search results

Banana, No totals. I'm using it in a list box, and it's for an approval process. The crosstab will show all of the columns/values needed for the user to make the determination of whether to approve it, but at the end of it, I was going to have a notes column that is going to be rather wide...

That's actually the direction I was working in, but have never had luck with unions. I gave it a few tries, but I don't know what I'm doing wrong. TRANSFORM Sum(tblProductionInputDetail.ProductionUnits) AS SumOfProductionUnits SELECT tblProductionInput.ProductionID as PID...

Hi guys I'm hoping this is even possible. I have a crosstab query and I noticed the Column Headings and Values are always shown last. I have another field that I need to show after the values. How can I alter my code to do that? Thanks, Joe TRANSFORM...

Yeah, I had a feeling... Thanks for looking at it anyways

It's also probably worth noting that this file was originally 2007 MDB, then I went to 2003 MDB for the ULS. I tried another compact and it bombarded me with error messages.

Yeah, that was the first thing i tried. What happened was I couldn't even get the thing to open in design mode, so at that point I did a compact and no dice. Then I figured I'd delete it and add it from a backup, and that's when this problem came up.

Here's another showing the remove grayed out.

Lol, if that were the case, I'd hang up my hat now!

yes, there should be 2 screen shots in there...one of the message and one of the VB

I'm adding to the front end, so this version is not really in use yet. I have a script to copy the MDE locally on every startup, and that's how I generally deploy it.

sure thing

Not sure why the pics didn't show, here's a link: http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk1.jpg http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk2.jpg

I'm not sure what you mean by Production Database. I know I used the word production in some of my forms, but it's possible that I may have used it out of context.

Does that have any effect on the security and MDW file?

Hey guys- Access is being weird again. I'm using 2003 and I removed a form (frmProductionStep5) however it is still showing up in VB. I even get an error upon opening VB: The form name 'frmProductionStep5' is misspelled or refers to a form that doesn't exists. If the invalid form name is a...

I had a feeling I was missing something there, and I'm not 100% I quite have it. So from what I read, it keeps the connection contained inside of a Function therefore any error is handled within that function. So by adding the error handling lines of code, I can keep the connection all...

Wow, that is really helpful! I actually kinda structured it like that just without the error handling and I made the function public: Public cnProductionDatabase As ADODB.Connection Public Function OpenADOConnection() Set cnProductionDatabase = New ADODB.Connection 'DEFINE LOCATION OF THE...

Funny thing is that I use public variables all the time, but they are strings. I guess it just never dawned on me that I could use it for an ADODB.Connection as well. Plus I never had to work with a connection before, I always used currentproject.connection. Now I'm pulling stuff into excel...

Wow...that was really easy...Thanks Paul!

Hi guys! I seem to be having trouble with ADO connections. I want the connection to work on a public level so all of my functions and subs can use the same connection, without having to keep redefining and opening it the same connection (I also get an authentication error whenever I try this)...