Hi ravikumar89,
Thanks, I am familiar with BO formulas. I was just having a hard time finding examples for this particular function/outcome.
USTRAGNU1
USTRAGNU1
Last Activity: May 28 '19, 04:00 PM
Joined: Mar 16 '17
Location:
-
Hello...twinnyf o!
Thanks, that is what I decided to go with and I can just use the built in formatter.
Have a good one!
TurboLeave a comment:
-
Thank you all for your quick replies! I can't open the demo.zip at work, but I will give this a try, thanks!
MikeLeave a comment:
-
VBA Concatenation Assistance Request
Team Bytes,
I have a query that is outputting a few duplicate records because of two fields, [HR Reporting].[Type of Occupational Cert] and [HR reporting].[Date Occupational Cert Issued]. I would like to output one record with the multiple certifications and dates concatenated in one field. Example of current output:
Name Certs Cert Date
Doe Jane CISSP 1/2/03 (the rest of the fields are the same)
... -
The Alerter can't isolate just the asterisk in the date string. I would have to build a formula inside the alerter anyway.Leave a comment:
-
Ok thanks Rabbit.
I have a Business Objects XI 3.1 variable formula which places an asterisk and a space in front of a date object if the object date is less than or equal to current date. Simple enough.
But I am trying to modify the formula so that if the condition is met and the output does contain an asterisk, I want the font of the asterisk/date to be red, preferably bold. My searches keep returning examples of...Leave a comment:
-
Help With SAP Business Objects Formula
Good Afternoon,
Would anyone be able to assist with a Business Objects XI 3.1 formula question? I don't see it as one of the topics.
Thank you. -
USTRAGNU1 replied to Can a command button be coded to prompt a user between two different subroutinesin AccessIn fact, and expert from another site ended his email with "Cheers", so I looked up British terms and peppered my reply with them for humorous effect.
He replied by telling me he is from California, he just likes using Cheers as a salutation. Yikes.Leave a comment:
-
USTRAGNU1 replied to Can a command button be coded to prompt a user between two different subroutinesin AccessI thought everyone was from England. Sorry about that! I was watching a documentary on Hampton Court palace last night. Absolutely amazing structure/history. I watched it twice!Leave a comment:
-
USTRAGNU1 replied to Can a command button be coded to prompt a user between two different subroutinesin AccessOIC that is a nice option as well. Thank you.
UTSLeave a comment:
-
USTRAGNU1 replied to Can a command button be coded to prompt a user between two different subroutinesin AccessExcellent. Mille Grazie!
UTSLeave a comment:
-
USTRAGNU1 replied to Can a command button be coded to prompt a user between two different subroutinesin AccessTouchdown, thanks! Or should I say GGGGGGOOOOOAAAA AALLLLLL!
UTSLeave a comment:
-
USTRAGNU1 started a topic Can a command button be coded to prompt a user between two different subroutinesin AccessCan a command button be coded to prompt a user between two different subroutines
Hello,
I have two subroutines. One creates/delivers a one worksheet excel workbook, the other one creates/delivers a multiple worksheet excel workbook.
Can the code behind a single command button be modified to prompt a user to choose between two different subroutines? Sort of like the principle of a parameter query?
I have looked online but not quite found anything.
Thank you.
... -
Z,
To be honest, I did not understand some of your instructions, so I attempted to start over and delete the current PERSONAL.XLSB (I only had a couple of recorded macros).
When I got to the folder, I saw four temp files in there with the PERSONAL file, so I deleted the temp files and the problem hath been solved.
Thanks for hanging with me! You guys rock!
UTSLeave a comment:
-
The file is created from a database on a network share and added to an email. I open it from the mail attachment before I send it to click/run the macro before I send it.
However, when I perform the same process from a copy of the database on my desktop I experience the same situation.
Interesting.Leave a comment:
-
Interesting...I can't delete the .tmp items when I go into Macros. The delete button does not activate when I click on them. Oh well. Closing a couple of extra worksheets is still a lot better than what they did before I created the sub, which is open the workbook in the export email as an attachment and manually format each of seven pages! Thanks, I guess we can close this one out. I will do some more research as to why the delete button does not...Leave a comment:
-
I always make back ups to the back ups, heck yeah. Ok I will try that and let you know, thanks.Leave a comment:
-
Excel Macro Runs Great But Have to Close Multiple Sheets
Good Day,
I created a macro in Excel that works great. It formats multiple sheets exactly as expected, but when it completes it seems like I have to close out four or five worksheets before I can close out of excel completely.
One item of note: I experienced errors when I first built the macro. When I went in to edit the macro, I noticed a ton of temp macros that were never there before. Could I assume this is the problem?... -
Top notch, thanks so much! I will run and test and let you know what happens!
UTSLeave a comment:
-
Would it be too much to ask if you could modify "SaveAttachment sToDirectory" to target specific file extensions? I am only working with .csv files for this project...
UTSLeave a comment:
No activity results to display
Leave a comment: