Search results

I found the problem. I redid these steps on a copy of my database, and the error came back. It's because the null value I left in the currency field on that one record. Once I replaced the null field with 0 on that record, the error resolved itself. The null value probably broke those...

I remembered I happened to have been recording a training video when this first occurred so I reviewed it. I use this query for a form. The "edit" column on my form is turned into links that open a modal window to view a single record. Private Sub Edit_Click() DoCmd.OpenForm "Invoice Modal...

Yeah, I've been meaning to fix that but at this point I already have dozens of queries and forms. Will Access update all the field references automatically? My background comes from Salesforce. In Salesforce all the tables' primary keys by default are labeled 'Id' and can't be changed; at first...

One of my queries which has always worked before now gives a "No Current Record" error. I didn't change the query. Another query which is almost identical save for the fact that it uses parameters and a WHERE statement still works. This started about an hour after I split the database into...

Well, it's definitely working somehow. The correct FK is saved to the child record every time. I've tested it dozens of times from different parent records. I had before set the FK form field's default value to "=[Forms]![Members Form]![ID]". Could it be getting the FK ID from the open args that...

Thanks for the assistance everyone. I got it working finally! My initial mistake was using the wizard to create the button I suppose. I made a new button without the wizard, set its on click event to embedded procedure, then wrote this: Private Sub New_Log_Record_Click() DoCmd.OpenForm...

This would use a datasheet view for the subform, correct? I've done that with some other subforms before. Here though, there are a few text fields on the log form where the user might need to enter a paragraph worth of text. I thought doing that might be cumbersome to view in datasheet view...

Can you elaborate please? :) Sorry, it sounds simple but I'm new to Access and I can't find where I would pass "Pass the ID in the openargs argument of the docmd.openform". I suspect this involves doing something in VBA? I'm currently reading the chapters on VBA from the Access Bible 2019 but I...

I'm trying to implement a simple communication log feature. I have two tables, Members and Logs in a one to many relationship. I want to add a button to the Members form called "Create New Log." When clicked, it opens a modal dialog window where the user can fill out the fields for the Logs...

I'm trying to write an update query that will link records between two tables depending on whether an integer value derived from one table falls between the values of two integer values from the other table. I have a Members table, and a Rates table. The Members table has DOB. The Rates table...

That's a good recommendation. I'll try to implement it soon. I was so focused on trying to get a running total going that I didn't think about that. I was trying to get a running total working as a proof of concept going first. Right now I just have a Members table and an Invoices table in a...

I took this example code from rogersaccesslibrary.com: SELECT tblOrderDetails.OrderDetailID, tblOrderDetails.OrderID, tblOrderDetails.ProductID, tblOrderDetails.Price, (SELECT Sum(Price) FROM tblOrderDetails as OD WHERE OD.OrderDetailID <=...