yet another resource editting thread
I need to edit resources at runtime (i.e. the string table, menus, and
dialog control sizes). I would like to use the BeginUpdateResource,
UpdateResource, and EndUpdateResource functions.
One of the problems I have is this:
If I load the menu from file with FindResource, LoadResource,
LockResource, I have the binary menu data, and I can't really
manipulate raw binary.
If I load the menu with LoadMenu, i have a CMenu, that I can change
but I don't know how to convert the final menu back to binary data
that I would update with the UpdateResource command.
So, how do you update?
I have a field called "TimeStamp" What I would like is that if someone
modifiys or make any change in the form that the "TimeStamp" will record
the time and date of change.
How can this be achieved?
In an event procedure in the form's AfterUpdate event, you could do
Me!txtYourTimeStampField = Now()
Note that if you use the BeforeUpdate event, every time your code changes
the value of this field, the form tries to update, the BeforeUpdate
(re-)triggers, and you "loop up" (at least, it seems to me I've seen
this...)...spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.
If anyone knows how I can get this behavior to work, it would be GREATLY
I did a record new macro, and got code similar to the following:
Add the fiollowing to your code as shown:
...Foreground locking error running scheduled integration
I have a scheduled integration setup that first runs the login to GP, then an
integration group (2 AR integrations). I have them set at 5 minutes apart.
The TK article for this particular error says that the error is because
"Great Plains is still in the process of launching when the Integration
Manager starts running." I then increased the time to 15 minutes
apart and finally at 30 minutes apart, but the first record of both
integrations still fails with this error "could not set foreground locking
value to 0."
How can I get rid of this error? It only takes les...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...Possible to Look Up Records by Initials?
I have a user who's telling me that prior to this weekend in CRM, she could
lookup user records by initials rather than typing in part of the name. I
don't see where that setting would have been marked in CRM. Has anyone else
heard of this? If so, how did you implement this type of search
Steps to recreate problem:
Account Owner field's magnifying glass
Assign to another user fields magnifiying glass
Look Up Records' Look For field = initials of user you're attempting to Find.
I doubt you can use the init...How to record percentage increases in materials costing sheet.
I am trying to do a materials costing sheet where I would like to be able to
periodically increast the base cost of the product by different percentages.
E.g. Cost of Apples $10.00 but might be increased by 5% then 2.5% and
therefore the base cost would keep changing. I know how do first % increase
but not how to then use that figure as the base figure for future
adjustments. Thanks for amy help. I am very new to this.
You could put a % in one cell. Select the cell and give it a name by
Insert-->Name-->Define. Call it "increase".
Then, in the cell where you put the f...HOWTO create a Mail Merge Template in MSCRM with multiple child records
I have created successfully a basic Mail Merge template in MS Word in
Dynamics CRM 4.0 for Order Entity.
My challenge now is how to design a template that retrieves the order
details (product and prices) related to the order record? This sounds like a
On Jun 2, 1:26=A0pm, "Benjie Fallar III" <bfall...@hotmail.com> wrote:
> I have created successfully a basic Mail Merge template in MS Word in
> Dynamics CRM 4.0 for Order Entity.
> My challenge now is how to design a template that retrieves the order
> details (prod...2003 SP1 ADC running with Exchange 2000
Can you run ADC version 2003 SP1 even though all your Exchange servers are
This means that you have already ran domain/forest prep right? If so you can
only run the 2003 version of the ADC. This is not recommended and could
cause replication errors with Exchange/AD.
> Can you run ADC version 2003 SP1 even though all your Exchange servers are
> still 2000?
Correct, domain and forest prep has already been ran. Why can I run 2003 but
not 2003 with SP1? We want to use the cross adminstrative group mailbox move
function that came with...Recording ownership in an LLC partnership
I'm a partner in an LLC company and would like to track my ownership
interest in Money 2004.
It's not "real" obvious how I might go about this, particularly ...
What account type should be used?
How do I record my portion of the profits earned, for which I'm am
How do I record the gain in ownership value these profits provided when I
haven't necessarily received them in cash?
How do I record a portion of these profits as received in cash when they
aren't dividends but distributions?
I'd prefer to use an investment oriented approach rather ...Can you record a macro in Publisher like you can in Excel?
In Excel I use the feature to Record a Macro. Excel records the keystrokes
and converts to VB. Does Publisher have that option? In my version,
Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
don't know how to code VB.
> In Excel I use the feature to Record a Macro. Excel records the keystrokes
> and converts to VB. Does Publisher have that option? In my version,
> Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
> don't know how to code VB.
Publisher does not have a Macro Recorder, sorry.
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...Fragments Left after running XP Defrag Program
Ran Defrag and had two 'Fragments' reported (last two lines of the log
print). One was for 6156 Fragments and one was for 7030 Fragments; the first
file is 1.51 GB and the second is 2.00 GB, and both are 'buried' deep in
\Documents and Settings\Bill & Peggy\Local Settings\Application
Data\Identities\25C08628.........\Microsoft\Outlook Express\ and both files
are .dbx files. Question: These files are apparently taking up 3.5 GB of HD
Space; can I delete them? I do not use Outlook Express although I have in the
past, but now am using exclusively MSN for both my ...Payables Transaction Edit List
Our customer had the following error print on the Payables Transaction Edit
List: **ERROR: One of more landed costs need to be apportioned.Document
Total. This prevented the user from posting the batch. The batch went into
However, the error message did not appear when logged in as 'sa' and 'sa'
was able to post the batch. This customer does not even own the landed cost
module. Plus, this was an A/P invoice, not a POP invoice. Why was this
...Referring to a FileName in Macro
I have a Macro with the following code
TestQry is the name of the file. Is there anyway that this macro cod
can refer to the activeWorkbook or filename so that if the file i
saved to a new name this macro will still ru
Message posted from http://www.ExcelForum.com
How about just:
"DoctorV <" wrote:
> I have a Macro with the following code
> Application.Run "TestQry!Macro2"
> Application.Run "TestQry!Macro1"
&g...Macro Copy and Paste
I am currently trying to copy from one workbook that has 7 differen
tabs and paste into one worksheet on a separate master workbook. M
problem is that when I set up the macro to copy from one of the tabs i
the workbook and paste to the other work book, I only want the the row
to come in where there is data. Currently I am having to run a macr
that takes every 100 lines, but ideally I only want the informatio
copy and pasted where there is only data.
In addition, once I have copy and pasted everything from the first tab
my next step is to copy and paste information from the second tab t
th...Macro Question #10
I am working with a text file that I imported into Excel.
It is a transactional report of sales by customer. The
data will have the customer number and name spread out
over three cells. What I want to do is to create a macro
that will contatenate all three cell and then perform a
paste special and paste them into another cell in another
column. Since the number of transactions by customer can
vary the customer name and number can appear anywhere on
I created a macro to do this using the first customer
which appears in cell B5 through D5. The next customer
appears...Editing more than 1 table at a time with SQL.
Say I have two tables in a DB called TABLE1, and TABLE2.
My question is would I be able to use SQL in code to Edit, Delete or Insert
data to both tables in one string rather than one table at a time?
For instance what if I want to change both tables with a [IDNUMBER] = 2 to a
[IDNUMBER] = 4, OR change the ...Spreadsheet macro stopped working!
I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:
Scorecard, statistics, database and equations (for calculating some
I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for ...Sorting records in the Report Design View
Currently, I use "Sorting and Grouping" tool in the Report Design View
to create group headers so that I can group my data accordingly.
However, I would like to know if I can apply a custom sort order.
For example, the field name that I want to group is "Region". I have
records of "East", "North", "South", and "West". Is there a way that
I can order by "North", "South", "East", and "West" instead? If I use
the "Sorting and Grouping" tool, it won't work because it only accepts
a...records in current month
I want to use a query that returns records in the current month from a
date field, but cant work the query out - anyone help please
Set the criteria under the date field to:
Between Date()-Day(Date())+1 AND DateSerial(Year(Date()),Month(Date())+1,0)
Microsoft Access MVP
> I want to use a query that returns records in the current month from a
> date field, but cant work the query out - anyone help please
...Excel 2007 macro compatability
I have created a macro in Excel 2007 that includes importing a text file. It
works fine on my PC, but fails on a co-workers PC running Excel 2000. The
failure points to the "TextFile Platform" command in the macro. I have tried
several (437, 1252, 20127), but get the same results.
Have you try
Regards Ron de Bruin
"Al @ Frontier" <Al @ Frontier@discussions.microsoft.com> wrote in message
>I have cr...How do I Run Outlook and keep it on the hard disk
I had another hard drive installed on the computer and had Office 2000
installed on it but I do not appear to have Outlook. How can I get it onto
the hard drive and get it to stay there?
Mike <Mike@discussions.microsoft.com> wrote:
> I had another hard drive installed on the computer and had Office 2000
> installed on it but I do not appear to have Outlook. How can I get it
> onto the hard drive and get it to stay there?
Can you be more precise? If, for example, you hae another disk added to
your PC and the new disk was made the C drive, then it's no surprise. If,
i...Excel E-mail Macros
I need to know how to create a macro that will send an
excel file as an attachment to one individual, and then
send one of the file's worksheets to 3 e-mail addresses
using the mail recipient method so that the worksheet
appears in the body of the e-mail. The e-mail program I
am using is Outlook.
Any help with this will be GREATLY appreciatd.
I'd tell you, but Ron de Bruin already did all the work. It'd be silly for
me to do it again...Try Ron's site:
"John" <email@example.com> wrote in message
Last week, Art was trying to help me with this, but the solution doesn't work
for me. I'm looking for a macro that would be contained within my
personal.xls, that I could use as needed.
Lets say I have A1:C5 selected, which represent headdings and data for jan,
feb and march. [On a different spreadsheet, it may be different columns, or
a different number of columns. The point is that I will select the range
before I run the macro.]
I want to do an auto fit for each column, so that the column widths are big
enough to fit the numbers. No problem, format-->column-->autof...