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
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
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
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,
...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 email@example.com instead
of firstname.lastname@example.org? Thanks.
> 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
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?
> of a shortcut?
...Full page receipt - multiple pages
This is a multi-part message in MIME format.
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.
------=_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
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.
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
For i = 1 To .Paragraphs.Count
Set frange = .Paragraphs(i).Range
frange.End = frange.Start + 6
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?
> 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
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.
On Fri, 21 Dec 2007 17:14:02 -0800, jdw <email@example.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.
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
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
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).
"firstname.lastname@example.org" <email@example.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?
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 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
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
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.
> 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:
Description Total Price per Unit
Unit 1 3 $3.00
Unit 2 2 $2.50
Unit 3 2 $1.25
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...
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++)
then I connect with something similar
connect(CString * hosts)
for(int i =0; i<num; i++)
The problem is that after this I wait for the connection events with a
WaitForMultipleObjects, but it always connect ...