Search results for query: *

I have an Access DB including links to several objects - eg. pictures and soundfiles. The DB works fine until I move it or copy it because all the linked pathnames are no longer valid. I've tried inserting relative filenames (eg. "pic1.jpg" instead of "D:\Mike\MyDocs\MyDB\Pics\pic1.jpg"), but I...

This doesn't appear to be possible as when I try to insert a hyperlink in a memo form (in which I record notes of conversations, meetings, etc.), I see this option is disabled. Is there a way round this? Thanks Mike

Is it possible to set the properties of a Common Dialog Control so that the files/folders are presented alphabetically? For some reason that escapes me, every time the user uses CD controls in my projects they themselves have to order the files because there seems to be no rhyme nor reason to...

Hello I'm sure this is very simple. I'd like to include a "click here" link in my form, so that when the user clicks on my e-mail address, their Outlook (or whatever) opens a new window for them to write. Thanks Mike

I notice that I wrote my question in one font - looks like courier - but it now appears in a completely different font for the reader. And I also see a whole array of different fonts before me on these (marvellous) tek-tip pages. By the way, in my post above, I forgot to ask if somebody can...

Hello I think this is more a general discussion question, but as my particular interest is for VB apps, here goes... Can anybody direct me to a page/link advising which fonts to use or not to use in text boxes, labels, etc.? I tend to choose my fonts intuitively but I know the end results...

Thank you, Michael and Billy. This is reassuring to know :) Mike

I don't have any PCs with XP to check this out for myself. Thanks! Mike

Hi Ted I downloaded them from Microsoft's Download pages (did a search under "Speech"). I don't have the exact page to hand, but it was SAPI 5.0 or something similar. There were several options available and some awfully big files to download. I downloaded the two smallest as I'd...

Hello Where can I find examples on how to use Methods related to this control (you know, the "mouthy" one)? eg. "Gender" - I'm trying to get a female voice, but all I get is a very cryptic message "Gender (Index String) as Long" or something similar every time I...

I have a Word document and I've inserted several jpg's into it. Occasionally, on updating the document I notice that my inserted graphics have been replaced by red diagonal crosses for no apparent reason. Fortunately, I keep back-ups of my files, so no major damage is ever done, but it is...

Hello, I was wondering if any of you know of a program (preferably freeware!) that can analyse Access Databases eg. producing automatic print-outs/reports detailing relationships between queries, tables, forms, etc. If this all sounds very strange, I ask because I used to use a wonderful little...

Thanks PGK but WHAT code?! I'm a complete novice, remember! Cheers Mike

I have a table called "writers" with a list of writers (fieldname = "writer"). I have a main form called "books" which, as well as stuff like title, year, ISBN, rating, comment, etc. also has a combo box (named "author") which calls up my writers table...

I have a table called "writers" with a list of writers (fieldname = "writer"). I have a main form called "books" which, as well as stuff like title, year, ISBN, rating, comment, etc. also has a combo box (named "author") which calls up my writers table...

Actually, I think I've worked out how to do most of this. I've added an object field to my main table, I've inserted a bound picture box on my form and as I flick through my records, I insert the relevant jpg using the right button on the mouse (insert object etc.). By double-clicking on the...

I'm sorry, in my other forums I would have gone back to edit my previous message, but that doesn't seem possible here. Just to say that I've found where the problem was - I had an extra criteria in my SQL that slipped in accidentally (ID). I've removed it and everything is now working perfectly...

Dear All Many many thanks for such fast and practical advice. I'm still looking into all of the suggestions, and weighing up their pros and cons. BTW, I take the point about not being able to run away from code. I've seen how the filter by form feature works and maybe it's not so difficult...

Little Smudge "Filter by Form will do ALL that you ask for and is automatically available. No work needed" Thank you, you're right but it's far far too complicated for a 3rd party to use (or at least to assume that everybody understands how to fill in criteria fields). I need to...

I've set up a database as follows in Access to track my students. The main table is called "student" and it contains 4 fields: "Id";"name";"surname";"year" I've added a few fictional students thus...