Opiions on what is the best method/ format for storing Procedures and Functions developed over time
I have hundreds of DBs and thousands of Procedures and Functions that I've
written over time.
Right now they are stored in the original DBs. To reuse them, I have to
remember which GD DB they were in. Does anyone have a system or concept
(preferably Access based) for storing these in an easily retrieved fashion?
This is an interesting idea. Here is what I came up with.
The idea is to export the modules as code, parse the procedures and save
them in a record.
Arvin has some code that will export each module as a text file:
h...Adding conditions to sales reports
For accounting reasons, our parent company needs to know the amount of
sales made to employees of our store. I thought I had this figured out
with a SQL query (see below) but it turns out the numbers from my
query are very different from the numbers returned to the Sales > Top
Is there a way to run the Top Customers report, but adding a condition
(not in the filter option list) to include only rows where
Customer.Employee = 1?
I appreciate any tips.
Here's my SQL, maybe there's something easily seen that I missed...
SELECT c.LastName + ', ' + c.Firs...CRM Field Formatting NTEXT and NVARCHAR won't "Automatically expan
In CRM 3.0, I have created a custom entity.
I've tried 2 approaches to creating a Description field that fills the
available space on the form.
1. Create a ntext(2000) attribute, expose on the form, edit the field
properties, Formatting tab, and check the "Automatically expand to use
available space." checkbox.
2. Create a nvarchar(2000) attribute (display as textarea), expose on the
form, edit the field properties, Formatting tab, and check the "Automatically
expand to use available space." checkbox.
Either way, the field does not auto expand when the form is ...How do i format this time ?
i have a column with times in this format, i.e.:
which respectively mean the follwoing times:
00 h: 04 min: 33 s
01 h: 04 min: 33 s
19 h: 04 min: 33 s
how can i set the cells so they show the time in the latter format ? I
welcome any suggestions. Regards,
=3DLEFT(TEXT(A1,"000000"),2)& " hrs : " & MID(TEXT(A1,"000000"),3,2)&"
Min : "&RIGHT(A1,2)&" S"
On Nov 18, 5:37=A0pm, VICTOR <victor.hera...@gmail.com> wrote:
> i have a column with t...But hyphenation DOES work!
I'm running Word from Office 2007 (with that darned 'Ribbon'!), but in the
Compatibility Mode with a document created in much-more-friendly Word 2003.
Within a few seconds after my document loads, I get a message saying that the
auto-hyphenation feature isn't resident, and that I should run the
installation program again. Well, it IS working just fine, thank you,
automatically hyphenating my .doc as I work. Is this a concern or just a bug?
This might be a sign that *part* of the text is formatted in a language that
hasn't been installed. Select the whole ...Custom error message code not working?
From http://www.databasedev.co.uk/custom-error-message.html I use:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
'If an error occurs because of missing data in a required field
'display our own custom error message
Const conErrRequiredData = 3314
If DataErr = conErrRequiredData Then
MsgBox ("Please ensure that you enter a First Name and Last Name")
Response = acDataErrContinue
'Display a standard error message
Response = acdatadisplay
I tested it with the error code 3022 (double valu...Money 2004 Date Format Displaying Incorrectly
A nitnoid problem, but one that bugs me all the same.
I am running Money 2004 Premium on a Windows 2000
I have my computer date regional options for date format
Short Date = dd-MMM-yy (e.g. 18 FEB 04)
Long Date dddd, dd MMMM, yyyy
(e.g. Wednesday, 18 February 2004)
Yet, in my Money 2004 version the date format shows as
follows in the date columns of all account registers:
Short Date = 18-2-04 (instead of 18-FEB-04)
Long Date = February 18, 2004 (instead of 18 February 2004)
When I change the regional options for dates to other
formats, it...Loop all Sheets not working.
I have the following macro which I want executed for all worksheets within a
I have tried it out and it only runs in the sheet that is selected, if I
choose another sheet and run it, it runs.
Can someone advise why it is not running against all sheets or what changes
are required to make it run against all sheets?
‘The following hides columns A,C to E, G to M, and O to AL.
‘It then sets the column width for Columns B, F and N as well as the ‘row
height for row 1.
‘Lastly, columns B, F and N are selected and formatting done to ‘ensure that
they are not the Tex...countif not working
vba excel 07
Want to count all strings that are two characters long in a range. Using
countif(range, "??") but it doesn't work.
The strings are numbers so I think that might be screwing it up. Tried
countif(range,"<100") but that didn't work either.
Look at theese examples:
Set MyRange = Range("A1:A100")
MyCount = WorksheetFunction.CountIf(MyRange, "<100") _
- WorksheetFunction.CountIf(MyRange, "<10")
'N...Workflow process not working
I am trying to configure MS_CRM and I have created an email rule so
when a new case is created, it is suppose to email the customer
automatically with a case number.
However, it is not working as needed. If I go to the Action tab and
apply rule, then it will send the email.
How can I make this work so it does it when the email is created?
In the workflow manager I created the following:
When case is created
Case.Case Number not nukk
E-mail Template:New Case Auto Reply
Any thoughts and advice is much appreciated
...Help Doesn't work Office XP Pro / Standard
Running XP Office Pro on XP Pro. Help windows for all
office products does not work properly. Empty, gray
dialog box pops up, no hyperlinks, no text. Any advice is
welcome. (except "RELOAD OS", that's not advice, that's a
Have you tried running Detect and Repair from the Help menu of any of
the Office products? Make sure you have your Office CD handy when you
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"R T...Weeks worked should be stored by check and not by transaction
Weeks worked is useless to us as is. The weeks-worked should be stored per
check, not per pay transaction. If a person receives 3 paycodes in a check
(for example: regular,holiday,vacation) they will be overstated times 3
because of weeks being attached to pay transactions. There is no single pay
code that all employees receive each check, so putting weeks on a constant
pay code is not an answer either. Also, where we answer the "weeks" question
on the payroll build, the documentation says this applies to salaried people
but not to hourly people. Why would anyone want weeks wo...conditional format
I tried to convert a simple form in 2002 format.
My database is a 2000 file.
In this form i apply conditional format to many objects.
In Access 2000 i display all with my conditions, but in
the new version (Access XP) when display my form the
I tried with a simple form with less objects and all is
ok. Have i too many objects? Why?
Sorry for my english, i write from Italy and i don't speak
and write english wery well!!!
...Working with external quoting systems
We have CRM 3.0, which is only used for contact management since we have
developed other applications in MS Access 2003 for developing quotes and
working with files from other software packages. The Access system fetches
the customer information the the CRM database and that's just about all. We
plan to migrate to CRM 4.0 and would like to keep the functionality of our
rather complex quoting system, but have it more fully integrated so we can
use all the opportunity management features and sales automation and
My guess is that we should try to re-write the quote ...Need help with conditions Liz
I've a question...........
If A1 = 2/17/2007
B1 = 2/22/2007
I've cell C1 with a formula to calculate the difference between those dates
and based on the result which appears on C1 I've a condition in cell D1 which
is if C1 is greater or equal to 0 then YES and if less than 0 then NO. But I
need one more condition that is if c1 is has no value which is when the A1
and B1 is blank I need the D1 cell to appear blank to but should have the
condition in place. PS: I've formatted the C column by unchecking the zero
values under Tools/Options/View.
See your...Setting default formats for color and comments
How do I set my color palette as a default so that I don't have to keep changing it in each workbook. And I do set the default formats for Comment texts so that I don't have to keep changing it in each comment. Thanks.
for your comments question have a look at
For your color question the following site may help you
> How do I set my color palette as a default so that I don't have to
> keep changing it in each workbo...conditional formatting, empty cells
Hi faced to the following problem: Let us asssume that i want to c fin
all values in column A with range 3 to 9 and make them red.
Everything goes fine when I select the whole column, go to th
conditional formatting and use the system: if cell value is not betwee
0-9 make the cell red. The blank cells are not colored
BUT: when I use the same system with values between 3-9, the empt
cells are colored to red and system is not working.
Can anyone explain why this system is working from 0 to eternity an
not from 1 to eternity..
Message posted from http://www.ExcelForum.com
are these ce...How do I format a strikethrough font in Publisher 2003 (SP2)?
It must be there!... But I cannot find it.
I am talking about the "strikethrough" font format in Publicher 2003.
I can see several types of underlines, shadow and enbossing, but not the
Please help. THANKS!
I don't believe strikethrough is available in Publisher. The best you can
do is draw lines through the text.
"Marco Margaritelli" <MarcoMargaritelli@discussions.microsoft.com> wrote in
> It must be there!... But I cannot find it.
> I am...URLs in html format
I regularly send and reply to messages from people who
use HTML format. However, if I include a URL, even though
it is blue and underlined, it is not live. Can you tell
me what I need to do to make the URLs live in HTML
...Format a cell as seconds
Is there a way to format cells to appear as seconds. I
would like to type 7 and have it generate a 0:00:07. I
know that I could use the TIME function for this, but I
would need two cells for that. I want to format the cell
I'm working in.
have a look at
> Is there a way to format cells to appear as seconds. I
> would like to type 7 and have it generate a 0:00:07. I
> know that I could use the TIME function for this, but I
> would need two cells for tha...Excel XML Time format & arithmetic
I have an Excel Xml file and I want to perform a Sum operation with time
If I set [h]:mm format to the cells ¡, I can see the next right values:
When I save the file as Excel XML 2003, I have this:
<Cell ss:Index="2" ss:StyleID="s64"><Data
ss:Type="DateTime">1899-12-31T08:25:00.000</Data></Ce...Help w/Conditional Formatting Code
I have used up my conditional formatting options in Conditional Formatting.
I am trying to add two more conditions via code and need help with syntax
please. Thank you in advance for any help you can provide.
Private Sub Form Current()
If Me![FieldName] = 1 or 2 Then
Me!PtName.BackColor = 33023
Me!PtName.BackColor = 0
ciao TotallyConfused wrote:
> I have used up my conditional formatting options in Conditional
> Formatting. I am trying to add two more conditions via code and need
> help with syntax please. Thank you in advance for any ...Formating numbering in Publisher
I am trying to change some bullet poins into a numbered list. So I put my
cursor at the start of the line of text, and press the numbered list icon. It
turns it into a numbered list, which is what I want it to do (as I go to each
line I have to start the numbering at the next number in sequence, but that
The trick is though, sometimes the numbers are bold, sometimes the numbers
are normal. How can I make them all bold or all normal (The text is all
Thanks so much!!!
> I am trying to change some bullet poins into a numbered list. So I
&...Excel Web Query not working!
I've been using the excel web query functionality at home and at the
office for a while now to retrieve stock quotes from yahoo finance.
recently however it stopped working on two of my 3 machines!
More specifically its the queries that require one to be logged in that
have stopped working.
I get an error message saying that "The Internet site reports that a
conenction was extablished but the Data is not available"
After reading the topics here and at other places on the web i tried:
1) Rolling back using system restore (to get rid of any updates that
couldve brok...formula to add a figure to a total if conditions are.....
OK, obviously by the subject excel is not my strong point! ;-)
What I would like please is the formula to do the following.
If the total in cell A1 is under 750, add 80 to the figure and total it.
Does that make sense?
put this in B1....
"Mr Offle" wrote:
> OK, obviously by the subject excel is not my strong point! ;-)
> What I would like please is the formula to do the following.
> If the total in cell A1 is under 750, add 80 to the figure and total it.
> Does that make sense?