Search results

Thanks for both of your advice. I'll play more with this and see where I go. Dan

Hi all, A little more explanation... I am tracking the delta days (both positive and negative integers) between the date a job arrives in our facility and when it is promised to ship to the customer. Ideally, all jobs arrive before their schedule ship date, but when they don't we note a...

Hi all, A frequent lurker, but a seldom poster. I have read much about Workdays user functions that screen out weekend and holidays. The examples posted are understandable. All those I have found do not deliver positive and negative results, rather absolute differences. I am seeking a...

Thanks for the assistance. I resolved the problem overnight by uninstalling SQL Assistant, a program I seldom use. Dan

I have tried creating a new blank database and importing everything into it, but the noted behavior follows into the new database. Thanks for your assistance. I will keep working at it. Dan

The reserve words I am using include on, when, select, null. All these words cause the same effect in that once entered, the words seem to autocorrect to all caps versions of the words, e.g. ON, WHEN, SELECT, NULL. As these are reserve words that I know are SQL reserve words, as that entering...

I haven't experienced any difficulties using reserved words in Access text boxes before and notice this behavior in only one form in the database.

Interestingly, this occurs in only one of the forms in this database, though in all of the text fields in this form. I would like to see if I can figure out what is causing this problem, rather than just rebuilding the form from scratch. Since all my text boxes are affected, I feel it is a...

When I enter the word on, it corrects to ON. When I enter other words I know to be typical VBA/SQL words, such as select, it corrects to SELECT. Also interestingly, when I add a period, a dialog box opens that asks me if I want to use SQL Assistant to connect to a database. I do use SQL...

I am having difficulty overcoming this problem. When I enter text in a field that is a VBA phrase, it seems to autocorrect to the capitalized VBA phrase. I have tried deselecting all the spelling autocorrect select boxes and have set the properties in an affected field to No for allow...

I would like to add a Sort Criteria field entry to a table based on input to another field. In this case, I want to automatically add the number 1 to an existing Sort Criteria field when the Issue Status is selected as Hot in this field. When the Issue Status is selected as Active, I want the...

Combo Box: Multiselect dcx, Thanks for your reply and advice. I get impatient with myself when I'm learning something new...I want to have the background and understanding that will happen over time... I'll do some more research so I understand the goodies under the hood a bit better...

Thanks dcx, I've now made a small dummy database using List Boxes rather than Combo Boxes and can select multiples from my Issue Owners list. One further question, if you have time... I am using QBF to drive this query and wanted to select multiples of many lists for query parameters. When I...

Be Gentle My Learned Friends...Neophyte Learning the Ropes... I am seeking to be able to add a Select All function to a QBF Form. I now select multiple options from Combo Boxes and would like to have one-click, one-selection ease for users to select all within one Combo Box. Ideas? Thanks, Dan

I have set up a Parameter Query to build a query based on one selection from two separate lists....and would like to determine if and how to select multiples or all from each list... My Parameter Query currently lets me select from an issue status list, i.e. active, pending, completed... Then I...