I needed date blocks in months, probably a better way of expressing what I wanted.
Then I can take sales amount within the month blocks and put them in a report data set column
Sort of like ... This is a concept and not code...
FMTD_0 = SUM(FShipdate) >= Feb 1, 2020 And <= Feb 29, 2020
FMTD_1 = SUM(FShipdate) >= Jan 1, 2020 And <= Jan 31, 2020
FMTD_2 = SUM(FShipdate) >= Dec 1, 2019 And <= Dec 31, 2019
FMTD_3 = SUM(FShipdate) >= Nov 1, 2019 And <= Nov 30, 2019
If it ain't broke don't fix it
Discover my world at jkirkerx.com
I have a weird situation where (randomly) a previous Cell value is read by the Excel VBA code.
eg: Cell 1A had a value = Y. It was updated to N. However a subsequent VBA code read the cell value as Y
It has been hard to troubleshoot as this was a random occurrence. I was lucky to catch one today, and upon stepping through the code (using F8) discovered that the correct current value was read during debug!. Re-run the macro without debug mode and the correct value was read.
Its very confusing and I cannot think of anything but an Excel bug.
Have you encountered this issue at all and if so what solution/s have you applied.
Thanks in advance.
With the amount of people that have been using Excel, it is very unlikely that there's a bug that's that basic. Also, the computer doesn't do stuff "randomly"; that's simply our way of describing stuff when we can't see the pattern.
Is there timing involved in your code? Can you reproduce the error?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
May I have some help on coding this in VB.net console app
If the user selects the ‘Enter RLE’ option:
a. the user is asked how many lines of RLE compressed data they want to enter
b. the program should check that the number entered is greater than 2 and if it isn’t display a suitable error message and get the user to keep re-entering the number until it is valid
c. if the user entered a valid number, they then enter the compressed data one line at a time until they have entered the specified number of lines
d. once all the compressed data has been entered, the program decompresses the data and displays the ASCII art image
e. the user is returned to the main menu.
You basically dumped your requirements but told us nothing about which part you are having troubles with. Remember we know nothing about your current knowledge, we cannot access your mind, so without any issue description your "question" only looks like a 'please do it for me' type of question.
I'm really not trying to be harsch. Maybe reading How to get an answer to your question - Visual Basic Discussion Boards[^] would give you some clues about why we need you to be as specific as possible when you post a question.
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
asked for few solutions. Didn't ask you to complete the whole code.
Then what are you asking us for?
You've titled your post "cant get Ascii art to display after the RLE file" but haven't shown us any of your code.
So to show you any way of doing this we would have to write (all) the code from scratch. This is not a code writing service. Show us that you have at least tried something and we are usually more than willing to help, but posting angry faces in reply is not a way to gain our good favour
Last Visit: 31-Dec-99 19:00 Last Update: 2-Dec-21 15:24