Search results

  1. T

    Other user can't open SQL Table in Access

    Hello. Apologies in advance...this is the first time I'm linking a MS SQL table to Access so maybe I'm doing something stupid. I moved my Access data to my IT's SQL server and then linked it to my Access DB. It works flawlessly for me. When our other user tries to open the table in Access...
  2. T

    How to stop table opening on startup

    I inherited a DB and on startup, one of the tables is automatically opening. I do not want users even seeing the table, let alone tinkering with it. But I have no idea how to turn this off. The only way I know auto opening something on startup is listing in the startup form in Options, and obv...
  3. T

    Form with multiple dropdown filters

    I have a massive table and am looking to create a form that helps to easily locate info I'd like to make a form that has two drop down menus in this order - the field name columns - the first columns data This would essentially triangulate a specific cell's data and that's what I'd like shown...
  4. T

    Parameter search in Union query

    I have a union query between two queries. The current SQL is: SELECT * FROM 2018Query UNION ALL SELECT * FROM 2019Query; I'd like to add a parameter search. I had one previously on a non-union query that worked perfectly, but this was in design view and idk how to add this to SQL View. In the...
Back
Top Bottom