Search results

Sorry for the very late follow up but there were several delays and corporate policy roadblocks on the client's end since I originally posted. I stubbornly wanted to avoid changing the column data type so I went the route of trying to get the ODBC driver recognizing datetime2. First, I tried...

I do have control over the SQL Server tables so I will try datetime when I get access to UAT environment again next week. I'm still puzzled as to why this issue is not present in my development environment though...

Thanks for the response. Sorry for the delayed reply, I had to schedule some time to get onto the client's UAT environment as I was not experiencing this issue on my development environment. The data type of the field on SQL Server is datetime2(0) (same as on my development environment). The...

I'm going to check with the client to see how important live updates are, it may be that they don't actually care. Either way I'll stick with Snapshot and implement a mechanism like you suggested for live updating, if need be. Thanks again for the responses!

Thanks for the response. This is a continuous form but it is not editable. There is a button on each row that opens a single form for editing the record. When I said "I want changes made by other users to be reflected without closing and reopening the form" I was referring to when another user...

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...

I went with Isaac's suggestion of creating a query to reference from my form's RecordSource. In the combo box AfterUpdatehandler, I now execute the following code to navigate to the chosen record: Me.RecordSource = "SELECT * FROM MyQuery WHERE id = " & Me![cmbId] Me.Requery I chose this...

I was just able to confirm that NoMatch is false when this occurs. Me.Recordset!Id is equal to the chosen id but Me!Id (text box with ControlSource set to Id) has the wrong record's id. There's isn't anything that requeries or changes the form's RecordSource. I ran trace on SQL Server (that is...

Since the ids that have caused this problem work sometimes but not others, it seems strange that NoMatch would sometimes be true. However, this is a strange problem so I'm not ruling anything out. I'll add code to show a dialog if NoMatch is true.

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...

The "Allow Full Menus" option under Current Database -> Ribbon and Toolbar Options was unchecked. After enabling this option, the missing ribbon items appeared!

Thank you for all of your responses. Micron: I honestly can't remember whether I progressively added the buttons or not. However, I have both closed and reopened and executed a compact/repair to no avail. I even tried creating a new row in USysRibbons in case the original was stale or...

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=" ">...

I am so accustomed to using Quick Reply, I forgot there was a full-on reply form. Thanks! Here it is:

I've modified both the ReportUtilities suite and ReportSpecs library for use with Access 2016 64-bit and consolidated them into a single ACCDB. I'd like to upload it here for others to reference but I cannot seem to find the upload mechanism.

That's strange because GlobalAlloc (https://docs.microsoft.com/en-us/windows/desktop/api/winbase/nf-winbase-globalalloc) also has a SIZE_T parameter and API Viewer indicates to use LongPtr for this parameter.

According to Microsoft's documentation (https://docs.microsoft.com/en-us/windows/desktop/devnotes/rtlmovememory), the last parameter is of type SIZE_T. As far as I know, size_t is 64 bits on 64-bit system so I believe LongPtr makes sense here.

That tool is incredibly handy. I was able to find x64 equivalents of all API calls except the following: Private Declare Sub hmemcpy32 Lib "kernel32" Alias "RtlMoveMemory" (lpDest As Any, lpSource As Any, ByVal dwBytes As Long) However, based on all of the other translations I've seen, I...

That was my first thought so I put a breakpoint on an API call that uses a handle to see if it was invoked. The following APIs are definitely called: Private Declare PtrSafe Function api_FindWindow32 Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As Any) As...