Well, I'm an idiot. lol...
My query qryAuctionList, I forgot to tick the checkbox to have DateListed displayed. oops.
Pasting the SQL statement into a query editor showed me the "way". Thanks all! And @Gasman - anytime buddy!
I have a couple procedures I use throughout several of my databases to filter a listbox based on the value in a textbox. I stole these ideas from someone, and honestly can't remember who (so if you're here, thanks and sorry!).
I've tried to determine where the error is coming from, but I'm...
If I wanted to put my/your function somewhere else, perhaps on On_Open or On_Current? I don't want to call the procedure too often, because I'm sure it'll cause several other problems. Is there a better method to accomplish the hiding of the "bit's n' piece's" of Access so the user is...
Tinkering around with your modNavPaneTaskbar, I'm having the exact same problem on my forms. One will hide the nav pane, then the next form displays it.
I just exchanged my function with your HideNavigationPane() function, and put HideNavigationPane in where I had FormStartup().
I'll take a quick look at your example and try to model mine on yours. I tried putting DoEvents in, and I got the same error stating GoToRecord isn't available right now.
Adding "DoEvents()" after Call FormStartUp gives me a compile error: Expected: =
Never used DoEvents(), googled it, and still not entirely sure what it does outside of "pausing" the processes for Windows to "catch up", so-to-speak.
I would LOVE a better method to hiding the navigation pane...
This is NOT my startup form. That form seems to be working just fine. The navigation pane isn't needed for the end-user, so no, I don't really have to keep calling the code over and over again. But right now, no matter if the code is there or not, the nav pane shows up when I open this form...
I have a procedure I created (let's be real, it's stupid simple...) and call each time a form is loaded. But I'm having an issue with one specific form and getting it to work correctly.
Here's the procedure:
Public Function FormStartUp()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand...
I *think* that might just do what I need it to. Unfortunately I have to cut out of work (wife's birthday) so I won't know for sure until tomorrow. Thanks a million, @arnelgp
Attached is a VERY stripped down database with the data and queries in question.
Looking at sqryCalc2, there are six different entries under MemberID 24877. Currently it counts all of these as individual [DatePurchase]'s. as a distinct entry. It should count these as FIVE, and not SIX.
Here...
How does that fit into my queries, though? I've tried DateValue and I get a data mismatch error. That leads me to believe it's counting before it's converting.
SELECT sqryCalc1.ID, Count(sqryCalc2.MemberID) AS NumPurchases, Sum(Nz([DailyPurchaseTotal],0)) AS SumOfPurchaseAmount...
I have a query where I'm trying to read only the short date out of a table's "PurchaseDate" column (which is formatted as short date, but includes the time when input from a form) and count those unique short dates.
Details:
I have a database that tracks customer rewards. When a customer comes...
Moving down your list:
1) The different uses of Dateserial/Now/Date were all troubleshooting from ages ago. I'll give your suggestions to whirl to see if they work.
2) FormatDateValue puts out today's Small Date (7/27/2020) so it too could probably just be Date.
After trying a couple of your...