Search results

Thanks for pointing that out. The links got garbled in the copy paste. I didn't realize the image had its own, separate, unusual unusable link. One of these days I'll get the hang of this internet thing.

The recording of Tom van Stiphout and Kim Young's presentation to the Access Pacific Chapter of AUG is now available on YouTube, at the AUG Channel. Tom and Kim draw on decades of experience creating and troubling-shooting Access applications. Learn what you should be doing to avoid problems...

I hold to the opposite view regarding hiding and showing controls. If a control is irrelevant, i.e. it is intended only for certain roles like an admin or supervisor, it should just be hidden, of course. That's not what we're talking about here, though. I see no value to displaying a big empty...

I like to use the Enter event of the subform control. If the parent form is a new record, which means it is dirty, but hasn't yet been saved, I inform the user the main form must be completed and the data validated before anything can be added to the subform and set focus to one of the other...

Yes, this is exactly the kind of application Access handles well. It's not clear, unfortunately, what you mean by " the customer wants to enter supply requests but doesn't want to go through the same process of selecting the items again." Can you clarify? In English, preferably. You might...

shl.sendkeys "^{F4}" mimics the action of pressing the ctrl and F4 keys simultaneously. It closes an open Window. The risk of using SendKeys is that it doesn't necessarily impact the object you expect or want it to. It's probably wiser to find and alternative way that does identify the proper...

And vice versa.

Cleaned up the old links. They were supposed to redirect, but some of them were failing to do so.

Maria has heard back from the Access team at Microsoft. They have added this to their list of items to be investigated.

I looked up joke on Wikipedia. Yup, it definitely applies to post #7.

Maria responded to your question: So, thanks for reporting this and for being patient.

"Record" is the field name you are trying to use here? Why use a name that has other, very precise meaning in databases? Why not use a name that reflects what the table stores, "DeletedTenant", or if you want to include the word Record, "DeletedTenantRecord"? I don't think "Record" itself is a...

What Dave asked about is the relationship Grandfather-->Son-->Grandson, not just Father --> Son. You do not need a separate way to relate Grandfather to Grandson. The way this is often done is a Self-Join in a single table, in fact. Without seeing sample data, and relying only the XML...

I like the Word option because I think you can do fancier formatting, but basic reports, invoices, certificates without fancy scrollwork and so on are great in Access.

Ah, thanks for the prod. I know that UA has problems with older links. Time for a house-cleaning.

Thanks for clarifying it's Mail Merge, not just merge. I guess the original intent would have been merging information into letters that could be mailed, although I tend to think of it as merging data into any boilerplate template. One of my clients created equipment certificates for their...

Thank you for clarifying. " I'm seeking for application that build with Microsoft access..." I guess when someone asks for information on using Access, that is a fairly strong indication that person is interested primarily in Access. Why would someone assume the opposite to be true?

Word templates are a standard feature. Search for "Word template". They can be used with Merge from Access to populate the variable elements.

Good on Gasman for asking. Sometimes we can be reluctant to ask the questions that we think "everyone should know".

I'm not quite sure I catch your drift here. What are you trying to suggest? Thanks for clarifying.