Search results

Thanks for that John. I did suspect that that would be a possible solution although I really don't want to go down that route as I'm new to VBA and we need a quick result (by 31st March!). The data I've posted is the least of it, since we need to include multiple customer records with multiple...

Can Access produce an XML file similar to the following example? <Company> <registrationNo>178560</registrationNo> <tradingName>Widgets Ltd</tradingName> <SICCodeList> <SICCode>55.50</SICCode> <SICCode>55.60</SICCode> <SICCode>55.70</SICCode> </SICCodeList> </Company> where 'Company'...

Thanks for that. Work is extremely hectic at the mo with a website going live so I'll post it up when Ive got a spare min. Surfer

How about having a listbox (underneath the Address combo box) that has its Source as a query. This query can then concatenate your address fields together (add a new field after the AddressID, in the query with something like: [tblCompany].[Add1]+Chr$(13)+Chr(10) & [tblCompany].[Add2] AS...

In your button click event are you using the ContactID in the Link criteria when opening the Contact Form? eg: stLinkCriteria = "[ContactID]=" & Me![ContactID] stDocName = "frmContactDetails" DoCmd.OpenForm stDocName, , , stLinkCriteria It sounds like you want to be adding a field to your...

Marcus, Is there any way of pre-populating the spreadsheet by putting in the PersonID on every line? Otherwise, I guess you have to use a record set in VB and write in the value of the last PersonID read.

Andy, Im not sure I understand your question.. is this a one-off exercise?

Goh, I guess you mean your subform A has the Link to the main form and not the tab control? As I dont think you can link a tab control to anything. But I see what you mean. I have a slight difference in that I have a separate subform on the main form that controls which 'Client's Category' to...

mmm.. depends what you are wanting to achieve Brad. What do you mean when you say "so I find a Contact on the Contact form"? Do you have a form where you can search for a Contact (by name maybe)? In which case you probably just want to have cascading combo boxes for Company and Address (plenty...

by default, (as far as I know) when you click or tab out of a new record Access automatically adds the record to the table, so you shouldn't need to close and reopen the form. What is the form's Record Source?

Brad, It sounds like you need to sort out your DB relationships first. You possibly want Contacts to have a Foreigh Key to Addresses (ie: have the AddressID on the Contacts table), and then have the Addresses table with the Company ID. That would mean you can use subforms on the Company form for...

I have a main form with Client details on. There is a subform that lists 'Categories' that a client belongs to. (This is a continuous form listing records in a ClientCat table) Beneath that, is a tab control with other subforms on. 2 of which are linked (via Link Child/Master properties) to the...

No, unfortunately not :( but today the main user said he is happy with not having the contact details displayed as I gave him a double click event that take them to those :rolleyes: thanks anyways.

Kevin, thats very kind of you. I have some major deadlines at the mo so I'll try to get a cutdown version as soon as poss. Thanks

thanks for the reply Kevin. Unfortunately I haven't been clear about what I wanted. This is what I want: <Company name> <Primary Contact name> <Contract Date1> <Contract Date2> .. <Company name> <Primary Contact name> <Contract Date1> <Contract Date2> .. <Company name> <Primary Contact name>...

btw, the Contact I want to display on the form is just one record (the 'Primary' contact) for a company, and there is only one primary contact per company. Using the following query as the row source for Contact, I get the same name appearing on every company record: SELECT...

I want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view. However, the problem is that they want to also see on the same form Contact details (Name & Tel.no). This is a one to many relationship with the underlying query so I cannot build...

Try this: SELECT tblTable1.MyDate FROM tblTable1 WHERE (((Year([MyDate]))=Year(Date()))); The Year function extracts the year part from the field in question and then its matched with Year function that pulls the year from Todays date. HTH