Search results

I've upgraded an Access 2003 application to Access 2016 and migrated the back-end to SQL Server. Now all of my date fields are in the format yyyy-dd-mm hh:mm:ss despite the text box Format being set to Short Date. I suspected this was due to the regional settings in Windows but when I checked...

I've upgraded an Access 2003 application to Access 2016 and migrated it's back-end to SQL Server. I'm experiencing lockups on a particular form which features ~25K records. Upon running an SQL Server Profiler trace, I noticed that for every row returned by query, an sp_execute query is also...

On my form, I have a combo box that lists all record identifiers, for easy navigation. In the combo box AfterUpdate handler, I execute the following code to navigate to the chosen record. Me.RecordsetClone.FindFirst "[id] = " & Me![cmbId] Me.Bookmark = Me.RecordsetClone.Bookmark This works well...

I created a Ribbon for my application, with the following XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="dbCustomTab" label="Lone Mountain" visible="true"> <group id="dbCustomGroup" label=" ">...

This is a long shot but I figured I might as well try. I made use of the ReportUtilities suite developed by Stephan Lebans in a project to convert an Access report to Word document. This references ReportSpecs MDE developed by Steve Arbaugh (Attac Consulting). It worked perfectly and saved me...

I have a form that jumps from Tab Index 25 to Tab Index 33 even though there are controls with Tab Index 26, 27, etc. Tab Stop is set to Yes for the skipped controls. Any ideas?

I am referencing an MDE file (for which I do not have the original source) in order to utilize some of its contained functions. The MDE is referencing a discontinued library (OWC10.DLL version 1.0), causing a missing reference error every time I open the code editor. Fortunately, absence of...

I already asked this question on Stack Overflow but received no responses. I just came across this forum so thought I might have better luck here. I am utilizing forms and reports from an old Access database in a C# application. I do this by launching the Access database, hiding the main...