Search results

I should add that I'm intentionally limiting this to one employee and one SOP; but we have a couple hundred employees and several dozen SOPs. I figure I should be able to start with that and generalize to all employees and all SOPs afterward. Though I'm happy to take other suggestions...

tblMasterListControlledDocs ctrldocID Document Number Revision Document/Revision Date Document Description 5311 SOP-011 07 11/12/2020 SOP Packaging and Assembly 5307 SOP-011 06 11/2/2020 SOP Packaging and Assembly 5305 SOP-011 05 8/28/2020 SOP Packaging and Assembly 5206...

Hi all, Sorry for the lack of a descriptive title. I'm trying to associate revision levels of SOPs with historical training records (ie, someone trained on SOP-001 on 1/1/2020 was trained to Revision 3, because Revision 3 is dated 12/31/2020, and Revision 4 is dated 1/2/2020). So I need to...

Got it, thanks!

Can you elaborate? I'm confused here. I've also seen (elsewhere) the suggestion to just split the grid into multiple squares and use the empty split cells as pseudo-margins for the checkbox--is that what you're doing?

Yes! My issue has been that if I try to position the checkbox in the Layout it snaps into that particular square of the layout. It looks like you have avoided this somehow? How did you pull this off? Definitely good enough for my use case...

Was just reading through Allen Browne's thoughts on WingDings and checkboxes in general too. Thanks for the ideas! I'll admit, the amount of time I spend adding functionality in our database versus the time spent finagling Access's weird limitations is... unfortunate. I mean, Access is...

A checkbox in a typical layout just looks nasty: Or so it does to me, I don't like the upper left alignment of the checkbox. Below, we see what I did to alleviate this: On the left of the checkbox is one tabular layout, on the right is another. The checkbox itself is not in a layout: That's...

Exactly, I'm just trying to find out what property of the that largest control I can use to index my rectangle from. My understanding is that padding = distance from other controls, margin = distance from the control content to control border. However... the gridlines are (or appear to be)...

Hello all, I've been so impressed with all the assistance you kind folks have offered me over the last couple weeks, so I'm back with another question. I have a form set up for data entry, continuous form with a header. One of the fields is a Yes/No checkbox. As I'm sure you've all seen...

ha, thanks, and no apologies needed, I am indeed very new. The funny thing is that as I get better at database development, I end up spending more time, not less, on stuff that isn't 100% necessary for the brief because I'm learning what's possible, so some of the stuff that I would just...

It's funny you mention that. I just spent a half hour learning some of the ins and outs of those differences. For potential future readers: If you execute a query with the Currentdb.Execute method, the query is processed literally, and any parameters it contains won't be evaluated. This throws...

@gemma-the-husky , thanks for looking man, I've been checking elsewhere too but can't find anything... That said, I know we have people with a WEALTH of knowledge here that I trust more than my googling abilities. If you ever come up with anything, do let us know! @MajP Thanks for the heads up...

Thanks, @The_Doc_Man --this is a good framework and like you say, leaves a lot of opportunity for customization. I'm very new to VBA so very much still learning, but this gives me enough to work off of. Much appreciated.

If it can be done in code, I'm all ears--though there's no popup with an error code after cancellation visible to the end user. Any idea where I could find out?

Thanks for the ideas--mostly I was just curious if there was an event I was unaware of that I could get to fire without having to go that route. Sounds like there isn't? I like the idea of a secondary check for query execution more than the RYO warning approach (seems like slightly less work?)...

Hello all, I have a command button that's used to trigger a macro that opens an "insert" query. However, it's possible for the user to click the button, then hit the cancel option on the default warning that appears when executing this type of query. I like the warning behavior, so I don't...

A million thanks, Pat, once again! Beautiful explanation of the advantages of validation in the BeforeUpdate event of the form. My issue now seems to be that when I prompt the user to enter a complete date (and you might have gotten at this when you reference how a control can be "dirtied" ...

Thanks for the elucidating response, Pat! You've been helping me all day... And yes, while I get that 2/24/202 is a valid date, Microsoft makes some other assumptions in their in-built validation, like assuming that 2-digit years are referring to the 20 or 21st century. As a result, I was...

To help me understand a little better: My form is using a query, not a table, as the recordsource. I get that forms don't hold data, that tables do. What do you use to identify uniqueness in the recordset resulting from the query?