Passing a variable as a parameter value instead of a literal string to a child report?
In the Navigation section (Jump to URL), I have the following:
This works as designed - a new window pops up with the "My Report"
report and the StartDate and FinishDate of 01/01/2009 and 12/31/2010
are passed respectively.
But what is the syntax for changing the "01/01/2009" and "12/31/2010"
to variables that point to the StartDate and FinishDate parameters of
the PAR...Sorting Alphanumeric values in a text field
I'm using Access 2003 for a database for my company. I have a field in a
table that has both text and numbers. They are part numbers, for example
21BC124. I kept the field as text because of the text with in the numbers
and didn't figure that a numeric field would alow the text. In my part
numbers table it sorts correctly (first by number then by letter then by
number again), but in my reports and queries there are a few number that sort
in the wrong place. Like this...
I can't quite f...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Clearing security settings
I am setting up a new server that will be home to GP
version 8. I am migrating from 7.5 to 8. I want to clear
out all users, advanced security, and standard security
settings and recreate them on the new server. Anybody
ever scripted this? I assume I want to truncate tables,
but I don't know which ones, other than what is show in
techkno Steps to remove Advanced Security (874401).
If you run a delete statement on the SY02000 table, it will remove all
settings, then you can run a reconcile against security restrictions and user
"Cindy Lange" wrote:
> I...lost menu bar #2
HELP!!! The main menu bar is missing off my excel sheet
and I can't seem to find anyone to help me get it back.
The menu I am missing is the one that includes - File,
Edit, Insert and etc. I have tried...right clicking -
customize - toolbars, but I don't seem to have the needed
item. Anyone with suggestions - please reply...
if you right-click on the menu bar you should see an item like
'General'. Check this item
JoEllen OSBDC wrote:
> HELP!!! The main menu bar is missing off my excel sheet
> and I can't s...Exchange 2003...Queues...Find Messages...icons?
I regularily view messages that have been in the queue on Exchange 2003. If I select one of the domains of the
messages in the queue and do a find messages I get a window with the various messages. The messages will
have an icon beside them that varies. I am unable to find any documentation to describe the significance of the
various icons under sender. Here are a few that I have seen:
1) A normal envelope
2) An envelope with a red circle around a red square in the lower right corner
3) no icon
Anyone now where I can find a description of these and there significance?
R...Set default time zone for all users
Is there a way to make the time zone default to a certain value so that I don't have to go into every user and change it to the correct zone?
No. Each user must change their own timezone settings. I have no idea why
Microsoft do not pick up your computers timezone. Hopefully this will be
changed in a version 2.0 release
"Jack Black" <email@example.com> wrote in message
> Is there a way to make the time zone default to a certain value so that I
don't have to go into every user and change i...Missing Menu Options (Outlook 2002)...
I've noticed a few things disappearing:
1) When I right-click an e-mail to add the person to the
Junk Senders list, the options under "Junk E-mail" are no
longer visible (just gives me a stubby blank box)
2) I don't have access to "Tools --> Rules Wizard" -
that'c completely disappeared.
...How do I set up a formula in excel that is the tenth root of 7 ve.
How do I set up a formula in excel that is the tenth root of 7 versus the
square root of 7?
try the formula =7^(1/10).
"kestig1" <firstname.lastname@example.org> wrote in message
> How do I set up a formula in excel that is the tenth root of 7 versus the
> square root of 7?
...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...if statement with text
I am trying to create an if statement where the string of text contains
total, if yes then perform calculation base on that row and column. if no
total in text leave blank
FIND returns #VALUE if "Total" is not in A1
Therefore, ISERROR returns False if "Total" is in A1 (i.e., it was found, no
Remove 'Junk' from return address.
"jerry" <email@example.com> wrote in message
news:E249057A-F6E4-45BF-929A-B2BB61C3A700@micro...Can I set my custom views on Pivot table
I want to get Pivot table data on my invoice, is it possible to set custom
views so that I can get Pivot table results on invoice format, I've tried
views that offer excel but it doesn't offer custom views
...Prices and cost Set to zero when exporting a new store
When I export a new store with 1.2.085v from headquarters all the cost and
price information is set to zero. I have seen that there is a fix for 1.3v
but i cannot seem to find any other fix for our version. Any suggestions?
Just run worksheets to update the cost and price.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
Joe Gonzalez wrote:
> When I export a new store with ...How do I get text to copy from one cell to another ?
Type = in the target cell. MouseClick the cell containing text. Pres
BrianB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27034
...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...What happened to the padlock icon for my .dot template
I previous upgraded to Word 2007 and cannot figure out how to open a locked
document so that I can make changes. HELLLLLLP Please!
Go to Office button > Word Options > Customize. Select the category of All
Commands. Select the Lock command, and click the Add button in the middle of
the dialog. Click OK.
The Lock icon will now appear on the Quick Access Toolbar.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
Eric Jacobson wrote:
> I previo...convert text in excel to uppercase
Is it possible to convert all text in a workbook or on a spreadsheet to all
In VBA Editor
Dim MySht As Worksheet, MyCell As Range
For Each MySht In ThisWorkbook.Sheets
For Each MyCell In MySht.UsedRange.Cells
MyCell = UCase(MyCell)
> Is it possible to convert all text in a workbook or on a spreadsheet to all
"elaine" <firstname.lastname@example.org> s..."Organizational folder": 'new' menu is not available
I am following article:
and I try to create an organization folder. I go to my "Public FOlder",
click "System folder".
I see EFORMS listed there. I right click the option and I don't see the
What's wrong ? Exch 2000SP3.
...Macro Security Setting not applying ...
I have a workbook that will sporadically lose it's ability to run macros
even though the macro security setting is set to 'medium'. i.e. - no message
box comes up when opening the file and when trying to run any macros, the
"cannot run macros ..." box comes up.
The only way I can fix this is to open the file, select macro-security
setting "low", save the file, open it again, and then return the setting to
This file is out on a shared drive and many of my users need to access this
- so the quick-fix noted above really isn't...Set Enabled On All Controls in a Form?
I am trying to set all controls visible, unlocked, and enabled, as the
baseline for disabling or locking down some fields based on other
criteria. Here's what I tried, which gives me an "Invalid or
unqualified reference" error:
Dim ctl As Control
For Each ctl In Me.Controls
.Enabled = True
.Visible = True
.Locked = False
I based this on several examples that were intended to do something to
all text boxes on a form. (I have never done this before, so sorry if
this i...Provide space in text
Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.
A1 = Abelia Edward Goucher2 litre
Abelia Edward Goucher 2 litre
A2 = Acer campestre Nanum180stem 6-8
Acer campestre Nanum 180stem 6-8
Thankyou if can be of help.
If you double clcik in the cell with the data then you can move th
blink line to were you wan...Will DPM 2010 include Disk to Disk to USB Disk instead of tape?
In 2007 if I want to backup to usb for offsite I have to use a third party
program like Firestreamer to make the usb disk look like a Tape.
Will 2010 allow us to use usb drives or ESata drive for offsite storage?
This would be way cool since Tape can be very expensive for large data sets...
USB drives are cheap and again if goes bad get another one.
Thanks Dan for your feedback. We have been getting this request from our
customers but so far this is not in the list of DPM 2010 features. I'll pass
on your feedback to the product group.
Gaurav Gupta | Program Manag...Halfway through my publisher document the text starts scrambling
I am in the middle of a Publisher document that I have to get out ASAP and
the words are scrmbling all of a sudden; for instance instead of the it
Might try an updated printer driver.
What version Publisher are you using? What printer? What version Windows?
Canon has issues with Publisher 98 and Windows 98
How to troubleshoot text printing (inkjet printers) in Publisher 2000
PUB2000: Troubleshooting Text Printing (Laser Printers)
http://support.microsoft.com/default.aspx?scid=kb;en-us;198...Find a text
I am trying to find a text and delate a Row if the text is in the row.
But I am not sure how to do it.
Can someone help me?
Dim Cell As Range
For Each Cell In ActiveSheet.UsedRange
If Cell = "Samtals hreyfing:" Then
‚the text Samtals hreyfing sin in in the column E:E
‚If the text Samtals hreyfing: is in the row then I want to delete the Row
I think you may be looking for this...
Dim Cell As Range
For Each Cell In Intersect(ActiveSheet.UsedRange, Columns("E"))
...Set a reference to Microsoft VBScript Regular Expressions (vbscript.dll)
In vba, how do you do that?
On Dec 1, 7:28=A0am, cate <catebekens...@yahoo.com> wrote:
> In vba, how do you do that?
> Thank you.
Sorry, I had no idea how simple it was. Tools->References->[x]
Microsoft VBScript Regular Expression 5.5
Its about halfway down
Microsoft VBScript Regular Expressions 5.5
Please rate when your question is answered to help us and others know what
> In vba, how do you do that?
> Thank you.
That's one way t...