Using a formula to fill a field
I am ery new to Access and was wondering, is there anyway to make a field
fill automaticaly with a formula? Like in excel for example if you have a
fromula on a cell and the arguments change the cell changes.
I have a table with a field of invoice amounts and then a table with account
info, i want to know if there is a way for the account table (ie: Balance
field) to update automaticaly when you add an invoice with that accountID.
Access is a relational database. An Access table may look like a
spreadsheet, but it is really just a "bucket o' data". No, you can't ad...Hidden fields in new emails
When I begin to type a new message, the text doesn't appear (the words are
hidden) until spell check/sending/or printing. When I select the icon for
the font color of text (black) it begins to show my typing as I'm composing
the message, but the other words (anything I typed in the 'hidden field')
only shows up in the spell check portion and remains hidden. Why are my
messages starting with this hidden field and how do I get rid of it? I'm
sure I must have pressed some command inadvertently as it was not always
working like this. (only been using about a week so s...Auto Filling Fields in Current Record from Previous Record
I have looked through posts related to Auto-Filling a field from a
previous record but am still a little unsure of how to do things.
What I would like to do is auto fill a field in the current record
with one from a different field in a previous record. What I have is
a form that records "engine hours" and "tonnes moved" for a piece of
equipment. The operator will record the staring hours and tonnes (at
the start of a day) and the hours and tonnes at the end of the day.
So in the database, I would like the "Starting Hours" and "Starting
Tonnes"...Sorting Issue (Mixde Fields)
I have an issue where I need to sort a worksheet based on a field (Bin
Location)that is sorting as seen below...
How can I get Excel to sort it the following way...
Please help.... I need to get this figured out today.
I appreciate any responses.
One way: add a column showing the length of the column you want to sort, then
sort using the new column then the "real" column.
"Jonathan G." wrote:
> I have an issue where I need to sort a worksheet based on a field (Bin
> Location)that is s...Publisher 2003 printing missing
At my school my students are creating newsletters. On random lines...on each
student's printout...there are partial lines printed. Some titles don't
print. Students have tried changing the size of the font, the font itself,
the size of the text boxes, etc. We are always missing partial lines. It is
a different place on each paper and it happens on different printers. Any
> At my school my students are creating newsletters. On random lines...on each
> student's printout...there are partial lines printed. Some titles don't
> p...Outlook 2003 cannot see other email addresses in the to field
Outlook 2003 cannot see other email addresses in the to
field - when someone emails me and a group of other
people, I only see my email address. I cannot reply to all
and send the other people an email. Is this a bug?
No, they probably used the BCC field or a mail merge instead so only your
address shows up.
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Save Embedded Pictures in Their Original Format
-Create an Office XP CD slipstreamed with Service Pack 3
"Jenni&...How do I create drop down form fields in Excel?
Is it possible to create dropdown lists in Excel? If so, how do I do it?
You can use Data Validation to create the dropdown lists. There are
instructions in Excel's Help, and here:
> Is it possible to create dropdown lists in Excel? If so, how do I do it?
Excel FAQ, Tips & Book List
...Adding company name to the "From" field
Hopefully this is an easy problem. We are running Exchange 2003 on Windows
Server 2003 in a mixed domain. (Win2k and Win2003 servers)
Lets say I am working for a company named "XYZ". The owner of the company
wants the "from" line in the email client to say "Bill Smith, XYZ Company".
Unfortunately I can not find a way to do this. Any help is appreciated.
Just use ADModify to rewrite the Display name for every user in your
company, or for users of that company (if companys are sharing and AD)
ADModify can be found here:
http://www.gotdotnet.co...edit suggest names when completing To, cc and bcc fields
Apparently I don't have an Address Book linked to Outlook
2000. No matter, because I seem to be ok with the suggest
names feature, which I guess is not Address Book-linked,
but linked to a memory bank of names and corresponding
addresses typed in during the past.
However, here is my question:
How do you edit this Suggest Names list? In particular,
A. Suppose you want to stop Outlook from suggesting a
particular name because it is not current anymore. Worse,
you might inadvertantly click on it and send msg to
somebody you don't want to receive it. Is there a way to
delet...2003: Copy R-Click Option Missing!
In outlook 2003 when i right-click on an email message,
only the move command/option is there (amongst others),
but the copy command is missing?
the only way I can copy is to drag the message to a folder
with the right mouse button depressed and then the copy
option shows up.
Why is the copy option missing when I right click on an
...Date range in months from month and year fields
In our database we track consultants work dates in four seperate fields,
starting month, starting year, ending month, ending year.
Is there anyway to calculate the range of months they have worked with this
So if someone started March 2004 and ended July 2007 is there a formula to
calculate the 40 months they worked?
DateDiff("m",[starting month] & "/" & "01" & "/" & [starting year],[ending
month] & "/" & "01" & "/" & [ending year])
> In our da...MS Outlook will not start
Unable to display the folder. Microsoft Outlook could not
access the specified folder location. The .DLL file for
the information service could not be found. MAPI was
unable to load the information service PSTPRX.DLL. Be
sure the service is correctly installed and configured.
Recreate your mailprofile in Control Panel-> Mail-> button Show Profiles...
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Damian ten Bohmer" <email@example.com> wrote in message
news:...value from field not accepted within onlineform (3.0 -> 4.0)
We just tried to update our running CRM 3.0 to 4.0
there where nearly no problems! (1 report was not upgradeable)
We where very happy.
but right now a real problem was discovered:
the fields: longitude and latidude from the contact form are no more accepted.
Enter a value beetween ....
But the values do perfectly match within the range
When I delete the values I can save the form.
When there is any value in the fields it causes the error: Enter a value ...
Best regards for any help
...Office XP icons missing on Windows 7 Pro x64
I installed Office XP on a PC running Windows 7 Pro x64.
The icons for the various office programs exist, but are blank. When I look
at the shortcuts, it doesn't allow me to choose the location of the icon -
it's greyed out. I've run windws explorer elevated, but I still can't change
the icon location.
If I navigate to the Winword.exe location, it has an icon. If I create a new
shortcut, that new shortcut also doesn't have an icon. If I try pinning one
to the start menu or taskbar, I get the same problem.
I also have Outlook 2007 installed, but the icon for thi...Related Fields in sub activities view
In the standard My Activities view I am able to display information from the
Account (Regarding) i.e. industry, city etc. When switching to Phone Call or
Appointment, the information is not displayed even though the facility is
there in admin to add these fields - is there a fix for this?
...Vendor Lookup Field with Modifier
I would like to modify the ap entry form and create 1 or 2mores field.
This additional field will be used to track related party vendor number/name
For example, the invoice is being paid to Vendor A. But because our invoice
for Vendor A may be related to Vendor B, I would like to enter this info in
the system. Currently, we just enter the related vendor ID in the note field.
But due to the large number of related party transactions, the users are
entering incorrect vendor numbers or they are not properly formatted , in the
note field. This makes it difficult to analyze related party...Windows CE R3 installation
I post here yet another question about the WindowsCE 6.0 R3
I encountered the fact, that a library is updated during the R3
installation, but the corresponding source file not.
I then had a look at the installer file and saw that there the source
code file is missing.
Well the library i am talking about is the bthci.lib and the (only
one) source code file is
Does anybody know about this inconsistency?
...Parse field in query
I have a table called MasterData with a field called Originator.
The field data looks like this...
CN=Kathy T. Buon/OU=Miami/OU=BU/O=WC/C=US
Terry J Leif
I need it to look like this...
Kathy T. Buon
Terry J Leif
How can this be parsed??
What a mess that you're stuck with! Below will look for the first / and
return the string before it in a query. If there isn't a / it returns the
entire string. Of course this doesn't help with the CN= in CN=Kathy T. Buon.
Parsed: IIf(InStr([Originator],"/")...Parse Name Field into First Name Last Name
I have a field called [Patient Name] that I want to parse out into a First
Name Field and Last Name Field. I am using the Charindex() to find the comma
that seperates the First and Last Name, I am then passing the Charindex value
to the Left Function to grab the Last Name. Below is what the code looks like:
LEFT([Patient Name],Charindex(',', [Patient Name])-1) AS LAST_NAME
I am getting the below error when using the above code
Invalid length parameter passed to the LEFT or SUBSTRING function.
Warning: Null value is eliminated by an aggregate or other SET operation.
...Return only the numbers contained in a field
I would like some help please building a query that will return the
numbers only contained in a field:
Table "PurchaseOrder" has a "Memo" field that usually has the
following data: "Sales Order 7540:" or "Sales Order 34:".
How can I create a query that will show me all the Sales Orders and
their linked Purchase Orders (PurchaseOrder.RefNumber) where the
SalesOrder.RefNumber equals only the numbers in PurchaseOrder.Memo
Thanks in advance,
Welllll. You can but it might not be pretty, accurate, or fast. Actually I'd
expect ugly...Need help getting query to reference a field in a subform
I am trying to run a query using a specific field in a subform as the
criteria. The query is displaying one combo box from the Form, as well
as several fields from its own subform.
My Form name is: FormGrantManagement
My Subform name is: TableMOA subform
My Subform's subform is: TableCostReports
The field in the subform I want to reference is: MOAID
I have found other help topics that lead me to think that a criteria
along the lines of [Forms]![FormGrantManagement]![TableMOA subform]!
[Form]![MOAID] is what I need to use, and I have tried multiple
variations of this but witho...Missing engineering functions
In an earlier version of Excel, I had "engineering
functions" like =dec2hex and =hex2dec. Not, in Excel 2003, I
see them in the "help files' but not in my list of available
formulas. How do I get them to work in Excel 2003?
Thanks in advance,
I don't have Excel 2003, but you should be able to go to
Tools | Add-ins and check mark "Analysis Took Pak" in
the list that appears.
San Francisco, CA
"Geoff" <firstname.lastname@example.org> wrote in message news:zwfIc.299$Qu5.email@example.com...Request for Microsoft reply: Default start page feature missing??
When you go Tools > Options > General Tab, there is no section to change the
defual start page.
When using the help function within the box "Set Personal Options Form" the
very first help topic is "Set start page and view options" this clearly talks
about a Default Pane.
I was first alerted to the supposed availability of this feature in the book
"Working with Microsoft Dynamics CRM 3.0 by Mike Snyder Page 193.
Does anyone else get this section in the General tab? Is it a bug in my
installation? Did Microsoft leave it out?
This po...drop page fields here and drop series fields here
I have an OLAP chart ion my chart sheet.
On the bottom and top have drop page fields and seriers fields here.
I have no idea which fields I can drag and drop.
any information is great appreciated,
This chart is a pivotchart? If so the field list should be displayed. You
can drag any field in the field list to any area, so your choice should be
based on what you want to display and how you want to display it.
Note that as you change the pivot chart the pivot table will also change and
visa versa, so you can drag the fields around on the pivot table to see the
effects on the pivo...Access to Excel: Identify attachment field in access database
How do I query a database field of type attachment?
I have a database field of type attachment and I want to run a query in
excel that identifies columns with no attachments and some other criterias
and populates it.
here is the query I have so far:
If rst.fields("7") Is Null and rst.fields("5") = "Chicago" Then
Me.File.Value = "NO"
Hope I made it clear
Thanks in advance
You have two choices.
1) Use a SQL statement that gets only the records that meet your
requirements by filtering the Da...