Search results

Typical - no sooner did i post the question then i get the Combo Box to update using a solution i am sure i had already tried!! I now however have another problem with this, when i select the new customer from the combo box, some of the information on the form should change to this customers...

Hi, Can anybody help me please, i suspect that this problem has a simple answer but a search on the forum didn't really answer it. I have developed a Database for my brother who runs his own business. Within this database he has a number of Tables including one for maintaining / recording his...

Shouldn't it be: =format(Now(),"ww")

Dan, Will have to check, don't have the particular database with me at the moment. Will let you know what happens. Many Thanks Alan

i accept that the code provided in previous replies is correct since i tried it in a different database and it worked fine!! I will have to have a good look at the first database i used the coding in. In the meantime, many thanks to everybody who took the time and trouble to offer advice -...

Nope - not a square bracket to be seen anywhere? I know it can be done since i have seen it on other databases and while it doesn't make that much difference it looks better without the [...] - any further suggestions / help appreciated. Alan

Thanks for your response, however that doesn't update as i go through the records. I added similar code to the forms OnCurrent event which although it updates the caption as i navigate through the records it shows the information in square brackets i.e. [ABC Company Ltd]. Any ideas on how to...

Have been trying to make the caption at the top of my forms to display information from the data being displayed in the form i.e. Company name and point of contact. In this instance it could read "ABC Company - John Smith". I searched for a similar thread and come across an answer to a similar...

Idris, I achieved this using the following - bring up the report properties, locate the entry entitled 'Picture' and click in the space next to it. Navigate to where the logo is on your hard drive and 'add it'. Next line down in the Report properties is an entry called 'Picture Type'. Click...

Hi, I currently use Bullguard V6 which is ok as an anti-virus / firewall package but it is due for renewal soon and i am thinking of replacing it with an Internet Security Suite, preferably one with built anti-spyware. Any recommendations? Any to avoid - already discounted Nortons through...