User Profile
tsgiannis
Iron Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: A Problem with attached images in Access, Windows 10, Office 365
Well Access and Images is a tough case For start you could check my article on working with Images and Access : https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html (for the time being 32bit) Other than that since it seems you quickly filling the space two options : 1. If its single user you could switch your BE to Sqlite 2. If its going to be multi user then Firebird is your friend I had a case with 1000s of images populating a MsFlexGrid without issues with Access as FE and Firebird as BE873Views0likes0CommentsRe: Moving Away from MS Access
This is probably the discussion that will never end The case is that from time to time several attempts were made to easily migrate Ms Access applications to either .NET(Winforms) or Web. Probably older would remember MUST the application that would undertake this migration semi automatically....it failed, vanished into thin air due to lack of interest. Personally some years ago I was doing PHP and I simple loved it...so at this time I was all fired up to create an application that would the application, time of involvement estimated around 1 - 2 years....did a market research , well nobody cared, so I simply let it go. Now I am on the Python boat, especially with the help of AI it would be a breeze to create such an application, time estimated around 6 months (sample) ,but again who would pay for that. So the problem is not that it cannot be done ,but that pretty much everyone is expecting that it would be a free feature, just because they paid for the license for Ms Access they anticipate that it would be served on a plate free of charge. Probably if nothing else drags me , I will go on with the development just to have something to keep me going when daily work load is minimum but I will only provide it as a paid service. So its perfectly doable ,its just a matter of commitment and reward.2.2KViews0likes4CommentsRe: Moving Away from MS Access
For me is all about money. You pay you do the moving/migration....someone else will do the job and will deliver the desired output/ You don't pay and you try to "evade" the cost....all you will see is obstacles and huge walls. Web is just another platform and it has its own pros and cons, you just have to do your homework even if you are just to hire someone and just make your choices. Let me give you a scenario: Suppose someone builds an application that does the hard job of translating an Access application ...how much would you pay for this functionality (?) .....probably you wouldn't ..so why build the application in the 1st place.7KViews0likes3CommentsRe: Improve performance Access frontend with Azure backend
Welcome to the true "performance" of Access+SQL Simple things...binding the forms/recordsets to tables ...is slow What you can do...well you need to replace whatever you can with PT (as you did), create some good amount of temp tables for caching, maybe check the performance when you load e.g. comboboxes with in memory arrays and so on. If nothing does the job then you will need to work on the unbound scenario where the data are INSERTED on demand but the form is unbound and the form is populated only with the minimum amount of required data.2.9KViews0likes0CommentsRe: Opening a .mdb file
Interesting...I think the oldest I had was '97 ...but 1.0... !! For the author it seems that once upon a time was a converter that could convert Access from 2.0 and up to 2003 This tools is long long gone but thankfully Internet Archive (after a good search) still has it https://web.archive.org/web/20060216154605/http://download.microsoft.com/download/c/d/c/cdc5d70c-25ab-42fb-974f-1514dc48ee30/Acc2Conv.exe Test it and report back If this fails I guess it's corrupt and you need to check some of the Access specialized people to restore it.80KViews1like1CommentRe: Problems Importing XML Files Into Access
If you want total control with XML you need to do it via code. Something like that Set xmlDoc = New MSXML2.DOMDocument intFile = FreeFile() Open strXMLFilename For Input As intFile strXMLFile = input$(LOF(1), 1) Close intFile Set xmlDoc = CreateObject("MSXML2.DOMDocument.6.0") xmlDoc.LoadXML strXMLFile Then you will iterate its nodes..grab the values and place them accordingly7.4KViews0likes0CommentsRe: How should I create a transactions table?
JL2022 Your first concept is almost correct AA -->AutoNumber 1st Table Items ID(AA:PK) , Product,[Other details like S/N,descriptions...etc] 2nd Table Roster ID(AA:PK),Technician 3rd Table Transactions ID (AA:PK), ItemID,RosterID,Start_Transaction,End_Transaction Essentially the available Items are the Items that are not in an unfinished Transaction I am attaching a small database to take a look2.6KViews0likes0CommentsRe: Problem Creating a usable zip file using VBA. Does anyone have an alternative?
RBStewart I am attaching the class file to import to Access The usage is like this Dim czip As New CzipArchive With czip .AddFile B, "YourFile.ext ' Just put your file .CompressArchive baZip, , 1 Debug.Print "End: " & Now() End With7.7KViews0likes0CommentsRe: MS Access 2016 is not Responding when i open a Report or Table
Probably the linking to Excel is the culprit...to be certain make make table queries and create local tables out of the Excel and test again. Just yesterday i had a case with a rather small Excel as Linked table...it was literally crawling..making an Access table out of this just skyrocketted the performance.3.9KViews0likes1CommentRe: Importing Data From Excel Via Code Giving Unreliable Outcomes
If you want to take the matter in your hands you need to use Excel Automation...in this case Access will treat Excel as an Object...read the cells and transfer them to a temp table where you can manipulate them to your liking...in this way you are stopping Access from making guesses on what datatype you have thus giving the confusion973Views0likes0CommentsRe: Drag and Drop a file within a form in Microsoft Access 2016 on Windows 10 problem
ktesler Something changed in the Windows 10 ecosystem causing this functionality to get problematic...it used to work just fine in Windows 7 but i think we some recent update it tampers with DDH_MAXCALLS and thus the code doesn't work properly...i used to work with something similar in the Windows 7 era and probably early Win 10 editions but later it just doesn't...increasing the DDH_MAXCALLS (i think i saw something like 500) it should help but not much6.6KViews0likes0Comments