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 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...
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...
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...
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...
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...
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.
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.