MS Access help

VeNT · 3 Mar 2006 at 11:25

help!!
I want to create a database thats searchable and can create reports automaticaly from a table of clients information (names addresses invoices etc etc) I want to be able to search for clients in areas (so I could specify clients with "truro" in their address) and have it display the table with that info.
does anyone know of a website that gives me a good grounding in how to do this? also I want to do this all though a simple interface (I'd like to learn how to make that too) as its for my mum to use.

lordedmond · 3 Mar 2006 at 12:28

try the dummies guide for starters ( no offense intended )

I have done a similer thing in the past , it involved a lot of VB code if i remember correctly

VeNT · 3 Mar 2006 at 13:09

yeah got the dummies guide, its not as helpfull, I knew how to do this once (about 5 years ago at college) but I've forgotten since

VeNT · 4 Mar 2006 at 14:15

can't anyone help?

Mel_P · 4 Mar 2006 at 15:27

You are really talking about the basic use of Access and the normal Access Help is useful here.

e.g. create a parameter query to look for a name:

criteria Like "*" & [name] & "*"

This will ask for an input. The query can produce a set of data which can be used as the data for a report.

Mel P

VeNT · 5 Mar 2006 at 22:52

yes but I know how to create the queary, I want to know how to make a form that will let me search for any one criteria in each area of the table?

Sone · 5 Mar 2006 at 23:05

i used to do a lot of access dev at work, and as everybody says this is really simple stuff. Utteraccess.com used to help me loads with work even when i was first starting at a very basic level.

The way i would i do this is to make a public variabe and a get varialbe module and set the query to "like "*" and getvar() and "*". Or you could link directly to it from the form something like "like "*" and [FORMS]![form1]![control1] and "*"". (if its simple i would link it directly, i just find sticking things in variables good when databases get into 50+ forms)

edit, replace and with & signs

VeNT · 6 Mar 2006 at 11:56

Sone said:
i used to do a lot of access dev at work, and as everybody says this is really simple stuff. Utteraccess.com used to help me loads with work even when i was first starting at a very basic level.

The way i would i do this is to make a public variabe and a get varialbe module and set the query to "like "*" and getvar() and "*". Or you could link directly to it from the form something like "like "*" and [FORMS]![form1]![control1] and "*"". (if its simple i would link it directly, i just find sticking things in variables good when databases get into 50+ forms)

edit, replace and with & signs

if I understood any of that I'm sure it would help.
gonna look at that site, ta