Search results

I want a query that pulls four fields from a table, finds the maximum of those fields and appends that value as a computed field. It seems simple enough and maybe I'm complicating it but I want to do this without writing a VB function. In other words I want it to be done using only SQL and and...

I have a database with a bunch of data entry forms that are used for entering and editing records. What I want to do is use the form to also search for specific records. Specifically, I have a text box bound to an ID value (not the primary key, just a unique string), call it tbxID. What I want...

So I was working yesterday in a coffee shop with free wifi that knocks you off and forces you to log in again after an hour. Access never complained about being disconnected. While I was unknowingly disconnected I continued adding data to the database. The shared backend file is on OneDrive so...

I have a form (actually a lot of forms) with continuous subforms containing a combo box and a button. These forms support multiple selection and may grow without (practical) limit. My problem is that when the list of selected records grows larger than can be contained in the subform the...

forms!myform!field works but isn't there some way to do this relative to me. that would be simpler? I have yet to really understand what me. entails and what it does not. Hank

I think I know what I need but i don't know enough SQL to write it. I have a many to many relationship between assets and vulnerabilities (and a bunch more but one is sufficient) and a junction table assets_vulnerabilities. A vulnerability may apply to multiple assets and an asset can have...

Hello, My name is Hank Cohen, I have worked all my life in computing, compilers, real-time systems, data acquisition & signal processing, network security, security protocols, crypto devices. Over 35 years of it but never until just recently did I ever do any relational database programming...