Nice people thread part 7 - a thread in its prime

Nikkster

I returned to lodger land this evening. Really should have made up my bed sooner rather than when I wanted to get into it.

The loo roll I left was all used up. I did take advice and leave my towels out (now changed)

Doozergirl

Blimey you lot have been busy!

Does anyone know how to create an Access database? I used to be able to do it 10 years ago and I can't even get my excel spreadsheet to import into it now. Clearly I have no idea anymore at all, and I was even trying to be clever linking the tables.

I'm taking the information of planning applications off of the t'internet planning portal. I'm listing the a) applicant and their details b) details specific to their application and c) their architect if there is one. I guess I could just have a one table and use excel without problem as the people I'm looking for are highly unlikely to put in more than one application. I just thought it might be more posh in a database that maybe I could turn into a bit of a CRM that logs me contacting them? Or should I just use a CRM?

Am I talking rubbish?

What I thought would be a list of a few target developments has turned into a list of 53 definite possibilities and I still have a list of another 60 odd to work through and decide if I like them. Feeling tired. H being on "holiday" results in me having more time to do work. Oh, the irony!

zagubov

lostinrates wrote: »

Oh and I am 68% tight. Though many of the questions are not relevant.

(and I would not skip my round, far from it, and some things I consider sensible and Eco not just tight...like using everything in the packet, ) putting cheap stuff in expensive bottles is not tight it's a waste of time. I put some things in plain bottles , because I dislike branded crud, not because I am embarrassed or dishonest about it.

There's an old story of somebody who told a toothpaste company he could increase their sales for a large sum of cash. He wideened the necks of the tube.

I've noticed versions of this trick elsewhere. Unbranded cheap stuff is often sold in wide-necked bottles so you use it up so much faster than the branded stuff so you go back to shell out more cash sooner. So I'd be quite content to decant stuff from one bottle to another.

Greetings from north of the border by the way. I waved at doozer,lj, johnny, stevie and allthess's. but in the driving rain I doubt anyone saw me. It was a miserable but mercifully swift journey. Why though is the M6 southbound always a multi-mile traffic jam north of Brum?

New car managed it on one tank. Beginning to see the good side of the new car!

PasturesNew

Doozergirl wrote: »

Does anyone know how to create an Access database?

Yes, but no. It'll be different on whatever system you've got to what I would tell you to do, from memory, from Access 97

Doozergirl wrote: »

I'm taking the information of planning applications off of the t'internet planning portal. I'm listing the a) applicant and their details b) details specific to their application and c) their architect if there is one. I guess I could just have a one table and use excel without problem as the people I'm looking for are highly unlikely to put in more than one application. I just thought it might be more posh in a database that maybe I could turn into a bit of a CRM that logs me contacting them? Or should I just use a CRM?

Or you could just use Word
There's a feature in there to input data into a simple form.... and you can do your mail merge from that.

Doozergirl wrote: »

What I thought would be a list of a few target developments has turned into a list of 53 definite possibilities and I still have a list of another 60 odd to work through and decide if I like them. Feeling tired. H being on "holiday" results in me having more time to do work. Oh, the irony!

I started to write out the db structure, then deleted it and thought "why try to help when you don't even have the software ..."

Doozergirl

PasturesNew wrote: »

Yes, but no. It'll be different on whatever system you've got to what I would tell you to do, from memory, from Access 97

I started to write out the db structure, then deleted it and thought "why try to help when you don't even have the software ..."

Aww, thanks PN. I'm sure it's when it all changed (is it 2007?) and made all the office products more user friendly that it all went wrong for me! Even when I knew ow to use it I thought Access was useless. I used to use Goldmine and loved it. (how much does that cost these days? waddles off to induce a heart attack...)

michaels

What about designing a couple of tables in grid (spreadsheet) view, adding the foreign keys in design mode and setting up the relationships and then using the form wizard to give you a nice front end?

Doozergirl

michaels wrote: »

What about designing a couple of tables in grid (spreadsheet) view, adding the foreign keys in design mode and setting up the relationships and then using the form wizard to give you a nice front end?

Should be easy shouldn't it

I think one of the eight databases I've created is well on the way, but I imported data wrong so I've got things that aren't tables with data separated by commas.

That said, looking for CRMs and there's all sorts of free stuff and Google App type things that can be used. Ideally what I want is some kind of sales system so perhaps some extra research on what is available on the tinternet is the way to go...

EDIT: Alrighty, I've just started using Insightly and I think this is going to do more than my access thing would have. Or definitely, based on my current access skills.

zagubov

Doozergirl wrote: »

Blimey you lot have been busy!

Does anyone know how to create an Access database? I used to be able to do it 10 years ago and I can't even get my excel spreadsheet to import into it now. Clearly I have no idea anymore at all, and I was even trying to be clever linking the tables.

I'm taking the information of planning applications off of the t'internet planning portal. I'm listing the a) applicant and their details b) details specific to their application and c) their architect if there is one. I guess I could just have a one table and use excel without problem as the people I'm looking for are highly unlikely to put in more than one application. I just thought it might be more posh in a database that maybe I could turn into a bit of a CRM that logs me contacting them? Or should I just use a CRM?

Am I talking rubbish?

What I thought would be a list of a few target developments has turned into a list of 53 definite possibilities and I still have a list of another 60 odd to work through and decide if I like them. Feeling tired. H being on "holiday" results in me having more time to do work. Oh, the irony!

I don't know if GDB can back me up on this but I got he impression from Private Eye that the only time the country lost serious millions on IT systems was when they tried to develop, improve or replace databases.

I never got anything to work past Appleworks 5.

God, help me, there's no hope for me in an IT-dominated world!:(

sparrer

I've just come across this thread, don't know why I've not seen it before unless I passed it by due to the 'Debate House Prices and Economy' main title as I'm not a home owner.

I did read the first post -
'Newbies, we don't bite, but we may ask you about where you stand on what you may consider strange things, such as mushrooms or your proximity to Hertfordshire. Stick around, you'll soon get the hang of things'
- which amused me. I don't stand on mushrooms at all, at my height I tend to stand under them, handy in a downpour, and I have one foot in Hertfordshire, the other in a neighbouring county. As for biting, perhaps I'll keep my preferences to myself about that one!

Have enjoyed reading the posts and will pop back again to see if I've been exiled to Coventry, or considered a fungi so I can stay

Masomnia

sparrer wrote: »

.... as I'm not a home owner.

Get out.