Search results

Ah! The Frame! Thanks Ranman256 - I guess I'm just too used to Excel VBA! Now working fine, based on OpenArgs functionality. Would have replied earlier, but I was struggling to keep the pop-up form "paused" 'till I discovered acDialog as the Windows mode. Thanks again to ALL contributors....

Thanks Ranman256 and Minty. I know I really only need two options, (which is why the SELECT CASE has only two conditions), but I wanted to keep the standard "Add/Delete/Edit" cluster for my Users. I'll happily make the change if I have to, but my problem is (at the moment) working out the...

Hi... The Background I have a Form, on which there is an Image. The Image is either a photo of an object, or a "default" photo saying "Awaiting Image". The photos are NOT embedded - they are paths to images in sub-folders. The Requirement I want to allow the User to double-click the photo to...

Thanks to all who replied - MarkK takes the prize - AutoResize=Yes has worked. Foolishly, I assumed ("Make an Ass of U and Me") that I knew what AutoResize meant. That was another of my many mistakes! Reading up on the property it seems to be a bit of a trap for the unwary - most properties...

Hi guys.... I have a form on which there is an Image. When the User doubleclicks the Image, I want a "pop-up" Form to appear, with various radio-button options etc. This all works (ish), but I'm struggling to size the "pop-up" Form vertically. On the Form I have removed all scroll bars...

I know it's "over the top" ridders, but I've spent my professional I.T. life writing applications for seriously non-I.T. specialists. I'm old fashioned (or is that just 'old'? - is 66 old?) - I still believe it's often worth going the extra mile to give Users the extra inch (no sniggering...

After a fair bit of reading, at my skill level the only real option is to take up the suggestions from Static and ridders of having a Label saying something like “Click for more ==>” next to the box, or possibly some code to change the colour and width of the Textbox’s border. In either case I...

Back in 2004 the User anb001 had a problem with forcing a text box to show a vertical scroll bar. The argument in 2004 seemed to focus on "Why" rather than "How". I have the same problem, and as it happens the same reasons as anb001. I want the User to be aware at a glance that there is more...

Hi pbaldy.... I already have referential integrity at relationship level. What I DON'T have is a functioning brain! I set up a test whereby a Board was in a Location, then tried to delete the Board. Of course, this worked (hence the post). When I tried to delete the Location, it correctly...

Hi Guys, it's the amateur seeking help again! I want to delete a record from a Table, but that record might be referenced by an entry in another Table. For example i have a Table of Locations, and a Table of Boards. Boards exist in Locations. If my user chooses to delete a Location, I'd like to...

Works a treat - less code, easier to follow, and more elegant, because I'm passing the "Object of interest" not a subset of that Object. Thanks MarkK!

Thanks for the kind and useful explanation. I'll amend my code (and thinking!) accordingly....

I have a Form which is a main menu form, on which there are buttons which, when clicked, invoke other Forms. These other Forms have a Query as their ControlSource, and this Query is unfiltered, so it gets all of the records in a particular Table. The "master" form is called (unsurprisingly)...

Ridders - A “test harness” is some code not destined to be in the final version, but which will set up conditions to allow code which IS destined to be in the final version to be tested during development, usually for the purpose of debugging. To those interested in “God’s Own County”, I agree...

Thanks to all - I'll investigate the links and no doubt find the answers. Ridders - in my parlance a "test harness" is just some method of causing something to execute to see what happens. In this case it's some VBA code which won’t be in the final version, but just exists to execute some code...

Looks like i have an antique version of Access! Thanks to all who contributed helpful and polite replies. My normal routine is to save frequently, and during development I always try to document what I'm doing in the file name, along with a version number, for example "GKD V31 (fixing menu...

I'm in the Access 2010 VBA editor, developing VBA code (fairly experienced in VBA, but not in Access VBA), and to test my code I'd like to execute a test harness to display a particular form. When I single step the code I can switch windows to see what's happening to the form, but at times I'd...

Tried Repair/Compact - still appending 1s to my file name!

One of my mantras is "The only really stupid question is the one you don't ask", so I'm asking it! If I've been working on an accdb file, when I come to "Save Database As" the database name has at least one "1" (and often a series of them) appended to it. Where is the setting which controls...

Interesting! The rogue "[]"s vanished on a cut-n-paste from the post, but curiously I now get "#Error", even though the "[]"s don't reappear! when going from Design View to Form View then back to Design View. I'll try the Notepad route, and see if I can fix it. Thanks for all the advice!....