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!

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

Search results for query: *

  1. LeeJames75

    Computer very slow - it's not a virus

    And also. If all these come back stating the machine is clean, I would suggest when running the game, turning off Norton. Providing it isn't a online game. If it is an online game, then basically the machine will be slow. Also tell your friend to get rid of AOL as that uses alot of memory...
  2. LeeJames75

    Computer very slow - it's not a virus

    Hi. Personal choice here is yes ok Norton is ok, however I would use the following. AVG antivirus - Free Version and schedule daily updates and checks. And then install AVG Anti Spy - Free full use for 30 days, and basic use thereon after. These found more trojans etc than Adaware and...
  3. LeeJames75

    Desktop Internet related icons do not work.

    Also you can download TWEAKUI POWERTOY off the MS Website and it allows you to relink and repair icons. It is an excellent tool. http://download.microsoft.com/download/f/c/a/fca6767b-9ed9-45a6-b352-839afb2a2679/TweakUiPowertoySetup.exe
  4. LeeJames75

    Explorer.exe hanging

    Someone I work with had this problem on their laptop. Laptop booted up and only displayed the background. No desktop items or the windows start bar appeared. However they could do Ctl+Alt+Del to bring up the task manager. After looking around the net for possible solutions, I decided to copy...
  5. LeeJames75

    Me fUnction

    You have a duplicate function name in your code.
  6. LeeJames75

    How do I save a record from a QBF of 1 Table to another Table

    Thank you Remou for the strong advice. Before my inital posting, I read this thread702-891878 and downloaded the example, then did some more searches and found that I can create a TYPE where I can assign the fields to a new table. Whereby adding a SAVE BUTTON on the form that displayed the...
  7. LeeJames75

    How do I save a record from a QBF of 1 Table to another Table

    Hi there. I have 2 tables. Patient and GP. My intention is to do a QBF of a GP and when the correct record is found, I have a tick box which is checked and then click on a button to write the data to a table containing the PAtient ID and fields of the GP details, which is then shown another...
  8. LeeJames75

    Showing and image file

    It's ok, False Alarm, The length of the fields were reset to 50 chars.
  9. LeeJames75

    Showing and image file

    ARRGGHHHH Just upgraded to Access 2003 and this code doesn't work. Not even when the default is set to 2000
  10. LeeJames75

    Access 2003

    Am I right in assuming that with Access 2003. I can copy/import Databases, or individual units of tables, SQL, Macros and Forms from 97 and 2000, work on them in terms of amendments, and resave them as 97 and 2000 formats. Regards Lee James England
  11. LeeJames75

    Showing and image file

    This bit of code has helped me alot. Now I want to expand on this. Say for example I have my records, I scroll through them and the photo's appear. I introduce some more photos in the folder I am calling them from, but in the text field I spell the name wrong. Instead of Access coming to an...
  12. LeeJames75

    Stop statement stopped working

    This may sound like a dum answer. But check your references. When I was doing some DAO referencing. I moved DAO Objects to P3 in the List. And it stated that all my methods were not listed. I had to leave it at P7 in the List. Lee James England
  13. LeeJames75

    Problem when processing more than 1 mass Email query

    The First command button accepted fine, When I hit the 2nd Command button the program kept breaking at .Movefirst I can now run all 4 command buttons. Regards Lee James England
  14. LeeJames75

    Problem when processing more than 1 mass Email query

    I Solved my problem.... I referenced the DAO.RECORDSET And set rs = CurrentDb.OpenRecordset("qry_email", dbOpenSnapshot) I also took out the MoveFirst and used While Not .EOF instead of Do While Not .EOF. The processing time is quicker, and the memory useage is alot less than previous, very...
  15. LeeJames75

    Problem when processing more than 1 mass Email query

    But I am reseting the Recordset. I have a new sub command for each query. I just copy the code, change the click number and then change to the query I am using.
  16. LeeJames75

    Problem when processing more than 1 mass Email query

    This is my code to run an overall mass mail of all emails in a query in BCC. This works fine. Public Sub Command4_Click() Dim otk As Outlook.Application Dim eml As Outlook.MailItem Dim rs As Recordset Dim Strlist As String ' Opens the table/query and builds the...
  17. LeeJames75

    Is there an Auto Save feature in Access 2000 as there is in Excel ??

    Bob. Apparently, after some more shutdowns, the PC rebooted ok, and the records returned. I haven't a clue what went off. (My client is non IT) I am attending the clients site this afternoon and doing a Windows Update, and making sure they don't have the virus.
  18. LeeJames75

    Mass E-Mail Code

    Ok. Having no VBA experience whatsoever and only having used VBA for 5 or 6 modules. I have been testing this code and have found a problem, Those with huge distribution lists Please take note !!! The second example above opens multiple instances of Outlook and then places each email address...
  19. LeeJames75

    Mass E-Mail Code

    Horray to you all. The 2nd example with a minor modification has worked a treat. By replacing eml.TO with eml.BCC the other members will not be able to see the other email addresses. With the searching and applying the code and the modifying and testing, has only taken me less than 1 hour...
  20. LeeJames75

    Mass E-Mail Code

    After some extensive searching through the archives, I have stumbled across this. I am currently working as a Data Analyst/Administrator for a Skatepark in England. They have a database of 9000 members. And wish to send bulk emails to SKATERS, BOARDERS and BMXERS. Now I have 3 queries...

Part and Inventory Search

Back
Top