Access 2003 Look up field not displaying properly
I have a look up field in a form that is not displaying correctly. When I
open the form and click on the Business area field, my combo box opens
however there is no visible list to choose from; however if I pretend i see
something scroll down and click, then one of the choices does appear in my
What am I not doing?????
First guess - look at the Column Count and Column Width proprties.
"Diana1130" <Diana1130@discussions.microsoft.com> wrote in message
>I have a lo...Default document has 10 point spacing after lines can't find a way to change this default, though i can change it in each individual document
Operating System: Mac OS X 10.5 (Leopard)
I can't find a way to change this default, though i can change it in each individual document
> I can't find a way to change this default, though i can change it in
> each individual document
Open the Normal.docx template and change the font size there. Save and
from then on, all new documents based on Normal will have the font size
--- Mac:MS MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http...Excel
Can anyone tell me how to convert a date to the number of
days ago that date actually was? I need to find the number
of days ago. Thanks in advance!
the function Today() returns you a number when the cell is
formatted 'General' or 'Number' -today sept 29 you get
37893-. Apply the same to your date and deduct one from
Generally speaking, why don't you read 'About dates and
date systems' in Excel Help
>Can anyone tell me how to convert a date to the number of
>days ago that date actually was? I need to...Should be extra user defined fields in General Entry
It would be helpful for information purposes as well as customization
purposes to have a couple of user defined fields for the entire journal entry
and possibly a couple for each journal entry line.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft....Compile error in hidden module: NT Reg Code
When accessing Excel, a user is getting an error "Compile error in hidden
module: NT Reg Code" with the option of 'OK' and 'Help' then followed by a
Macro error, "Macro error at cell: [AUTOSAVE.XLA]AutoSave!B202
Any help pr suggestions would be greatly appreciated!
Go to tools>add-ins and uncheck everything you find here, close excel and
re-open and see if the issue goes away. Now add back one at a time,
re-starting Excel each time and when it comes back, that's the one. I
suspect this is XL2000 and it is the autosave add-in that is faulti...Announcement: New tool for C# code generation from UML state diagrams
Hello list readers,
in its latest version SinelaboreRT generates C# Code from UML state
The UML state charts can be designed with the Cadifra
UML editor, Enterprise Architect, Magic Draw or UModel.
The state handling code gets automatically generated and does not
require any additional runtime library.
Here are some of the key features:
- Generates clear code
- Automates robustness checks of the design
- Supporting hierarchical designs
- No run-time environment needed
- No gap between design and code anymore
- Simple integration in different development environments
-...Disabled Field Font Colour
Is there a way to make the disabled fields font either bolder or brigher to
the eye as some of my customers are complaining that the screens are
difficult to read.
This is not a supported way of changing color.
Go to CRM Web folder at CRM server, its usually located in wwwroot and open
the file /_forms/controls/controls.css. Then search the following lines and
just change the color from grey to the desired one.
Similarly, you can change the look and feel of other controls b...How do I find averages?
I have a number, lets say 80. I want to find other values, lets say 10 number
values, between 50 and 100 such as that those numbers added have an average
In other words:
a + b + c + d + e + f + g +... = 80
How can I find random values between 50 and 100 (a, b, c, d, etc) whose
average is 80.
Is it possible in Excel 2000?
Can any of the numbers be zero?
"Daniel Lugones" wrote:
> I have a number, lets say 80. I want to find other values, lets say 10 number
> values, between 50 and 100 such as that those numbers add...contents of 'From' field changed after upgrade to 2003
I recently upgraded our Exchange 2000 environment to
2003. As soon as all mailboxes were transferred to the
new server, the bulk emails that are sent out from my
company, showed 'username@domainname' in the 'From' field
instead of the Display Name. The Display Name has always
shown up in the 'From' field until this upgrade.
All internal mail from Outlook still shows the display
name, all SMTP mail shows the username@domainname format.
Have looked at the modifications to the schema by 2003
but can't see anything that makes sense to me regarding
C...In VBA how do I link the fields of a form to an on-the-fly SQL que
I have a form whose fields are linked to an underlying table of
constellations and their variable stars. When the form opens it is initially
linked to the entire table-- all the stars in all the constellations. On the
form, I create a SQL query by searching on a single constellation, and I want
to be able to do this over and over again as I work through the various
constellations. I don't want to save the query-- just a temporary one in
memory while I am adding new/updating old records for the selected stars. I
can create the query OK-- the SQL works fine. But once a new qu...How can I update all fields in Word 2007?
In Word 2003, I used to be able to Select All (Ctrl-A), then right-click
anywhere and choose Update Field - and that would update all my
cross-references in the document, including Tables of Contents and Figures.
How can I do the same in Word 2007? (the former keystrokes don't work).
Update Field may not be on the context menu depending on what, exactly, is
included in the selection. However, Ctrl+A and then F9 will update all
fields in the main body of the document.
Note that switching to Print Preview and then back to your favorite view is
also helpful, as this forces ...Cube and custom field
I want to create a cube that will show an evaluation of “out of project”
actual work hours.
For this I created a Custom Field in the Resource to contain the
[Estimation] in % that is to be used.
I created a second field in Resource to contain the following formula:
[Actual Hour] * [Estimation] / 60
Example: If we estimate that a resource is working 10% of is time out of
projects and the resource worked 125 hours, the expected result is 12.5 hours.
The result is what I expect in MS Project – Resource View
How can I obtain now to obtain a view that will show me the sa...primary key collisions due to auto reseeding of auto number field.
has anyone come across this problem in Access2003
Can you be more specific, Simon?
Is the AutoNumber being seeded intentionally?
Or is it one of the causes listed at the top of this article:
Fixing AutoNumbers when Access assigns negatives or duplicates
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"simcon" <firstname.lastname@example.org> wrote in message
news:0AFF03CF-F2B6-4312-ABA3-9DF036466FBD@m...How to find the right MLM business online that succeeds for you
U can 2
Building a MLM business can have it's advantages
* Lifetime Residual income
* Financial Security
* Spend more time with your kids
* Get out of debt
* Drive a new car
* Purchase a vacation home
* Pay off your mortgage
But to be successful, you must choose the right company.
* Choose a company that is at least 3 years old.
* Choose a company that has a product or service everybody can use.
* Choose a company with a easy to understand compensation plan.
* Choose a company that has a low monthly fee, where most everybody can
* Choose a company that ...Select a query showing only selective post codes relating a relevant postal area
please could you help as i would like to run a query only selecting relevant
post codes from my database. The post codes i would like to select are from
ST1 to ST4, ST6 to ST7.
Thank you spending time to help this issue
Message posted via AccessMonster.com
I assume that those are the starting three characters of the post code and
that the next character is a space. You could try a query using the criteria
Between "ST1" and "ST4 zzzzzz" OR Between "ST6" and ...Find and Replace a Style
Can you find and replace a style in Excel?
When you modify a style, Excel automatically applies the changes to all
styles in the workbook. You can copy the style if you want to save the
"Jim Bennett" wrote:
> Can you find and replace a style in Excel?
Thanks for your post!
My problem is that I already have 2 styles in use in the spreadsheet and I
only want to use one of them. I have many cells using both styles and I want
them all to use just one. I am familiar with the procedure in Word but I
can't seem to find the same functionality in Excel.
"Pete...Can't find Outlook files
VERY long story short...
My machine's motherboard got messed up. I bought a new
machine, installed Office XP Small Biz, then slaved my
original hard drive in the new box. However, I can't
seem to get Outlook to recognize/find my old inbox. What
files should I be looking for or how can I do this?
Unfortunately, I didn't regularly archive my
inbox/personal folder structures, so there's no .pst
files on the old drive. They have to be there somewhere,
though, right??? I can't ever seem to find anything that
makes sense in MS Knowledgebase - can anyone direct me
...How do I move Office 2007 from old to new PC? No CD, have code
I just got a new PC with Windows 7. I already had Office 2007 on another PC
and want to move it to the new PC. How do I do that? I don't want to buy
another copy of Office 2007.
"Rich K" <Rich K@discussions.microsoft.com> wrote in message
> I just got a new PC with Windows 7. I already had Office 2007 on another
> and want to move it to the new PC. How do I do that? I don't want to buy
> another copy of Office 2007.
To MOVE it, just uninstall from the old and install on t...Quickest and easiest way to migrate old "Include" code to aspx
<!--webbot bot="Include" U-Include="_private/standard_footer.htm"
I have an older FrontPage site I am trying to quickly upgrade to ASP 3.5.
The code above (called by most pages on the website) no longer works
though -- it doesn't show anything. What's the quickest and easiest way to
get it going (I've finished most all other things and don't really want to
go down the Masterpage path if possible).
On Mar 17, 11:44=A0pm, "Mark B" <none...@none.com> wrote:
> <!--webbot bot=3D"Include&q...Can you add a user-defined field to the new task dialog box?
I use a custom arrangement to view my tasks in which I have a field called
"No." (for number). I use it to order the tasks each day. That works fine.
However, when I double click a task or if I start a new task with the
shortcut key "Ctrl+Shift+K" (or Ctrl+N), a dialog box opens. This standard
dialog box for an untitled task doesn't contain a field for my "No.".
Is there a way I can modify that dialog box to add a number field that would
show up in my custom arrangement under the "No." field? i.e. basically, I
want to ad...Counting records according to an field value
I'm trying to get a simple matrix set up in MOSS that summarizes incident
ticket totals. I just want it to count all the open, closed and resolved
tickets and report them in a nice 2X4 matrix as a web part.
...Graphic converter missing?
One of our people has been using a specific clip art on
Publisher 2003 (Win XP) fine, but now when she tries to
insert it from the clip art she gets the message that says
she needs a graphics converter. The instructions say to
go through Add or Remove Programs then click the "Change"
button, but no luck. I reinstalled Publisher 2003 from
the original CD, still no luck. She can copy and paste
the specific graphic from a previous document, but she's
afraid that others she may want to use but does not have
in an existing document may give her the same message. Any
idea ...Lock fields in subform except two after authorization date is ente
Need assistance from the experts. I used the following code to lock the
fields in a subform per a request. Now I have been request to lock all the
fields except two in the sub form and I am not sure how to handle this. I
tried enabled on the different fields but that did not correct the problem.
The goal is to enter data for that record and once an authorization date is
entered it would lock the record. Is there a way to allowedits and lock it
back if someone needs to change the field StructureKeymark? Thanks in advance
This is just a few lines for the main fiel...set field data as control source of another field in a report
In a table I have fields as [a], [b] .... and so on.
for each record I have a special calculation, say
[a]+[b] for a recored;
[a]*[b]*[d] for another recored, and so on.
I would like to use these calculation formulas which I have saved in a field
of the same record as a calculation (as a data in a seperate field) in a
Have I misunderstood this. When you say that you have a special calculation
for each record in your table, do you mean that you have typed the text
a + b + c
in your table?
If yes, may I suggest that you do this in a query grid so that the query
shows the result of you...Finding and Deleting
I have the same issue as in this post (with a different word) from 2005:
****I need to find the word "High" in a whole speedsheet, and remove the
row containg that word.
This was the response:
My question is how do I apply the solution? Where does this does this code
go? Any info would be greatly appreciated.
My question is how do I apply the solution? Where does this does this code