Reply:

Table not listed in Table Names / Table Descriptions window
Hi, 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 emails
I 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-10
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 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 Cognos
Is 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 Stamp
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 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 ...

Customization
Can 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 Grouping
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? 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 net
How 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 Questions
1) 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 2000
Hi 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 yes
I 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 Windows
Hi 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 Files
DID 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 question
Any 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 field
I 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 displayed
Create 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 (grou
The 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 lists
Whenever 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 folder
It 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 Tax
Can 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...