Search results

Hi David- It doesn't return a Boolean, it returns a date. Basically it gives me the last friday of the workweek Ex. lastdow(3/3/2009) = 3/6/2009 Public Function LastDOW(ByVal dtDate As Date, Optional intWeekBegin As Integer = vbUseSystemDayOfWeek) As Date LastDOW = DateSerial(Year(dtDate)...

Great! It is much faster. Still a little slow, but at least now it's tolerable. Thanks again for your help :) Final Code: SELECT lastdow([FinalizeDate]) AS CompleteDate, IsNull([finalizedate]) AS Expr1 FROM tblProductionInput WHERE (((IsNull([finalizedate]))=False)) GROUP BY...

1. The finalizedate column has the same date listed several times so I get the same lastdow (I think you caught on, but it's last day of week just in case) listed several times. 2. Hmm, that makes a lot of sense, but I could never get the Gropu by clause to work. I have another situation too...

Hi- Sometimes I like to take UDF's and insert them into my queries in access. However, it seems whenever I do this, it takes and incredibly long time to process. Any idea on how to improve this? Here's a sample query that takes forever to load: SELECT DISTINCT lastdow([FinalizeDate]) AS...

Thanks, lol! Now, Sam Fox, that's a new one!

Ya know, the IRS doesn't even know how they are going to handle the Standord/Madoff problems. I read an article in the WSJ that some are claiming it as theft losses. Since the income recognized in past years was really illusory, some are amending returns 3 years back because it wasn't really...

I'll give anything a shot. The philosophy of most of my professors was If you don't know it, just look it up. So I could probably look up most of what I need. I can do some research and see how companies are structured over there. Worse case scenario, I realise UK is overwhelmingly different...

Ok, just figured out the problem, but I still don't know how to make it work. The problem is that I can't have the focus set in the text box i'm using to search when it does the requery. That explains why when I use another object to cause it to requery it works fine. So does anybody know...

Just another observation I noticed as I'm trying to get this to work. When I do something to cause the list box to requery it works perfect, so is OnChange the right event trigger for what i'm trying to do?

I also just noticed that when I completely take it out, it returns nothing.

No dice... but that was a really informative post, thanks! It has been printed and placed in my reference file for future use! Diff example, typing 49 in txtTracking now returns 481-527 487-480 487-481 488-524 488-525 489-518 but fails to return 496-515, 498-558, 499-534 SELECT DISTINCT...

Hey guys. I'm running into a problem working with the LIKE operator in one of my queries that is defining a rowsource for a listbox on a form. I think this is a fairly simple thing, but I can't figure out how to make it work right. Then entire SQL command is below, but here is the clause in...

I completely understand, and I'm grateful you would even consider looking at it for me. As for the reassignment, the only reason I'm surprised is because I come from the school of Excel VBA where the code generally changes things for good. I was just ignorant to the fact that runtime...

I got it!! Sigh...*headdesk* As it turns out there was a residual line of code on my form open that updates the rowsource. So all along my SQL was right, but VBA was changing it without me knowing. What I don't understand is when I went back to edit the rowsource in design view it was...

I could have sworn i posted this, but I don't see it, oh well, here it is: ftp://ftp.cceservices.com user-access pass-temp09 Security should give Admin full rights. The form in question is frmProductionStep3b. It can only be opened with an openarg usually passed from frmProductionStep3a...

Leigh, I'm going to post it to our ftp site, I just have to get an account made so I can upload it. Gemma- now i would have done all this directly with an sql statement, without using the temp table That's what I think I'm trying to do. The temp table was my first instinct (and I was rather...

I originally had a junction table that was the identical structure as the parent table. But I was having other problems getting the parent and junction table to union, and I was having probs getting the junction to update the parent accurately, so I decided to simplify things and take it out.

Hi Leigh, I actually was on the right track to begin with, then I saw your example, and it got me the rest of the way...so I thought. But the recordsets are the leftovers of the original code and basically subsidize your example's append and delete queries. That wouldn't cause a problem...

Hey, that's not a bad idea. I'd really appreciate that.

Hi Guys, I'm have two listboxes: lstUnassigned and lstAssigned that (to quote LPurvis) "Assigns related records - selecting from 'Unassigned' listbox to 'Assigned' listbox entries." The problem I'm having is when I click on one to go from unassigned to assigned, it moves it over to assigned...