Display Data by reference
I would like to know how can I display a record from a data base by
reference. I have a variable call txtFName, a database’s table call
BasicData, and the field from the data base is call FirstName, In txtFname I
have stored “FirstName”, my question is how can I display the data I have in
FirstName using txtFname.
It has to be in the forms Record Source (query or SQL statement) or use
Build a little, test a little.
> I Guys,
> I would like to know how can I display a record from a data base b...Can I display the actual data in the data field of a pivot chart?
Using Excel 2003, I am creating a pivot table using customer data similar to
Customer Location Interface Code
11 Word 123
13 Outlook 456
22 Excel ABC
23 Outlook XYZ
I am placing the Customer Location in the row area, the Interface in the
column area and the Code in the data area. I would like the Code to show in
the pivot table as the "123", "4...Consolidate Data
Want to consolidate data from many flies which are in the same format to a
sigle file how can i do it in the best way?
You can use a DIR looping macro to open or create formulas for each workbook
desired to the next available row on the destination file.
Microsoft MVP Excel
"Melwin" <Melwin@discussions.microsoft.com> wrote in message
> Want to consolidate data from many flies which are in the same format to a
> sigle file how can i do it...Excel memory Error
When I go to open a new excel spreedsheet, I keep getting a Memor
error. I have removed and reinstalled Office 2000. The error does no
go away. I have a 80 gig hard drive with over 50 gig free. I have
gig of Ram. Page file is set to 700 meg.
Can anyone help me.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
I've had the same problem as you this ...I'm looking for: Excel Employee Schedule Sheet...
I need it to total the daily hours & week automatically...
Thanks for helping...
Keywizz Productions, Inc.
...Help comparing data in 2 columns and finding same data in both
I have a 2 column spreadsheet with numerical data in each column.
I need to compare columns and note which numbers are in both columns
(preferably in a third column)
I have this...
col A col B
I need this....
col A col B col C
1001855 1001855 X
1001855 1001866 X
1001866 1001877 X
A has over 14,000 lines and B has over 10,000
either may have duplicates.
=IF(COUNTIF(A:A,$B1)>0,"X&qu...Analysis Cubes Sample and Live Data
I want to create analysis cubes for the Sample company as well as for the
live company. It is important to have these cubes for sample data so that
the users can play and get used to working with this tool. Because of the
dates (2010 - 2017) in the Sample Company Fabrikam, I cannot create the cubes
in the same analysis cubes Data Warehouse. Should a different data warehouse
be created for the sample company?
I would install two different instances of the analysis cubes.
1-Install the analysis cubes using the default names from the installer. I
think the database and An...Setting Column Width on Imported Data
I would like to know if it is possible to set the column width of a column I
am importing to Excel from Access. I need this column for what I'm doing in
the Excel file, but I don't want it so wide, or would even like it hidden.
Problem is everytime the data gets updated the column goes back to really
Any suggestions would be greatly appreciated.
...Multiple copies of excel
Everytime I open a new worksheet Excel opens a new copy. As a result I
cannot copy or link from one worksheet to another. I know there is a
setting somewhere to correct this, I found it in Excel XP but I forgot how I
did it, but I am now in Excel 2007.
If you open excel, then use Office button|Open, then things work ok, right?
If yes, then I'd try this:
Tools|Options|General|Ignore other applications (uncheck it)
Office button|Excel Options|Advanced category|General section|
uncheck Ignore other Applications
If that doesn't work, try re-registe...Data Stroage for Windows 2008 R2 Hyper-V servers
We would like to change our backup solution from Symantec to DPM 2010. I am
unclear with how much storage is required for backups of our Hyper-V servers.
We currently backup our servers to disk.
If I have a Windows 2008 R2 Hyper-V host with 4 vms running on that host,
and each vm has 10GB of storage (40 GB total), it seems that my first backup
will take approximately 40 GB. When I do my second backup, will it require an
additional 40 GB of storage, or will it only store the changed files on the
four VMs? How will the third backup behave?
Our hosts are configured with clustere...Data entry form #2
I need to create a data entry form in excel. I need only two fields
Stock no. & quantity.
As soon as I enter the stock no. the curser should go to the quantit
column and when I press enter it should store that data in my exce
sheet ( in A1 & B1) and clear the message box for the next entry. Th
next entry should be store in A2 & B2.
Can someone send me the code for it.
SMILE's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=488
View this thr...How do I compare data from 2 worksheets to find duplicate entries
I am a novice Excel user. I have to worksheets that have data, some of it is
similar (ie. Item #'s, etc.) I want to automatically compare the reports and
highlight data on one worksheet that is identicle to the data on the other
worksheet. If I can't do this, I'm going to have to manually compare the
A coded solution is probably the way to go for your challenge. You can
iterate through each item on the first sheet and check to see if it exists in
the second sheet before copying it to a new (report), third sheet.
I have many files.
Any file has data on column X and special range.
I need to a code when run it on any file, open Box similar to following:
response=InputBox("Enter new row number") and after i input row number,
then copy of data on column X and it's Range, paste to new row number on
Example for my first file: data on column X has Range (X2:X570),after run
code, new row number in Box is 7644,then, copy of data paste to sheet2 and
You don't say which sheet has the original data in X2:X570 so I'll pick
...Excel ActiveX TextBox by VB-Coding
The intention is to construct an ActiveX Control TextBox on an Excel
worksheet ; and so, the following code is generated by deploying the
Control ToolBox and Macro Recorder simultaneously.
' ActiveXTextBox Macro
' Macro recorded 2004-11-26 by SynthesisUserNameDotAuthor
' Keyboard Shortcut: Ctrl+e
DisplayAsIcon:=False, Left:=178.2, Top:=1326.6, Width:=72,
And then, the result shows that the TextBox thus added cou...Get external data??
I have an Access 2000 program that I package with Developer. I currently
only allow "Built-in toolbars" and "Menu Bar Only'. However I want the user
to have the "Get external data" option under "File". What do I need to allow
for the user to get this option?
> I have an Access 2000 program that I package with Developer. I currently
> only allow "Built-in toolbars" and "Menu Bar Only'. However I want the
> to have the "Get external data" option...Delete duplicate data.
I have thousands of rows, and each of them contains several columns of
data. If I want to delete the duplicated rows, how can I do that?
Cust ID Name Desc
001 John sg1.
002 Sam sg2.
001 John sg1.
I want to delete the duplicated customer ID of 001? Thanks.
Assuming that the entire row is duplicated as in you example you can use
Data > Filter > Advanced Filter > Unique Records Only. You can than copy
If the entire row is not duplicated, it's a...Replacing Excel Template
Ok, quick question...
What are the potential ramifications of replacing the template file in
I have created a new template file with my companys colors and want to
send it to others, but don't want to mess anyone up... Thanks!
You mean you want to change book.xlt in the XLStart folder?
It would depend on what the other users do with excel. If they only want to
make workbooks that are based on that template, then you'd be fine.
But if they wanted to do other things, then I would think it wouldn't be so
Why not just save it as a template and have the other users...Rename Worksheet From Cell Data
Is there a way to rename a worksheet based on a cell in the worksheet?
Running the tiny macro will set the tab name to the value in B9:
ActiveSheet.Name = Range("B9").Value
Macros are very easy to install and use:
1. ALT-F11 brings up the VBE window
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
To use the macro from Excel:
1. ALT-F...Excel 2003 in seperate Window
I am using multiple monitors and would like to to have a seperate workbook
open on either monitor so that i can look at either monitor and see the
At the moment the workbooks open in the same window and they cant be split.
I have looked at Tools, Option, View, Show and checked and unchecked
"startup Task Pane" and "windows in Taskbar"
I have also tried
1. Go to Start / My Computer then right click and select explore.
2. Then Select Tools
3. Then Select Folder Options
4. Then Select File Types Tab.
5. Scroll down the list of Registered Files type...Letter Templates from Access Data
Is it possible to create letter templates from access DB? If so how.
For example I want to create an insurance letter regarding the medical
necessity of bariatric surgery. I would need to be in the patients record &
would like to choose a template that would place the PT name, comorbitities,
etc... into a pre-written letter that would be ready to mail.
The quick response is "Yes" you can do that.
One way would be to open Access and in the Help Search field enter the
phrase "mail merge". Then, take it from there.
"Andy" <sh...linking data
Is it possible to have one spreadsheet (A) linked to another spreadsheet (B)
so that any changes made to (A) are automatically recorded in (B)?
The simplest way to do this, as I can see, is to use a Worksheet_Change
event macro in sheet A that will copy any changes (in sheet A) to sheet B.
Does this sound like what you might want? HTH Otto
"JR Winder" <email@example.com> wrote in message
> Is it possible to have one spreadsheet (A) linked to another spreadsheet
> (B) so that any changes made...inserting data into password protected excel file
How do we insert data into an excel file that is password protected
using ODBC connectivity. I am getting an error whenever I am tryin to
insert date into the password protected excel files. Its saying cannot
decrypt the file. How do I solve this issue??
...is excel multiuser?
can we make our worksheet multiuser? i mean not only as read only but also as writeable
Not really multiuser. You can share a workbook (Tools - Share workbook),
which allows multiple users to open and edit the workbook concurrently.
When any user saves, it checks for conflicting updates (another user updated
the same cell(s) and has saved the workbook). Updates aren't seen across
users in real time.
mvpearl omitthisword at verizon period net
"murtaza" <firstname.lastname@example.org> wrote in message
news...Convert vertical data to horizontal data
I have a listing of 6 performance ratings for each employee. The ratings
appear vertically. How do I convert the ratings data to a single row for
Copy - paste special - transpose
Please hit "Yes" if this post was helpful.
> I have a listing of 6 performance ratings for each employee. The ratings
> appear vertically. How do I convert the ratings data to a single row for
> each employee?
I think I need more information. I tried what you suggested but I got the
following me...Newbie Excel/Database Question
I have a database with two tables (class and book) that are joined by a link
table (class_book) such that a class has many books and the same book can be
used in many classes.
How might I go about pulling this data into Excel and showing the classes
down the left side, the books along the top, and an 'X' at the intersection
of the two when a book is required by a class.
You can do this with a pivot table. With 2 worksheet columns "Book" an
"Class" holding your data. You might have to do a "Make Table" query i
Access to achieve this.