Search results

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.

Sir, I can't thank you enough for your help. Without your help I couldn't have come so far with this. I have created a navigation form that will load with Dashboard open. In Dashboard in a report I marked the dates from which samples have been picked. So I won't pick samples more than once for...

The data in the table "tblInquiries" are the population and the sample 5% will also be there but "AuditStatus" field will be "Check". I took a sample for the first user (b_d_amtanna") only. The user has 257 inquiries. Out of these 117 are "II" SearchType and 140 are "MI" SearchType. So the...

Thank you for your valuable input. I have decided to go with a single table for the data. I was able to get 5% sample for a user in a day. In a day there might be 30 to 100 users for which I have to run the query. And for each user the query has to run twice based on 2 criteria. So for a day the...

I have added another table for Error Details. Created a relationship Created a from with master and child Child ProfileId does not update and the record set is not updateable as well. Can anyone please take a look into my database? Thanks in advance.

This table is actually a log users keep what they work everyday. They get below fields from somewhere else. ProfileName, ProfileId, NumberOfEvents, EntityId, RequeueReason, Notes ReviewedBy and ReviewDate are for tracking who and when entered the data into this database. ProfileId-- can't be...