Search results

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...

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 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...

I ran into a data mismatch error and for some reason, I just can't seem to find where it is. I "think" I've narrowed it down to one column in one table, and it's a date entry. So... Here is the function that keeps bugging out on me: Public Function IssueRewards() Dim IssueSQL As String...

Hi there! I have a report that uses three separate tables for data. I have the data separated into three queries. Goal: For the MemberID selected, I want a section for Purchases and a separate section for Rewards. I can do it with subreports, but I'm not sure if it's possible with one, single...

This SHOULD be a no-brainer, but for some reason it's not working for me. I had it working shortly, then I changed the query and it stopped working. So I changed the query back and it's still not working, so there's obviously something else going on that I'm missing. Another set of eyes would...

I have a form that serves as the central "hub" for my database. It's called frmRewards. Sometimes (when opening from Reports) I want the form to open to a specific record. Other times, I want it to open to a new record. The main issue lies within record navigation after I open the form using...

Hey there! I have a form: To the right of the form under PURCHASES is a subform which consists of a very simple datasheet that allows users to enter purchases. The issue I'm having is more a data coherency issue than any major database-breaking problem. As you can see when you want to...

I have a form (frmRewards) that has a listbox (lstCustomers) which is used to select customers from a list. When you double-click the customer's name, the rest of the form is populated (no subforms). When I delete the record, I get the infamous #Deleted issue in the listbox. I've tried a...

Hey all! @plog has done some amazing work helping me fumble through this SQL mess. Now that he's solved the most pressing issues with my queries, I was hoping I could nab some help with trying to nest them all into one query I can call on demand. Spending roughly ten minutes on this I got...

Hi there! First off, I'm a long-time reader but first time account-creator and poster. So, hi! I have a query I'm struggling to create. I need to SELECT and COUNT records from tbPurchases where tbPurchases.PurchaseDate is > Last(tblRewards.IssueDate) WHERE CustomerID = tbPurchases.MemberID...