Recent content by sportsguy

  1. sportsguy

    Solved Excel VBA error I don't understand

    Thanks Issac, the article was helpful, and I switched to a range object due to the error message "424 Object required" as the text variable doesn't work However, this code works, and the RefersTo: is a range object, so I didn't set the range object correctly. Here is the answer which works...
  2. sportsguy

    Solved Excel VBA error I don't understand

    Goal is to loop through a subset of sheets in the workbook and set a local sheet range name based with the same cell per sheet. Sub CreateRangeName() On Error GoTo Err_RN Dim myCell As Range For Each ws In ActiveWorkbook.Worksheets ws.Activate Range("Z1").Select...
  3. sportsguy

    Connecting access front end forms to sql server tables

    Absolutely correct, there are ways to do when inserting rows, use the data entry = True on the access subform. This prevents downloading the whole table, which can blow up access. Or put IS NULL in any required field in the subform query to prevent downloading the whole table, or some sort of...
  4. sportsguy

    Which ODBC diver to use?

    on the server, every table has a primary key, i am the admin the SQL Server, and all has been running fine, until the latest patches applied over the weekend to SQL Server 2016 in the data center. The server has the updated ODBC and matches my laptop version . . . . going through the standard...
  5. sportsguy

    Which ODBC diver to use?

    actually i am on 2017.178.01.01 and the errors are several, even changing the where/ filter on the query, and at rerun ODBC says that the link is irretrievably broken
  6. sportsguy

    ODBC access very slow when form is open

    I have the same slow issue, though not related to a Dlookup with the same ODBC driver to SQL Server 2016 in the company data center. THinking we need to update the server virtual machine to SQL 2019 in the data center Thanks
  7. sportsguy

    Which ODBC diver to use?

    That's the same one I am using and I Ioaded the x64 for my configuration, the question is now x32 or x64 works better with O365 x32? Have any opinions? thanks in advance sportsguy
  8. sportsguy

    Which ODBC diver to use?

    Windows 10 x64 MS Office 365 x32 On Prem Azure billing SQL Server 2016 x64 version 13.0.5882.1 the latest SQL Server update patches require the use of the latest ODBC driver I loaded the SQL Server 2017 x64 version to my laptop, but I am still getting some weird errors when MS Access queries...
  9. sportsguy

    Occasional Access O365 issue but significant

    @Minty I just finished importing everything in to a new database, and works fine. . . I have never lost as much work as I have with O365. I hate it, but i do like the cloud disk on my personal O365 account. . . though there can be some version control issues as in which file did i open and...
  10. sportsguy

    Occasional Access O365 issue but significant

    I have a very nice front end database connected to a back end *.mdb database, all on my local drive. Everything works fine all day long, the next day, like this morning, I open the database, the home/start form pops up nicely, and any button button i click, crashes MS access, just quits...
  11. sportsguy

    Solved I am not an idiot but

    @neuromann9999, ever lose 1/2 Million $, everything you have, with an arrogant attitude, thinking that you know everything? try it some time, and then you might realize that only idiots think that some things are easy and only idiots think they know it all. . . Thanks pbaldy. . . I just...
  12. sportsguy

    Solved I am not an idiot but

    I have a table, built from an excel source file to paste the excel data into (everything in this f* company is in excel) One of the field names is "EE_Status", short text 10 I cannot for the life of me, get the column to show up up in normal view, it shows up in design view, but not in the...
  13. sportsguy

    Naming a VBA selected range

    so far, All examples have failed, and yet, I don't exactly know why. I have extracted data from a SQL Server onto a tab named DATA, the row count will be different each time, but the column count is fixed. I highlight the data and am trying to assign the highlighted range to the name PIVOTDATA...
  14. sportsguy

    Agent Job Error running SSIS package importing Access database table

    @pisorsiaac - LOL! no worries, I want to get the certification, I admit that I am a SQL SERVER dba poser, I just don't have time, and at the end of my career, I don't have alot of studying desires! So I cheat alot (google), but I also don't like posterswith no experience or obviously haven't...
  15. sportsguy

    Agent Job Error running SSIS package importing Access database table

    thanks for the reply, obviously I am a poser :(. The actual error message is "The requested OLE DB provider Microsoft Jet OLEDB.4.0 is not registered." so the follow on messages are all about the failures due to that issue. And yes, the error only happens at run time. Let me look at the flat...
Top Bottom