Custom Outlook 2007 forms to sharepoint
Can someone please confirm and help with me trying to publish of send a
custom outlook 2007 form that i have created to a sharepoint list of even a
Can this be done and if so is it hard to achieve?
Thank you so much in advance!
...problem creating report
I have 15 working forms from 2 diferant colums from one table
what I want is to run each query on its own line of a report with 4
calculations at the end
I can select 1 query and produce the first line but how do I move to
second line and query?
Duane Hookom wrote:
> This is a really unusual question. What do your forms and columns have to do
> with your queries and report?
> A report can have only one record source. This record source could be a
> union query. You can also use subreports to display additional queries.
...Access 2007 SP1
the following message was posted several months ago on this newsgroup
and on microsoft feedback page from access 2007 beta release
in access 2007, I can click the "page setup" menu then the "page setup"
button, and choose to print the report on a specific printer. However,
after saving the report and re-opening it, he still prints on default
printer. The specific printer setting is not saved with the report (this
worked with all previous versions of access, it s...Copying only report sheets
Hi: Happy new year. I created a MS excel workbook which has 4 data
sheets and 4 report sheets. Each report sheet links to each data sheet.
Now I want to create another workbook that will show only the 4 report
sheets. How can I do it in VB code? Agin, in each report sheet, I copy
and paste data from data sheet and thus each report points to
individual data sheet.
Best wishes and thanks
jesmin's Profile: http://www.excelforum.com/me...Editable .doc bound report object in Access 2003
I have a report which containers a bound word file, which allows me to edit
the wording in Word.
However, when I convert the database to the .mde format, I loose that
Is there a setting or a way I can keep that functionality for this report in
the .mde version?
...Error printing report: "specified path for the output file does
I'm trying to print a Payable Distribution History report but get the error
"specified path for the output file does not exist". It does not happen with
other reports. Any help to fix this error would greatly appreciated.
go check the Report Destination screen and make sure that there is no path
listed in the field where you can enter one. It would be in the File checkbox.
If it is grayed out, mark the File option, delete the path and then unmark
the File box. Should you want to save it to a file, then select a valid path.
When I create a userid object for a new employee in 'Users and
NT account is created. I usually wait about 3-5 minutes and the email
Yesteday when I created a new user the email address took about
15 minutes, but Exchange 2003 only created a X500 email address. No
I am thinking that this is a problem with RUS, however I have run a
rebuild and update, and still no luck, I cant seem to find any messages
in the event log either!
I deleted the entry and recreated the same user with the same result.
I hope someone can help me!!!
Tha...How to create treeview active control as another activex control's child?
I want to create an activex control who will wrap a treeview active
control but has some its own logic. I don't know how to create it and
how to set its position and size. say,if I want my active control's
size is the same as the treeview active control. Any idea ?
...Help creating two listings from one record
I have extracted "members" from my database. One record will contain
LastName and FirstName, and may also contain SpouseName. Because I am
creating membership cards in Publisher, I think I probably should actually
create another query or ?? that contains one record with either [FirstName
Probablyl something like ...
If SpouseName greater spaces List SpouseName LastName
else next sentence. List FirstName LastName
I don't have a clue how to do this in Access. Appreciate all help.
Try this --
[FirstName] &a...Visual Basic
I trying to create a table using visual basic, when i try to run it. It
prompt me "No fields defined, can't append Table or Index. Anyone, could
highlight to me what is the problem. My code is as follows:
Public Sub PCreateTable()
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef
Dim idx As DAO.Index
Dim fldTradeDate As DAO.Field
Dim fldStockName As DAO.Field
Dim fldRemarks As DAO.Field
Dim fldCurrency As DAO.Field
Dim fldClose As DAO.Field
Dim fldChange As DAO.Field
Dim fldVolume As DAO.Field
Dim fldHigh As DAO.Field
Dim fldLow As DAO.Field
Dim fldValue As DAO.Field
Dim fldDay...Creating Postcard 2 UP & 2 sided with Mail merge
Good morning. I hope that some one can help with the design and setup for
doing the following:
1) Postcard 8.5 by 5.5 (basically half of 8.% X 11 letter paper).
2) Print on both sides
3) Mail merge on both sides
How do I set it up so that I can have 2 postcards to be printed on 1 sheet
using either one of MS Publisher or MS Word? (prefer Word)
I know that my printer does it.
First, I already have the design in both MS Publisher and MS Word.
I also have the mail merge done.
Page Setup: Width 8.5 Height: 5.5
Paper: Letter (8.5 X 11)...Keep Pivot Table custom chart type
I'm creating a pivot table custom chart type "Line - Column on 2 Axes". The
chart looks great when I create it. The problem is when the user does
anything to the chart (filters the data, adds a new flield of data, etc.),
the chart changes to where both data series are displayed as bar charts and
the second axis is gone. I can't find an event that fires when they modify
the chart, so I don't know that I can programatically change it back. Is
there a way to keep it from changing in the first place? I'm using Excel 2003.
Loss of formatting is a known prob...Importing of customizations is not complete
I develop on a separate server, the customizations are exported and then
imported and published on the production server. Even though I get no error
messages not all customizations are loaded in the production CRM!
As far as I can judge it concerns relatively "small" modifications such as
the modification of the display name of an attribute. I can find the modified
display name in the XML file but it doesn’t get loaded!
I have a script running in an EXCEL document that creates new workbooks
based on input from the user. It then saves the file in a set location.
I would like to adjust the code to creat a shortcut to the new file and
place the shortcut in a different folder.
Is there a way to do this?
In the VBE editor, go to Tools > References and set a reference to 'Windows
Script Host Object Model"
Now, the code below would create a shortcut named "Book1Shortcut" located in
the folder "C:\Test\myfolder" with the target Excel file of the shortcut
being "C:\Test\Boo...Creating an additional profile in Outlook 2000?
Iam a newb with Outlook and have searched on here for a solution to my problem.
I am using XP home edition and Outlook 2000 with update of SP3. My ISP
provides me with 5 email accounts, all of which are not aliases from my
understanding of what an alias account is. Mine are
I am wanting to be able to access 2 email accounts, one with my nickname for
friends and forums and the other for my new business, while using my version
of Outlook 2000 without having to upgrade to a newer version.
I don't want to create a new '...Customizing menu item names, form names etc.?
Is there any way to customize the names of forms - for example if I
want to call an "account" a "business partner" and modify it in the
menu items and form/view names as well, can I do it?
Thanks in advance,
...Delivery report #2
In an Exchange 5.5 installation, sometime (only sometime) when I send a
message such this :
- a messange sent from A to B (internet address), cc C
I get the delivery report :
From : server administrator
sent : <date time>
to : A
subject : <message subject>
to : B
cc : C
subject : <message subject>
sent : <date time>
was delivered to :
D (a new internal address !!!!) <same send time>
Any ideas ?
Probably an alternate recipient on user A, B, or C. At least that'd be my
Open Exchange Admin, look at the properties or user A, B, ...Using a listbox selection to limit records in a form and report
I am trying to use a listbox of names to limit the results of a form to just
those names. On a similar track, I want to use the selected names to limit a
report. I have the listbox created and have added a button next to it to
initiate the next step, but cannot figure out how to do it. Also, would like
to (if possible) use multiple listboxs in the same way (ie, name and/or
"dascooper" <firstname.lastname@example.org> wrote in message
>I am trying to use a listbox of names to limit the resu...Printing a range of invoices for 1 customer
I've been vexed by this a lot over the years, so thought it was time to make
sure I wasn't missing something obvious.
When a customer's account goes overdue, or one day they decide they want to
"settle", is there a way to (in one fell swoop) print all the open
transactions for that customer?
I don't mean just the summary you can get from Receivables Transacting
Inqury--Customer. I mean I want to print each open SOP document complete
with all the line details (without opening each one, printing, closing, and
going to the next one and repeating).
Any a...Custom scrollbars
Is there way to implement custom drawn scrollbars for standard controls such
as treeview and listview? References to code samples would be greatly
...pivot table: create worksheetsheet using pivot table
While working in a pivot table, I accidentally created a new worksheet in my
file with isolated data from the report e.g. pivot table shows all days of
the month with totals for each deposit account... my 'accident' created a
sheet with all the data for a single date. It turns out, this would be a
useful tool for my manager, but we cannot reproduce my accident. My mouse
was on the blitz and after a few solo selections the new worksheet appeared.
Does anyone know how to do this (intentionally)?
...Using custom fonts
I've been playing with this now for a while and it is starting to anoy me. I
create my own font file (*.fnt win3.00 format), but no matter what i try, i
cannot get the following font character codes to show... They always show as
the "replace char with this char if not found in font set" character, no
matter what control i try to use this font with!
0xHEX ( ASCII )
0x82 -> 0x8C (130 -> 140)
0x91 -> 0x9C (145 -> 156)
0x9E -> 0x9F (158 ->159)
All other font characters show up correctly without problems...
Is there somthing i am mis...Discrepancy with report and x/z tape for weighted items
We sell chocolates by weight at one of our stores and we have found that
there is a rounding issue with this item, it processes correctly but at the
time of closing the sales amounts on the x/z report do not match, it is
usually a penny different but because of this the batch won't integrate to
our accounting software (Great Plains). Does anyone know how to fix this
...Can Publisher create professional books?
I've been told that Publisher can't really format professional
books and to try a Tex variation.
Wondering about opinions on this. I don't want people to be able
to distinguish any difference between a book I publish and
any other book in a bookstore.
Also, what version of Publisher is recomended for this? I am
using one for Win95 and it can't suppress headers on final pages,
which makes for stupid looking end pages. Do later versions have
significant improvements for the book publisher and what are they?
Thanks for your help.
ParaMind B...Print 2 reports
Is it possible to print 2 copies of my report using the following code?
Private Sub Command27_Click()
On Error GoTo Err_Command27_Click
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
strWhere = "[WarehouseID] = " & Me.[WarehouseID]
DoCmd.OpenReport "rptWarehouse", acViewNormal, , strWhere