Search results

I gotcha. There's an FE and a BE, but there is confid data in there. Not a big deal to send to you directly, but I just don't want to post it on the internet. Could you PM your email?

I apologize, I'm not sure what you mean by sample. Tell me about it, that's why i'm so stumped.

Nope :-/ What's weird is that the first half of the query in isolation returns 1 record. WHen I add the Union and the second query, there are 0 records, so it is limiting it? By the way, I don't think it makes a lot of difference, but this is in a list box. Thanks, Joe

Hi, I'm trying to make use of the UNION SQL command, but I can't quite seem to get it to work. Here's my Code: SELECT tblProductionTracking.ProductionTrackingID, tblProductionTracking.FunctionTrackingID, tblProductionTracking.TrackingNumber, tblProductionTracking.TrackingOnly...

I'm stuck again.... Let me explain what I'm trying to do, and maybe someone can give me a better idea of how to get what I'm looking for. Put simply our company draws maps of powerlines in AutoCAD. We are hired to engineer an area, and there are several different steps (functions) to our...

Wow, that totally blew my mind. I never would have thought to do that. That's actually how I've found myself setting these up. I'll make a public function basically running a quick ado query that will return the value, or whether the record exists, etc.

That is music to my ears. Glad I didn't miss the boat on that one. Maybe it's coincidental, but it seems as if the M-M relationships are where I start to run into the problems with binding forms. None-the-less, thanks for the advice! I can always count on taking away some new insight from...

I think you are right on target. The items aren't simple: all subfunction prices are negotiated per job therefore the employee can be doing the exact same function for 2 different jobs, yet there can be two different prices (and the prices are stored in the subfunction table). If I were to...

This is precisely where my problem lies. Much of what my forms are doing would require the pivot setup. For example, I have a form to setup the different functions that our in-house employees (CAD engineers) can do for a particular job. The employees get paid not on the function, but on one...

I wanted to stick my head in on this one to comment and ask another question. My philosophy thus far has been fairly similar to duluter and have found that bound is a bit hard to work with. Then again, I have not come to a point in which I need a continuous or datasheet forms. I did however...

Ah yes, I remember my first day at a Public firm....sigh, the memories! I definitely wish you the best of luck. Did u get into a Big 4? I only lasted a year at my first place and then realized I could do it on my own. Now I'm just waiting on FL's Board of Accountancy to approve my firm. Do...

Hi- I have been getting help on the AWF forum for about 4 months now, and I am constantly trying to think of ways to give something back for everything it has given me. Unfortunately with my “newbie” status, I have a hard time doing that because I’m just not that strong in Access yet...

Hi aba- I'm fairly new myself. With respect to the the week problem, this post might give you a little insight: http://www.access-programmers.co.uk/forums/showthread.php?p=775087

I was really wondering what that was in reference to! Actually, I'm an accountant, and in US tax returns are due on April 15, so its my biggest deadline. I am however an April 16 Lover ;)

Ahh, I didn't know u were lookin to test it; sorry for the confusion. I certainly don't expect you to do anything like recreate it. I thought by looking at the table structure you would be able to determine something else that wasn't evident. I'm grateful just for you taking the time to help...

Yep, that's how I knew that the first one worked great. I'd like to get the second one to work because learning a new technique always makes me smile. I have a fresh head this mornin so after the coffee brews up, I'm gonna spend some time and see if I can't wrap my head around it. I certainly...

Oh me and my blonde moments. I gave Admin full rights in this one. So is the alias defined in the FROM clause? I tried the null one with no luck, but the one with the subquery worked. I'm still not sure what the Null part of the WHERE clause does to narrow it down. It could be that...

I didn't before I posted, but doing such answered my first question. I never knew you could just define temp tables like that on the fly. It didn't work though. It did show everything it was supposed to, but it didn't remove it from the unassigned list.

Leigh, That demo is quite helpful! I'm a lil confused on the rowsource though. I see that id references "CAT" tables but I did not see them in the object list. Is there something I'm missing here? Looking at your suggested query I don't understand how the 'IS Null' is going to filter out...

Hi- I have 2 listboxes: lstUnassigned .rowsource: SELECT tblProductionTracking.ProductionTrackingID, tblProductionTracking.ProductionID, tblProductionTracking.FunctionTrackingID, tblProductionTracking.TrackingNumber FROM tblProductionInput INNER JOIN tblProductionTracking ON...