Search results

  1. S

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    Well, the question was: Is a data sheet a data sheet. - The very unsurprising answer is: Yes.
  2. S

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    Absolutely! I still remember the time of my very first steps with a "real" database, Oracle in my case, where data would be simply output to a command line (like) UI.- Of course no in-place edits possible there, but it still was a representation of the data in a table but it was retrieved by a...
  3. S

    ODBC Connection Fails when I remove a Field from SQL Server Table

    For a DSNless connection you set the connection string by other means than a DSN. No DSN is involved in the process at all! If you use a File DSN, the File DSN has to exist and it is used to create the connection string of the linked table(s). So, this is not DSNless, even though the resulting...
  4. S

    Solved JAR/WAR replacing Winsock MS Access VBA

    This is a very vague requirement. I suggest you clarify with those imposing the requirement what it means exactly. JAR is a Java ARchive, WAR is a (Java) Web Application aRchive. They are means to distribute Java applications or libraries. If you are using Winsock to communicate with a server...
  5. S

    JOIN versus WHERE

    I think the discrepancy results from two different viewpoints. There are quite a few sources on the web which support your "Order of SQL execution". However, these texts were written to give a human developer, trying to write or understand SQL, a conceptual guide on how to his query is going to...
  6. S

    JOIN versus WHERE

    I don't think, I know any current DBMS where this is actually the case. BTW: Even with a proper join, applying the where condition first is the more efficient way to process many queries. - Query optimizers are usually aware of this.
  7. S

    JOIN versus WHERE

    This is the key statement here. It is the business of the database engine and the query optimizer to find the most efficient plan to execute a certain query. The strategy (algorithm) they use to find this plan is usually not publicly documented and might change with any update to the database...
  8. S

    Solved External hard drive to ethernet switch

    The NAS cannot do anything about it. It's the VPN creating the problem. A VPN connection activated locally on a computer (as opposed to on a gateway in the network) may switch the computers network settings to route all traffic through the VPN. - As your NAS is not known on the VPNs network, the...
  9. S

    Solved How to pass parameters on a pass through query in ms access

    Are you sure the QryJobWorksCompleted is a Pass-Through-Query? - The error message you show in the screenshot indicates it is not.
  10. S

    How to change the source of a linked table?

    Maybe you can build the import spec by analyzing the existing tables/files and writing their structure into the ImEx-tables thus creating an import specification retroactively. - This is going to be a bit of work. Not sure if it worth it for a one time operation.
  11. S

    How to change the source of a linked table?

    That's why it is advisable to store the specification used to link (or import) a CSV file. Then you can recreate the table with one line of VBA code. You can try whether it works to just change the path to the linked file in the TableDef.Connect property, but I don't think it is possible.
  12. S

    How to save Access file linked to SQL Server

    If you connected the Access file to SQL Server already, the file was created and your question has answered itself. ;-) You can still create .mdb files. Choose that file extension while creating the new Access file. - But you should only do so if you have a good reason for it. The default is...
  13. S

    Solved External hard drive to ethernet switch

    Looks like you are looking for a NAS (=Network Attached Storage) device. In any case, this recent thread should contain a lot of useful info for you: https://www.access-programmers.co.uk/forums/threads/lan-question.329495
  14. S

    Create event on image component

    You should explain in more detail what you are trying to achieve and what/how it does not work. An Image control also has a Click event that works exactly like the Click event of a Textbox. Your code should work there all the same.
  15. S

    Unlock locked form fields with VBA

    This is the right direction. However, you need to pay attention to what this refers to in the context. I believe with your script snippet it will refer to the document as a whole, while inside the input tags it refers to the individual input element.
  16. S

    Unlock locked form fields with VBA

    You should explicitly mention that this about a HTML form in a web browser control, not about an Access form. I'm afraid there is no generic solution to this problem. You'll have to analyze the JavaScript code of the web page to find the right approach to unlock those controls. You could try...
  17. S

    VBA Limitations - Restrictions

    Yes, these points are valid. These are not hard limitations by the VBA environment. They are guidelines to write maintainable code that is easy to read and to extend/modified with low risk of errors on the side of the developer. The default set of the code quality rules are a good starting...
  18. S

    Solved LAN question

    I cannot give a definitive answer. In theory: yes. However, there are a couple of potential gotchas. The router's operating system must support the SMB protocol for the file share. - Most (all?) do, but I'm not sure about supported and required/recommended protocol versions and their...
  19. S

    Solved LAN question

    I beg to differ. A NAS device is basically a complete file server in a box. You attach the device itself to a network and it is then providing a network share independently of any of the other computers on the network. An external drive is just a disk drive. You must attach it to a computer (or...
  20. S

    Solved Form Field and SendKeys

    I very much hope that the solution for all threads about SendKeys will be: "avoid SendKeys". Good that you solved it and thank you for posting your solution!
Top Bottom