Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Chris121

    Referential Integrity Requiirements?

    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...
  2. Chris121

    Referential Integrity Requiirements?

    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]...
  3. Chris121

    Fonts inside rar, inside .zip

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

    Fonts inside rar, inside .zip

    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...
  5. Chris121

    Fonts inside rar, inside .zip

    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...
  6. Chris121

    Date/Time format for number of years

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

    Date/Time format for number of years

    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...
  8. Chris121

    Date/Time format for number of years

    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]))
  9. Chris121

    Date/Time format for number of years

    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...
  10. Chris121

    550-Verification failed

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

    550-Verification failed

    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...
  12. Chris121

    550-Verification failed

    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...
  13. Chris121

    550-Verification failed

    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...
  14. Chris121

    very general office question

    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...
  15. Chris121

    very general office question

    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...
  16. Chris121

    very general office question

    Hi A friend of mine is starting up a consultancy business and has asked for my help in setting up a PC based system to keep records, print invoices & financial statements etc. It will be just him for the forseeable future, so nothing to big or clever reqd. My first notion, is to build an...
  17. Chris121

    Can unread messages in subfolders show on parent folder?

    Hi I'm using Outlook 2000 (Not on exchange server) and have lots of sub-folders under my inbox. Rules have been set up to filter incoming mail into various sub-folders. Presently, unread messages are indicated by the blue figure in brackets next to each individual folder, but if the inbox...
  18. Chris121

    Auto date entry in Excel - how?

    Thanks Skip I expect it's part of the software - a database called FCL. It must be written into the coding to handle dates that way. Surely a funcion or macro could make excel do it? Christine.
  19. Chris121

    Auto date entry in Excel - how?

    Hi At work we have a uniix database but I access it with Multiview Software on my desktop PC. In the unix database, it has this really handy feature for filling in date fields quickly. You just enter the date, hit return and you get a dd/mm/yy in the field which autofills /current...
  20. Chris121

    subform from 1:1 related table

    ok Folks - I've got it sussed now. Having both primary keys as auto-number fields is a no-no I changed the [delays] key to number, instead of autonumber and all is well. Thanks anyway. Chris.

Part and Inventory Search

Back
Top