Search results

Thanks for that I'll be taking a look at the relevent structures as it will help. Whats the best method for putting this in to practise using forms in Access to get the relevent parties on to the 'project sheet'? I'm thinking that I may need to do some sort of basic search to find the...

I have a few tables now with business's, contacts and employee's. I want to set up some 'project sheets' for a few little projects we have. I'm not sure the best way to put this together or the correct terminology so I can investigate further. I want to set up a project table with basic...

Realised where I was going wrong! All sorted now. In case anyone wonders my code is below and if you wish I'll happily accept any comments on improving it! Dim strContID1 As String Dim strBusID As String Dim strContID As String Dim wdApp As New Word.Application Dim wdMMDoc As Word.Document...

I have a simple Form with a sub form linked in. The main form has a business name visable and hidden the business ID (which is also the primary Key). The sub form Lists the relevent contacts to that business. The form its self works fine, its a datasheet in datasheet view but edit / deletes...

Thanks, I changed over the settings then on the form used a query to lookup the relevent list for the combo box. Thats solved it!

I've setup a business database for companies we deal with, using Access 2010 I will eventually put the 'database' on a SQL server and use forms to access it from a users perspective. As part of adding the business types I want to make sure that when someone enters the data in the field they...

So, I've had a play! Still not got anywhere so I thought that adding the business name to the contacts table may help... Which is kind of did but the link for the ID number does not come through? I'm completely confused now. This is part of what will be a bigger DB for clients too but...

On a thought... am I doing this completely wrong? If I'm entering the data for a business, then saving. should I be using a SQL Query to use the 'businessname' just entered and on screen then call up a new form for client entry? Where the form searchs then opens the business in an 'read-only'...

Thanks for the replies. John, Thanks for the example, I've tried to pull it through in to my DB and I had a few issues coding is sadly not my strong point as I can do a bit of VBA in excel and word from recorded macro's but thats about it. Still I looked up your code and got some more idea's...

I'm new to Access 2010 and creating a business contact DB so eventually people can merge letters from it. I've started by putting a data input form together and various forms to update which all work fine. The next part I'm struggling with though, When I create a new business I then want to...