Reply:

memo field
I am building a simple database (Access 2003) to store various types of information from our 33 union contracts. I am putting together a table to hold excerpts out of each contract relating to a variety of subjects we want to capture. The language that I want to copy out of each contract is contained in WORD documents, however, different people have put these contracts together over time and each person seemed to have their own way of formatting so there is a variety of different formatting techniques involved (paragraphs, tabs, bullets, indentions, short tables, section titles, etc). ...

Create a Web Address on a Form for Followhyperlink
I am trying to create a web address in Access. I have a form that has text boxes numbered 1-8. It is my intention to concatenate the text in the text boxes to create an address then use the followhyperlink method. I can create the string that I need but I get an error when the code gets to the followhyperlink method; runtime error 490 cannot open the specified file. The reason why I intend to concatenate the text in the text boxes is to allow the user flexibility. Some portions of the address are going to be static and others are going to depend on a value in a list box. Here is an exampl...

Multiple login popups
I have several users who are experiencing multiple login popups when they open Outlook 2003 and connect to our Courier IMAP server. When this happens, it's a crap shoot as to whether they can send or receive email, Outlook might hang, or fail to connect to the server ("error receiving null folder" or something to that effect.) Worth noting is that each of them has a 2nd Outlook profile which they use when they're out of the office (This pofile is setup to talk to local Putty socket tunnel, but the problem I describing shows up when I've chosen their main profile). This...

Pocket PC deletes From field
Hi, I've had this problem a lot and it's been happening a lot lately: Whenever I have to restore from a backup on my pocket pc, and then sync to Outlook XP, the From field on all of the messages they both shared goes blank. When I click on the message, the From information is still there, but it wont show me it in the browsing panel. Kind of annoying, and I can't find any way of stopping it or a fix. Thanks for any suggestions, -Bill ...

Managing Multiple Email Domains
Hello. I am trying to host email accounts for several different domains (.com's on the internet). We only have one AD domain. How can I make it so that email users from these different companies can access their email (through OWA or Outlook using RPC over Http) using their own internet domain name, such as dan@mycompany.com instead of dan@thisdomain.local? Thanks. http://www.swinc.com/resource/e2kfaq_sec3.htm DAN wrote: > Hello. I am trying to host email accounts for several > different domains (.com's on the internet). We only have > one AD domain. How can I make ...

collect data from the same row in multiple spreadsheets
I have 140 employees with a separate workbook for each.The workbooks contains their by-weekly timesheets. Each workbook has 26 sheets (one for each pay period). I need to start a workbook that will contain the total line for each employee (line 37). For instance, The first sheet in each workbook in named "july 3". I need to collect line 37 from each July 3 sheet (total 140 lines) and have them show in the new workbook on the "july 3" sheet. I have to do this 26 times to complete the new workbook. Does anyone know of a shortcut? Hi Jeannine > of a shortcut? ...

Full page receipt - multiple pages
This is a multi-part message in MIME format. ------=_NextPart_000_001D_01CB49F0.C3457980 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit Hi all Does anyone know how to make my receipt spans over the next page if the number of items in the transactions is alot I am using 8.5 widht x 5.5 height inch paper I already set the page width variable in the xml But the transactions details are printed out overlapped with my footer. Please help Thank you, regards, Joie ------=_NextPart_000_001D_01...

For tickets, a bigger Notes field, please.
When working with tickets, under Details > Information > Notes and Article, the Notes field only uses half of the window (vertically). The bottom 2" of the window, under the Show Article check box, is unused. I have to scroll the unnecessarily-cramped Notes field almost every time I view a ticket. Please consider expanding the Notes field to the biggest size the window will permit. ---------------- 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 ...

How do I change 6 digit field, cols 1 thru 6 to one (1) blank?
How do I change a 6 digit field in columns 1 thru 6 to one (1) blank or null? It's an 80 character record with random 6 digit numbers in the first 6 positions that I need to delete and file is too big to do by hand. Any Ideas? thanks, Bentley Assuming that each record is a separate paragraph, a macro containing the following code will do it: Dim i As Long Dim frange As Range With ActiveDocument For i = 1 To .Paragraphs.Count Set frange = .Paragraphs(i).Range frange.End = frange.Start + 6 frange.Delete Next i End With Or usin...

merge to creat worksheets
I have a workbook that contains two worksheets. Worksheet 1 has a list of names and various other pieces of information (related to the name, in the same row, just different columns) Worksheet 2 is a template of a form. What I need to do is to create separate worksheets (in the same book) based on the template in sheet 2 for everyone on the list in sheet 1. Is this possible? If so can you provide directions? Thanks! Hi see: http://www.rondebruin.nl/copy5.htm#all -- Regards Frank Kabel Frankfurt, Germany Glenn wrote: > I have a workbook that contains two worksheets. > > Wor...

~~ Need Help Creating Composite ActiveX Control
Help! I'm having a very tough time finding examples of how to do something which I think should be fairly easy. Could you kindly point me in the right direction? I have an application that has dialog boxes which can be extended by hosting an ActiveX control written by a third party. Typically this ActiveX control will consist of a number of edit controls and checkboxes. How do I create an ActiveX control with C++ that consists of mulitple controls? Is it possible to do this with MFC or do I have to use an ATL composite control? My hosting application is already a MFC app. How do I ...

Opening a file created with access 2003 with access 97
Can you open and access 2003 data base using access 97 ? I've got one that I can't seem to open as it says that it doesn't recognize the db format. -- jdw On Fri, 21 Dec 2007 17:14:02 -0800, jdw <jdw@discussions.microsoft.com> wrote: >Can you open and access 2003 data base using access 97 ? I've got one that I >can't seem to open as it says that it doesn't recognize the db format. No. The programmers who developed Access97 in 1996 or so did not have the luxury of having an Access 2003 database available to work with, since it did not exist yet and w...

Custom Fields causing error in Crystal report viewer
Hi, I have created a new report using Crystal Pro 9.2.2 based on the contact and Opportunity tables joined (inner) by contactid. If i use the standard fields on the report i can publish and then view the report fine from a MS CRM Client. As soon as I add one of my custom fields from the opportunity table i get an error when trying to view the report from a the CRM client. I don't have the exact error at hand but it is something like: "Crystal Report Viewer Error: Query engine error on report: aaaxxx98akaka.rpt". If i take the custom field back out and add in another stan...

Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes. I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety. Please help. I am new to this. I have the relations set in the order that the tables appear on the 1st line of this post. On Thu, 11 Mar 2010 06:38:14 GMT, "rnjalston" <u58689@uwe> wrote: >I have 5 tables: Manufacturers...

Exported payee info appearing in memo field?
Whenever I download information from one particular bank the payee field is not filled in and the memo field has the payee information in it. Meaning I have to go through every transaction and assign it the correct payee. It is only an issue with one of my banks, and happens in both Money 2003 and 2004. The bank, of course, is saying no one else has this problem, and that I should contact Money tech support. Does this sound familier to anyone and is there a fix that I can do? Thank you so much! In microsoft.public.money, Delia wrote: >Whenever I download information from one part...

Using Outlook on multiple computers
I'm going to college soon. I have a desktop computer and a laptop. It is very important that both have access to my Outlook inbox. I would love to be on campus somewhere on my laptop with Wi-Fi, download my e-mail, come back to the dorm and automatically have it synch up with my desktop. Also, I would love for my desktop to have it's own .pst file. That means I don't simply want to read off the laptop's .pst file when I'm on my desktop. I would a program that automatically (or w/ the click of a button) synchs Outlook between my laptop and desktop. Do you guys know of suc...

Create Email From Access W/Information From Form or Query in
I have designed Databases for many years now, but never attempted this: I need to know how to create an email with information located in the active form or off of a query. I would like to have the email automatically generated with the To Address, The Subject Line and the Body of the Text. I would like that email to open but not to send until the operator has a chance to make modifications. (one record per email). -- Mark Matzke "mmatzke@comcast.net" <mmatzkecomcastnet@discussions.microsoft.com> wrote in message news:F3F01720-2676-4DE6-A881-0E640CAF4CB5@microsoft.com...

Creating Price Lists
Hi, We are busy developing a product catalog and due to the nature of our business, all pricing within CRM will be user provided. We have been advised to create a base price list using a zero amount to maintain the integrity of the system. We have also been experimenting with a non applicable price list. Could someone please advise on what they believe the best price with regards to this might be? Thanks Mark Hi Mark, I've just spent all day today configuring Microsoft CRM with a 250product price list for one of our clients. (A very, very time consuming process. Each product had ...

can i synchronise outlook on multiple computers?
I use multiple computers in my office and use a laptop and notebook away from the office. Is there a way to download and synchronise the e-mail and contacts (I use outlook) between computers. I can never find messages and replies when I need them and want to file them one time. Buster Spencer Buster Spencer wrote: > I use multiple computers in my office Do you log onto a domain at work? Do they permit roaming profiles? Ask your company's IT folks about roaming profiles. Does your company use Exchange as their e-mail server? > and use a laptop and notebook away...

Time Field in transaction table
I am trying to build some custom queries to fill spreadsheets with some data and I am running into a weird problem. The transactions times are quite a few hours ahead. For example, I know for certain some of the transactions happened on 5/9/2009, and the sales report in POS shows the transaction showing up on 5/29/2009, but when I look at the raw data in the table, the transaction time column shows 5/10/2009. Is the time setup as so many hours from GMT or something that I am not accounting for? I assume it just went by system time of the computer, but so far its not looking that way....

I need to list multiple related records within a single report she
I have a report which shows data, one sheet per school, for secondary schools. On each school's sheet I need to list the feeder primary school(s). At the moment, when there is more than one feeder primary school, the report is creating one duplicate sheet per secondary school, each with a different primary listed, rather than listing, say, 2 or 3 primary schools on the one secondary school reoport sheet. How do I solve this? Any help would be much appreciated. The primary school data is drawn from a different, but related, table to the secondary data, with a one-to-many join on the...

Formatting Lost When Multiple Cells are blank
I provide technical support for software users. These users export data from the software with multiple columns and multiple rows. One column for End Date is formatted as Custom format Type: m/d/yyy" "h\:mm\:ss AM/PM. These files are often very large, sometimes over 55,000 rows. The problem happens when there are multiple rows in a row without data. It seems as if the formatting is lost. For example, the first ten rows have data recorded (date and time) and there are then 500 rows with blank data and then the next ten rows (rows 511 through 521) have data. These cell...

multiple users with same email address
I've setup my folks as seperate users on XP but they both share the same email address. When one logs on and recieves an email, the other cannot get it in his/her inbox. How do I set it up so that they both recieve all emails to the shared email address regardless of who logs into XP first? Thanks Set them up with separate e-mail addresses/accounts - or set up the mail profiles to share the same PST file for delivery so they can at least see the same stuff. simpleton.... wrote: > I've setup my folks as seperate users on XP but they both > share the same email address. &g...

Creating A Breakout List from a Summary List
I have a summary list that is the first input on a page that I need to then list out in individual rows. For example: Turn this.. Description Total Price per Unit Unit 1 3 $3.00 Unit 2 2 $2.50 Unit 3 2 $1.25 Into this.... Description Price Unit 1 $3.00 Unit 1 $3.00 Unit 1 $3.00 Unit 2 $2.50 Unit 2 $2.50 Unit 3 $1.25 ...

Problem with multiple CAsyncSocket...
HI all! I have to design a client application that connects to multiple servers. This application already connect to a server, but I need it to connect to more than one. I do something like this: int num = NUM_SOCKET; CAsyncSocket * hSock = new CAsyncSocket[num]; for(int i =0; i<num; i++) { hSock[i].Create(); } then I connect with something similar connect(CString * hosts) { for(int i =0; i<num; i++) { hSock[i].Connect(hosts[i],NUM_PORT); } } The problem is that after this I wait for the connection events with a WaitForMultipleObjects, but it always connect ...