Any help would be appreciated. When viewing records resulting from a
multiple table query, I discovered "Duplicate" records being selected.
However, all fields are not exactly the same, for the value selected from the
second table makes the record truly unique. How do I modify the query
statement to "output" only one occurance of the record? I tried unique value
for the "member number" field but the query still selected member 001 two
You need to tell Access how to decide which of the two fields is the one you
w...Change the automatic classification format ?
The default format quote is "XXXX-0000-XXXXXX".
But we don't need the suffix. Is it possible to change this auto format, or
to give another value to the suffix, as the name or the initials of the user
who create the quote ?
If it's possible, I use the same way for the orders.
Maybe changes are possible in the SQL tables ?
Thanks for your help.
...Stylecop SA 1201 and initialization order
We currently have the problem that stylecop complains "All private
fields must be placed after all public fields. [StyleCop Rule
SA1202]". But the specific private static readonly field is used as an
input in the initialization expressions for several public static
readonly fields, so reversing the field order breaks initialization
order of those static members.
How should we deal with that?
> We currently have the problem that stylecop complains "All private
> fields must be placed after all public fields. [StyleC...fuzzy matching help please in an Access 2003 query
I have two data files each containing phone numbers but in one file some of
the numbers have text such as "home" as well as the numbers. Also one file
has landline and mobile numbers separated by a /. I have set both of the
fields I want to match as text rather than number. I think there is a way
to match on part of a field [using "Like"] but I can't make it work using the
expression builder- can anyone help with this please?
Does one file (A) have strictly phone numbers?
AND the other file (B) have numbers that are just numbers, or have "home&quo...Outlook Web Access stripping Power Point Images
One of the owners of our company is trying to view a Power Point
that he downloaded from Outlook Web Access. He can't see the images.
While I am at the office, connected to our Network, I can open Outlook
download the Power Point Presentation and see everything.
Is there a setting that would prevent the images from being downloaded in
Outlook Web Access?
Is the attachment type forbidden by IE?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Sandy M" <SandyM@discussions.mi...filtering by form
I have a table that has all my company's clients; is there a way to filter by
form to see just the clients that are affiliated with one particular name?
(i.e., if a saleperson wanted to see only their clients and pull up each form
that contains only his clients, how can that be done?)
The answer will depend on how your data is structured, and what version of
Access you use.
In the Client table, do you have a StaffID field, so that each client is
assigned to one sales person? If so, you can just filter on the StaffID
field. In Access 2002 and later, if you use a combo for this fiel...Unable to save relationships/Access 2003
I have a backend database in which I am attempting to build relationships,
but I find I cannot save them. When I save, close the window, and reopen it,
the relationships have gone, though the tables are still there are. It
happens whether or not I enforce referential integrity.
The problem occurs on one particular database. I have tested it on another
and all is ok.
We have recently migrated from 97 to 2003, and the relationships that were
created earlier in 97 have been saved. When I open the window, only my new
relationships have been lost, the old ones are still there.
Many tha...Input from Form, Create fields for Query which joins them with lis
Using Access 2007, I am creating a temporary table [ActivityTrker] which will
feed a master table [MeetingMaster]. The reason for this is because the user
wants to do "bulk" selection and not have to do one person at a time; plus,
the meetings can be one of 30 types, and they can take place any time, any
day of the week; thus, no preloading a table with Meeting date/time and just
asking for attendance.
I have searched this and other forums, asked for help once before, have
researced multiple books/web sites, and not really found any help so far.
Right now, I am not able to ...SRS Report automatic update data?
the report make in Visual Studio.NET for CRM, automatic updated data???
or have a property??
And how i add my report to reports menu in the opportunity form?
...Automatically Save Attachments ?
Is it possible to set up Exchange to automatically save (and then remove)
attachments? We have a support email account that customers will use to send
files and we'd like to be able to automatically (as the emails are received
on the server, not waiting for a user to open Outlook) save the attachment to
a network folder.
Is this possible?
thanks for any help
Not natively. You would need to look at a 3rd party archiving/compliance
product to do this for you. There are LOTs of choices out there.
"dw" <dw@disc...GP 9 and Vista -SP3 install failing
The client has 1 workstation running Vista Ultimate, Version 6.0 build 6000.
GP9 SP2 loaded up fine after disabling UAC. Now trying to load SP3, but no
luck so far. UAC is still disabled. When SP3 ran, it looked like it was
working fine. When launching GP, I received the message "New code has been
found...", but when the login screen comes up, I'm still at v .0281. Under
Control Panel>Programs and Features>Installed updates, it lists KB937795. Any
I would look in the GP folder and make sure the CNK files are not marked Read
That, to me, would be the...Automatic e-mail batching of customer receipts at the end of a day
Is there a way to automatically batch out and e-mail all of the customer's
receipts at the end of a day. Thank you in advance.
If you are interested we can offer a custom solution to broadcast the
receipts emails. Please drop a email.
ERP Solutions Specialist
> Is there a way to automatically batch out and e-mail all of the customer's
> receipts at the end of a day. Thank you in advance.
On Jun 28, 3:14 pm, knightsbridge
> Is th...Outlook XP Access Grant
I would like to deactivate this option when you connect a Pocket PC or
another kind of software is traying to have access to the Outlook one
windows with the question: "Access Grant" appears and ask me if I want to
give to that application or device the access to my outlook folders and
My question is:
How can I desactivate that for always and I would never need anymore this
click OK for Access Grant.
Thanks and Regards,
See if the information on the following page helps:
...Sales order automatic allocation
After installing SP2 in GP 8.0, I am unable to use the Automatic sales order
allocation. I use advanced distribution.
Does anyone have any suggestions?
Can you provide more detail?
This posting is provided "AS IS" with no warranties and confers no rights.
Do not send e-mail directly to this alias. This alias is for newsgroup
"Carl" <Carl@discussions.microsoft.com> wrote in message
> After installing SP2 in GP 8.0, I am unable to use th...Access database locked.
Hi, I am facing an issue with access database.I have a web page that creates reports by pulling data from aparticular access database. This web page fails to create complexreports that returns lots of data. Once such a report is run, the webpage keeps on processing but never gives any result. But after this,when I try to run simple reports on the page, it fails to connect tothe db. This does not give any error, but the web page keeps onprocessing but never stops and never gives any result.It seems that the access db gets locked, a ldb file is created at thelocation of the mdb file. When th...Do not modify the table???
Looking for data flow diagram of GP 9.0 SQL tables I found this:
3. Do not modify the table – sometimes it seems to be nice if you just
append couple of extra columns to the table - like in IV00101 - inventory
master file why wouldn't you just add couple of additional descriptions. If
you do this - Great Plains Dexterity engine will fail reading all your items
- due to the fact that DYNAMICS.DIC (main Great Plains Dictionary file) has
exact description of all the tables and Dexterity uses it for reading and
writing into the specific table
http://www.albaspectrum.com/Customization...Is there a definitive list for when the SA user is REQUIRED?
Some of my users insist they need to use the SA login to do their job. I was
under the impression that very few procedures require SA, such as creating a
new company and creating users.
I've asked this question once before, but I'd like a more definite answer so
please don't respond unless you have a complete list. If someone from
Microsoft could respond that would be great.
Rather than trying over and over for a definative list, which you didn't get
last time(s), why not tell us what specific process they claim to need the sa
login for? You will get a prompt res...Tracking changes to a form's fields---still searching for an answe
I have a table and module set up to track all changes made to a record on my
form. I am using the following code for the module:
Option Compare Database
Function LogChanges(lngID As Long, Optional strField As String = "")
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim varOld As Variant
Dim varNew As Variant
Dim strFormName As String
Dim strControlName As String
varOld = Screen.ActiveControl.OldValue
varNew = Screen.ActiveControl.Value
strFormName = Screen.ActiveForm.Name
strControlName = Screen.ActiveControl.Name
...Access 2003 Importing missing File types
I cant import Excel or even TXT files.
I have tried everything to resolve this issue when
Importing to Access 2003 and missing most File types.
Currently when selecting GET EXTERNAL DATA / IMPORT
only files of Type: MS Office Access, Sharepoint
Services, XML and ODBC (many options are missing - this
is true for the Link option too)
Missing are File types like: excel, txt, csv etc.
Have updated and detected and repaired Office 2003
Please help as this is a very important function.
It seems that you didn't use the personalised instalation.
Do tha...Automatically skip dates when data is zero
In a clustered column chart, is there a way to make Excel automatically
"skip" a date (or dates) on the X-axis when the value for the date(s) equals
Thanks in advance for any help.
This example use a formula in a helper column to exclude any data with zero
values from the chart.
The next example is slightly more complex as it excludes the zero values
from a pie chart as well as sorts the data.
Hopefully ...Automatic Refresh
I have a subform that has a drop down list for one of the fields to enter.
This list can be updated by accessing a form, which is in datasheet format.
People get through entering data in the main forms and then get to the drop
down list and find they have to enter a new item in the list using the extra
form. The item will not appear on the drop down menu unless they press
records refresh. What I want is for the records to be refreshed automaticaly
when the datasheet form is updated or exited.
Posted via a free Usenet account from http://www.teranews.com
Coli...Can you automatically mark messages you send as watched?
Can you automatically mark messages you send as watched? Seems like there
has to be a better way than waiting for it to come back to your server and
then mark your own post.
Kilowatt@charter.net For initial email contact you must put "private"
in the subject line.
You can set your view settings to "Replies to My Messages"
> Can you automatically mark messages you send as watched? Seems like
> there has to be a better way than waiting for it to come back to your
> server and then mark your own post.
...How do you automatically forward recurring email?
I receive a weekly email, but would like to have it instantly and
automatically copied (forwarded) to another email address, without my
Is there a way of automatically sharing a specifically marked email with
Right-click one of these messages, choose Create Rule, and follow the prompts
to create a new Rules Wizard rule with a forwarding action.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
"Card Scanner&q...Integration Manager Version 10.0
I'm looking for the documentation/link on how to ugrade from IM 9.0 to IM 10.0.