Search results

Hi all, I have several forms which use a listbox for record navigation (in addition to forward/back buttons). The listbox works well when navigating the form via mouse & keyboard; however, some users of the form prefer to enter data via keyboard only. When tabbing into the listbox, I would...

Hi all, I solved the issue, at least partially - it wasn't actually to do with the query, it was the listbox itself not updating upon switching records. For now I've added a "TestListbox.Requery" on every command button that can change a record. ... is there a more direct way to add commands...

Hi all, So i'm having an unexpected issue getting a listbox to query data from another table. It seems like it should be straightforward? Hopefully it's just a syntax issue? So, in my main form ( PO_Creation_Form ), I have a listbox that I would like to show items from another table that are...

Hi guys, I just wanted to say thank you so much for your help. I've solved the issue now, and I feel like I've got a much better handle on how things operate in Access. As a newbie to Access and databases in general (though not coding), it's been a bit of a steep learning curve. Seems to be...

Thank you for the help. I do have a field in Contracts for [UnitOfMass], and other fields that I want to propagate. I'll look in to DLookup, and using VBA. As mentioned, I'm new to Access so it's a bit of a steep learning curve.

Thanks for your help. I've been looking into it further, and can't seem to grasp what I need to do... In this case, each product is unique, and is associated with only one order. Each order may have several products. It's a true one-to-many relationship, not a many-to-many, so the relationship...

Hi all. I'm new to Access, so apologies if this is a rather basic question... I'm building a database to handle contracts / inventory / stock etc. Each contract can contain several products, and I would like to propagate a few default values from the contract into the products. I have a table...