Recent content by lone_rider15

Hello! I hope everyone is doing great. I have an unbound form shown below. I have added a subroutine to the form's on load event to fill up the controls from an ADO record set. Once the necessary changes are made, the record is updated by the "Complete" button click. Trying to achieve...

Hi, I have a function for password hashing. I took the function from https://access-programmers.co.uk/forums/showthread.php?t=172530 Public Const Salt As Long = 543211234 Public Function Encrypt(strIn As String) As String Dim strChr As String Dim i As Integer For i = 1 To...

In production environment it worked fine however it is. I didn't have to change anything. Than you all for the help.

Thanks! Problem solved.

Thank you for looking into this. The record gets loaded within a second when the form loads. There are 100K records in the table. But only 3000 meet the criteria to get loaded. The records are already in the table but I run an update query to change "AuditStatus" field value to "Assigned" and...

Background: I have an application with back end SQL Server 2014 and front end in Access. In the attached screenshot I am on the “Begin Review” form. The record source of the form is a linked table. The record comes in review if the “Audit Status” field value is “Assigned”. The “Complete” button...

I have added the space. With CurrentDb.QueryDefs("qryMyPass") .SQL = "EXEC spAddressMissingQue '" & [Forms]![frmLogin]![txtUserId] & "'" .Execute End With But still no luck. Same error.

The error message is - Run-time error '3146': ODBC --call failed. Then I click "Debug" and ".Execute" gets highlighted. txtUserId is a text field type in my table. Thanks for looking into this.

Hello everyone, I have an Access Application with SQL server as back end. I am trying to call a stored procedure from Access. Below is my code. Private Sub AssignReview() Dim rst As Object Set rst = Me.RecordsetClone Me.Requery If rst.EOF Or rst.RecordCount = 0 Then...

Quote: When the user logs off it'll make his assigned record's audit status "Check" so that it can be assigned to another user. I'm sorry, I completely forgot to mention that I did not make this happen to get a user's assigned record's audit status "Check" while logging off. I...

But now I see another problem. If I log off from the database while working on a record and log back in and complete the record, I do not get another record until I move to another form and back to "Begin Review":banghead:. How can I solve this? Thanks in advance.

I got the idea of RecordLocks Property. If I set the RecordLocks Property to Edited Record, I guess my qrySelectToAssign will get locked since a page of records will be locked and qrySelectToAssign will try to select 1 record from top. How do I tell programmatically to look for the first record...

Thank you sir. That code solved the first problem. Yes, I am aware of splitting the database. Can you please tell me a bit more about the "Record Locks"? How should I proceed to solve the second problem?

I have created a query "qrySelectToAssign" and then another update query to assign the selected record to the user. SELECT TOP 1 tblInquiries.InquiryMatchId, tblInquiries.AuditStatus, tblInquiries.AssignedTo FROM tblInquiries WHERE (((tblInquiries.AuditStatus)="Check") AND...

The user gets assigned one record from all records which is marked "Check". May be the first in the queue or last. I'm open to any suggestions. Thanks again.