Search results

I have a hyperlink control on a form which is linked to a jpeg image stored on the local HD. Whenever I click on the link, I get a Access Security Notice ("This location may be unsafe.") even though I have set the image's file folder to a Trusted Location. Is there any way this message can be...

I have successfully placed an Attachment control on a Form (to display images) and a nice thing about it is that clicking on the image brings up an icon that allows directly adding additional images (as well as selecting which image to display via forward and back arrows). The problem I am...

Never mind - I reloaded the split database and now it works. I have no idea why.

Am trying to display images on a form in a split database. I add the attachment field to the associated form's table and add the attachment control to the form but cannot get the image(s) to display on the form (the control remains blank). I can add the image(s) in table view (and display...

No, it's turned off. I did though google it to find out what sort of problems it might cause and was surprised there are so many. You would think MS would either cure this thing or remove it. Anyhow, and sort of related, I had previously tried to run some VBA code which choked on one of my...

Thanks Dan, but do you mean it fixes the event's problem for good or just restores the event that one time?

Sorry, had a brain fart. What I really needed to do was run a SaveAsText (for the form in question) followed by LoadFromText in the Immediate Window. This will supposedly regen the form and flush out any corruption that may have crept in. Anyhow, the procedure completed as expected - will...

Gr-r-reat - the export just errored out on insufficient HD space. It did create a text file but the file size is 50 GB! (which is about how much free space existed before the export began). I had no idea my database was so large :) (it's actually BTW about 6 MB in .accdb form). So much for...

I don't believe so but I'll check it when (or whenever) it finishes exporting the dbase to a text file (it's been going about 1/2 hour now and the little wheel keeps on turning). I kind of expected the export function would let you specify which object to export, which it did not, so it looks...

Funny you should mention that as I had to do that a few years ago, via text files, to solve another strange problem. That difficulty may have occurred, so I was told, from the conversion of the database from an older version of Access to Access 2010. Maybe I'll have to try that again (it would...

May be but don't think so as I have had this problem b/f I added tabs to the form.

Tried that - the "[Event Procedure]" wasn't restored (unless I am misunderstanding what you want to be tried). It is however restored if the 3 dot button (what is the correct name for that button anyhow?) is clicked as in my original post.

I used to have third party code that was used to change the background color of a text or combo control when it had focus and it modified the control properties. It however seemed to cause other issues (I would get weird unexplained "Return without GoSub" (or some such) error messages at form...

Mark, I think you may be correct - it only happens at design time. I have however tab control pages now but did not in past and IIRC, the problem still popped up occasionally. I have had user(s) complain that a feature is no longer working (the problem turning out to be as discussed here) but...

I have a reoccurring problem with Text Box events seemingly randomly disappearing i.e. the "[Event Procedure]" text disappears from the control's property sheet (for a given action) but the underlying VBA remains. As a result, the specified event does not happen. To restore, all I have to do...

Hey Paul, tried it and it works as advertised but I've found that either the "Cancel = True" or the set focus statement in your example keep it to the current record (after the error message is cleared) i.e. the Cancel = True does not seem to be required. Not a problem, just an observation...

Thanks Paul, I will give that a try!

I know how to make a text box entry "required" such that one cannot exit a record until a value is entered but cannot figure out how to make it required only if another field on the form has an entry. None of the form events seem to support that when focus moves to another record as far as I...

OK, thanks.

Nope, using accdb.