Recent content by PhilC

  1. P

    Convert MS Access database to web based DB

    Hello Pat, I like your concept in your first response. But how on Earth do I get Access to READ an incoming email? I know how to send one. I have used CDO and it works perfectly, but I have never worked out how to 'read' an incoming email. Can you advise please, as this seems to provide an...
  2. P

    Convert MS Access database to web based DB

    Hello Guys, I have created an Access database which runs cribbage league results. I now want to convert this so I can add it to our existing website and allow members to enter their own results.. I think I know how to transform the tables to SQL. But the problem I have is creating a new front...
  3. P

    Copy entire form to clipboard

    Yes, but cannot get access to the snip and sketch executable. Microsoft have hidden it and I need to get access through a chain of folders and subfolders. I welcome any quick solution. The Take Ownership option is greyed out and I cannot find the subfolders that Arnel specified.
  4. P

    Copy entire form to clipboard

    Thanks both arnelgp and Uncle Gizmo. I had thought of Snip & Sketch, but not pursued the idea. If I could find the exe file I could use Shell command to launch it programmatically. But finding the exe file has proved a nightmare. Can anyone tell me the path? Many thanks
  5. P

    Copy entire form to clipboard

    Hello Guys, Having worked for years with most Ms Office products, I have reached an impasse with Ms Access. For the first time ever, I want to copy the screen image of a form using VBA. Preferably from within the form itself once it is active. My aim is to use the image on a website. I do not...
  6. P

    Trouble with Ease of Access settings

    Thanks David and CJ. How on earth have I missed that???? Probably cos I have never had need to previously. Many many thanks to you both.
  7. P

    Trouble with Ease of Access settings

    Hello Guys I have a cataract which means I have had to use ease of access to set the screen to a more preferred option so I can see everything. I now have a black background with white text. Perfect! BUT when I enter the VB screen in Access some of the code text is coloured a very dark purple...
  8. P

    Emailing from Access

    Thanks for the input. I think I may need to make my problem clearer. I use Thunderbird for all my email traffic. But I have now got two email accounts. The old one, which I have used for all of my emails is phil@beaconsfieldcottage.co.uk. But I have recently set up another account called...
  9. P

    Emailing from Access

    I have used MS Access for many years to send emails using the SendObject method without any fuss. Now I have added a second account to my email browser (Mozilla Thunderbird). I want ro be able to specify the account to send messages in a new Db I am designing. Unfortunately I don't think...
  10. P

    Query to select players for a team without duplicates

    Hello June7, Thank you for your contribution. I tried your suggestion, but could not get it to work. So I tried an alternative strategy. I created a temporary table called tblSelectedPlayers and wrote an afterUpdate event where the playerID selected from the first combo was added to the...
  11. P

    Query to select players for a team without duplicates

    Hello All, I need some inspiration! I have created a form. The form also has a subform which is a continuous form. The form will be used to enter results from matches played in our local cribbage league. I will explain how matches are played. In any match there are two teams, A and B. Each...
  12. P

    Forms and Themes

    Thanks Pat. Miraculously the new database had rectified itself by this morning after a reboot of the laptop. But I remain mystified as to why it happened in the first place. Where do I find the "use Access Theme" setting? I've looked, but cannot locate it. Thanks
  13. P

    Forms and Themes

    I've just had a disturbing experience! I have spent today building a new database. Nothing special there. I've built many so I know what I am doing. A few minutes ago I was creating a new form and everything was going swimmingly. Then I had to close the new database and open another database to...
  14. P

    Quiz database - Brainfreeze

    Pat, I think we're singing from the same hymn sheet. Your suggestion is exactly what I have done to create the tblScore table. My apologies if I have inadvertently misled you. I have 3 tables: tblTeam, tblRound and tblScore. As you advised, I created tblscore from a query containing...
  15. P

    Quiz database - Brainfreeze

    Yes each team will gain a score for each of the ten rounds. A team can score 2 points for each correct answer, but if they have played their joker on that round they can score a maximum of 40 points. So over ten rounds they could score 9 x 20 points and 1 x 40 points. Every team is independent...
Top Bottom