Outlook 2003 Forms issue.
Very strange problem.
Outlook 2003 with SP2 and the MUI pack (French) installed. All installed
as part of the full Office 2003 suite. The MUI is installed so users can
choose if they want Office in English or French.
When Outlook is launched in English, it all works as expected.
When you set the language to French, if you go to Tools | Forms | Design
a form and then click on any of the forms (like appointment) we get an
"Microsoft Office Outlook ne peut pas enrigistrer le formulaire. Une
erreur s'est produite et ce composant ne fonctionne plus correctement.
Veuil...form's won't open
i have a front half of a database that i use successfully at one pc (where
the back-half is located). i've put the front half on other pc's and linked
them over the network to the back-half successfully. at another store's
location, i repeated this but had some problems. on the main pc, everything
is fine but on another pc, the front half doesn't work at all. it's set up
to open a launcher form at startup, which works, but all of the buttons on
the launcher form don't do anything. either nothing at all happens, a new
window opens for a brief second and then closes ...Handle Duplicate Primary Key Field at Time of Entry Instead of at Form Update
Note: This was originally posted at the queries group by mistake ......
Hi Folks - Currently, I am using the Error Event of my form to capture
duplicate key entry. However, this is not invoked until the form updates. Is
there a way to check for a duplicate after the user tabs out of the primary
key field? Thanks.
"Jeff Boyce" <firstname.lastname@example.org> wrote in
> The Primary Key of a table is used to ensure each row/record is
> unique. How is it that you are allowing your users to "crea...Trying to add a field from another table on a form
I've added relationship between the form's master table and the other table.
I've updated the control source on the txt box to the table/field that I need
(=[table]![field]) but all of the fields are displaying as "#Name?" on my
form. I'm sorry, I know this is probably something stupid.
Use a query as the forms source and join the tables in the query. Redo the
text box control source.
Build a little, test a little.
> I've added relationship between the form's master table and the other table.
> I...Dynamic map within Excel based on spreadsheet values
Hi, I hope this is possible, we have a team of people working on mapping
different areas of a city. Each area they are working on is called an
AOI or area of interest. These are custom polygons drawn by hand, not
states or anything like that. The excel spreadsheet keeps track of how
much progress they have made on each AOI. I was wondering if I could put
a dynamic map in the Excel spreadsheet showing the current status of
each AOI, based on a color scheme.
I've tried Mappoint but had trouble making the custom territories, it
seemed geared mostly towards using pre-defined territorie...Automatic Populate Todays Date in Cell when File is Saved.
I am creating a user data entry spreadsheet in excel and I want to record the
date in a specific field when the excel file is opened. I need the field
"Submit Date" to be automatically populated and protected when a user opens
the file and performs a save. If the user does not Save the file the date
field should remain empty. Can anyone help with this please?
Paste the following macro into the Workbook module. You access the Workbook
module by right-clicking on the Excel icon to the left of the word "File" in
the menu across the top of the spreadsheet, select View C...Copying toolbars from one PC to another
Is there a way to copy a customized Excel toolbar from one PC to another?
Excel stores custom toolbars in a file called Excel.xlb. It is normally
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel ( \
in Win2K or later, or
C:\Program Files\Microsoft Office\Office\XLStart
in Win98 or earlier. Find it and copy it to the target PC in the relevant
"Shieber" <email@example.com> wrote in message
> Is there a way to copy a customized Excel toolba...How to refer the results of one cell to another cell?
If I have the following spreadsheet, how do I get a
calculation in D1 to put the value in A1 as well (as D1)?
A B C D
1| 2 3 =B1 + C1
I don't want to put the formula into A1, just the value --
'5' in this case.
Select D1 then Edit > Copy
Select A1 then Edit Paste Special and check value.
"Dave Boland" wrote:
> If I have the following spreadsheet, how do I get a
> calculation in D1 to put the value in A1 as well (as D1)?
> A B C D
> 1| 2 3 =B1 + C1
> ...Update Form
I have a main form which has combo boxes which pull from a table to fill in
Sometimes these tables need new data added. I have added a command button
which opens a second form where the list can be updated.
When I close the second form the new choices do not appear in my combo box
unless I close and re-open the form.
Is there a way I can do an automatic refresh or update without having to
close the main form?
Thanks in advance
After you have updated the table behind the list,
you can requery the main combo form like this:
repla...How do I hide zero values but keep currency format in P.O. form?
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total cells
to only show price values when there are values in Quantity and Unit Price?
When you format a cell as currency you get a custom format like this
(depending on the otpions you chose)...
Choose the ...Multiple pictures for current status display in a form
I tryed to look through several groups but haven't found a genius hint
yet. Hope you can help me.
I would like to create a MS-Access form that reads data from an online
system, showing the status of various machines (running, pausing,
actual product and so on). I would like to show on the form a symbol
for each machine. This symbol should be depending on additional status
information. For example a red machine for a stopped machine, a green
for a running... I don't want to use just a simple rectangle but a
jpg or gif.
The next problem is, that I have a dynamic amount of these ...new data-entry form
I have a form that is set to data-entry "True" so that the user can only
enter new records, and not view or change previous entered records.
I have about 10 fields, on the form and would like the first two fields that
when selected on the first entry, become the default for all subsequent
entries until the form is closed. Is this possible? Would it be better to
have a form pop up before starting to enter data that would have the user
make the selections for those two fields first, and once selected, would
become the default selection for those two same fields on the ...Copy Order form into EXcel
I have created a form to be filled in. Before printing out I want to move all
the data created in the form into a database: Excel sheet where all info is
stored per row. In the order I have 1 client (Client A) that buys 3 products
(product 1, 2, 3). In the sheet I want to appear in row one: client A -
product1, row two: client A - product2, ertc.
Than when I create a new form with a new client I want that it appears under
the previous row.
The form has formulas as Data Validation, VLookup
Does anybody knows how to do that?
Can you upload the worksheet to your posting at Theco...After crash, form displays #Name?
I was working on my Db when all of a sudden it crashed. I saved a backup
and closed it down. I opened the back up and now on my main " Job
Information" form, almost all of my text boxes with equations display
"#Name?". Some of the text boxes reference other tables, some other forms,
and some the same form they are located on. I checked the data source an a
select few boxes and all the data, according to my table, is correct. Its
worth noting that the entire DB was working perfectly before this crash.
Now if i go into design mode for the form, delete any t...Form with ADO recordset : ctrl+f gives "invalid parameter"
Hi group !
I think I've said it all in the subject !
I have a form with and ADO recordset as the source (PostgreSQL backend).
It works find, but whenever I try to "ctrl+f" in a field, an "invalid parameter" error raises.
Does anyone know where this comes from ?
Thanks in advance !
...How do I populate a cell with the NT Logon username?
looling for a way, via a macro, to populate the cell with the users "NT
For Windows NT, 2000, XP this works:
Sheets(2).Range("H137").Value = Environ("username")
HTH. Best wishes Harald
"Mike" <Mike@discussions.microsoft.com> skrev i melding
> looling for a way, via a macro, to populate the cell with the users "NT
> Logon" username
...Sort form and remove sort
Hello. Thanks in advance for the help.
I have a form linked to a query listing expenses. After opening, the
form filters based on a selection I make from a previous form.
Form Name: ExpensesAll
Original Query: ExpensesAllqry
Filter Queries: ExpensesNotSub
I would like to add option buttons at the bottom that will allow me to
sort the information on the ExpensesAll form. For example, I have a
field called "Expense Type". I would like to be able to click the
option button and sort this information without having to highlight
t...how can I post to GL from custom form ?
is there any guide, or example of a posting from a custom form ?
I needs ot have a cusotme form to take some data from another DB or customer
tables and then save it in some journal then post it .... ?
anybody done that before / or is it a plain crazy idea ?
You may want to look at eOne Solutions' version of Extender (Enterprise
Edition). It allows one to create forms easily and tie them in to various
transactions in Great Plains. They provide a number of sample application
that will give you an idea of the functionality and how to build it.
http://www.eonesoluti...Change cell color based on contents
Sorry if this is wrong forum, not sure where it should go.
Is there a way to change a cell's color based on it's contents? Fo
instance, if a cell contains zero, I would like it to be red. I
greater than 100, I want it blue. Anything in between 0 and 100, n
color change is required. Thanks
bre's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2076
View this thread: http://www.excelforum.com/showthread.php?threadid=48370
You can use Conditional Formatting from the Format menu to...Excel; Can I Filter based on a cell value?
Is it possible to filter a list based on a cell value? What I want to do is for the user to type in a criteria in cell F1 and G1 (Dept and Acct No's) and click a button that will launch a macro that will filter the list and display only entries that have Dept and Acct No's that match those entered in F1 and G1.
I have looked through the help files in Excel and can't find a way to do this.
If this is not possible is it possible to set something up so that cells that do not fit the criteria are deleted from the spreadsheet somehow? It is ok if non-matching entries are de...Knowledge Base Articles for new Hotfixes
I've been noticing for the last little bit that, whenever a new hotfix is
released, it takes quite a while for the associated Knowledge Base article to
appear for it. In the case of the 293 hotfix, it took almost two months
before we were able to see a KB article and see what would be affected by the
In the future, Microsoft should be releasing the KB article at the same
time. I'm sure I'm not the only one who has had to deal with this.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes....Hide data in a field on a form
I have Privacy Act protected data that I would like to hide from general
users of a database with permissions for specific users. I'd like the data
to appear as a series of asteriks with a "show" botton that pops up a new box
with a warning that data is not to be disclosed. Any suggestions?
Check out Password as Input Mask.
Build a little, test a little.
"Tammy S." wrote:
> I have Privacy Act protected data that I would like to hide from general
> users of a database with permissions for specific users. I'd like the data
> to ap...How to copy Chart and its data to another excel worksheet
I need to copy a set of data AND the chart that I made from it to a specific
worksheet in another workbook... but when I try to just select it, copy it
and paste it in the ither worksheet, the source of the data remains on the
other workbook... is there a way of doing it without having to re-establish
all the links?? Please help!
You can copy an entire worksheet into a new workbook. Assuming yr data and
chart are in the same worksheet, right-click the tab where the name of the
sheet appears (somewhere near the bottom left side), select "Move or Copy..."
in the po...Moving read inbox messages to folders based on sender's address
I like to leave messages in my inbox until I've read/handled the
items. (Minutes or months later.)
Then I like to store the messages in folders and 95% of the time I'll
store the message in a folder created for the sender.
Of course, after using Outlook for 8 years, I have a ton of folders
and spend an inordinate amount of time drilling down throught the
folder heirarchy to find that belonging to my current correspondent.
What I'd like to do is right click on a message from
"BSmith@yahoo.com" and have menu option read "Move to Folder Bob
Is there a ...Re: Appointment Form Question
Thanks Ken, However that field is not enabled in the Appointment form design
window. And Is not available as a field if I create/bind a new text box.
PS I'm using Outlook 2003
"Ken Slovak - [MVP - Outlook]" <firstname.lastname@example.org> wrote in message
> Select All Task Fields and Notes from that group. That will show the text
> the Body of the appointments.
> Ken Slovak
> [MVP - Outlook]
> Author: Absolute Beginner's Guide to Microsoft Office Outlook 2...