Search results

  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

    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.
  4. 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...
  5. L

    Insert Into Statement

    Thank you
  6. 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 )...
  7. L

    Followhyperlink to Different Browser

    I was not able to use that. I need something simpler. Thank you.
  8. 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...
  9. 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.
  10. 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.
  11. L

    Linked Tables or Not Linked

    I have several linked tables in a database. They are linked to two other databases. I am sure you guys can answer this. Is it more efficient to use linked tables for queries or is it better to use the Append To Another Database? I am trying to speed up the queries. What do you think? Thank you.
  12. L

    Optimization

    There are only 3 users. Each has their own front-end and it resides on a shared drive as directed by the managers. I put front-end on my C drive and it does the same thing. I have compacted and repaired it and I use a module to turn off the subdatasheets.
  13. L

    Optimization

    There is no way. Access is frowned upon here and if they could get rid of it they would. Just recently they heard that Microsoft was getting rid of Access and it was sheer jubilation. I let them know about the SharePoint version that was being done away with and that the actual Microsoft Access...
  14. L

    Optimization

    The new IT group is attempting to move all Access DBs into one area on the shared drive. Since the process started several months ago, there has been a noticeable continuous slowing of one of my DBs. It is linked to a SQL Server. I have no permissions to do anything to the SQL Server. I have...
  15. L

    Web Development

    Yes., that is exactly what I want to do. Right now, I want to concentrate on the front-end development because the current Access DB is connected to SQL Server.
  16. L

    Web Development

    I would like to move up to front-end web development. I have 25 years of experience with Access. I am not giving up on Access and will continue to use it. Maybe some of you can point me in the right direction. What should I learn to make the transition from Access to the web? The web is full of...
  17. L

    Urgent!! 2013 to 2016 Stops All Functionality

    Here is what happened. After the upgrade I contacted IT to see if they had encountered the problem before. They had not. After listening to how they are getting rid of Access (not true), I needed to move on quickly, so I asked him to restore it back to 2013. I later posted the question in a...
  18. L

    Trust Issue 2013 to 2016

    Thank you.
  19. L

    Trust Issue 2013 to 2016

    It is a Software Center with a list of the programs available to your license. He selected Office 365 2016 and installed it.
  20. L

    Trust Issue 2013 to 2016

    He just installed the new one over the old one.
Top Bottom