Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattpearcey

  1. mattpearcey

    Does anyone have any voting code?

    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
  2. mattpearcey

    Does anyone have any voting code?

    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...
  3. mattpearcey

    HTML mails using Outlook 2000 and 97

    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...
  4. mattpearcey

    MS Outlook 2000 - Email format query

    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...
  5. mattpearcey

    Outlook Email Format - Best format?

    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...
  6. mattpearcey

    Users and Passwords on 97 DB

    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...
  7. mattpearcey

    Subreports within reports

    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...
  8. mattpearcey

    Form completed (record added) = email notification

    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...
  9. mattpearcey

    Many subforms from one table

    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...
  10. mattpearcey

    Users and Passwords on 97 DB

    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...
  11. mattpearcey

    Hyperlinks in Protected Word documents

    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...
  12. mattpearcey

    Very Long Report.....

    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...
  13. mattpearcey

    Very Long Report.....

    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
  14. mattpearcey

    OrderBy Property

    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...
  15. mattpearcey

    Very Long Report.....

    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
See more

Part and Inventory Search

Back
Top