Search results

Yes, it's a similar situation here - Attachment fields are used to store copies of letters sent, observation forms, etc - they are are almost all very small 1 page word or pdf docs, but they are very important to track and report on for regulatory reasons. Beyond a few necessities for this...

Thank you, I've downloaded this, and am taking a look through now - it looks just the job! Luckily this came just in time (my contract here ends in 6 days), so I'm hoping to do something with this (the problem is still outstanding), which will save some poor temps weeks of depression-inducing...

Ah, I hadn't gathered that at all - thank you. Logical... lol Thank you for the explanations - I want to learn how and why things work, rather than just copying the code. Thanks for all your help!

Ah doing it at form level rather than field - I like that. Sounds perfect! Just to understand the code, there's an assumed "If" in that Lenght statement? Vbnullstring is covering the possibilitiy of a null field, rather than a used but deleted field? Also is setting a control to 0 the same...

I get that for an input field. But if I have a form load with 10 fields, and most will have data for each record we step through, and only want it to show for empty fields on a given record. I am presuming that Lost Focus only ever triggers for something subsequent to it gaining focus? Or is...

That's a very slick solution! I was looking at Input Masks, etc - I didn't think of a second text box... Any thoughts on what event trigger you could use for the 2nd part if you expect those fields to be filled most of the time, and just want it to be visible when they are empty?

You often see (particularly on websites) a form field with greyed out text displayed in it, that disappears when typed over - so for example you could have name/address or whatever is supposed to be typed into that field showing. I'm not looking for default text typed over or anything - a...

I'm pretty sure that attachments came about in Access 2007. I can categorically say they aren't in 2000 and they are in 2010 and 2013.

I'm an old hand at databases but very new (a few weeks) to coding. This regards an Access 2010 db, although if there are any differences in 2013 it would be useful info (but not a barrier for this problem). I have many attachments and their notes (sometimes multiple objects in a single...

That works perfectly, thank you! The perils of using Me!...

Actually.. it's not quite working? It's damn close, but not quite. What it's doing is opening the correct form, based on the student that was selected, but it's then always populating that form with the first student in the list, not the one that was actually selected. Any idea?

I was just coming back to say that your code did indeed do the trick - I just didn't understand why it did! But thank you, the explanation above is very clear. :)

I am probably being thick here... but surely that code doesn't actually test against column 2? Where does it test for a yes/no? (unless that is somehow implicit in the If...Then...Else Structure?) Shouldn't it be something like If Me.combo_NameSearch.Column(2) SomeTestSyntaxHere Then...

Hi all, As is usual here, I have a problem! In fact I have two, but we'll look at the more pressing for now. I'm not a programmer. Just for background, I've been working with Access on and off since Access 95, although until 6 months ago hadn't touched anything later than 2000. This all...