Submit button to email for request form to be approved/denied
I sent a message earlier about the submit button in access. What I have
designed is a form that a user can go into and enter information then once
they hit the submit button it will go to the specified email address but I
don't particularly know how to code it. The way it is designed I think I
would have to have different forms so that the user can submit it then it
will go to another form. The approving parties will approve or deny the
request then submit the information back, then that email will shoot back to
the user who requested approval. Can anyone help me on...Exchange 2003 truncating SMTP data #2
I posted a message about this a while back and was not able to find a
solution. We are running Exchange 2003 Service Pack 2, and have
discovered a problem where if a message has a single dot "." by itself
on a line, the message is truncated at that dot. This only happens for
outgoing messages from our Exchange server to other outside servers via
SMTP. Internal messages and incoming messages are fine and don't have
I believe this has something to do with the SMTP end of data character
being a dot ".", but we haven't been able to figure out w...Analyze Tool
I have a query list that is quite extensive (I think). Several, perhaps the
majority, of the queries use output from other queries which use output from
other queries, etc. I am going to be importing these queries to a new SQL
server (Finally!) and do not want to have the normal problems I have endured
in the importing from a test to production environment. Is there a report I
can run that can show me what calls what and where the query is on the 'food'
Thank you for your awesome knowledge!
"Bunky" <Bunky@dis...How to send data in "Post" format instead of "GET" to a server in MFC
I have a problem I send my data in GET format to a server but they want
me to send it in POST format otherwise they invalidate my request.
This is my current modified code to send the data
pFile->AddRequestHeaders("Accept: text/*\r\nUser-Agent: OzAu\r\n");
But is still doesnt work as i am appending data as query string at the
end of the url. how do i send that data in a post format in MFC ?
...Exporting Data from access and appending to an existing excel sprd
I run a series of queries each month in an access form that I have created. I
can export the data into a new excel spreadsheet no problem. I am just
wondering whether or not there is a way to export the data into an existing
excel file and append it to the bottom of data that has been exported in
previous months. It's not really critical, I'm just trying to make things
that much easier.
You can always use the drag and drop technique. Open the Excel file to the
desired worksheet, then minimize it to your task bar. Drag a saved query from
your database to the...Analyze Excel files structure
Does anyone know of any tool to analyze Excel files and display/print
information about the file such as:
Number of worksheets
Number of external data sources, type of source
Number of macros
Number of addins used, name of addin
Security settings, although I'm really not sure what I want to show on this
Any help will be greatly appreciated!
Thanks in advance,
...PDF Table to Excel Spreadsheet
This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.
Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.
http://www.google.com/sea...How can I swithc my x and y labels & automatically have the data m
I have data from a survey. The question number is on the horizontal x and
the subject number is on the vertical y. I want to switch these two and have
all of the data automatically switch over too. I don't want to have to
re-input all of this data.
If it fits (limited by only 256 columns).
select the range
Select a cell outside this area (new sheet??)
edit|paste special|click transpose
> I have data from a survey. The question number is on the horizontal x and
> the subject number is on the vertical y. I want to switch these two and ...External Data
I'm importing a txt file generated by SAP. Using Import External data works
fine, on refresh, the numbers with a trailing minus ( selected under Advanced
Text Import Settings) reverts back to text. I "Edit Text Import", reset
that, refresh works fine. Then I save and close file; open file refresh 1111-
is text again.
How do I retain the settings permanently?
I have a column of data (numbers) which I want to turn by 90 degrees and
make it into a row. I think this is called 'transposing'. ?
I thought there was a transpose option on the data menu, but can't find it.
There is a TRANSPOSE function which I've tried, & can't get to work - what
is meant by 'enter the formula into an array' as suggested in help ?
Can anyone point me in the right direction please ?
I have Excel 2000
> I thought there was a transpose option on the data menu, but can't
> find it.
Its on the Paste Speci...Dynamically moving from one form to another
I'm trying to build a module that when a user closes a form (say form 2), it
will take them back to the form that called form 2 via a close button on form
2. I want it to work on all my forms, so that no matter what form gets
closed, it will take them back to the original form then close form 2.
I set up two public string variables in the forms. One that contains the
caller form and one that contains the current form. I figgured that when I
pass both of those variables to the module, it will move to the caller form
then close the current form.
It maintains the variables th...On scatter chart, how can data points be moved with curser?
EXCEL 2003 allows data pointa on a scatter chart to be draged from one
location to another. I use this feature a lot to fit an equation with dummy
data points to actual data points. I am unable to do this in EXCEL 2007. I
have asked others with this new system and they were not able find a way to
do it either. Has this function been removed? How can this feature be
According to MS documentation:-
"Direct manipulation of data points: In the past, you could select a data
point in a chart and move it — which also changed the underlying data. This
rarely use...Subform not showing all data
I have a subform that the agent can enter comments in regarding the owner's
request. I have set it up so that there is a history of comments. The
matching links are a home-grown key that will not change for a request, the
specialist, and an option that is chosen by the operator. My problem is I
want all comments to be shown but I auto-populate the option and specialist
from the Main Form for any new comments. Ideas?
On Thu, 27 Sep 2007 10:43:06 -0700, Bunky <Bunky@discussions.microsoft.com>
>I have a subform that the agent can enter comments in regarding the owne...pie chart with text data
I'm a newbie at some of the functions of Excel and this is one of
them. I need to take the responses to a survey that have been saved as
an excel sheet and make them into a pie chart. There are 5 answers and
4 categories. Is there any way to do that? I would appreciate any help
I can get on this one. Do I need to assign a numeric value to each
response and another to each category? Like I said, I haven't used
some of the functions in excel and this is one of them. Thanks for any
It isn't clear what you want to do.
Do you have many responsdents, each responding to 5 an...great plains user can't connect to sql analyzer
Does anybody know why a great plains user can't connect to sql analyzer?
For example, within great plains I created user 'utest', password: 'utest'
and gave permission to access a company. Then I could see, through sql server
enterprise manager, that login session 'utest' was created. So I tried to
connect to sql analyzer using that user but it fails to connect.
What I could see is that retyping the same password using enterprise manager
or sp_password then it's possible to connect that user to sql analyzer.
I'll appreciate any insight on the s...selecting a default field when opening form
I know this is probably really simple, but I need some help, please. When I
open a form to enter data, there are several fields on the form....Customer,
Part Number, Date, etc...how do I get my cursor to go to the field I want
when an operator opens the form? For example, when I open the form, I want
the cursor to be in the "Customer" field ready to enter data. Thanks for the
Message posted via AccessMonster.com
Use this code in the OnOpen event for the form:
I have a large list of data and I need to separate the numbers into a
separate column. My data looks like this:
Abasraju(C. Blanca, Peru) 297-8
Achey, Jeff 67
Adi Kailash "Little Kailash" (India) 365-6
Africa 338-9, 342, 346-8
Agua Negra 1980: 99-108
I want to put the text in column A, and move the numerical values to
column B. I would appreciate any help. Thanks Ralph
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Assume the data starts in E1 going d...Two Data Sets: Stacked Column Chart
How do I show two years side-by-side in a stacked column chart? I want to
compare two "stacked" columns each month (one for each year). I can create
one showing each month for ONE year but I want to add another year in another
stacked column for each month. Can this be done?
Yes, it can be done. It just takes some careful arrangement of data. See Jon
Peltier's excellent site on charting:
(depending on your browser, you may need to scroll down a bit to get to
beginning of article)
Luke ...Where is the Customer Data stored?
Where is customer data is stored? Is there any way to access this data
outside of logging into Point-of-Sale.
In a troubleshooting nightmare, I was instructed to save certain files and
uninstall POS. I have tons of POS files remaining, but am unable to log into
POS on this system. I want to save my customer data and reinstall.
The customer data is stored in the CUSTOMER table - you can access it via SQL.
"ShaVonya R." wrote:
> Where is customer data is stored? Is there any way to access this data
> outside of logging into Point-of-Sale.
> In a troubleshoo...Adding multiple source data to chart
I have a column chart with two x-axis'. I have a data
line representing stock prices running across the chart,
and stock volume in columns. When I add a second stock
price line, the first one disappears.
Are the two stock prices significantly different? One in single units,
the other in hundreds of dollars? Are they on the same axis? What else
is unique about the data set? And, in how you are plotting it?
MS MVP Excel 2000-2004
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
I...Admin = form works User = form fails
This is a real stumper...
I have an ubound main form named frmCreelWaste. It has a combo on it
I have a subform based on a select query against tblCreelWaste.
The main and sub are linked by Parent = cboWarpNo to Child = WarpNo.
In the .mdw file, there is a Group called WarpGroup, of which WarpRoom
is a member, and...
User WarpRoom has Open/Run permission for both forms.
User WarpRoom has ReadDesign, Read, Update, Insert, Delete for
WarpGroup has Open/Run permissions for both forms.
WarpGroup has ReadDesign, R...How to Import data from Lotus notes
Ours Client hawe Lotus Notes database with Customer and Contact data with
word attachments. How to migrate data to CRM.
My problem is how to export data from Lotus notes !
Please advice for method or tool
Not very difficult to write "universal" agent, able to export all items of
selected documents into Excel sheet. Then just rename column headers and Save
as.. as CSV file - and import into MS CRM.
I have done whatever is given in the Post Callout MSDN example.
I am not able to generate the three files which should be generated when
create, update, delete happens.
We tried to debug the same and added a sample output to constructor class
and we got the output. But the other three outputs are not generated.
If anyone faced similar situation before, kindly let us know the solution.
I've answered this question in the developer discussion. Please do not post
the same questions in more then 1 duscussion.
With kind regards,
Avanade Netherlands...Purchase Order Form
I use MS Access 2003.
I would like to create a Purchase Order form that is similar to the one in
the sample Northwind Database. The difference in my form would be that all
items for the supplier will be listed and viewable (instead of selecting from
a drop down list - for each item to be ordered).
This would be the procedure for creating a purchase order:
1st select the supplier from a drop down list. Then just enter quantities
for the items you want to purchase. When completed, I would like the form to
display ONLY the items that have quantities, so I can print or email it to
the s...problems with copying data to clipboard
Hi, I've been working on this for some time, and I can't figure out my
problem. I'm using samples straight from the newsgroups for my code,
but I get an Unhandled Exception: User breakpoint when my code calls
Here is my code. It gets text from a CListbox, coverts it to a
CString, and follows the usual procedure for pasting it to the
clipboard. I've changed the strcpy line from copying the curItem
string to copying a simple "test" string, and it doesn't work either.
Here is my code: