Search results

Alright, first off, I'm not even sure this is possible. I'm working with Access 2007, too. I have a report that is based off of a very simple query that requests a part number. I know you can select a particular amount of records to be returned in a query (All, 5, 25, 100, 5%, 25%). What I'm...

I figured it out with a little more tweaking. Thanks!

Yes, I have it summed by the Job Number, but that only makes it sum the pallets that have the exact same quantities.

I have a query that, for the most part, sums the data for any given Job Number. My problem is that 9 out of 10 of the job numbers are the same--9 pallets all with the exact same parts with the exact same quantities... And then the 10th is an oddball. So when I run my query, I get a summary of...

Thanks so much for your help. ^_^ Now, on to the rest of the kinks!

Holy cow, I am massively blind. I figured out the problem--the qryAFNEXTTRUCK query was tied to the wrong union query. Sorry for the massive amount of confusion. *palmforhead*

And I've been playing with it more... As far as I can tell, the error actually traces all the way back to the query. qryAFNEXTTRUCK For some reason, it doesn't seem to want to work correctly...

I couldn't fit the whole thing, so I uploaded it on a different site. Hope this isn't too confusing for you... If you have any questions, feel free to ask. http://www.fileden.com/files/2006/7/13/128238/ASL%20Database.zip

Okay, here's what I get when I do that: Option Compare Database '------------------------------------------------------------ ' mcrAFTRUCKOUT ' '------------------------------------------------------------ Function mcrAFTRUCKOUT() On Error GoTo mcrAFTRUCKOUT_Err DoCmd.OpenForm...

No, it's not open at all. Nothing is open to start with--I'm just trying to open frmAFOUT.

When I try to open the form, I actually don't get an error, I get a request for a parameter. It asks for these three in a row, if I don't type anything in and just hit enter: Forms!frmAFPRINTTRUCKREPORTS.Start_DatesForms!frmAFPRINTTRUCKREPORTS.End_DatesqryAFTRUCKRPTUNION.NEXTTRUCKIf I click...

There should be a way to put the setvalue kind of function into VBA coding, right?

I'm running it as an '07 file, and I just opened up the '03 in the '07 version, so I assume it's converted. I'm not familiar with how '07 works at all yet. :(

Thanks... I already found that link though. I figured out how to find it. I'm still getting the error message when I try to run that particular macro though. I've made the folder my database is in into a trusted location, but still no good. The weird thing is that the error that keeps...

I have several macros in a database I was creating with Access 2003. My boss switched us all over to the 2007 version, and now I guess you can't use the SetValue macro option in the same way. I was using it to set a field in one form to match what was in a field on another open form. Now it...

Thank you so much! Worked like a charm!

Hey, I tried looking for answers to this, but unfortunately the words I'm using in my search are too small or too common. I've got this union query: SELECT Max(tblAFIN.[TRUCK]) AS [NEXTTRUCK] FROM tblAFIN; UNION ALL SELECT Max(tblAFOUT.[TRUCK]) AS [NEXTTRUCK] FROM tblAFOUT;And I only want it...

Thanks! I'll see what I can't do with that. =)

I have two tables, a "Product In" table and a "Product Out" table. They have lots of different products, each skid of which is labeled with it's own unique ID. The In table will only have one entry for each pallet ID, the out table could have several of the same pallet IDs, and not necessarily...

I have a button like this, but when I click "Cancel", I get an error message. I'm pretty sure this is because nothing has been changed, so nothing can be undone. Is there a condition I could add before the "Runcommand" condition so that it only runs "Undo" if something has been changed?