Search results

  1. T

    Late Control binding to make Forms Field independant.

    @DHookom: the app compiles for me (A365-32). Do you need to decompile?
  2. T

    Recommendations on appending or linking historical data into a new dataset

    Then pull it ONCE. Something like: insert into myLocalTable select * from mySapTable where myDateField > DMax(myDateField, myLocalTable)
  3. T

    Access not 'receiving' command line passed to it in batch file

    I think you need to prefix the path to your database with the path to msaccess.exe
  4. T

    Hello, I'm new to access and this forum

    Welcome Malcolm. That sounds like an ambitious project. Ask lots of questions in this forum, especially about the correct database design. As an engineer you will appreciate that the best homes are built on solid foundations.
  5. T

    Late Control binding to make Forms Field independant.

    Zip files can be attached as well.
  6. T

    I'm sure there is a simple solution asset tracking MY NEW PROJECT.

    The junction table (we could call it MachineParts) with the Tag field will likely have several records, one for each machine/part combination. That is good! Your desire to have all the tags in one field is likely because you are thinking ahead, to a time where you're creating a report with all...
  7. T

    I'm sure there is a simple solution asset tracking MY NEW PROJECT.

    Good for you for asking questions early on. Getting the database design correct is an absolutely essential step. What I am hearing is that you have machines, and each machine has zero or more parts, and those parts can be of different kinds (e.g. LI or PT). You need a table to list the...
  8. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    One more suggestion: SSMS > Tools > Import and Export Settings > Reset all Settings.
  9. T

    Warehouse inventory and sites

    Oh Chatty... You don't understand the scope of "advanced" and "comprehensive", and you have not read the "Features not covered" section on this NW2 help page. In fact, the inventory system in NW2 is VERY BASIC, and not meant for any real-world business.
  10. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    "£" seems to indicate you may be in the UK. Make sure your Azure database is in a data center near you, not in say Asia or USA. As an example, on the portal home page I hover over Resource group, and it shows my resources correctly to be in West USA: As another example, here I am in a command...
  11. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    "... recommended MINIMUM versions ..."
  12. T

    Enhancing a small form

    The old-fashioned way. I saved a color bitmap at (in this case) 48 x 49 pixels. Then dropped a button on a form, and clicked on the ... button of its Picture property and selected it.
  13. T

    Enhancing a small form

    b/w only?
  14. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    WRT the connection used by SSMS: it says so on the Connect dialog: ADO.NET
  15. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    I just tried it with a basic Azure db, and it was also almost instantaneous.
  16. T

    Solved SSMS22 Application Itself Slower Than SSMS21

    These are all instantaneous for me, with a local SQL Server.
  17. T

    DLAST FOR DATE SERIAL

    That query needs another clause: GROUP BY SalesPerson
  18. T

    Not all strings are equal

    Hi Josef, I think assigning the result of DLookup to a string somehow modifies it because this fails: s = DLookup("myReplicationId", "tblAccessReplicationId", "myShortText='aaa'") DumpBytes s while this works: DumpBytes DLookup(...) I'm tempted to see if I can hook up a debugger to the...
  19. T

    Not all strings are equal

    Playing is good! That's how I learn. You could have called "DumpBytes ..., 0" to indicate unlimited size. Your approach reveals something interesting: in a recordset the returned value is the string representation of the GUID, as-usual in Unicode so every other byte is a zero. It probably makes...
  20. T

    Not all strings are equal

    Yes, I am aware there is a big difference between a String and a Variant of subtype String. The latter would not have a VarType of vbString. Indeed a conversion function like you showed may be the best idea. What I was after with my question is more understanding of WHY this is so, not how to...
Back
Top Bottom