Problems calculating a converted html table to Excel XP (2002)
I have a generated report off the web that must be converted into Excel. When the report comes up initially it is in a .asp format. I save the report off the web in HTML format. Then open excel, then go to file -> open and browse for the file that I just saved.
The report opens fine with all data showing up as is. However when I try to go and calculate a column of numbers, the answer that I get is 0. So if I go and add up say this list of numbers which is : 5, 7, and 8. The sum should be 20. Instead I get 0 everytime. I have tried to format the cells to be numbers instead of gen...Help filling in form from 2 different tables
I have two tables, CustomerData and EmployeeData. CustomerData has all the
address, phn, name, empid# of last employee to help em and custid (primary
key) and employeedata has name addr phn and empid (primarykey) I have a combo
box that pulls up custdata (by Custid sorting by Lastname & ", " & Firstname)
I wanna do an Afterupdate event to fill out the following textboxes (based on
the Custid it fills out the Lastname, Firstname, Address, Phnnumber) and then
based on the Empid of the last Employee that helped em it will fill out the
textboxes witht he first and last na...size of private information store
the private information store is reporting that it is at 16GB. I have done
several offline defrags with eseutil /d. The physical size of the .edb and
..stm file remain the same. I have reduced the size of the various mailboxes
by ov 5 GB. Any ideas why the size of the .edb file is not reducing
check your "deleted items retention" window...
"Joe McHale" <Joe McHale@discussions.microsoft.com> wrote in message
> the private information store is reporting that it is at 16GB. I have
...Pivot Tables and Charts
Is there a way to make a table and then when i change the chart have it to
where it does not turn around and change the table
Create another pivot table, based on the first one. Then, create the
pivot chart from the second pivot table. You can hide the sheet that
contains the second pivot table.
When you change the pivot chart, only the hidden pivot table will be
> Is there a way to make a table and then when i change the chart have it to
> where it does not turn around and change the table
http://www.contextures.com/tipte...Outlook Web Access Problems (SBS 2003)
Wonder if any one can help...
We use Outlook Web Access and until last week we have never had any
problems.... (SBS 2003)
I get to the login screen and put my username and password in and I get the
"You could not be logged on to Outlook Web Access. Ensure that your user
name and password are correct, and then try again."
I've tested the login as both the user the admininstrator and internally on
the server and I get the same problem... I'm not aware that we have
installed any new apps or made any changes recently
Any ideas....?, the users just seem to have los...Inserting Multiple Worksheets?
Is it possible insert multiple blank worksheets into a workbook? I.E.
I want to insert 20 fresh worksheets without having to insert one shee
Also, supposing I have a set of tabs with each one corresponding to th
day of the month, is it possible to somehow drag more worksheets tab
that would continue the naming system
Mr Zero's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558
View this thread: http://www.excelforum.com/showthread.php?threadid=27724
you can insert...How do I format the Auto Date font that is inserted
Sorry to bother with such a minor thing....
When creating a page that is captured from the web, a date and
time is already inserted at the top of the page... which is
The only problem is that it is so tiny and light colored font
that it is hard to see.
Is there a way to change that font?
PS- I just started using Onenote and it is a great program!
I just love it. Perfect for what I need.
I see the answer in a previous post.
Sorry, I thought I had read all the previous post headers.
"Nancy" <email@example.com...as400<iSeries db<ntWS<macro<excel tools
i have an inventory of appx 1000 serial numbers. using keystroke recording, i
can populate 2 - 6 fields on 4 green screens to complete a process on one
serial number. is there a way to tweak my macro to incrementally continue,
automatically, from a list stored in an excel workbook on the client? would
be very grateful for fresh ideas.
Show us your macro and some data details.
(remove nothere from the email address if mailing direct)
"ayeFayze" <ayeFayze@discussions.microsoft.com> wrote in message
...Access Report from the Web
We have few Access reports on a form,
that we would like to run from the web (sherpoint)
is it posible ?
if not, what can be as alternative ?
In general not a good idea unless you approach it like I do with this
It basically runs one instance of Access on the server and uses a COM
component and lots of error checking to
handle the report requests. Note: the product hasn't been updated to work
with access 2007 or 2010 (you would need to tweak source code).
Low en...Exchange 2003 mount public db
I have Exchange 2003 SP2 on SBS Server.
On of my customer losed old mail on a public folder and I need to restore
I have the database file that contains the emails but i wouldn't stop
exchange mount the old db (DBOLD) create e pst of email, dismount the db and
mount the official db.
It's too dangerous!
Then I reinstall the same machine on a server with the same domain,
organization, Admnistrative group of Exchange.
Dismount the original db and I try to mount the db of the other server
I receive an error like this:
The information store could not be loaded bec...how I can insert date picker in excell template?
Maybe one of these will help:
...Access Maximum records
Can anyone tell me what is the maximum records you can have in access?
Thanks in advance
K Vander Vlist
Kathy Vander Vlist <KathyVanderVlist@discussions.microsoft.com> wrote:
> Can anyone tell me what is the maximum records you can have in access?
> Thanks in advance
There is no maximum number of records. There's a maximum size to the
file, which is 2GB in Access 2000-2003. I'm not sure if that's changed
in Access 2007. Generally, information about limitations of the product
version you...Pivot Table
consider an examle of data and a pivot table like in the page of famous jon:
http://peltiertech.com/Excel/Pivots/pivottables.htm, namely the most left
table in the third row.
I want to report all product that have sales above 8000. Other product i do
not want to see in the table.
I know how to report 3 best products but it is not i need.
...table not getting updated
I have a form with info derived from a query. It opens from another form
with default data in some of the fields.
While trying to save information programmably, i can not get this to happen.
The only time that I can get the info to update in a table is when I
actually change one of the default values.
Can anyone help we determine a method to use to force the action of data
moving to the table?
> I have a form with info derived from a query. It opens from another
> form with default data in some of the fields.
> While trying to save information programmabl...How can I allow users to sort a protected table using dropdowns?
I'm trying to create a table where users can't edit the content of the cells
but can edit the ordering of the table- what's the best way to achieve this?
I've written this code some time back for one of my users and it works
perfectly for them. Maybe you would like to adapt to suit your needs..
ActiveSheet.Unprotect 'Unprotect the sheet
Range("A1:F100").Sort Key1:=Range("B1"), _ 'where "B1" will be the sort
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase...executing code on access forms on different pc's
We have several access databases that we used without any problems for years.
All databases are in access2003 format and have forms with VB code behind it.
recently we are getting new PC's that cannot execute the forms in (MDE
version) databases. It reports missing references. Opening the MDB version is
no problem but then it cannot be opened on the older PC's anymore. Both old
and new PC's have Office 2003 installed and are running XPSP2. The missing
references are 3 files:
Does anyone know where these files come from? Could they belon...End of table
I have several workbooks that were created by someone else. They all
have one characteristic that I would like to change.
When I create a worksheet, the Ctrl-End key combination jumps to the
bottom of the table -- the lower right cell. If my table has 200 rows
and 10 columns, Ctrl-End will jump to J200.
In these worksheets, Ctlr-End jumps several hundred, and in some cases
several thousand, rows beyond the last data cell.
I have tried deleting the rows below the last data cell and deleting
the cell contents, which appear empty.
How can I find out why it is doing this and correct it?
Curio...OWA Additional Mail Store
How do I log in using the OWA to a mailbox that is stored in a message store
other than the default one?
Post in microsoft.public.exchange.admin for best results - and provide your
version of Exchange and more details about your setup...
Darren Klein wrote:
> How do I log in using the OWA to a mailbox that is stored in a
> message store other than the default one?
> Thank you,
...Date and Time Table Modified
I have 4 forms used by managers to enter data. When they enter data, the data
is saved in tables. I would like to include a date and time stamp so that I
know when they entered each piece of new data. Do I need to have a field in
my table to collect the date and time? How do I collect that in my form?
Yes, you need to add a field to your table.
In the form's BeforeUpdate event, put code to update that field. Assuming
that you named the field LastUpdated and that you included the field in the
form's RecordSource, the code would look something like:
Private Sub Form_Bef...Help with Populating StringMap table
I have a user request that I'm sure is made with some frequency, so I'd like
to see if anyone lse has solved a similar probelm, and/or if my solution
My users requested that we replace the State/Province text box with a State
drop-down list. Since this textbox appears in several places, and since the
tools for populating and maintaining picklist are poor (to be generous), I
decided to look into automating the process.
I created a stagin database for just such things, with a mirror stringmap
table. Through a query, I can populate the CRM stringmap table quite easily,
with ...sql report 3 tables
I am trying to write a report which will contain 4 tables, I need to display
all 4 tables on one page. Unfortunatley because of the siz of the first 2
tables the 3rd table sits way down on the right hand side, how can i
manipulate were the tables sit on the preview window?
Are you writing your report in visual studio?
in Report layout view, right click outside of the report area and select
Properties. from the second tab you can change the layout of the report. By
default it is set to 8.5 X 11, try chaning it to 11 X 8.5.
Also, try changing the font size in your tab...Insert blank rows
Rather than using the control button to select every other row, which can be
very time consuming when you have more than 100 rows, I am trying to figure
out how to auto-insert blank rows between pre-populated rows of information.
Try this macro. ALT+F11 to open VB editor. Right click 'ThisWorkbook' and
insert module and paste the code in on the right . Change the sheet name to
your sheet and run the code
Dim ws As Worksheet, x as long
Set ws = Sheets("Sheet3")
lastrow = ws.Cells(Cells.Rows.Count, "A").End(xlUp).Row
For x = ...Exchange mailbox recovery using Exchange DB files
I've shifted my Exchange 2003 machine to a new machine configured it and
created all user accounts/mailboxes same as in old Exchange server and
everything is working.
I've all the Exchange DB files from old machine HDD i.e. .edb, .stm,
..log files as it is.
But I don't have any type of backup using backup utility, but I have copy of
old Exchange files.
How can I transfer mailboxes/mails from old machine to new one.
I already studied Microsoft's Exchange 2003 Disaster Recovery Guide, and KB
article "Offline Backup and Restoration Procedures for Exchange" ...Publisher 2007's PDF converter removes transparency from pictures.
I really would appreciate any help in the following issue.
I have some gif pictures in my publisher 2007 document that are transparent
(tried this with png pictures too). Everything looks good when I print the
document to a printer. But if I use Microsoft's built-in PDF converter then
the transparancy becomes "white" and that is not good. My printer requires a
PDF and can't work from publisher 2007 files.
Any suggestions on how to STOP publisher from getting rid of the
I'm not seeing this. When you move the image over another obje...Table design ?
Is it design worthy to have field type attachment for contacts picture and a
2nd field type attachment for Doc, PDF files and can internet likes b placed
in the attachments.
Thank You The Lord's Blessings this evening
On Mon, 12 Nov 2007 17:02:16 -0800, MaRSMAN
>Is it design worthy to have field type attachment for contacts picture and a
>2nd field type attachment for Doc, PDF files and can internet likes b placed
>in the attachments.
>Thank You The Lord's Blessings this evening
I would not recommend storing exte...