Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...Trouble sending emails #2
I am recieving emails, but every time I try to send one I get an error
message saying, "The server does not support the required HTTP methods. Ther
server responded 'Not Implemented'." I have no idea wht that means or what I
need to change. Help!
On Thu, 30 Dec 2004 15:05:06 -0800, Tina wrote:
> I am recieving emails, but every time I try to send one I get an error
> message saying, "The server does not support the required HTTP methods. Ther
> server responded 'Not Implemented'." I have no idea wht that means or what I
> need to change. ...Cannot send mail from outlook, error 0x800CCC78
This message started to appear back in Sept and I haven't been able to send
e-mail from Outlook ever since (apart from a 2 day period in Novemeber when
the issue disappeared just as quickly as it appeared).
I now have to cut and paste e-mail i recieve into the e-mail interface of my
provider in order to get e-mail sent.
I have posted this error 3 times now and haven't got a solution, plenty of
questions about versions, platforms, port numbers etc etc, but no fix.
Judging by the hits on google to this, it is and established problem.
Come on Microsoft, do your stuff.....Pivot Table Question #15
Love pivot tables but i have a question, the table is set up as so
Month Pallet# BoxesPur BoxesSold Price Frt Gross
Jan 1 5 1.0
..3 Formula Formula
2 5 2.0
3 10 3
Jan Total 10 10 6.0
So, the problem is in the Jan Total row, is there a way...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...form and query problem. please help.
All tables are linked with weak entities. However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.
It wont work and i have no idea what to do at this point. in addition the
workshop will not let me add workshop to invoice. this is a small mdb and i'd
like to email it to anyone who can assist me with the relationships as I
think this is the problem but I don't know what to do. please help me.
invoiceNO - autonumber
wo...how do I remove fx from the function line, can't enter data
I have the fx displayed just under my toolbar, and I can't enter or change
data in any of the cells in the file. I can't get the red X, the Green check
mark, or the black = sign to appear. There are very few areas that are not
"greyed out" under the headings at the top. This situation applies to all of
the excel files on this computer. I have Excel 2000. Please help.
Can you move the cursor around anywhere in the spreadsheet?
> I have the fx displayed just under my toolbar, and I can't enter or change
> data in any of the c...Send/Receive Problem
I am using Outlook 2002 on an XP platform.
I cannot get Outlook to check for Email at regular intervals. I have the my
Outlook set to Send and Receive all my accounts every 10 minutes but nothing
happens. The only way I can receive Emails is by manually using the
Send/Recv button or pressing F9.
Can anyone offer any help.
In case it is relevant I am using Norton Internet Security 2003.
Not sure it it Yor problem, but Outlook has some problems
with Noroton Antivirus runing and chekking e-mails. As far
as I know, Outlook may stop recieving e-mails from POP3
servers due to very le...how do i recover data in publisher
i have been entering addresses to set up a mail merge. i cllicked the "ok"
in the window and lost all data . can i recover it
Look in a folder in My Documents named "My Data Sources". Publisher data is
saved as .mdb(Access) file.
Did you try selecting "Edit Address List" in the Mailings and Catalog menu
"dee" <firstname.lastname@example.org> wrote in message
>i have been entering addresses to set up a mail merge. i cllicked ...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...cant send emails 02-14-10
I have tried everything you guys have suggested in the other posts, including
uninstalling and reinstalling the mail software. I have two email accounts &
neither will send. It had been working since Nov 09 and just suddenly
stopped. I have windows 7 & windows live mail. Here is the error I keep
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
This is the local server I use.
Subject 'Fw: Fwd: xoxo'
Window...Retrieving sorted data from same table.
I am working on a table (mentioned below) I am looking for a query
which can get me the data according to the =93id=94 column with respect to
The condition is that I have to get three consecutive entries which
have speed > 60
Below is the sample table with data on which I have to retrieve the
data on above condition.
The output i need can be as given below
DVXC002 12/10/09 0:12 96
DVXC002 12/10/09 18:40 89
DVXC002 12/10/09 19:43 65
DVXC005 12/10/09 11:56 69
DVXC005 12/10/09 15:26 62
DVXC005 12/10/09 17:35 85
Need your help urgently....Thanks in advan...E2K3
Our company is preparing for E2K3, one of the new policies we wanted to
enforce was Prohibit Send and Receive limits. We did not enforce this in
Ex5.5, but now we want to. Planned E2K3 limits would be 90MB-Warning, 100MB -
Prohibit Send and 300MB - Prohibit Send and Receive.
In our initial testing, it appears as though the Prohibit Send and Receive
limit is not checked or enforced until the MAINTENANCE INTERVAL (MI)is run.
We have this (MI) set to run at 1am-5am, so it looks like a user could
continue to receive mail, say up to 900MB+ prior to the MI run, and after it
runs, mail would ...Import directory data into Excel 2003
I have over 1000 media files that I would like to extract information
from and put into an Excel spreadsheet.
Using Explorer, I have defined the fields I would like to see, such as
title, duration, comment etc. Now, I need to import this data into
So far, I've not been able to find a way to do this. Can someone offer
some suggestions please?
www.myoldcontacts.com - Tell your friends to tell their friends
www.sysadmininc.com - Consultancy, Service, Sales, Networking...
www.british-expats.com - Connect with British Expats World Wide
www.kxez.com/shows_britishinv...show last data point in chart
I am charting a range of observations/data points. Is
there a way to make the last data point show up
differently on the chart (different color/shape)?
> I am charting a range of observations/data points. Is there a way to make
the last data point show up differently on the chart (different
Click the charted data once to select the entire data series. Pause. Click
the single point to select it. Then use the Format menu.
Thanks for your reply.
Well, that would work if I knew which point on the chart
...Copy Data from One Group of Cells to Another Group
I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date
order. When I enter data into the last row of Sheet 1, I need the data in
that row in columns A, B, C and D to be copied into Sheet 2 columns A, C, D
and E in a newly inserted row 14. Is this possible with the use of a macro? I
can find the last cell in Sheet 1, but then need to go up one row and back to
column A. I am having difficulty with that.
Thanks is advance for any assistance offered!
/s/ Alan Auerbach
On Sat, 26 May 2007, ...Import excel data to outlook calendar
I have found lots of tips to import excel data to the
address book, etc, but can't find how to "custom map" or
how to import data from an excel spreadsheet into the
outlook calendar. Could anyone make any suggestions?
normally you are in the wrong newsgoup, but I try to help you.
- First export the dates from your OL calender to an excel file.
- In this file, you can find all the headlines for importing.
- If you try to import date, be sure that the headline matches as described
- Then to the normal job for import in Outlook
Ich hoffe, das hilft / ...Registration Entry for External Data Refresh Prompt
Hello, I have several Excel Workbooks with external queries, pivots, etc. I
have "ASK TO UPDATE AUTOMATIC LINKS" checked in TOOLS - OPTIONS. But it
seems like I still stometimes get asked whether or not I want to update.
Particularily I notice when I close the workbook I may get prompted if I want
it to automatically update. Is there something I can do so I do not get
prompted? Something in the registry perhaps?
Thanks for any assistance!
...Showing the perimeter of a set of (X,Y) data!
Good day all,
I need to plot the perimeter of a set of data.
I have a set of (X,Y) data with error bar and it is a nice mess so I
just actually need to see (show) the area were the data can be found.
Then hopefully overlay an other set of (X',Y') data and show that they
both cover the same surface of existence.
i.e this is a set of metrology measurement in X and Y of a part build
from different mould. Obviously you get a nice cloud of X and Y but
does the new material offer the same 'cloud' ?
I think the easiest way to do this is plot the data on a XY Scatter cha...How do I get total value data labels in a stacked bar chart?
I have a 3-D stacked bar chart with four series and I want to have the total
value in each category be displayed in a data label. Can I do this, and if
This should help
> I have a 3-D stacked bar chart with four series and I want to have the total
> value in each category be displayed in a data label. Can I do this, and if
> so, how??
Andy Pope, Microsoft MVP - Excel
Thanks, Andy. The CFO is thrilled.
"Andy Pope" wrote:
I have a subform (datasheet view) in a form where I want to make one column
a different color. I can go into Design view and change the color but it
doesn't change in the form view. This form was made ages ago with an
automatic format and now I can't get away from the automatic format. Help!
"DSmith" <donna@DONTSPAMresxrn.com> wrote in message
>I have a subform (datasheet view) in a form where I want to make one column
>a different color. I can go into Design view and change the color but it