Search results

I'm glad you found my suggestion helpful -- but the formula evolved down the thread, so there are a couple issues: DateSerial needs it's arguments in the order "Year-Month-Day" regardless of where you live in the world (which is partly why I used it; so your regional settings won't affect the...

Which version of Access & Excel are you using? (The wording of some errors varies by version.) When opening an Excel 2016 workbook that has cells linked to other data sources, the user is warned: If this is the prompt you're referring to, you can't bypass that from Access (or else malicious...

Image attached:

Yes, you can. :-)

You can have the date picker pop up automatically when the control is selected: ...but I don't think you can have it always displayed. (Not the built-in control anyhow.)

You want to return records where the criteria shows up in any of the fields, correct? Just add all the fields together into one long string, and use your LIKE criteria on that: strWhere =...

This should do the trick: 'the last day of the next month: [DueDate_30dEOM] : dateserial(year(dateadd("m",2,[TaxDate])),month(dateadd("m",2,[TaxDate])),1)-1 'add 2 months, find the 1st day of that month, and subtract 1 day 'the last day of the month after that [DueDate_60dEOM] ...

Hmm, I'm still a little unclear on what you need to accomplish, but I can tell you that the reason you're getting .Replacement.Font.Size = 999999 is because you're asking for the size of the replacement text before the replacement has been setup or occurred. I'm surprised it doesn't just give...

There's many potential "proper ways" to accomplish the same thing in Access, and different people will have different advice. (That can be awesome & annoying at the same time!) I figure, if it works, it's the proper way! So, one customerID could have multiple address records and multiple...

If they are simple queries with no parameters that you need to run sometimes, there's no need to bother changing anything. ("If it ain't broke, don't fix it.") However, if the reason you have so many buttons is because there are minor variations of the same queries - and perhaps you continue to...

Welcome! :cool:

might need some more info...

Thanks for the poll, ridders. One thing I would like to see (if it's not already an option I haven't found) is an instant pop-up notification when someone replies on a thread I'm subscribed to, like the pop-up for Private Messages. Also, not necessarily for the poll, but just a comment: as a...

Sure enough, Office had installed two copies of almost identical packages, next to each other, on the same day. Microsoft Office 365 ProPlus - en-us v.16.0.8201.2102 (869 MB) Microsoft Office 365 - en-us v.16.0.8201.2102 (869 MB)I uninstalled one, rebooted, uninstalled the other...

I tried re-creating the db, first by programmatically importing the objects, and again with 'Get External Data' as you suggested. I've got a couple different errors popping up (attached). I recently switched from a paid Office365 subscription to a student version (since my student account from...

I'm getting error from an Access 2016 database (running Windows 10). The error shows several times on open of the database, then most times I try run anything with VBA, and then several times on close of the database. Screenshot of the error: The database is a single copy, standalone on my...

I don't think there is a limit to the number of attributes, just a maximum of 255 per file. There can't be of "all" attributes since anyone could can make up custom attributes, like a Name:value pair.

Updated to improve efficiency, May 2018. (Been meaning to do that for a year. It's more than twice as fast as it was.) GetDetailsOf didn't change — your folder did! The attributes available to the GetDetailsOf method vary depending on the folder in which it is displayed. While Comments...

I'm glad you got it sorted out. Just out of curiosity, was it necessary for the username to be visible on the form? If not, you could have made a sub (ie, "logUser") to insert a record into a log table (one table for all forms, since the form name would be saved too) the name of the form...

Hooray, my post was mistakenly flagged for moderation due to a known bug, but Uncle Gizmo fixed it up! ...Now after all I went through to get that posted, you better use it. Hahaha totally kidding; slapping together a some code like that is just as much for my own benefit, and something to...