Search:
Type: Posts; User: Webtest
Search:
Search took 0.29 seconds.
-
Glad you got some mileage out of this! I always try to share my "aha" moments. You never know when a little knowledge will come in handy.
-
The working FINAL SOLUTION many thanks to si_the_geek !!!
SELECT Updates.TransDate, Updates.Balance, Accounts.OrgName, Updates.AcctID,
Accounts.Owner
FROM (Accounts
INNER JOIN Updates ON...
-
Si ...
Thank you very much for your interest and your assistance. Your solution works PERFECTLY! Sorry about my error in my initial posting ... it is very understandable that you would copy it and...
-
I actually got this working, thanks to the "Design View" (as opposed to the SQL view), but I had to create 2 queries to do it.
The first query just builds the (virtual) table of Date/Account pairs...
-
Thanks for the detailed explanations Si. I think I'm beginning to see the process ...
Create something like a virtual temporary table aliased UpdateAmount that contains only the records from the...
-
Esteemed Forum Participants and Lurkers:
================================
Microsoft Access 2000 (9.0.3821 SR-1)
I am trying hard to understand and use Access, but it is eluding me. I have...
-
Robbo ... (Is that an "Old Tanglefoot" in your personal icon?)
It's been awhile since I have had VBA open, and I have no experience with auto generating e-mails ... but ... and I'm just guessing...
-
Thanks westconn1 ...
I sort of figured that was going to be the approach. I can't mess with the folder ... it isn't mine. My VBA program writes the file to the shared drive before the user can...
-
It is a simple HTML page file .... myTableFile.htm
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
We have a few low-level web (intRAnet) document publishers in this group, and I would like to add a macro...
-
Thanks everyone ...
If I had spent as much time trying to hack through the problem as I did writing the letter to the Forum, I would have solved it. I was in a hurry to leave to go home. Here is...
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
I can't remember how to pass an array to a nested function. This is a snippet ... I can do everything...
-
Legacy File operations vs. File System Objects (Microsoft Scripting Runtime)
========================================================
Scan 4 directories ... 150 files in each directory.
Fetch...
-
Thanks All ...
Most of the time is spent deleting and copying files on a networked drive. I have 150 files ... about 1.7 megs each ... to manipulate. That takes around 10 minutes no matter how...
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
I have a lengthy Excel macro (VBA program) that takes 10 to 15 minutes to run to completion. While it is...
-
Thanks for your help koolsid. It is all working now. One of these days I'll investigate all the nuances of ".SetSourceData" and see what it really can do.
-
Thanks CoolSid ... I did use the Macro Recorder and I came up with a workable solution ... but it sure does complicate the code a LOT!
The old single line:
'Update the HISTORY chart
...
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
I have a workbook with 2 chart pages that I have been keeping for a few months. Basically, the 2 charts...
-
Yes, SET just creates 2 names for the SAME dictionary ... not 2 separate dictionaries. If I change one of the items in "junk", it changes the same item in "aSmart_List". I know I can equate ranges...
-
Doesn't the "Set" directive just point the "junk" directory to the other one? I need 2 separate dictionaries, but 98% of the keys are the same.
Thanks ... I'll try it and post the results.
-
Try naming your subroutine "MyIsNumeric" ... just a quick guess.
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
Is there a quick and dirty way to copy all of the contents of one dictionary into a different dictionary? ...
-
This is a simple example ... you can put your PARAMETER and New Value in the Global constants ... If you change "Integer" to "Variant" you can put anything in PARAMETER and NEW_VALUE. This will...
-
How do you intend to specify the particular value(s) for the particular parameter(s) that you want to change? There is no problem scanning any number of rows to change the value matched to...
-
The easiest way to get started is to Record a Macro or two to do some simple things.
Menu/Tool Bar: Tools > Macro > Record New Macro
then
Tools > Macro > Stop Recording
Now, you...
-
VERY basically ...
Refresh:
ActiveSheet.Calculate
Edit:
Range("B5").Value = Range("B5").Value + 27
-
THE SHEET WAS PROTECTED !!! When I unlocked the sheet it works FINE. Thanks for the help, Hack!
-
Thanks Hack ...
That's close. It certainly de-activates the "operate" function. When in the "Design" mode, I still can't click on a button to select it for editing the properties, such as...
-
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003
Does anyone remember the shortcut to switch modes in Excel from Editing controls (standard VBA buttons and...
-
JayCR:
The following post will show you a loop to find all network printers. Start around post #6 in this thread.
http://www.vbforums.com/showthread.php?t=385944&highlight=printer
-
darbid:
The Visual Basic systems available in the MS Office applications are extremely powerful and comprehensive programming languages. I personally use Excel VBA extensively. There are some...
-
You have shown a 'duplicate' row that is adjacent to its match. Is that always the case, or do you have to use the universal situation where the 'match' can be anywhere in the list? Can you sort...
-
Excel: How to: Pass Command Line Parameter [DKenny is KING!]
-
Watermeloene:
I believe you have to use an API call to the OS to pass command line parameters to a VBA program. I was able to us this successfully to pass command line parameters to an Excel VBA...
-
What is the typical contents of the cell that you want to split? is it Text?
-
Do you have an "Option Explicit" line before the first Sub/Function in your module? The functions you show are actually String functions operating on DECIMAL numbers. Even though the "Binary"...
-
Are you looking for something like this?
Function HexaNum(aNum As Variant) As String
HexaNum = Hex(aNum)
End Function
Variant allows the function to be passed a Long or an Integer ... I don't...
-
The numbers are identical internally ... it's just a matter of how you display them. I've got to head for home now, but I'll look at it again tomorrow.
-
There are no native bit shifts or rotates in VBA (that I know of).
This can be optimized, but here is a quick and dirty solution ... signs may get in your way.
'16 bit Logical Rotate Left...
-
What datatype are you using / how many bits in your bitfield??? Do you need sign-extension or not???
|
Click Here to Expand Forum to Full Width
|