Search results

I was having a periodic connection problem between an Access 365 FE and SQL server BE. The ODBC connections would lock requiring restarting the SQL server service for the database. The log indicated "I/O is frozen on database #####" followed by a backup. then "I/O was resumed on database #####"...

That would be a way to get to task manager and shut down Access but the OP was looking to get to the code to see what is happening.

What is not working? What have you tried. Access dates include time unless you take pains to remove the time. Today does not end until midnight If TheDate is > Now + 1 then if TheDate is #3/27/26" and now is #3/26/26 11:03:02 AM# then FALSE

In college the Freshmen IT weed out class was Fortran 4 running submitted batches to an IBM 370 using punch cards. Plus a course on IBM GCL. The only IBM manual was in the computer room. Next we went to Pascal, C, Cobol, Lisp but we had line terminals connected to a VAX 11-70 that could submit...

I does not have to hold the data only a pointer to that data. According to Copilot it its stored in a byte array, and like a memory pointer to a memory location, it stores the location of a record in the record set. Unlike a memory pointer, it is not globally meaningful and does not directly...

Two Bytes can hold a pointer to a 2^16 = 65,536 address space. Two AscII2 characters can hold a pointer to 2^32 = 4,294,967,296 address space.

If the client is on runtime, there isn't much you can do to get into the running application. Adding external logging to a shared network drive is my 1st choice. I log all errors and some in-process problems. The log line starts with date/time then Computer ID, User ID, Windows version, Access...

I agree with Ken and it's not a quibble. The bookmark contains a value, lets call it a pointer. When the record set is recreated, memory for the 1st record set is released and the new record set is placed into memory which may or may not occupy the original memory. Now if the bookmark is a...

If you are using runtime, then no, because runtime does not provide the Access user interface to break into.

Sometimes I think switching to a property based system would be cleaner; allowing searching for things like a City in a state and multiple counties. tblPropType ID Desc 1, City 2, StateAbv 3, PostalCode 4, StreetAddress 5, StreetName 6, County 7, Country tblAddress ID ContactdID PropTypeID...

Assuming QryJson is large and slow, you can calculate all the values in a single pass for each JsonReceived. See my add-on to your original code. You will need to extend it for all your dsum values. ' In module header private Type ValJson A as double B as double C1 as double C2...

Adding a Form_Current event to Mainfrm will create the link Private Sub Form_Current() On Error GoTo errForm_Current With Me.Child31.Form.RecordsetClone .FindFirst "[ProductID] = " & Me.ProductID If .NoMatch Then MsgBox "Unknow Error - No ProductID " &...

It looks like the the 8 "TaxableValue" queries could be handle by a records set and a cross tab query. [TaxClassA] in A, B, C1, C2, C3, D, RVAT, E DSum("TaxableValue", "QryJson", "[InvoiceID] =" & Me.txtJsonReceived & "And [TaxClassA] = 'A'") DSum("TaxableValue", "QryJson", "[InvoiceID] =" &...

Sounds like Zero Trust being implement like requiring password changes every few months. Uses could not remember the current password so they wrote it down and stuck it to the monitor.

Move the load event to the main form. Private Sub Form_Load() On Error GoTo errForm_Load If Me.OpenArgs & "" = "" Then 'Dont need to go any record Else With Me.RecordsetClone .FindFirst "[ProductID] = " & CLng(Me.OpenArgs) If .NoMatch Then...

FormA attemps to load FormX which does not exist. Opening MainFrm ' DoCmd.OpenForm "FormX", , , , , , Combo0 & "" DoCmd.OpenForm "MainFrm", , , , , , Combo0 & "" SubForm Form_Current attempts to search the "MainFrm" recordset after searching in the sub. Why not link in main and search in...

IMO It will take less time to normalize the raw data than to figure out how to do the link. You could use a temp table for the normalization pass if you don't want to save the corrected data.

I use public user defined form properties for external reference. It has the added benefit of typed returns and pre-formatting.

New Outlook is never really gone.:devilish: It looks like a 365 issue where Teams is updated but Outlook was not. I always thought teams behaved differently then the rest of Office365. I think it is updated independently of Office, ignoring you update channel settings. How can It be using an...

I also had a non-normalized field like yours giving me the same problems. The fix is to add the new detail tables for the zip code keeping the original form controls but detached. In the on current event, fill that control. In the after update event, update your normalized table. The user will...