Changing the field names of linked table
I have an ODBC link to some live data.
Unfortunately the field names for this data are just codes and aren't very
Though I have made a table in access which links the codes to the actual
I need a way to create a new table which has all the data from the ODBC link
but for the field names it uses the field description rather than the field
Can someone help?
> I have an ODBC link to some live data.
> Unfortunately the field names for this data are just codes and aren't
> very helpful.
> Though I have made a table in...Data Consolidation Problems in using wild cards in range names
I am using Excel 2003. I am not able to use wild cards in naming data ranges
in the data consolidation dialog box. It gives the response as 'Wrong
How to use the wild cards ? and *.
...Add Mailbox Error
Error trying to add a mailbox
Exchange 5.5 Outlook 2000
When trying to add a mailbox (Right Click Mailbox > Properties > Advanced
button > Advanced tab > Add button) we get this generic message:
"The name could not be resolved. The action could not be completed"
I was assuming it was a permissions issue and added Authenticated Users the
Search right to the Server in Exchange Manager. However the issue still
Clicking the “Add” button immediately produces the error message. The Add
Mailbox window never appears.
First of all, that's an outlook...Purchase Requisition Form
Before we can put in a Purchase Order in GP, we have to first fill out and
get approved a "Purchase Order Requisition form". The workflow would be that
somebody completes the PO Req form to buy a "copier" for eg. , and then he
sends it over via email to his boss. Who then accepts it or rejects it. If it
is accepted it to goes to finance and they write a chck. If rejected in will
be squashed. If anybody has done this..please share your ideas. We had it
working using forms in Outlook 2003 but now we upgraded to 2007 and the forms
no longer works for us and the original...trying this out
This is a test posting.
On Tue, 13 Nov 2007 16:06:51 +0800, "hmmmm" <email@example.com> wrote:
>This is a test posting.
Please use microsoft.public.test or microsoft.public.test.here for your
testing. This is a working newsgroup. If you have questions about an Access
database, please post them.
John W. Vinson [MVP]
...Need to compare 2 tables and only pull certain records from one ta
I have a monthly sales file that contains several invoices that allows
duplicate records of parts. My second table is a different sales file that
also contains several invoices and allows duplicate records. I want to match
from the second table as a basis. How do I pull matching invoices from the
two tables without pulling all the data from the first monthly sales file?
FROM SecondTable INNER JOIN FirstTable ON SecondTable[Invoices] = (SELECT
FirstTable.[Invoices] FROM FirstTable GROUP BY FirstTable.[Invoices])
ORDER BY SecondT...Cannot add extra mailboxes
I have a problem with some of my Outlook 2002 clients.
When I go to edit the properties for my exchange server,=20
=FAnder Advenced I can choose to add other mailboxes, but=20
when I push the ADD button, it comes with an error.
It says: The name cannot be found, I can't even type=20
anything, it just gives this error.
(This is a translation from Danish)
Anyone how can fix this ?
What version of Exchange? If 5.5 you need to create the users as
Windows accounts first before you create a new mailbox, if 2000 or
later you need to use the ADUC to add the users to the AD before ...Graph intra-day stock data
How do you graph intra day data (Date, Open, High, Low,
Close) format. Where the Date includes the time: (2/22/04
9:00 AM format). Currently, I get a chart with all the
individual 30 min bars being grouped into just a daily
bar, I would like individual bars for each half hour.
The easiest way would be to use a XY Scatter chart, rather than a Line
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <firstname.lastname@example.org>,
email@example.com...OWA Issues with Forms
I have added another Exchange Cluster to my enviroment. We have forms
enabled on the OWA servers and everything works fine on the original
virtual server. For mailboxes on the new virtual server, the forms
login page appears but when it goes to display the web page with the
inbox, it errors out. I am running Exchange 2003 SP2 on Windows 2003
R2 SP1 with all the latest patches. I have compared all the setting
on both the virtual servers and everything matches. Does anyone have
Thanks for the help.
"Webiknight" <firstname.lastname@example.org> wrote in news:1170254590.1509...limit size of integer in number field on form
I have a quantity per field set up in my SQL Server file (adp project)
as precision 11 scale 5. This means the largest number I can store is
999999.99999 . I have a subform that this field is entered on
(datasheet view) and if a user keys in a number that is 7 digits long
(one longer than what is allowed) I get the error "multiple step
operation generated errors". I can trap for this error in the forms
On Error event but it's just the generic error 2757 which covers a lot
more errors than mine. And the control.value doesn't contain what was
keyed in, it just has the old v...I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP
In article <2DB8F007-1E27-4A48-923B-C7D4D0238B5E@microsoft.com>,
sypher <email@example.com> wrote:
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
"sypher" <firstname.lastname@example.org> wrote in message
> I am trying to round a mone...Cannot add business unit or team
Any of the 3 CRM system admin users I have tried couldn't add neither unit
nor team. No modifications have been made to the security roles.
UnauthorizedAccessException: Access is denied.]
Caller, String TeamXML, Int32 Count, String Members) +0
xml, String columnSet)
Mic...Trying to clear up Received but not invoiced report
I am trying to clean up the received not invoiced items. The problem
began with entering a purchase order and then not matching the invoice
to the items received agaisnt the purchase order. SO we thought that
doing a returned transaction entery would solve the problem. The only
thing is now the return shows up on our Received/ Not invoiced report.
And the report is becoming a huge mess and difficult to use. What is
the best way to clear up items that have been received but were not
matched and already paid through the invoice entery?
There is a knowledgebase article on this very thing av...send/receive (2nd try)
New computer. Microsoft XP Home. Microsoft Office XP
Small Business 2002. Earthlink dial-up account. Two e-
mail accounts. After opening Outlook, 1st send/receive
(option 3, all accounts) usually prompts for both
passwords, downloads messages, all good. Next time,
though, no prompt for account 2, error cannot connect to
server, account 1 usually gets messages. Every five
minute send/receive option eventually degenerates to
cannot connect to server errors for both accounts.
Meanwhile internet browsing slows to a crawl. Any ideas?
...How do I... On opening file from hard disk, open a form
Microsoft Access 2003.
I would like my Main Menu form to open when a user opens my database. So
far I am in no way networked or web based, I'll probably get there but right
now I have a file (Inventoryv4.mdb) that resides on the user's hard drive.
when she opens this file, I would like my main menu form to open, instead of
her having to go through the little task pane and dbl clk on frm_MAINMENU.
How might one do this?
***Note: I need the task pane with all the tables queries, forms etc to
still be there, just in the background, preferably minimized, and the main
men...How to send email after entry from data access page
I hope this is an easy one, but i am not a programmer. I got volunteered for this because i built an inventory database. Access 2003I have a simple referral table that i have linked to an "Input" page for people to enter records (including a drop down list of email addresses). And an "Output" page where pepole can come and edit. That part seems to be working fine.I need to have an email sent out when a new record is posted. Ideally, i would like it to be sent out based on who is selected in that email list, but i would settle for anything at this point.Thank you in adv...How do I cancel a msg Outlook keeps trying to send unsuccessfully?
How do I cancel an "in process" email Outlook keeps trying to send
unsuccessfully due to a huge email message I tried to send with way too many
attachments? It's stuck in "send" mode, and as a result, I can't send any
emails because Outlook cannot get past trying to send this message. How do I
cancel a pending outbox transmission while it's trying to send? I've tried
everything I can think of to no avail. Please help!
Angelczech wrote on Fri, 12 March 2010 07:32
> How do I cancel an "in process" email Outlook keeps trying to send
...how to add bound image to a form
I have problem to add bound image in the table. I want to do students
database. Could help me to solve my problem. I want a form which can displays
a different image as I look other students database
If you open the form in design view, you should be able to drag the image
from the field list onto the form. If haven't done it, you need to add an
OLE type field to the table.
Mark A. Sam
"Joe" <Joe@discussions.microsoft.com> wrote in message
>I have problem to add bound image in the tab...trying to insert a 0 in front of zipcode
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an sin...Adding data in two columns
I am working with data in two columns and would like to total the dupilcate
numbers giving me a sum total.
Column A Column B
I would like to combine all into one line that would look like:
Column A Column B
Any suggestions would be greatly appeciated!!
use a pivot table for this. See:
http://www.ozgrid.com/Excel/excel-p...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...access-problem saving forms and reports
I have a problem every time im trying to save a form in access.
It doesnt matter to what table i create a form or a report,the access wont
allow me to save it and puts on an error message:
"microsoft office access doesnt have the option to save the form or the
report because he presents chars from a language that cannot be be saved in
your system area.
switch your system area to the language in the form or the report and than
my office is in hebrew and my windows in english,i have passed all the data
in the table and in the form between the languages back and fort...can't add addressses to contacts from incoming mail
when I recieve email in outlook2002 I can see the persons
name in the 'from' field, but can not add it to my
contacts - there is no feature to do this. And if I
click reply, it just puts the 'display name' and not the
email address in the reply so I can not send them replies.
The only way to fix this is to ask them to type their
email address in the body of the email message and then
add it to my contacts list.
Is this a bug? Or a design feature??!!
...Exporting data using Pulldown List & VLOOKUP
I am developing a portfolio tracker excel file. I am having some difficulty
in implementing one function, which I think I cannot create using macro.
I am downloading various parameters using the SMF Add-In. Which is working
fine. After downloading these data I want to export them into the other sheet
"Pull Down Option". I tried to use OFFSET and VLOOKUP function. But it is not
working. In the Pull Down Option sheet, I have created a droop down list, so
when I change the droop down list, the data associated (Sheet Data) with it &
a stock symbol shou...How can I add menu to a dialog?
Can anybody help me , how to load menu(created using menu editor) on a
Thankz in advance
Create a menu resource in editor. Select the dialog you want to attach this
menu to. Right click on the dialog, click on properties. In the ensuing
dialog, select the menu you created from the combobox.
Ajay Kalra [MVP - VC++]
"Tony Thomas" <email@example.com> wrote in message
> Can anybody help me , how to load menu(created using menu editor) on a