Search results

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...

Hi Pat, thank you for your suggestion but unfortunately it hasn't worked. Whenever I run a search now it comes back with the message 'No mailboxes were added upto the 16/06/2019'. Currently what the search does is it returns all active mailboxes and deleted ones if the search date (txtMonthEnd)...

Hi All, I'd like to refine this criteria even more. At the moment it won't show a record who's DateDeleted is more than or equal to the specified End Date. What I'd like to know is how do I get a record to show that has a DateDeleted value more than or equal to the end date but was deleted...

Thanks Bob Fitz that's helped a lot.

Hi Bob Fitz thanks for your reply. Here is the SQL for the querySELECT tblBreakdown.BreakdownID, tblBreakdown.MailboxID, tblBreakdown.OfficeID, tblBreakdown.StaffID, tblOffices.DeptNominalCode, tblStaff.StaffName, tblBreakdown.DateAdded, tblMailbox.Cost, tblMailbox.[Mailbox Type]...

Hi There, I am trying to create a query that shows the records that fall within the month of a specified date. For example if I selected the date 10th May 2017 in my date picker text box txtMonth how can I get the query to return any matching record with a date in May please. I have tried the...