Search results

I'm not sure a list box is the correct method. If using a subform, just choose datasheet or continuous forms, and use the link Master and Child fields in the subform's properties.

None of this would be necessary if using link Master and Child fields in the subform properties. Look on the Data tab. But...if you insist on using search for record (not necessary) The macro builder helps you by suggesting field names when you begin typing. I would just double click those...

That is handled by queries and reports. A query can be designed to gather the data you want, sort, group, sum, etc, and output to Excel, where it could then be formatted as desired. Crucial will be collecting and storing it in the right format, as described above. These queries will not work...

Use this expression as the source for txtTotalReceived: =IIf([PurchaseOrderID]>0,DSum("QuantityReceived","Purchase Order Details","[PurchaseOrderID]=" & [PurchaseOrderID]),"") (y)

I'm trying to write an expression in place of the existing calculated field. But, your PurchaseOrderID is displaying as Purchase Order ID in some places which is causing a lot of confusion when switching views and writing the expression... By the way, your Purchase Order Details has no primary...

I don't think the calculated field is the problem = I changed your code to refer to the subform field directly and it still didn't work.

If I change the > 0 to = 0, the button is disabled. This is evidence that the value isn't what we think it is.

My $0.02 is that this would be easier with two command buttons, but I understand wanting to consolidate them. Actually, it could probably still be done with just one command button. Worth a try...

Check it again. If you open an order that has all 1s, the caption is not displaying properly because it is based not on the total quantity, but on whether or not the button has been pressed. I'll keep thinking about this but for now my gut tells me there is other code conflicting with your...

I just stepped through the code and it appears you have an infinite loop here?

You could make it so that the caption of the toggle button is based on your subform footer count, but that doesn't appear how it is currently set up. It appears that the caption is based on whether or not the button is pressed (true or false). Here is the current code for the toggle button...

I just had a look at your database. First, this is a toggle button and not a command button, so that might change how people reading this understand the problem. Now, what I'm seeing is the button displaying "Set to Received in Full". Pressing it sets all items Quantity Received in the subform...

Yeah: the code needs to be run in the Current event of the subform. I don't believe a requery or refresh is needed for enable/disable of controls.

Don't use DLookup in queries.

Thanks for pushing me to test my solution (y):coffee:

This should work.

Hmm, well I'm getting Macro Single Step Error 2001. So I guess you're right. Best policy may be to ensure the location is trusted. In my case, my .bat file copies the front end from the server to a local folder on C:, and we don't see the yellow bar. This code is really just a back up policy...

So you need an Access Report with its recordsource set to a query that contains the Files table and the Users table. Add the repeating (many side of one-to-many relationship) fields to the detail section Format the fields as Hyperlinks Put the User name or User ID in the Report Header Open...

It hides no matter what. First line of AutoExec macro is RunCode, HideRibbon() <- public function Second line is to check if the DB is trusted, then either load one form if trusted, or load another if not. So by the time it's checking, the DB window is already streamlined with no ribbon...

If you do not need to retain the original table, you could just delete the table and let Access create a new one with the import. It's decent at picking data types, in my experience, if your Excel file was set up correctly (no numbers formatted as text, please!)