Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...Creating a table
There's probably an easier way to do it but...
I have a series of numbers in column A (150 in all) and a series of letters
in column B (22 in all). In total there are 4800 rows.
What I am trying to do is create a table with the number down the left hand
side and the letters across the top. In each cell within the table I need
to count how many times the combination of number/letter appears. Eg:
A B C
201 0 2 2
202 3 0 1
203 3 6 4
I tried combining the number/letter into a single text field using the
CONCATENATE function then filtering ...Adding Contacts Folder as Address Book in Exchange Server
I am trying to add my contacts folder to my address book in Outlook XP and
don't see the Tools, Options I used to see in Outlook 2000. How can I add
this folder to my address book? Is that an option you can turn on or off
for a profile in Exchange Server?
Remove 'spam' from email address to contact me directly
Right click on your Contacts folder, go to properties, outlook address book.
Can you tick the box there?
If not, go to tools, e-mail accounts, view/change address books, and make
sure you have the Outlook Address Book option there. Then try right-clicking...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Adding an "I'm out of the Office" Message
Re Outlook Express. I can't find anywhere on the index
about how to send one of those "I will be out of the
office from July blah blah to August blah blah." Anyone
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to an
Outlook Express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexp...Right click in Pivot Table or on Entire Column
I have added items to the right-click menu that popups up when you have a
cell or cells selected. But when you are in a Pivot Table or have an entire
column selected the right-click popup is different.
Is there a way to add an item to the right-click popup menu when you are in
a Pivot Table or have an entire column selected?
Thank you for your help.
Never mind. This one was right in the help section. I should have looked
> I have added items to the right-click menu that popups up when you have a
...FP: Couldnt close table
We have been receiving this error on two separate PCs
after a recent upgrade to 7.5. Our version is 7.50g43
(service pack 5). At first we thought it was isolated to
one PC now a second PC is having the same error. On the
first PC, I ran new network cable, installed a different
network card with no help. This PC is Win98, 64MB RAM,
600Mhz. The second PC has 128MB RAM also Win98. I don't
believe switching to XP is an option right now. This
message has appeared in the payables module on both
machines. But it has also appeared in receivables as
well. Not in GL or Payroll. I...Subform question 04-09-10
I have a form (Form1) that contains a subform (Subform1).
Within this subform I have a combo box which, depending on what is chosen,
pops up another form (Popup1)for additional information. I need this
additional information in the form that pops up to be 'linked' with the
The problem I am running into is that when the user enters information in
Popup1, the table has not been populated witht he data that is in the subform
so there is no record to 'link' to. What is the best way to force te
esubform to pass its information to the table?
Thanks i...Same Table cannot be the child table in two nexted relations...
I've been setting up a schema with the XML Designer in VS .NET 2003.
The designer lets me set up a lot of things including a complex type that
contains an unnamed complex type called modified.
When I try to preview the dataset, I get an error described as "The same
table (modified) cannot be the child table in two nested relations.
I've run into this before with a different complex type, and I've changed
the name of the instance of the type in the various elements it's used, and
the problem goes away.
In this case, problem is an unnamed complex type, so it only a...Pivot tables and Macros
I was looking to be able to manipulate (ie change selections from the
drop downs, not change the fields in the table or anything)and print
from a pivot table using a macro.
So how do I go about doing that?
When I set up a macro by recording the actions that I want to do, I
always get an error message when I try to run it as a macro.
What specific steps are you recording, and what error message do you get?
Can you click the Debug button, and see the line of code that is causing
Dust For Eyes wrote:
> I was looking to be able to manipulate (ie change selections from the
>...How to copy aQuery to a new Table?
I have a database in a Table, a report based on that same Table and a Query
based on that Report.
After two months or so I like, after some new data input, to save the Table
into a new Object Table. What is the best way for the Report and Query to
follow the new Table whitout recreating the original Report & Query?
Thankyou for your comments. I use MS Office Access 2007.
>>I have a database in a Table, a report based on that same Table and a Query
based on that Report.
Your phrasing is wrong when it comes to the elements of an Access database.
A dat...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Pivot Table in Excel
I have a problem using the pivot Table in excel 2000.
Earlier the location of the pivot table in excel was
pointing to say c:\sales.mdb. Now the location has changed
to D:\Sales.mdb. someone please tell me the place to
change in the excel to reflect the same. So that upon
refreshing the document i can see the latest data.
Currently i am getting a error message when i try to
refresh, but its not prompting to change to alternative
location. If i edit the excel file in a notepad...i can
see the location pointing to c:\sales.mdb.
Thanks in advance for any help regarding this..expect...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...Adding GAL users into a custom form
I have created a custom form, and am required to add a series of approvers.
What I am trying to achieve is:
* Add users from my GAL into a text field, so that when the form is sent,
they do not get initially CC'ed the form.
Is this achievable, and if so, how do I do it (if you could help by
including any appropriate code, that would be great).
...Non AD emails going to 1 user
I have an Exchange 2003 server running on SBS 2003 the issues is one user is
getting all the emails sent to him that look like they are coming from his
domain. For example his email is email@example.com but in his inbox he is
getting XYZ@mydomain.com but XYZ is not in the AD or has a email box set up
on this server. Why is getting this non AD email and how can I stop it.
Thanks in advance
Are you sure it's not a SPAM where the spammer may have simply put in
firstname.lastname@example.org and BCC it to all possible conceivable names
"LaOVis" <LaOVis@discuss...HTML Table import
I have a HTML document which contains a large data of data. When this html
file is imported into excel some of the columns get out of whack. eg. Some
columns are removed completely. This html renders ok in IE but get corrupted
or misread when imported into excel, mainly when the table gets big. eg. It
generally happens after the 10000 row mark.
Do you import it through data>import external data>new web query?
Excel 95 - Excel 2007
Northwest Excel Solutions
"Ryan Hafey" <Ryan Hafey@discussion...copying column width in tables
I created a table in Publisher with 6 columns. I would columns #1, 2,
4 and 5 to have the same width and columns 3 and 6 to have a different
width. I'd like to set the width of column 1 and then paste that size
to the other four so they all have exactly the same width. Presently,
I am eyeballing it, but it takes too much time and is not exact. Any
ideas on how to do this?
The only way is to create guides. Arrange, ruler guides. You could try creating
a table in Word, copy/paste.
Mary Sauer MSFT MVP
news://msnews.microsof...subform not refreshing
Hi there, I have a main form with a subform embedded to be able to scroll
through a list of records. There is no linking field between the two. The
subform displays all the records properly. One of the fields in the subform
is a checkbox to 'close' the record indicating that the info is no longer
current and shouldn't be displayed. This works fine. I should also mention
that the subform is based on a query.
I have a button on the main form which opens another modal form based on the
same query as the subform that will let me uncheck the checkbox in case the
record was 'clo...look up tables and IF statements
I have managed to create a look up table using the office assistant, and the
formula above dumps information into cell G3. If G2 is empty or has a zero I
don't want G3 to have anything in it. At the moment it just keeps coming up
Can anyone tell me what formula I should be using please
Would this modification do?
Hope this helps!
Thanks and kind regards
> I have managed to create a lo...Pivot Table from two worksheets
I am trying to create a pivot table from two worksheets. Each workshee
represents different accounts from which I am tracking expenses. I hav
these columns on both sheets: Type of Expense (labeled A, B, C, D)
Date, Description, and Amount.
I want the pivot table to organize all of the data from both sheet
according to Type of Expense and show the Date, Description, and Amoun
under each Type of Expense. I can get it to organize it by Type o
Expense and show a total for each, but how do I get it to show thi
Message posted from http://www.ExcelForum.com