Table not listed in Table Names / Table Descriptions windowHi,
I am missing a 3rd party table in the Table Names window. I'm trying to
view the table via the Tools > Resource Descriptions > Tables navigation but
my table does not display here. I can view the table under the SQL
Maintenance window (Tools > Maintenance > SQL). Does anyone know why it does
not appear under the Resource descriptions for Tables? I have other 3rd
party tables that appear here just fine.
Thanks in advance,
Jacqy
What module is it?
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com
I ch...
make column lists for select query.sheet1
table1 col1_1
table1 col1_2
table1 col1_3
table1 col1_4
table1 col1_5
table1 col1_6
table2 col2_1
table2 col2_2
table2 col2_3
table2 col2_4
....
....
sheet2
table1 col1_1,col1_2,col1_3,col1_4,col1_5,col1_6,
table2 col2_1,col2_2,col2_3,col2_4,
....
....
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
thanks.
I think you may want some dependent lists.
http://www.contextures.com/xlDataVal02.html
HTH,
Barb Reinhardt
"kang" wrote:
> sheet1
> table1 col1_1
> table1 col1_2
>...
Outgoing emailsI am having an issue when trying to send emails out....
It has been working fine until about 2 weeks ago. Please help.
Message appears as follows.....
-- The connection to the server has failed. Subject 'test', Account:
'mail.aapt.net.au', Server: 'mail.aapt.net.au', Protocol: SMTP, Port: 23,
Secure(SSL): No, Socket Error: 10060, Error Number: 0x800CCC0E
Try port 25. If you still get an error post back. There are cases where
that doesn't work either and you need to change it, and another option as
well . . . . let's just try one thing at ...
Emailing in excel 2003 02-26-10If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
date.
Thanks.
Check out Ron De Bruins "Send-Mail" tips:
http://www.rondebruin.nl/sendmail.htm
Micky
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
>
> The email body should say: this has been submitted for cell B34 and...
using GP with CognosIs it possible to map GP to a reporting tool like Cognos? If so, what would
be the easiest way to decipher to the data tables?
Thanks for your help.
The first thing is to install the SDK from the second CD. You need to explore
the disc and look for the tools folder then the SDK folder. When you install
the SDK, you will get a new item in your Dynamics program group. You will
have access to documentation on data flow.
Additionally, within GP you have the resource descriptions off the Tools
menu.
Richard Whaley has books that can help you, as well. Go to
www.accoladespublications....
Windows Live Email Time StampThe windows live time stamp on all outgoing emails is 4hours later than the
actual time. PC time is setup with the correct time zone. Only happens when
using the online windows live email access. Can anyone assist?
Thanks.
v "dioncnr" <dioncnr@discussions.microsoft.com> schreef in bericht
news:68BCFE8E-74E3-4967-B733-209DCE7C3BED@microsoft.com...
> The windows live time stamp on all outgoing emails is 4hours later than
> the
> actual time. PC time is setup with the correct time zone. Only happens
> when
> using the online windows live ...
CustomizationCan I customize existing screens of RMS store Manager? I have read to use
add-ins which is for seperate applications but If I want to add more field on
the Item Maintenenance screen, how this is possible
Regards
Ahsan Raheem Minhas
Sr. ERP Consultant
Business Solutions, Pakistan
No, you can't customize the built-in screens of RMS. Most manager type
add-ins end up replacing the RMS screens - duplicating their functionality
and adding more. Alternatively, you can use a "Hook" function to launch an
additional window with your extended fields upon Item Save. Replacing the ...
Quirky recent file list #2
Debra---
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
Stacie
--
SPenney
------------------------------------------------------------------------
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
changed. <g>
If/when you upgr...
Custom Report GroupingI have created a database in Access 2003 and am trying to group by months but
the months set up in the database are based on a tradional month. We use
4,4,5 accounting months. How can I create a group to based on dates I set up?
On Fri, 22 Jan 2010 08:18:09 -0800, CARRIE <CARRIE@discussions.microsoft.com>
wrote:
>I have created a database in Access 2003 and am trying to group by months but
>the months set up in the database are based on a tradional month. We use
>4,4,5 accounting months. How can I create a group to based on dates I set up?
I'd suggest se...
How can Journal be used if Project is not installed, or on the netHow can Journal be used if Project is not installed, or on the network
--
Rusty Nichols
Network Support Technician
The Journal folder works without Project being installed at all. It's an
integral part of Outlook. What functionality are you seeking?
"Rusty" <w_r_nichols_iii@yahoo.com> wrote in message
news:7EA79673-AE35-44D2-A09E-EBF73E7EC414@microsoft.com...
> How can Journal be used if Project is not installed, or on the network
How can Journal potentially affect the Exchange server, and I would like more
information on Journal for a Outlook foundation class?
...
Custom Control vs. Owner Draw Control?Hi
Custom Draw, Owner Draw, Custom Control, Owner Draw Control...
Overriding DrawItem() Method, Overriding OnPaint() Method, OnCustomDraw()
Method, WM_CTLCOLOR Handler, adding custom control which is in toolbox and
"Custom Control DLL"...
I started to search control development in MFC to learn how to write
(stylish)controls but it seems that it will be difficult and confused...
I have basic 2 questions, if you help me to find answers i will be very glad.
1-) In Terminology, are "custom control" and "owner draw control" same
things? If not, i understand th...
DB Emailing Questions1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give
me an idea of how the code will be like.
2) Also can i assign the email to have a recipient automatically or do i have
to write it down each time?
Thank you in advance.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
On Jan 21, 11:51=A0am, "axm0035 via AccessMonster.com" <u56602@uwe>
wrote:
> 1) How do i format the message text of an email in Acce...
Outgoing emails not sending for outlook express 2000Hi there,
Can anyone help me?Everytime I try to send an email these
error messages pop up and I have no idea what to do;
The host 'SMTP' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No,
Socket Error: 11001, Error Number: 0x800CCC0D
The host 'POP3' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL):
No, Socket Error: 11001, Err...
cmbo box on subform fills fields on form when chkbx is yesI have a multi-tabbed form that details bid data ranging from pricing to
contact info to departmental notes. Page two has a subform listing general
contractors to whom we bid. One bid may have 10-15 contractors listed. When a
purchase order is issued from one of these contractors I select a checkbox
indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
possible?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200803/1
On Mar 17, 3:04=A0p...
Getting List of Visible WindowsHi All,
I am working on a problem that requires me to know whether or not any
part of a particular window is visible (even if it's like a one pixel
corner). In my misunderstanding, I thought that ::IsWindowVisible
would cover it, but it looks like that call just verifies that the
hWnd actually has a dialog box. I was able to take it a step further
and find out whether or not a window is minimized using
::GetWindowPlacement, but I really need to find out if a window is
visible or not (in other words, not completely covered by higher
z-order windows).
Is there some sort of API call that ...
How can I instantly delete emails? I get a strikethrough + purge
...
List Shows Private FilesDID ANYONE ELSE NOTICE THIS?
Whenever I save an attachment, and go to the drop down
menu for file name, I am shown a list of dozens of files
recently accessed on the computer (not just files
accessed by Outlook Express). This occurs even if recent
cocuments is turned off in Windows XP and even if the
recent documents folder for Windows XP has been cleared.
This shows too much! Others using Outlook Express on the
same computer can potentially view the file names of
every document, image, and device recently accessed.
Where is the folder to clear this data out of?
duncan <anonym...
Outlook 2002/XP Folder List view questionAny assistance would be greatly appreciated. I have a user still using
Outlook XP and has the following issue.
Outlook does not remember the folder view settings. User has folders under
the Inbox folders and of those folders some are expanded and some are
collapsed. When he closes Outlook it does not "remember" the folder settings.
The user would like for Outlook to remember the settings because it has in
the past. Is there a way I can get this back?
Thanks
...
Globally change part of a fieldI have a text field that holds the file location of a picture. The content
looks like this:
H:\Access Data\Personnel Pictures\picturefile.bmp
The "picturefile.bmp" is different for every record. Everything preceding
it is identical in all records.
I've moved the folder with all the pictures to a new location and need to
update this field to the following:
S:\Everyone\Member Database\Personnel Pictures\picturefile.bmp
So basically, I need to swap out "H:\Access Data" for "S:\Everyone\Member
Database" in every record.
How so?
Thanks in advance.
Jer...
A rule that places a new email in a sub Folder doesnt get displayedCreate a folder; Create a rule that moves new mails to that folder; Happy
as larry. When a new mail arrives, outlook shows a blue numeric value next
to the folder to indicate unread messages.
However, if you add another folder to the folder created above, ie a sub
folder and create a rule to move new email, you have to have the tree fully
extended to be informed of a new email.
Is there a way to see if an new email has been sent to a sub folder without
having the tree list expanded?
Cheers
Phil
What version of Outlook and what Service Pack level?
--�
Milly Staples [MVP - Outloo...
Contact use?I am studying at moment and would appreciate confirmation of below,
company has an external consultant who has an internet mail address of
Bill@isp.com , company wants to receive all mail addressed to him and do not
publish his private internet mail address as they do not want customers to
contact him directly, the solution suggested is below.
create a mail-enabled contact object for Bill and specify two addresses,
Bill@company.com "@company.com being organisation email address" and
Bill@isp.com, for this contact. All messages that are addressed to
Bill@company.com will fir...
Outlook should be able to email MS CRM advanced find queries (grouThe only way to e-mail a group in MS-CRM is to use the Quick Campaign
function. The Quick Campaign has several disadvantages:
- attachments for emails are not possible
- this takes at least about 10 more clicks compared to sending a standard
outlook email
- the quick campaign doesn't have the look-and-feel of Outlook to which
users are accustomed to
Therefore it would be great if you could select the emailaddresses from
groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard
Outlook email message. Actually you would make the advanced find queries
available to sel...
Contact not importing names of csv listsWhenever I import a csv file into outlook 2007 it imports only the email
addresses, nothing else. I've titled the csv columns with the exact same
headings as the outlook contact headings. Still, it imports only the email
addresses. What do I need to do to get it to import the full names as well?
Is it correct to assume that because you stated that you "titled the csv
columns the same as the Outlook contact headings" - that you used
"auto-map" to import your data?
There is absolutely no reason, benefit or value whatsoever (under any
circumstances) in ...
outlook should let me move emails from sent to a specific folderIt only allows copies to be moved to specific folders and not the actual mail
itself - this creates unnecssary copies and makes everything confusing. Can't
there also be a SIMPLE rules wizard like in outlook 2002? I find this new
wizard too cumbersome and complex.
----------------
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 the...
Use TaxCan someone tell me if Great Plains has the ability to add use tax to a
invoice in payables management without adding it to the invoice amount. I
have vendors who do not charge me sales tax and I want Great Plains to
calculate that sales tax and not add it to the invoice amount.
There is a simple workaround. Let GP calculate use tax using the Sales Tax
field. Then put the amount of the sales tax in the trade discount field. This
offsets the tax amount and doesn't change the voucher total.
We do this for PO Invoices with use tax. The tax account is pointed to the
appropriate expense...