Search results

CJ! It's 0325 in London! When do you sleep! T

Thanks, CJ; Working from the bottom up: My bad. I have three Classes: Project; ProjectSource and SourceType. The class definition of ProjectSource includes a SourceType object; the Project Source table (obviously) goes through a painful enumeration of the SourceType again! (Wouldn't it be nice...

Re: How to go from Intermediate to Advanced What a silence......! At the risk of being flamed, let me offer some suggestions: Beginner: Uses (primarily) the built-in tools to create apps. Little or no VBA; Tables may or may not be normalized (Huh? What's...

Hi I have a form with several objects: Projects -> which have Sources -> which have SourceTypes The underlying DB has tables for Projects, Sources and SourceTypes: Table Projects; Fields: ProjectID : AutoNumber; etc, etc Table: Sources; Fields: ID : Autonumber...

Hot keys update! I have changed the msgbox to a debug.print, and get the following: Key pressed (1): Shift value is 2; KeyCode is 17() Key pressed (1): Shift value is 6; KeyCode is 18() Key pressed (1): Shift value is 6; KeyCode is 18() Key pressed (1): Shift value is 6; KeyCode is 18()...

Not pointless! Thanks for your response. The snippet you quote is simply another way of testing if the value of Shift is 6. More accurately it tests to see if both Ctrl and Alt are being pressed. (It is possible to have not only those two keys but also the Shift key pressed, which would yield...

Hi! I have a tab control on a form, and I want to use "Hotkeys' to get from one page to another (or more specifically, to toggle the visibility of the pages). So, I set up the tab control with the pages I want hidden set with visible=No. Then I enable the Form.KeyPreview, so that the form will...

Thanks, Cronk. I'd forgotten how different the Outlook Object Model is! Probably going to need a couple of structural changes to get it in1 However, I think I have the right path, now! Tony

Vacation can get ruined fast when you don't have the right manuals available! I have this project that I'm working on which needs to process a whole load of Outlook message items into an Access database (some metadata - not the actual MailItems themselves). The top level procedure...

Problem solved - thanks to all! It was a combination of cutting and pasting within the form! It seems that any cut-and-paste from one container (form.detail) to another (form.detail.frame1) 'loses' the connection between the control and the handler. The fix was laughably simple: Simply click...

I have a form with a tab control and an option group (frame). When I built the layout of the contents of the first tab, the frame responded properly to click events. Now that I have copied them onto the tab control, the events seem to disappear. (When I check the events for the controls, they...

Yes - it works. But, of course, it does nothing to resolve my initial frustration! I did discover that there was a bug posted against ADODB Recordset opening this way when used against a MySQL database from VBScript. It's a ong way away from my situation, but it was sort of encouraging to...

Well - close visual inspection, + Option Explicit and no compile errors lead me to believe that this is not an issue! Wondering about why the other 99.9% of the time it works, are what led me to make my original post. I'll stick with - It must be something blindingly obvious (except to the...

Thanks for the response, SOS The table (LAB_UniqueIDTest) has just 2 fields: LAB_ID which is a string, and LAB_UsageCount which is a Long The primary index is LAB_ID The real issue is why, all of a sudden, the rs.Open that I use (about 50 times) in the application, doesn't work. Must be...

I agree that it wouldn't be possible - I was trying to show that rather than the 'obvious' intention of the programmer, there are other possibilities. (Hypothetically) requiring SET forces the programmer to make that clear. My original code (from which I deleted as much as possible) did indeed...

I think another (good) reason for requiring SET is that it forces disambiguation. Consider the following (lots of looseness in the meta language here ;-): Class MyStuff Public Name as string End Class YourOtherStuff=MyStuff MyOtherStuff=YourOtherStuff (Declarations deliberately omitted to...

Hi I'm building a lab environment into one of my projects. I'm testing the distribution of values over a largish number of attempts to create a unique value. I have a table called LAB_UniqueIDTest, with two fields: LAB_ID - the string value being tested, and LAB_UsageCount - the number of times...

Hi there I have a need to enumerate all the Tables/Forms/Modules/Classes etc in an Access Database. At present I'm scanning MSysObjects, but I was wondering if there were an easier way. Using Tables as an example the (pseudo-)code looks like this: Get all MSysObjects where Type = <Tabletype>...

Thanks CJ I'd thought of that, but since there are quite a few controls where this 'extra' functionality would be useful, maintaining all of those extra flags would become somewhat of a nghtmare (Not right away, you understand, but in 6 months when I have to look at all of them and remember...

I have a need to 'prevent' an event from completing under certain circumstances, and it is not clear how I can accomplish this. I have an app that is browsing a survey. When the survey is in simple 'browse' mode, I want to be able to emulate the effect of a SkipResponse. (A SkipResponse is when...