How do I use the data in a named field to select a worksheet tab .
I need to use a named field to select a worksheet tab in another workbook. ie
i have a workbook called Master and need to collect data from a workbook
called Reports, but i need to collect it from different worksheets within
Reports depending on the month selected in Master. The tabs in Reports are
M01,M02,etc. In Master I have a Named Field called 'Month" with M01,M02 etc
entered in it. This field needs to select the corresponding tab in Reports.
Usually the reference syntax goes something like '[Filename]Tabname!Cellname
Here is an obscure example from an old...removing blank fields in a query
I need to build a table using a old database. the field I want has some data
in them but can also have blanks. I do not wan the fields with blanks how do
I accomplish this.
>>I do not wan the fields with blanks
Just omit that field.
Or do you not want records that have blank fields?
Use criteria of Is Not Null on the field.
Build a little - Test a little
> I need to build a table using a old database. the field I want has some data
> in them but can also have blanks. I do not wan the fields with blanks how ...Using onchange event to Hide a field
I would like to dynamically show / hide certain fields on my CRM form based
upon the user's selection from a Picklist. Is there any way to dynamically
show / hide a field on a form using the onchange event of the Picklist?
There is no supported way to do this. You could try setting the visibility of
the associated DIV to false, but no guarantees.
MVP - Microsoft CRM
On Tue, 16 Aug 2005 23:50:12 -0700, "cdobkins"
I would like to dyn...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <firstname.lastname@example.org> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Problem while converting excel to csv for Special Characters
I need to convert excel sheet data into csv format data=20
file, but while doing so for some Eastern countries, like=20
Poland, special characters in the excel sheet are getting=20
converted into junk data
Excel Sheet Original line - Zesp=F3l Opieki Zdrowotnej w=20
Line when converted to CSV - Zesp=F3? Opieki Zdrowotnej w B?
Really appreciate your response on this.
I'm not sure if this will help, but I just copied your first original line into
a excel worksheet (USA xl2002) and saved it as .csv.
I re-imported and it looked fine.
I opened t...Insert trigger
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Showing a date field as a number
I was wondering if there was any way that I could have a column showing the
date and time (20/12/2007 06:00:00) and another column show the date and time
as a number, (29548). This would be done in a select query, but I am not
Is it possible?
for 20/12/2007 06:00:00
#.0000 (with Decimal Places = to suit your needs)
# (with Decimal Places = 0)
Microsoft Access MVP
http://home.comcast.net/~cccs...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...Variable field names?
I am trying to execute the following code: -
strSQL = strSQL & Nz([" & strCOM_Year & "], 0)
where strCOM_Year is a string I want the system to use as a field
name. It doesn't like this. Keeps saying 'can't find the field "|"
referred to in you expression', even though I can clearly see in the
debug window that the current value of strCOM_Year is "2006/2007".
i.e. I am looking for the value in the field called 2006/2007.
> I am trying to execute the following code: -
> str...Font in drop-down field too small
I created a drop-down field with multiple menu choices. I am not able to
increase the font size for those menu choices. The adjacent cells have a
much larger font, and I would like my spreadsheet to be consistent.
If these are data validation dropdown lists, you can't change the font
size. There are a couple of workarounds here:
Juana Cafe wrote:
> I created a drop-down field with multiple menu choices. I am not able to
> increase the font size for those menu choices. The adjacent cells have a
> much larger font, and...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Calc Field to list invoices paid by same check on one line of repo
I have a customer who wanted a check dump file to send to their bank. Once
the bank receives the file (in txt or tab delimited), they will use the
infomration to actually print the checks for the customer. (This is not a
positive pay file situation.) I was able to take one of the check forms and
modify it to get all the data required by the bank. I am running into a
snafu with getting it down to one line per check with multiple invoices
listed one one line. It is listing the total check and one line per each
invoice paid by the check:
Ck 2345 for $800.00 -...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Global Customer custom data field
I am running 2 stores with HQ and Global customers. How can I change the
global customer title custom fields in the Additional tab in HQ. I change the
title fields in store manager, by going to Captions button under the
configuration section, but HQ Manager doesn't have a captions button. How can
I update those custom fields in HQ with thier current customers?
These values are kept in records 1-15 of the CustomCaption table of the HQ
database. Using HQAdministrator, you could execute a query like:
update CustomCaption set caption='my custom text' where id=1
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...Error when adding a custom field through Deployment Manager
I am receiving an error when trying to add a custom field through the
"An error occurred during the addition of the new field. The addition
failed. For more information, see the event log".
The Application event log lists the following entry:
"dmLog: Failed to grant access to the regenerated view Account after
inserting new attribute CFSTest."
My domain login has domain admin privelages and is a member of the
System Administrator role in CRM.
Any help with this would be greatly appreciated!
this usually means the field is already there... if you c...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <firstname.lastname@example.org> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (email@example.com),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...Case (in)sensitivity of table names/field names
I would like to work with Microsoft Access 2003 and Windows XP or Windows
Are table names case insensitive?
What about field names?
Thank you very much for your kind help.
Yes, both are case insensitive, as is data. IOW, a search for either peter
or Peter would find you.
Arvin Meyer, MCP, MVP
"peschrader" <peschrader@hREMOVEMEotmail.com> wrote in message
> Hi !
> I would like to work with M...insert downloads into power point
i downloaded an application called "BioDigital Simulator" of an animated
cleft lip/palate surgery and need it put into my power point presentation,
but can't fiugre out how to do so.... very frustrating...
What kind of file is this application? Is it a video? If so, what kind?
MPEG? AVI? MOV? Or is it an EXE file? Something else?
Which version of PPT are you using?
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover...DAO recordset on memo type field >255 long
I have a table with a memo field with data frequently >
My ultimate goal is to copy data from that table into a
word document table.
The method I am using is to query the table using a DAO
recordset and then I loop through the record in the record
set and insert them in my word table using vba code.
When the data is > 255 characters long, the characters
after 255 are not displayed properly in the recordset and
therefore in the word document.
Any idea what can be done about this? Maybe a different
method for accessing the data?
...Garbled characters when opening emails sent as attachments
On exchange 2003 SP2. Got a weird problem. The user is unable to view
emails that are sent as attachments. He can not view them using OWA nor can
he view them using the outlook client. If he opens and email attachment it
eithers opens up with no text in it or opens with no readable characters.
I emailed the user 3 emails with attachments that were in emails, in html,
rich text and plain text format. They were all received. This did not
replicate the problem.
A colleague in his department forwarded them on and he could open them.
Both the forwarder and the client are on outlook 2003....Insert dataset to another database
I'm posting this to this group also since it pertains to queries, primarily.
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query. But, I can't seem to get it to work, even in an experiment in
My sql in Access 2K:
SELECT D.lorder as Ord, A.Lorder
FROM [;Database = C:\MyDocuments\Acc2K\Wrk.mdb].OrdersData as A INNER JOIN
[;Database = C:\Access\Work\Sales06.mdb].Detl1 as D On D.Lorder = a.lorder
WHERE ((D.fg)= 'MXX-NC' Or (D.fg)= 'MXX.NC')...