User Profile
Tom_van_Stiphout
Steel Contributor
Joined Oct 08, 2019
User Widgets
Recent Discussions
Re: ODBC call failed. ORA-01406
I don't have Oracle to test with. Speculating, I would think it won't hurt checking the box in File > Options > Current Database > Support Large Number (BigInt) Data Type. You may also be able to carefully check all ODBC settings. ODBC drivers typically can create a Log file if you turn that option on. That may give you more info on this issue. Are you connecting to the same database that worked before, or a different one. If different, does connecting to the previous one still works? Does connecting to a very simply new test database work?76Views0likes2CommentsRe: Access Distribution Package
Here is the general guidance from MSFT: https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f#bkmk_install One of your options is a commercial package such as this one. A few other ones I used to know about have fallen by the wayside. You could ask an AI for some suggestions.42Views0likes0CommentsRe: The return of the performance leak - this time with subreports
I can repro your issue using A365 MEC v2511. When I comment out the DoCmd.OutputTo line, performance does not degrade. If I change OutputTo to acFormatTXT performance DOES degrade even more dramatically. I will report this to MSFT.49Views1like0CommentsRe: Access Still Struggles on Data Import
If you could help us with: 1. The data file, with any PII anonymised 2. An empty database with the destination table and the code and import spec (if any) to import the data 3. Your exact version number (File > Account). Then we could do some research to confirm the issue and see if it can be fixed.68Views0likes0CommentsRe: Adding sub form for a new year
Design the form, and inspect the subform for the most recent year. What is its Recordsource property? Is the Filter property set? But before we go down this road: please lay out all your tables on the Relationships diagram (see Database tools tab in the Ribbon), and post a screenshot here. We want to convince ourselves that you have a solid database design.112Views1like0CommentsRe: Adding sub form for a new year
You open the form in design view, add a new tab by right-clicking the tab control, then copy the previous subform, select the new tab, and paste. That said, think what this will look like in 10 years. So many tabs I would get dizzy. Plus, what if you win the lottery in year 5 and there is nobody available to do this annual maintenance? It would be much better to have a single tab for Dues, listing all dues. Perhaps there would be two text boxes to allow filtering for a date range. The big advantage is that this will work indefinitely, without any annual maintenance needed. Highly recommended.169Views1like0CommentsRe: ACCDE File - Hide Everything
This points to an unhandled runtime error. It is a best practice to have an error handler in all procedures. Check out this presentation of the error handler in Northwind sample database, which you could borrow for your project: AP: Enhanced Global Error Handlers in Northwind 2.2 With Tom van Stiphout and Kim Young90Views0likes1CommentRe: Changed systems 2/3 Working
I am assuming you are running an ACCDB, not an ACCDE. If so, hit Ctrl+Break and the debugger will open. Inspect the variables, especially the path. One way to do that is to hit Ctrl+G to go to the Immediate Window, and type: ?myVariableName When you hit Enter, it will print the value, something like this: c:\nonexistingfolder\60Views0likes0Comments
Recent Blog Articles
No content to show