problem with Like "*" & ([Forms]![Main]![txt_exis_pt_name]) & "*"
Please help everything works well till i put in the Like "*" &
([Forms]![Main]![txt_exis_pt_name]) & "*"
Using Like "*" & ([Forms]![Main]![txt_exis_pt_name]) & "*" broke the code
for all the other single relationship record criteria that bring back 1
record how can I fix it? When I say it broke it what I meant it brings back
the same record when I test for
2. med_rec and the other single row record
but the name works correctly. When I take out Using Like "*" &
([Forms]![Main]![txt_exis_pt_n...Query similar data across two tables
I have two tables I'd like to compare a field from each even though the data
in the fields are not a 100% match.
This would contain something like
This table would be like this:
(Basically the same 5 digit zip as above plus the zip+4. May or may not have
a dash -)
If I do a simple Join I can view which rows are identical, but I can't
figure out how to compare what I've tried to show above.
Any help would be much appreciated.
In your query, add a new field in that "calculates" t...VBA Query to look for a string within a field
I have a field in a table that has a four digit number located in the
DESCRIPTION field. It is not the only data in the field and is not
always at the front or end of the field. I need a query that will get
the SC_DATE and WO_NUMBER from tbCONTRACT where a specific 4-digit
number is located within the DESCRIPTION field.
WO_NUMBER SC_DATE DESCRIPTION
522834 01/17/2008 STRUCTURAL ASSEMBLY FOR I.B. 2210
723499 04/03/2008 225 PANEL LINE FOR DK W/SHELL 2220
374632 02/17/2008 ERECT GB 2230 (2210,2220 & 2230)
PRE SH...How do I publish CRM 3.0 web site with ISA Server 2004
How do I publish CRM 3.0 web site with ISA Server 2004? I configure a new web
listener to listen on port 5555 and with basic authentication, but now I am
getting a message back to use SSL. Must I create an certificate for CRM and
load the certificate on the CRM server and the ISA Server?
I get my instance to come up but as http://servername:5555 and then crm comes
up. I'm not sure how I then change it...therefore creating an alias to just
have it come up as http:servernamecrm or something like that....a bit of the
"Marius Roets" wrote:
> How do I publis...See this important patch from MS Corp.
Content-Type: multipart/related; boundary="pghfheomhzqcnjggw";
Content-Type: multipart/alternative; boundary="ubbveudfuifnmyge"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to protect your computer
from these vu...Contacts Problem
I've imported my contacts from Outlook Express and they appear fine when you
use the Icon on the bar on the left, but when I click 'new' and try to add a
contact from the icon next to the 'to' line the 'contact' folder is empty as
is the Outlook Address Book.
Many thanks in advance
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.554 / Virus Database: 346 - Release Date: 20/12/2003
Look at your Folder View. It looks to me like you've created more than one
...Problems and more problems with exchange 2003 sbs
Today I reboot the our server, this is the first occasion after
install a patch (that the windows has downloaded automatically) before
In 1 hour i received a message that the C: drive is full (yesterday I
has 7GB free space) . surprised and checking the problem, I receive in
my workstation a message that the outlook is not conected to the
server. I seen that the mdadata folder has same hundreds of logs of
After I move a lot of them to another location the exchange fill the
free space with new logs...I change the configuration to make a
circular logs and i moved a few hu...Exchange 2003 edb problems
Hi. I am having problems with one of our Exchanges. It recently stopped
working and the event log pointed at the problem being the database hitting
the 16Gb limit. Looking at the Priv1.edb and stm files the are adding up to
16Gb but online defraging only seems to show 150mb of white space. If I add
up all the mailboxes including deleted items however, it only comes to 5Gb.
I tried an offline defrag but it only reduced the stm file by the expected
Having deleted as many un-necessary emails as possible, I have reset the
deleted item retention to 0, and changed the maintenan...XMLA .NET connection problems
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the datasource.xml file, as follow:
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<ProviderName>Microsoft XML for Analysis</ProviderName>
</ProviderType>...Outlook 2007 & CRM Outlook client (V3C), problem tracking appointm
I'm currently using Outlook 2007 with the latest CRM Outlook client (V3C).
I have no problem adding emails to CRM with Outlook, but when I try to create
a new appointment, the CRM section does not appear in the ribbon. After
creating the appointment, if I highlight it in the calendar view and click on
the "Track in CRM" button on the Outlook toolbar, I get the following message
"This item type is not valid for promotion to Microsoft CRM". If I go back
in my calendar to an earlier appointment that was created when I was using
Outlook 2003, then everythi...cannot access reports remotely via web
When trying to access reports in CRM, i received the "Crystal Reports Logon
Error. Please verify that you have enough Crystal licenses."
However, if i launch the browser in the server CRM is installed i am able to
view all reports without any error. I've checked that NT
Authority/Authenticated and NT Authority/Intergrated is added to the builtin
Anything I missed here?
Try this critical update....
"Jordan M." <firstname.lastname@example.org> wrote in message
news:eGNo0w9Z...Look up Address problems!
I wonder if anyone can help with this problem.
I have imported a number of Accounts into our CRM system. All is
working fine except that I cannot link an invoice or delivery address
to an order or quote using the lookup address!
I imported the accounts originally using the administrator account.
If I logon to the CRM as myself and then create an order/quote (that
has the orignal account owner as the administrator) and use the look
up address, this works fine! I get the primary account address
If I then create an account as myself and then try to create an
order/quote and use ...MAcro Problem (probably easy)
I'm trying to record and run a macro that copies the format, colors an
a graphic from another excel report. I start the macro recorder, the
open the workbook, copy, switch workbooks, paste all, then switc
workbooks, close the graphic source workbook, and stop the recorder.
When I run the macro, it gives me an error like it can't open the othe
workbook. Any tips
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480
View this thread: http://www.excelforum.com/sho...GP BOM should be able to select variable BOM from date or range
I had a request from prospect to see if GP could allow their Mfg Mgrs to
create a cutoff or date range from which to select different BOMs.
They wish to change ingredients used in a dietary supplement starting
Tuesday. Work orders from Tues onward would use an alternate BOM. All work
orders prior to Tuesday would used the original BOM. There are other similar
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...Query
can excell make a query?please help me
Look in Excel's On-line Help for the topic "Importing data with
> can excell make a query?please help me
Excel FAQ, Tips & Book List
...Is there a way to turn off the prompts of a make table query?
I merely want to update the table to be used as an export to Excel using
TransferSpreadsheet. Each time it prompts for deleting old records and
adding new records. Is there a was to turn off the prompts?
Bottom line - I want to create an Macro to export the output of a query
to an Excel spreadsheet.
DoCmd.SetWarnings False 'Off
Your TransferSpreadsheet line here
DoCmd.SetWarnings True 'On
"I feel I have been denied critical, need to know, information!" - Tremors
"...Area Pages Display Problems
When I launch GP and select any series, for example, Financial. The area page
on the right provides varios categories.
In the Financial Area page, one of the Category is Cards and then underneath
cards it has Financial (To the the left of Financial there is a + or - icon)
and then Financial has several access items such as account, checkbook, etc.
The problem I am running into is when I click on the + icon it expands the
category properly and changes the icon to - correctly. Then when I click on
the minus icon it shrinks the category, but instead the of changing the icon
to + it chan...Problem Opening Outlook XP
I was having a few small problems with outlook xp so I uninstalled the
whole office suite. After uninstalling I cleaned everything refering
to "office", "outlook" in the registry (windows xp professional
w/sp2) with jv16 PowerTools 2006. Then I reinstalled Office XP.
Everything works except, when opening outlook I get the message
"Failed to register a VB Script DLL. Reinstall or run Regsvr32.exe
Vbscript.dll to self register.". Then outlook closes. I have
registered vbscript.dll successfully and still the error. I have
un/reinstalled several times now and still t...Big Problem! How to overload operator delete?
Big Problem! How to overload operator delete?
According to C++ standard, "A deallocation function can have more than
one parameter."(see 188.8.131.52); however, I don't know how to use an
overloaded delete operator. Let me use an example to illustrate this:
using namespace std;
void operator delete(void* p, const nothrow_t&)
cout << "Hello" << endl;
} // (1)
void operator delete(void* p, int a, int b)
cout << "World" <&...Sorting Problems
I am trying to sort numerically a column with a mix of numbers and text:
3 (36 hrs)
5 (19 hrs)
13 (6 hrs)
but this is what I end up with:
13 (6 hrs)
3 (36 hrs)
5 (19 hrs)
If you split the data into two columns--one column for the number portion and
one column for the parenthetical portion, you can sort by that first column. In
fact, you don't even need that second column!
One way to do that is to insert a column to the right of the original column.
Then select that column
Data|Text to columns
delimited by spa...Form Queries
I have a form [View Grievance Reports] with several reports set to run by a
single macro [View Grievance Reports Macros]. The form [View Grievance
Reports] has an unbounded list box that uses a table [Grievance Reports
Table] as the row source type. The report based macro works perfectly. I’m
now trying to adapt this form and macro to open a specific query when I
either click or double click on the query listed on the form. I can get the
Query based macro to work if I enter each query for click and double click.
If a query is listed on the form and it is not entered in the macro the q...Problem in displaying the chart
Good evening. I am facing one problem at creating chart. This
is my coding.
ActiveChart.ChartType = xlBarClustered
* ActiveChart.Location Where:=xlLocationAsObject, Name:="Cost"*
.HasTitle = True
.ChartTitle.Characters.Text = _
"5 Time Predictability of Design and Construction"
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).Has...List of where queries are used?
I have an access database which has many queries which are leftover from
various tests and temporary data extract needs. Is there a tool which can
tell me which queries are used in all reports, queries, macros, or modules
in the database?
You might want to take a look at the Total Access Analyzer (<
http://www.fmsinc.com/MicrosoftAccess/BestPractices.html>). Or you can use
Access's own Documenter. Run it on all the objects in Access with maximum
reporting settings, and then export/save it to a file of some sort that can
be searched (text, PDF, Wo...Date calculations
I have a pre-given date and want to know the resulting date after adding a
certain number of days in pre-given date. Mathematically it is like:
pre-given date + days = resulting date
Pregiven date is in one cell of a table on presentation and days and
resultings date are in their own cells each.
Thanx in anticipation
This gives the answer 11/04/2010 in cell C1.
If my comments have helped please hit Yes.
> I have a pre-given ...Publishing Problems
When i try publishing form changes, it's now giving an error the server has
never spit out before:
Publish completed with errors. Please see event log for details.
xxxxx: ***Error*** Failed to download XSL template files from Web Server
The Event Log said the following:
Web Excpetion status = ProtocolError HttpGet Error Unauthorized : The
remote server returned an error: (401) Unauthorized. , StackTrace : at
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)