Recent content by Chris121

Thanks for the advice Duane, Les I guess I should have mentioned - (gulp!).... I actually did this database a year ago. It came back to me with 1500 records in [customers] and 1466 records in [servicing]. I filled in some data in the missing [servicing] records and got back to 1500 in both...

Hello, I have designed an Access Database for my friends heating business. I have just 2 tables [customers] and [servicing]. Both have numerical ID's for each record. [customers].ID is autonumber and [servicing].ID is number. The ID in each case is the tables primary key. The [servicing]...

Thanks Doing a search for .zip in the root folder separated all .zips then as you said. Thanks again.

Thanks guys and I wish it were that easy. Each font group is inside a .rar archive folder. Each .rar and the associated info files are inside a .zip The .zip is inside a normal folder named with the font name. I cant select all .zip's or .rar's if I can only see a long list of normal...

Hello I have quite a number of fonts in .rar folders that are inside .zip folders, that are inside folders with the font name. I have extracted some manually, but with hundredds more to do, I wondered if there is some other method to extract all of the font files in one move? I don't need them...

Spot-on Perfect! Thanks Ken - have another star - you are one!! ;-) Chris.

Thanks again Ken - no more #Error! however, it's not working quite as I wanted. Pasting your formula above gave me a "to many parenthesis error" but I deleted a bracket and it works!! Only thing is, where there was a null in [years covered], I wanted the new date field to be empty but now it...

Hi Again Almost got it working with formula below. If there is a date in the [Years Covered] it works fine, but if that field is empty, I get #Error as the result. Any Ideas? Expr1: IIf([Customers]![Years Covered]=Null,Null,DateAdd("yyyy",[Customers]![Years Covered],[Customers]![ANN DATE]))

Hi When designing a table with a field that will contain a whole number between 1 and 5 for the number of years insurance cover bought with new purchase... How should that field be formatted so queries can be run and that nuber of years can be simply added to an install date (standard format of...

Inoticed an option in cpanel called MX entry - but it is set as I would expect - to inovo.tv

Thanks again folks, but I'm afraid I'm still none the wiser! Here is a copy of the bounce error message - I substituted *s for the actual address: Date: Fri, 04 Nov 2005 04:33:33 -0600 [10:33:33 GMT] From: Mail Delivery System <Mailer-Daemon@cpanel.ev1servers.net> To...

Hello Kordaff and thanks for the response and effort. The form does send mail to @inovo.tv or to msn, gmail or yahoo. However, it won't send to the customer or to my @ntlworld.com address. I'm afraid you lost me in your last sentance begining A dig mx?? Can you clarify? If it helps...

Hello People I am a disabled ex-serviceman here in the UK trying to eek a new living as a web design / hosting agent. I am using www.isphost.org and it's really cheap, yet has been working fine until this issue came up. Using cpanel, I added an account for a new domain - inovo.tv The website...

Hello Again folks Having given the issue some thought, I decided to look into an off-the-shelf solution - taking Skip's suggestion on board, but came across the following... Important notice for Quicken Users: Intuit UK has made a difficult business decision to discontinue future development...

He's a complete Novice with all things computer related. I'm a bit beyond a beginer with Access and XL. I'd like to keep it as simple as possible, so a pure XL solution seems favourite. However I don't know how to do autonumber in XL for unique invoice numbering and jobnumbering - its...