Search results

  1. L

    Unbound form: Update a record and get another record

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

    Decryption SHA1

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

    Application stays busy 30 seconds after running a Stored Procedure

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

    Running a stored procedure from Access Front end

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

    Quality Check Database Design

    Hello Everyone, I have a table with following fields. ID, ProfileName, ProfileId, NumberOfEvents, EntityId, RequeueReason, Notes, ReviewedBy, ReviewDate I want to develop a process for quality check. Where I would need following fields. ProfileName, ProfileId,NumberOfEvents, ReviewedBy...
  6. L

    Create a data entry form for time duration (hhh:mm:ss)

    Hello Everyone, I have an Access Application front end with SQL 2014 Enterprise as back end. I would like to add some tables and forms for my teams daily statement. There are 8 teams. Team sizes ranging from 2 to 64. So their daily target hours are different. Table structure will be same for...
  7. L

    Row total based on criteria in Cross Tab Query

    Hello Everyone, Is there any way to get row total based on criteria in a cross tab query? I am using MS Access 2013. I created a cross tab query. I need seven column with row count based on some criteria. I created 7 queries with the criteria. When I join them all with cross tab query it does...
  8. L

    Create a query table name from combobox

    Hello Everyone, I have 7 tables named with 7 days of week but has same data structure. I can't put them all in a single table because for example in Monday (22/11/16)'s file I have data from Sunday(20/11/16) and Monday (21/11/16), On Tuesday's file I have data from Tuesday (22/11/16) and Monday...
  9. L

    Hello from Bangladesh

    Hi, I started playing with Access 6 months earlier. I learned everything I know about Access from web. I have read many posts of this forum to get started with my project. I have built an application for my team of around 200 members. Thanks to everyone whose posts, blogs and YouTube videos...
Back
Top Bottom