Search results

Hi - Looking for the capability to go to (from a highlighted treeview control) specified module and display specified function/sub. All suggestions appreciated. Best wishes - Bob

Hi - Suffering severe brain-cramp today. Have two queries: 1) For a specified month, totals various home expense categories, e.g., Insurance, Utilities, etc.. 2) For a specified month, totals payment method, e.g., cash, check, credit card, etc., for each expense category. The problem --...

Hi Bob - Your post #3 at this thread struck home. I've been playing with a current application which tracks expenditures (but not payments). Looking for the most expeditious method of emulating Quicken, which displays both debits and credits, and a running total. Have you come across any...

U.S. Daylight Savings Time ended at 01 Nov 09 0200 local time. Have you set your clocks back? Bob

Hi - I've asked this before, with no responses. Figured I'd give it another try. Working on a Toshiba laptop, using XP, the feature that allows one to step thru a function and place the cursor over a defined value, which is then highlighted and displayed does not work. Makes troubleshooting...

Hi - There are various codes used in conjunction with SendKeys, e.g. SendKeys "%(FMC)", False to Compact. Where are these codes found? Have checked the Help File, the Microsoft site and have come up zero. Your wisdom appreciated. Bob

Hi - I downloaded Main menu just like tree view Using tabular form by khawar from sample databases. It uses a tabular form to very successfully replicate a treeview. I've tried to create a similar form. Try as I might, I'm unable to duplicate the form. Searches for info on tabular forms...

Hi - I've got myself 'wrapped around the axle' trying to create a query (which will then be used in a Union Query). Have a dynamic crosstab query which produces by-month totals for each category. The crosstab is designed to total the input month and the previous 5 months (6 months total)...

The following crosstab query returns columns in this order: Category | Total | Avg | Dec 08 | Jan 09 | Feb 09 | Mar 09 | Apr 09 | May 09 ...however, if in query view, I manually move the Total and Avg columns as shown below, then save the query, it will reopen in the modified...

Right off the bat, union queries are not my 'cup of tea'. SELECT tblCat.Category , Sum(tblTransfer.PayAmt) AS SumOfPayAmt FROM tblCat RIGHT JOIN tblTransfer ON tblCat.CatID = tblTransfer.CatID WHERE (((tblTransfer.ExpDte) Between DateValue([enter mm/yyyy]) AND...

Hi - I've just started playing with recursive fuctions, and admittedly I'm struggling just a tad. Here's a non-recursive function I wrote to remove unwanted characters from a string. Anyone up to a challenge of rewriting this as a recursive function: Public Function fFixWords3(pStr As...

In the process of responding to a post in another forum, I came across this function, which I hadn't used in years. It allows the user to specify a delimiter and designated block (e.g. 1,2,3) and returns that block. I don't know if I wrote it (would like to think so) or copied it from an...

In the process of responding to a post in another forum, I came across this function, which I hadn't used in years. It allows the user to specify a delimiter and designated block (e.g. 1,2,3) and returns that block. I don't know if I wrote it (would like to think so) or copied it from an...

Has anyone ever come across one? I found this several years ago (start here) and have attempted, from time to time, to simplify it, improve its functionality, and make it easier to install. It's be great if there were a working model out there. Bob

Hi - Is there an object reference delineating whether an 'object' (and I may be using the term incorrectly) is a table, query, form, report? I'm attempting to develop a command button that when clicked, would open an object (table, query, form, report) specified in a table (probably an...

Hi - Got a strange situation with a text box in a search form. The form is along the lines of the Cool Search Tool form that's been discussed here from time to time. The user types in letters, dates, numbers and on OnChange (i.e. each character typed) a BuildCriteria criteria is created and...

Hi - Got into a rather combative exchange (most on my part, the OP was a wimp) with an OP who claimed s/he was trying to develop a by-month schedle. I got real assertive there towards the end. Now, I discover the entire thread no longer exists. Checked for a nasty explanatory e-mail to no...

I'm attempting to update (populate) a null date/time field with random dates using: Public Function GenRndDate(ByVal Upper As Date, ByVal Lower As Date) As Date Randomize GenRndDate = Int((Upper - Lower + 1) * Rnd + Lower) End Function ...called from this Update Query: UPDATE...

Hi - Looking to see if anyone has a trick for formatting data examples for this forum. Example: At http://www.access-programmers.co.uk/forums/showthread.php?t=165152 (Post #4) I copied several rows of a query to serve as an example. In query view it was all nicely aligned, but pasting it to...

Hi - This thread http://www.access-programmers.co.uk/forums/showthread.php?t=159712 sought to categorize ages, e.g. 16 - 20, 21 - 25, etc.. It's received a number of responses, most of which are code-intensive using either multiple Iif() statements or Case statements. Nowhere did anyone hit...