How to find out the path where the exe is located?
I have to create a file in the directory where the program itself is
located, but I cannot find any function that would give the path. Any
suggestion? I only find things that give the path of the current directory,
but that is no good....
"ZPenzes" <email@example.com> wrote in
> I have to create a file in the directory where the program itself is
> located, but I cannot find any function that would give the path. Any
> suggestion? I only find things that give the path of the current
> directory, but that is ...Finding the number of records in a query
I want to restrict my users from running a query if there are records in a
second query. The second query has 2 parameters based on forms,
[Forms]![frmInvBusNums]![InventoryNum] and [Forms]![frmInvBusNums]![BusUnit]
The code I'm trying to run, which is totally wrong looks something like this:
Dim db As DAO.Database
' Dim rst As DAO.Recordset
' Set db = CurrentDb
' set rst=db.QueryDefs "Discrepancy_Report"
' If rst.RecordCount > 0 Then
' MsgBox "There are conflicts"
' Exit Sub
' ...Finding data within a worksheet made up of links
This should be simple, at least I would think so, but I can't find a way to
do it. I have a workbook that imports data from another workbook, then
populates another sheet with which I produce my output. The output sheet
shows all the appropriate date but the cell reference is simply the link to
For example: My sheet shows the number 100 but in the cell it reads
=otherworkseet!a1 (the source from which the data is extracted.
I want to find out how I can use find or a formula to show me every cell
that has the 100 in it without converting it to raw da...Editing hyperlink with find and replace
When I use find and replase to edit multiple hyperlinks in a Excel sheet
(linking to another workbook and sheet1) to link to sheet2 instead, the
hyperlink changes on screen but proforms exactly the same (links to sheet1).
How do I get to do what I want?
I'm not exactly clear on what the problem is but, fwiw, the usual way to
change links is via Edit, Links, Change Source.
"Trevor B" <Trevor B@discussions.microsoft.com> wrote in message
| When I use find and replase to edit multiple hyperlinks in a E...Where do I find the 3D Lotto Matrix System?
I want to win in the 3-digit PCSO suertres lotto. Along this desire, I want
to know the matrix system for this game.
> I want to win in the 3-digit PCSO suertres lotto. Along this desire,
> I want to know the matrix system for this game.
The normal price for this information is $49.95.
A payment received within the next hour is available for only $99.95.
This will include a 100% guaranteed method of winning *every* time you play.
You may not make a profit, but you will win.
On Wed, 27 Jan 2010 16:07:02 -0800, Charles
Thanks to anyone who helped me with my finding/deleting link
Now in a different workbook.. when i open it, it prompts whether t
enable or disable macros. When i go to the macros list though, it
blank, none listed. How could I find where thesee phantom macros ar
and get rid of them? FYI we always choose Disable macros. This is
work book that was built a long time ago, probably has about 50+ tab
of which we only currently use about 15.
Thanks for any help!
Message posted from http://www.ExcelForum.com
you also have to remove the modules:
- open the VBA editor (hi...CRM Setup couldnot find a valid organization on the specitied data
What's the matching info between the database and active directory? I try to
modify them to match each other.
"CEO" <firstname.lastname@example.org> wrote in message
> What's the matching info between the database and active directory? I try
> modify them to match each other.
1. I only backup the SQL database for CRM.(x_CRM.mdf , etc.);
2. I removed the original OU in Active Directive;
3. completely re-install CRM using a new database;
4. un-install CRM, remove database, but keep OU in AD...Advanced Find
In CRM 3.0, when creating an Advanced Find for the URL entity, we noticed
that in the Select > Fields list, there are two instances of URL.
Both instances work the same, but our users are curious why there are two
instances when there is only one URL entity in the system.
...KB945412-v10 sp1 fails
I installed GP on my laptop and created the sample company. logged in and
Next, I ran the upgrade to SP1 and it failed. The error message follows:
Title: Windows Installer
The upgrade cannot be installed by the Windows installer service because the
program to be upgraded may be missing, or the upgrade patch may update a
different version of the program. Verify that the program to be upgraded
exists on your computer and that you have the correct upgrade patch.
I think I might know why - the OS and programs are all installed on the E
In a post in 2007, John Oberlin ran into...Using sdk to find out if an Account already exists
Want to use sdk to see if an Account already exists , all i have is
I've looked at Retrieve method but it requires the Guid.
Any equivalent call to Retrieve that just takes name? Or a way to get
the Guid from the name?
Sample code would be great if available.
Thanks for all help.
The method you are looking for is RetrieveMultiple as only the guid
search gives the certainty to retrieve only one record.
All explanations are in the sdk but as the sdk sample is nearly the
exact code you want, here it is :
// Set up the CRM Service.
CrmService service =3D new ...Find Now returns "no items found" in a public folder when it should find something
I have an SBS 2003 server running with Outlook 2003 clients. In one
particular public folder if the user selects this folder in Outlook and uses
the "find" button, types in the criteria in the "look for" field and clicks
the "find now" button - Outlook does not find anything (there things to be
found) and comes up with a "no items found" message. If the user uses
advanced find from the "options" drop down menu - then the search works!
But when the user trys this seach in other public folders (with the relevant
search criteria) - it works....Need to find the table
I do get some odd requests for great plains. My latest requires me to track
down a table.
The one i need is for one of the forms that shows in the smart list. I need
the one under account transactions and is called Output VAT Nominal. I need
to know what table/s supply this form.
Even better would be if it was possible to access the hard coding of this
form. I looked for it and found nothing.
We run great plains version 8 should it help.
well, thankyou all kindly in advance.
Tools>Resource Descriptions is always a good place to start.
> I do get som...Advanced Find: Account which are not a member of a marketing list
It sound really simple and I thought it was but my advanced find is not
I am looking for the accounts of the current user and these account should
not be a member of a certain marketing list.
So I started at account level and set the criteria for owner to current
user. Then I selected the Related Marketing list. There set het marketing
list does not eqaul the specific marketing list.
Runnen the query does not give any result. Changing the marketing list
criteria to equal does return the members of the marketing list.
What am I missing??
Confirmed, that is the same be...How to find merged records?
How to find merged inactive records with advanced find?
Or do I need to use e.g. workflow to put those to special marketing list?
If I'm understand right, those merged inactive record I can delete and still
save the data that is copied to active record.
Merged information is anyway on opened form "The record was merged with the
X recrd, and then deactivated." but it is too much work to open all
inactivated records (~50000)
Have a look at this post:
Visit my bl...faq: use position of CList can find the element?
In CList , we can use variable of type POSITION to
GetAt(),SetAt(),etc. Now if we use it like this:
funtion1(POSITION currentpos, POSITION& previouspos)
};//in function1 return the value of previouspos
funtion1 returns the value of previouspos, can I use it to
GetAt(previouspos) the element in another function2:
does it worked?
I mean , wether the position of CList is soly and fixed when the
Thank you very much! :)
Thank this newsgroup very much! :)
Visual Studio ...How to find ObjectTypeCode in ISV-Config
In 4.0 I have a custom entity ‘new_changerequest’ with a 1:N relationship to
Account, i.e. Account -> new_changerequest. On the Account form I have a
button defined in ISV-Config to create a new new_changerequest:
var newwindow =
window.open('/userdefined/edit.aspx?_CreateFromType=1&_CreateFromId='+ oId +
Client="web,Outlook" AvailableOffline...Advanced Find not working after upgrade
After upgraded from Office SP 1 to SP 3, when I do a
advanced search (Outlook 2000), even though there are only
1 mail in a folder, the advanced find still cannot find
the mail after more than 1 minute eventhough the searching
criteria is correct.
Before the upgrade things works fine. Any idea?
Did you ever get this fixed...I am having the same problem...
> After upgraded from Office SP 1 to SP 3, when I do a
> advanced search (Outlook 2000), even though there are only
> 1 mail in a folder, the advanced find still cannot find
> the mail after mo...Find Last Item Entered in Row
Hi, I am hoping I can get some help on this.
I have a spreadsheet that has an item # in column A, and has a place to
enter prices for the next 52 weeks in columns B - BA. I need a formula in
colum BB that will find the last price entered for that item # in all of the
columns. There will be items that may get updated each week, and others that
will only get updated periodically, so those columns may be blank.
Any help would be appreciated.
Put this in BB1 and drag down
When competing hypoth...find window problems
When we try to find an item in Pos and then hit escape to close the find
window, it puts an item into the transaction . It's always the same item,
even though this item is in the middle of the items, not at the beginning or
end. This started happening after we upgraded to 1.3R. It's causing a
problem when we're busy, since we don't always catch it until after we print
a receipt. Anyone have any ideas why this is happening, and how we can stop
Here are the steps to replicate this problem. Type in an ILC that's not in
your database, to simulate an item no...Change Default View for Advanced Find Results? (OL 2003)
I'll pose the brief question first. If you know the answer to it,
there is no need to read the background (and many thanks in advance!).
The question: Is there a way to configure Outlook 2003 Advanced Find
so that the results always come up with a user pre-defined view (set of
fields) rather than Advanced Find results' default columns? (Or,
better yet, is there a way to permanently reset standard Find to search
only From and Subect instead of fulltext?)
I liked the fact that standard Find in OL 97 defaulted to searching
>From and Subject...took less time than fulltex...Windows cannot find file message
I have a strange problem when I try to open an Excel file from My Computer or
Windows Explorer. I get an error message to the effect that "Windows cannot
find the file c:\book1.xls' ,etc. etc. although the file definitey exists.
Not too sure what I've done, but any help fixing this problem would be most
One possibility is that the file is nested too deep in the filing system.
There is a limit to the number of characters that can be used for a file
path. For Excel I thing this is about 234; for Windows it is more.
See if the name given in the "ca...Finding Characters
Hi MVP's and other smart people,
I have a column of data (A1 thru A11500) with names or addresses etc. I would like to know if there is a way to display "Delete"
or similar in the adjacent cell in the same row but the next column (B1 thru B11500) where any particular cell in column 'A'
contains certain characters amongst the data within that cell.
I have done this many times using the 'IF' formula when it necessarily matched the entire cell contents but it's only 1 or 2
characters contained within the contents of each cell that I need to match this time.
Ho...where can i find uk tax and national insurance calculations
i want to set up a template for calculating take home pay after tax national
insurance etc. I would like to enter salary or hourly rate plus tax
code/allowance. I'm trying to balance possible
outgoings(rent,rates,gas,electric etc.) against salary required. i.e how
much would i need to earn if i have a bedsit @ 90 pw or a 1 bed flat @ 130pw,
diferent addresses might increase petrol used per week by 10pound or area
might increase car insurance by 100 pound, all effecting outgoins so
increasing salary requirements.
I'd suggest you go to a UK government site to get those rates...Unexpected Error- Running Advance Find Query
I am getting a message that says "Unexpected Error An Error has occurred"
when I am running an advanced find query on two custom entities. It seems to
be when I have certain custom fields included in my view that the query
Any help on this would be greatly appreciated. Thanks so much.
Just wanted to add that I seem to get errors when there is a 0.00 amount in
> I am getting a message that says "Unexpected Error An Error has occurred"
> when I am running an advanced find query on two custom entities. It se...Combo box
Using the wizzard for creation of combo boxes the third option onm initial
options page allows the combo box to find a record on a search.
I would like this option but also be able to add to the list to allow new
records to be created.
How can I do this in vba code/form properties? The wizard had a macro
running on the after update, couldnt quite see how to replicate this action
using code/form properties.
This would clear up my problem with my other long winded and hard to read
Not positive this is what you mean, but the combo box will refl...