Search results

Nigel, Oh if only InputBox had Data Validation...I suppose I could build the DV into the code, and loop until they get it right and/or parse/format, but I don't know, something just rubs me the wrong way about doing it like that, and I can't quite put my finger on it. Good catch Chris... It's...

Sorry it took so long for me to get back to this. Nigel, That is a pretty easy way to get it done. At first, I was concerned with the situation where a date range would need to be used, however, an easy solution to that would just to use two inputboxes :banghead: and combine the dates with a...

Sorry for the incredibly late reply, I never checked my PM's until now! April 15 causes a great deal of grief annually by way of finishing all of my clients tax returns on time. In other words, it's when taxes are due to the IRS, and I run a CPA firm

But wouldn't there be ambiguity in the global variable's value once multiple instances of the form were opened?

Hey guys, I have an situation where i need to instance a form in lieu of docmd. I'm trying to make a general purpose date form that loads on report_open when there is no date already in the report's openargs property (mainly for when it is called on it's own from the Nav Bar and not from...

(Found on a search)

As somebody just delving into classes, I too have often asked myself, 'why not just write a standard mod function instead of a property' or 'why not put all of this code from the class I just built into the form's class and call the form'. But in hesitating, and writing it in a class anyways, I...

Thanks Mark, that is really cool! Interesting more than anything.... I'm still trying to wrap my head around it. I had to edit this post because the first time I ran the code, it didn't run buildlist sub, but it is now. Thanks for the insight, these classes are really cool and after playing...

'Well, if it makes you feel any better, you certainly didn't bore me. Thank you very much for the information. I know I could use a UDT for this, but I love working with this stuff and the constant challenges, and I love the fact I learn something new everytime I program in it. So while I...

Hi- I am pretty new to class modules, properties, methods, arrays, etc etc. I'm trying to learn more and in doing so I've run into a snag that I just can not get past. Moreover, it's probably my unfamiliarity with arrays, when to use parentheses, when not to use them, how to dimension them...

Hi, I have a query that needs to have a date entered into it, but the same date needs to be entered into different locations within the query. I know I can make a dialog box come up and ask for user input, but since it is in multiple places, I don't want to have the date dialog box come up...

Genius is 1% inspiration and 99% perspiration.

Oh, I like your idea way better, forget the subselects! Thanks Paul! Joe

Hi, I am trying to create aging columns using a sub-select. The query is to list each account, then age the amounts via columns. My problem is that the column it creates with the subselect shows the total amount for all accounts rather than the single one I am trying to resolve. I think I need...

It is going to be either 2 alphanumeric characters or blank- "". That is why I am trying to get rid of the spaces.

I originally tried that, the spaces return an asc() of 32 which is what is so darn frustrating about this problem. From immediate window: ?asc(right(strAccountPrefix_LOB, 1)) 32 ?asc(right(strAccountPrefix_LOB, 2)) 32

@mdleuck: I tried that code and no luck. @spikepl, It is ultimately going to be used in a query's criteria. So the query is failing because of the space. Otherwise two alpha-numerics will be in there. I tried the following codes and no luck there either: strAccountPrefix_LOB =...

Hello all- Having some trouble with some of my code below. There are times where the strAccountPrefix_LOB variable is either blank or 2 characters. Because it is being dimensioned as 2 characters, when it is blank, it gives me spaces. The spaces return an asc() of 32, but the spaces will...

-Last name -First name Any multiples or not founds are left blank and looked up manually.

Almost. The accounting system is going to give us an export of the users and thier permissions. I need to email the users' supervisors to verify the permissions in place are still appropriate or if they need to be changed/removed. It's basically an entitlement review. To add one more layer...