Search results

Hi All I hope this is the correct thread / area for this. Anyway we have a guest details database with the FE in users My Documents and BE on our server. We usually run a mail merge with MS Word and all works fine. However the printer in the office has gone South so we have advised some...

Hi Buddy Not quite clued up with access. Any advancement on how to create "query that groups by address, postcode"? Regards

Hi All We have a database for our guests where each person is a separate record. Sometimes we send mailshots to all males or all females. However sometimes we need to send a mailshot to ALL where the male and female reside at the same address. Rather than send 2 letters to the same house is...

Hi All At our church we have 3 databases as follows: Guests Youth Kids Each database has a Frontend (stored in users My Docs folder) and a Backend (stored on a shared folder on our server) Would it be possible to merge these databases into one for query / mailshot purposes but still keep the...

OK I understand. But I'm as to where to enter your code! Also what if the user navigates to the backend folder on the server and opens that? Regards

Still lost! Is this on the FE or BE? Regards

Hi Buddy Sorry for being a total twit but I do not know where: Open Load Event Is located Regards

Hi All Can anyone recommend any decent Access training books or CBT's for someone new to access? Regards

Hi Buddy Sorry thats way over my head. Do you know any clear, step by step guides? Regards

Hi All Most of our staff are not IT professionals and I have noticed that some of them have been opening the database backend (stored on server shared folder) rather than their database frontend (stored in My Documents). Obviously this creates problems and can damage the databases. So is...

Useful info there buddy Thanks

Hi John Thanks for your reply. Anyway I have been updating the queries on my frontend. However I have another user that I would like to push these queries to. Should I have been updating any queries at the backend and then copying to frontend? Regards

Hi John Not sure what you mean by linked or replica! OK the way I set this up is by creating a database called Guest Info, then split the database into a frontend and backend, with the backend residing on shared folder on our server. Other end users have a copy of my frontend but if I dont...

Hi John Yes that works fine OK Ive set these queries up for my use of the database, but can I push these queries to other users of the database as they wont have these query settings? Regards

Hi John We enter either Male or Female via a drop down box. Thanks again for your reply

Hi John Thanks for the above advice although some of it is way over my head / experience. Anyway with regards to running a query of Male or Females, I created 2 separate queries where Male then Female are entered into the criteria box. Is that correct? Regards

Hi All OK I have created a database to record visitors details at our church so that we can contact them via post /email later. The way I have set this up is as follows: Created a database called Guest Info Split the database into a front end and back end Backend is stored on a shared folder...

Hi All As I said in my introduction, I am new to Access and need help to manage our people data better. OK we have Access 2003 (due for upgrade asap) and we have people (guests) fill out paper forms which include things like: Name Address Email Phone number Mobile number Date attended Now...

Hi All My name is Stuart and I am the IT Administrator for our church based in Scotland. Anyway we have started using MS Access 2003 to manage our people information a lot better. However databases are NOT my strong point and I need some help. Hopefully the forum can provide that. Regards