Recent content by txgeekgirl1

Olaf - My daughter lives in Koln and does enjoy the extra holidays along with her vacation. She most appreciates that in Germany - most companies don't scoff at a 3 week vacation, especially if traveling to the U.S. or crossing an ocean. Also that between Christmas and New Years most companies...

That would work in a private company - this is for gov't. We get no breaks and have no down time. I even had an Exec Director during a tornado tell me to do what I would have done before computers. I turned to my boss and said "She does know that what I do didn't exist before computers, right?"...

Olaf - you are right - it was brut force populated because we don't do some holidays and get extra days for others. Hopefully the people we are tracking lag time for and their supervisors straighten up and get their notes in the system in under 2 days like they are supposed to. *look for...

I did an ARRAY for holiday dates from 11/24/2016 - 01/01/2024 and threw it in the bottom of the function that takes out weekends.

GriffMG - THEN can or cannot be used - I write in several languages and use just to be consistent. The array is declared and lnNewDays is also declared higher up in code as it is used throughout the function. Thanks for your input

Instead of : STORE {} TO x FOR x = Casedata_.svcdate TO Casedata_.CreateDate I used a DO WHILE STORE casedata_.svcdate TO x DO WHILE x <= Casedata_.CreateDate

Thanks guys - I got it....ask Google enough in a number of different ways :) IF Casedata_.CreateDate - Casedata_.SvcDate > 2 THEN LOCAL x, y STORE casedata_.svcdate TO x STORE 0 TO y DO WHILE x <= Casedata_.CreateDate messagebox(DTOC(x)) IF DOW(x,2) <> 6 OR DOW(x,2) <> 7...

I am trying to walk a date range using a For variable to compare to an array. I am getting a not numeric nesting error - it seems to be in the walk between the svcdate and createdate - FOR x = Casedata_.svcdate TO Casedata_.CreateDate. Any help is much appreciated. IF Casedata_.CreateDate -...

Hi Gerry - I have been writing software and databases - I have NEVER had to try to do ANYTHING with VBA in Word. My boss had a thought.... they are scary things. Thanks for the site info

So - these controls - made off the developer toolbar - unlike Access or Excel - have NO Name, No identifying information. In WORD are you just not able to backcode the controls like you can in Access and Excel? I mean - I think it's crap if you can't considering it is all VB code and you should...

DocVariables is NOT what I am looking for - I need to be able to call a named field - in Access it would be something like me.tbMyField.enabled = false JACK hasn't been good since season 3 when they let his snotty little daughter work for him - not applicable in real life. Gerry - I will look...

Hi Folks! So I have been tasked with trying to make a word doc function like a lockable database form but am running into issues. Task - create 3-5 fields with input. Create a button that when clicked the 3-5 fields lock so that entries cannot be changed and enable a Word signature block...

We are in a position where we have a series of workers that need to grab "wet ink" signatures onsite and then at times forward those signed docs on via email and have other outside entities "sign". I have been playing with Word 2010 and on a tablet we can capture signatures with a stylus (much...

So let's assume I open the form before making the call to the function to populate the Function with the form name as a string but needing to be a form, how can I then get the form as the variable into that function.

I need to pass the form name to my function as a form in a string context. Although it is not normal - because we experiment a lot with pushing Access to it's limits - we are building master forms on the fly and the values could be 1-99 so MyNum can be any of these. Function FixForm expects a...