Recent content by mattpearcey

Many thanks BM, but you are correct - i am after something a little flasher. Ie. in HTML. Appreciate your post. Regards Matt Thank you for your help already. Matt Pearcey

I want to send out a HTML based email top my collegues that contains a form of tick boxes. These tick boxes are areas of interest/activities. I want them to be able to submit there prefered options and for them to come back to me, or go direct into a database in a lump hit, so that all we get...

I am an Outlook 2000 users, and create html based emails for campaigns in frontpage and save these into my stationary file so as to be used with outlook. Now, this looks and works great, as you have all the flexibility of links and form generation in your emails. However, i have a problem with...

I need confirmation, or at least advice as to which format is best used for email when using MS Outlook. In a previous company, I was told that Rich Text format was the safest as it does not carry virus'. Using Word or HTML is more likely to do so. Is this correct? Or is there any more...

I need confirmation, or at least advice as to which format is best used for email when using MS Outlook. In a previous company, I was told that Rich Text format was the safest as it does not carry virus'. Using Word or HTML is more likely to do so. Is this correct? Or is there any more...

Ok - i have this working, kind of, but i cannot get the users that i need to be able to see all the records to work. Basically i need to alter this code to work, but cannot make it happen at present. Option Compare Database Public logon Function strLogon() If logon = "Rosemary...

I think this is a basic one, but my head is spinning to solve it. I have a report that is based on a query from 2 tables. One is a main table (a), and then attached to this is another table(b) for more records specific to that main record. Reports work fine for this, as one report...

I have just introduced two new forms to my database, to incorporate an area to enter new information. Certain people, ie. managers, need to view this new information as soon as this is entered. Is there a way that i can make a button a required field? For example, like when you make up a new...

I have a table that i have inherited from another system, that is not normalised at all, and in essense - is one huge table. I cannot get rid of this, as i need to hold this info. However, i have managed to get this to look respectable in a form, but in order to make them relate to the records...

I have a database that has grown to a state where i need more people to use it, but to be able to view different records. I initially conquered this, by having 3 seperate frontends for each of my branches. With tabs showing the difference records for each branch. Therefore, branch A could...

I have a word document, in 2000, that i need to have protected. However, i have a number of hyperlinks within the document that do not work when i protect the document. Therefore, when i send this out to be used, the hyperlink does not work. How do i get this to work? Thank you for your...

I now have another query for you regarding this long report. Because i have had to use some of the page header to enter some fields, they are unfortunately appearing then at the top of each page. How can i get the page header to appear just at the first page? OR would it be best to remove the...

For my report, i have managed to get into the 22 inch frame, just! So i am ok. Would prefer page breaks though, but i doubt i will have to produce a report of this size again. But at least i know the boundaries now. Many thanks Thank you for your help already. Matt Pearcey

I have a continuous subform within a frame form to display my records. However, at present they are ordering, i guess, by default to the ID number. I want them to order by Name of the record - Alpha. How do i do this? I have tried many different things in the OrderBy property in the form's...

KatieKat Have you found a solution to your report length problem? I also need to do a very long report, but have got to the bottom and cannot go further. Some help if you have done this now, would be very much appreciated. Ta Thank you for your help already. Matt Pearcey