Search results

Ok, I think I jumped the gun here saying it was solved.... I can only get this to work if there is only one PersonID for each Address and Company so the PersonID is a foreign key in tblAddress and tblCompany. But as my tblAddress and tblCompany can have more than one person assigned to them...

Thank you, thank you, thank you. I was using the sub form/sub report control however upon taking a closer look (after watching the video its what I needed the form to do, so it should have worked), I realised that the queries were joined on foreign keys (AddressID and CompanyID) in the...

Good afternoon everyone, I am hoping someone can help as I can't seem to find an answer - although I may not be seeing the forest for the trees and if that is the case I apologise. Anyway I have a database that at the moment contains tables - tblPeople (ID,name, email etc, also addressID and...

Thank you for that, I will have a look to see if it is something that will work for us. Thanks again.

Ah, then in that case it may not be what I am looking for. I want end users to be able to easily add multiple hyperlinks to documents that relate to information on a form. I would prefer to use a 'browse to file' box to make this easier for the end user. It also has to be hyperlinks so that...

I have the code working but I have a few questions about it, 1) I put the Event Procedure in the 'OnDoubleClick' in the event tab but the results disappear when I close the form and open it up again - how do I prevent this? 2) Only one hyperlink can be shown in the text box at one time, is...

Hi GOH, Thanks for the code, it was just what I was looking for. Just two questions about it. 1) I put the Event Procedure in the 'OnDoubleClick' in the event tab but the results disappear when I close the form and open it up again - how do I prevent this? 2) Only one hyperlink can be shown in...

That code was exactly what I was looking for. Thanks

Ok, thanks. So how would I go about setting it up for the user to add a link? Would the user type in the path to a text box? Or a bound object box? Could more than one link be displayed in the same box? Is there a way to enable users to click a 'browse' button and find the file on the server...

So can the end user add a hyperlink to a form without going into design mode?

Good afternoon everyone, I am hoping someone can help with a little issue/query I have. I have created a database for CRM purposes and it contains info about our customers and a quote log. Once customer details have been added (via a form) and a quote number has been assigned then a mail...

The separate query seems to have done the trick - thank you.

Thanks for your reply. Yes it merges to word, but I found that if I didn't do step 1 then the RunMenuCommand doesn't work. I will see if creating a separate query fixes the problem.

Good afternoon, I am hoping someone can help - or at least point me in the right direction. I have created a database for CRM purposes and need to mail merge from the database. I have created a form frmQuoteDetails based on a query qryPeopleQuotes that shows one record at a time. I have...

Hi everyone, my name is Kristin. Although I have used an Access Database in the past, I have been tasked with creating my first one and it is already a daunting thought!