Search results for query: *

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...

I have a string that contains the name of a form, something like “Update Requests 1”. It has to start as a string because the digit at the end will change based on user interaction. The digit could be up to 99 so a giant case statement is unmanageable. I need to populate a variable of data type...

I had a program written in VBA which called a PowerShell script to create Exch2010 mailbox accounts for new users. Worked fabulous with Access 2003. We moved our Databases to a newer server with Access 2010 on it. I have checked reference libraries and anything pertaining to the code -...

I had a program written in VBA which called a PowerShell script to create Exch2010 mailbox accounts for new users. Worked fabulous with Access 2003. We moved our Databases to a newer server with Access 2010 on it. I have checked reference libraries and anything pertaining to the code -...

I think that is why my boss thinks it's possible - we do a lot of FP coding. We are looking to write a database but have to use a web interface and my boss thinks the easiest way to gather the data would be to have an array dump so he doesn't have to write field to field.

Is there a way to store an array in a SQL server record such that elements can be retrieved using array indexes rather than having to specify specific fields in a built DB.