Search results

It's actually just a text box with the Control source as a field in the query... So I didn't change anything and it somehow started working. I did close and reopen it, not sure if that did it. But I came across another problem. The dropdown on the main form gives me dates when orders were...

The DateValue() function does work in regards to pulling the dates on the main form. My issue is that for any records in the table that have the time stamp attached (all will, any that don't was just me testing), the subform will not pull up any records. The form comes up blank despite there...

Good afternoon everyone, So I'm having an issue with a subform populating records. I want it to populate all the orders for whichever date is selected on the main form. However, it doesn't pull up all of the records. I've been able to deduce that it's the format of the date. I have the date...

... Wow... :banghead: Thanks!

So I'm a bit baffled and hoping that I can get some help. Issue is that I'm able to get cascading comboboxes to work in 1 form but not on another, despite using the same vb. After selecting a Factor (name), only the Lot Numbers associated with that Factor name should show up. I've attached...

Thanks a lot pbaldy. I was hoping you could explain what exactly that little bit of code does. That way I actually understand it, and know why I'm doing it. ExitHandler: Set rs = Nothing Set db = Nothing Exit Sub Thanks!

So there's no more 2501 error pop-up. But now there is a blank pop-up that comes up even when I do have a report available. I've attached a pic so you know what I mean. And here's the code on the button to get the report: Private Sub btnReport_Click() On Error GoTo ErrorHandler...

Wow..... :banghead: Thanks pbaldy!

So I've searched and tried different codes to prevent this error from popping up. I was able to get the pop-up msg to display, but then I keep getting 2501. Basically: I have a report that I call upon via a form that is used by a query to populate the report. On the report NoData Event...

Thanks for the replies. I have a forms page setup as the main page; kind of like a switchboard for them to pick what they want to do. I can believe it. Just so I get this right; Disable 'Show Nav Pane' Disable 'Use Access Special Keys' Disable 'Allow Full Menus' Then convert to ACCDE Then...

So (I think) I finally finished a db I was working on during my internship. First, thank you to this site (and it's "sister-site") as well as those who have directly answered my noob questions. Appreciate the help. Secondly, I was wondering how I would go about making it... "user-friendly?"...

Thanks almahmood! This worked for me.

So I'm trying to create a query to show me today's transactions. I thought it would be as easy as =Date() Alas, I'm here... So I'm thinking it's because I have date and time in the field. And it's captured by Now() in some forms. How can I go about getting today's records. Thanks in advance.

Thanks for your response pbaldy. It has the FactorName only. I had tried to select 2 fields (FactorName & FactorID) since it's going into a table that requires FactorID and not FactorName. However, it wouldn't GROUP BY since SELECT DISTINCT had too many columns. It turns out that that's...

So I've been trying to get a "simple" cascading combo box to work but I can't seem to get it correct. The first combobox lists the fields correctly, but the second combobox comes up blank. There is information in each field within the table (tblFactors). Basically, I want to be able to pick...

Added the TransactionTypesAction field and used your code: SELECT FactorsID, SUM(OrderAmount * TransTypeAction) AS Inventory FROM tblOrders INNER JOIN tblTransactionTypes ON ID_TransactionType = TransactionTypesID GROUP BY FactorsID; ... and kept getting "JOIN expression not supported,"...

Good point. Changed. I've attached a screenshot of my tblTransactions. I'm doing something similar with the 1 and -1. However, I'm calculating it in separate queries, combining them, then adding them together. I've attached a screenshot. But maybe your way is more efficient. Or maybe my way...

The one with the adjusted FK names and fewer tables is the newer one. I included both to ensure I was headed in the right direction. Thanks.

I think I may do this. It would alleviate some issues I'm having with forms and (cascading) comboboxes. Interesting. I guess I'd have to use a subform in most of my forms with this layout. And I'm curious about "MedRec." Thanks for your reply. I was wondering about tblTransactions. I have...

I'm interning at a place where they receive certain medications and then send it out to be administered to people. The database is meant to keep a running balance of each medication. It will also keep records of what was received/dispensed, to whom it was given, and when it was received/given...