At the start of the new year, we started using a new program called VISUAL. It is made by Infor. They have tapped me to become the "expert" of sorts on this new system. I am no expert by any means when it comes to programming, but I can learn, as I've skimmed the surface a few times for html editing a few times, and I've checked out ahk just a hair, but haven't done anything with it. Enough about me. Now to my personal project.
Our orders need to have the correct shipping date on them in this new system, else it causes problems with invoicing. Don't know why, but it just does. Why is irrelevant right now. As it stands right now, VISUAL can implement VBScripting. To use a short term solution, we just make VISUAL blank out the date field, because it's normally populated by today's date. This is the syntax: <SHIPPED_DATE = " "> (without the <>.) When you're preparing stuff for tomorrow, it's easy to forget to change that field, thus this easy fix. Here's what I want to do. I want to create a box that comes up and prompts you to select one of two, maybe three buttons. These buttons say: Today, Tomorrow, and maybe Other. In the program, pressing T in the date field gets today's date to autopopulate. + gets it to go up to the next day, i.e. tomorrow. Here's what I've got so far.
dim date
date=InputBox("When is this order being shipped?","Date Selection","t")
SHIPPED_DATE = "document.write(date)"
Yes, this is an input box, rather than just a button to click on. I know MsgBox has these buttons, but the names of the buttons can't be modified. According to what I've read, InputBox has the capacity to utilize buttons, but I don't know how. Also, this does NOT return any date to the correct field. I was going for a today to autopopulate, but it didn't. It actually blanked it.
I was thinking that the today button would return a T for that field, while a T followed by a + yielded a tomorrow for that field. Is this possible from the sound of it?