Recent content by LtWorf33

Currently, The ComboBox says 'unbound'. I can give you a quick synopsis of what I have and what I am trying to achieve to help give you context of how I am trying to use this. - I have the following tables: tbl_FacilityInfo: Stores basic information about the facility (address, phone number...

Hi all. I am working on a Form [frm_FacilitySelect] that has a ComboBox. The form has a TabControl, each tab showing a different subform. Each subform displays different details regarding the facility selected in the ComboBox. Is it possible to change the contents of the subform based on the...

After building my project for a while, I am coming to the realization that I am going to be viewing multiple forms but I want all of them to be formatted the same. Is it possible to build one 'unbound' form template, and then populate the form using a conditional or a query?

Unbelievable. The solution was that simple. THANK YOU. I tried that every way but that one. Sometimes it helps to just step away for minute and get another set of (more experienced) eyes.

Hopefully I can explain the context and the use case a little better. Obviously, I would love suggestions if you have a better solution. - tbl_OutlookLink is essentially a 'hidden' table. Its purpose is to monitor the inbox. - I run the UPSERT query to check for changes, and append any new...

Hi all. A new week and a new hurdle for the system I am working on. I am running an "UPSERT/UPPEND" query. I found a couple of resources that detailed the process and it is working exactly as intended. I would like to expand on this query and include a 'conditional update'. UPDATE...

The solution worked and is exactly what I was looking for. Thanks a ton for your assistance. I'm guessing I will be coming back to this forum often as I develop this system more and more. Thanks again.

Testing now. Will update.

I thought the same thing, but I haven't found that answer. I was searching for a messageID or a conversationID. After more investigating, I realized that I wasn't even able to choose which fields to link when setting up a 'monitored' table this way.

I believe I have fields that would qualify as a unique identifier. The table is linked to an Outlook folder, so the time/date received would be best suited as a unique identifier. Being a linked table I do not have the ability to specifiy the PK, and the only solutions I have seen for my problem...

The table is a 'linked table' that is linked to an Outlook folder. The properties are set and cannot be edited. And I do not see any reference to a PK in the existing properties. It's highly probably I am missing something, but thus far I have not been able to see/edit and property/field/PK in...

Thank you! I am happy to find this community and am looking forward to getting more involved. INSERT INTO tbl_VendorRequests ( email_sender, subject, date_rec, description ) SELECT tbl_UnsortedEmails.From, tbl_UnsortedEmails.[Normalized Subject], tbl_UnsortedEmails.Received...

I have a form that is viewing records of a linked database. I have a button that runs an Append Query, to add that record to a different table. The problem is that the query appends all records. I only want to it append the currently selected/viewed record. The solution seems to be to specify a...