Recent content by MCCDOM

Yeah the bound column of cboDeviceSearch is set to 1.

Hi @arnelgp thanks for your reply. The Row Source of cboDeviceSearch is SELECT tblDevices.DeviceID, tblDevices.DeviceName FROM tblDevices ORDER BY tblDevices.DeviceName;

Hi Vald, Thank you for your response. Yeah sorry I just typed the from name like that to provide clarity of object being talked about for anybody reading. That's because I don't have anything in the Open Event of the DeviceDetails form. What should I have in this event please? Done. I...

Hi there, thank you for your replies. Sorry I missed out the part that the clickable DeviceID on frmStaffDetails was actually a subform sbfDevices. The code used for the clickable DeviceID is as follows: '------------------------------------------------------------ ' txtDeviceID_Click '...

Thanks @Pat Hartman this worked for me with trying to open the form (frmDeviceDetails) as blank but then using a unbound combobox (cboDeviceSearch) to search records and have the fields populated accordingly. However this has now broken the functionality of clicking on the DeviceID on another...

Sorry if I've caused any confusion. I will try and describe this as best as I can. The goal for the database is to keep a record of everything at work, from a list of email address, login credentials for emails, websites, cloud storage sites, etc. and many other useful bits of information like...

Base Address Alias Address email1@me.com info@me.com email1@me.com support@me.com email2@me.com info@me.com email1 has info and support as an alias The alias info@me.com has email1 and email2 as base addresses.

The Email Address and Alias Address is a many to many relationship, which is why I split them into separate tables originally and used a junction table. How would I represent this many to many relationship within the self referencing table please?

How would the self referencing table work for an alias email that has multiple main email accounts assigned to it please? For example johns@bigco.com and burtweedon@music.com is linked to the alias jsmith@bigco.com. ID EmailAddress MailboxtypeID EmailPassword ParentEmailID 1...

Thanks Minty, that is what I had envisaged from your original description. This will certainly make it easier to manage. Also thanks The_Doc_Man for your comment.

Hi Minty, Thanks for your quick response. When you say flag, do you mean like a Yes/No field for whether it's an alias or not? What if I added the record Alias to tblMailboxType that way I could use a query to filter out the alias accounts or vice versa. Or would the ParentEmailID be a more...

Hi All, Hope you're well. I've been scratching my head with this one. Basically I am trying to create a table that will store the login credentials for the different cloud storage accounts (tblCloudStorages). The username for the Cloud Storage will be an email address but it could either be an...

Sorry for the late reply but thank you Pat, your last suggestion has worked perfectly!

Thank you Pat, I will give that a try and report back.

Hi both, thank you for your suggestions. To clarify I would like the search to return all results of active mailboxes that were created on or before the search date specified. This would include mailboxes created years ago. This search function is working however. It's trying to get the search...