• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by Learn2010

  1. L

    Query Not Updatable

    My point: This has worked thousands of times before I imported everything from the original database. What changes could have taken place with that import? Thank you.
  2. L

    Query Not Updatable

    I have an Access database that is linked to a SQL back-end. It runs slow. I checked some things you guys gave in a prior post. Now, I have created a new database and imported everything into it. I had to go through and add 4 References to match the old DB. Nothing else changed. It is updating...
  3. L

    MS Access/SQL Server Speed Issues

    Thank you.
  4. L

    MS Access/SQL Server Speed Issues

    I use normal VBA code. Most of the queries pull data from the SQL DB. I process it, then append new or update the old via a query. As you can tell, my knowledge of SQL is not at a high level.
  5. L

    MS Access/SQL Server Speed Issues

    I believe it is DSN. Also, as I said, I have no control over the SQL other than connect to it. I use to have a contact when I first set it up. He has since left.
  6. L

    MS Access/SQL Server Speed Issues

    I don't know. It is even hard for me to get a SQL support person. So, when I do, I have to have the right question. I do know that they usually close the database at the end of each day.
  7. L

    MS Access/SQL Server Speed Issues

    I work for a hospital support team and have created Access databases with a SQL back-end for our department. I have no control over the SQL. Here is my issue. Onsite, my database is average to good speed. The other users are much slower than mine. Using Cisco to connect from offsite, we get the...
  8. L

    Insert Into Statement

    I found this on a crosspost and it doe answer my question. I thought it would speed it up. If not, I will use what I have. "Switching a saved query to VBA will in no way speed it up." Thank you.
  9. L

    Insert Into Statement

    I have several queries like this. I made a change to the query to simplify it and came up with this. How would this work? Thank you. START OF CODE INSERT INTO tblDiagnosesHold ( Diagnosis, ICD9Code, ICD10Code, PatientID ) SELECT tblDimDiagnoses.Diagnosis, tblDimDiagnoses.ICD9Code...
  10. L

    Insert Into Statement

    Thank you
  11. L

    Insert Into Statement

    I am trying to convert the SQL behind an Access query and use it in a Docmd.RunSQL "" query. I have made several attempts and cannot figure it out. Can someone help me with this? I have two tables linked on the PatientID. START OF CODE INSERT INTO tblDiagnosesHold ( Diagnosis, PatientID )...
  12. L

    Followhyperlink to Different Browser

    I was not able to use that. I need something simpler. Thank you.
  13. L

    Followhyperlink to Different Browser

    I have a procedure that creates a file that is to be uploaded through a website. I use the following to open that web page. Application.FollowHyperlink "http://page1.ohio.gov/Pages/default.aspx" We are currently using IE as our default browser. This opens that page in IE. However, that site...
  14. L

    Linked Tables or Not Linked

    The one in the field is a stand-alone version. The main DB loads it up with data. They go out, meet with a client, collect information, return to the office, and upload it into the main.
  15. L

    Linked Tables or Not Linked

    I have a SQL backend. I have a database that the team takes with them out in the field. When I open the main database it reloads that database. Also, if they make certain changes to records in the main, it updates the field DB.
Top Bottom