Search results

Dear all, I am trying to add a new record to a table by code (first time - quite excited). Here is the code: Dim Rst As Recordset Set Rst = CurrentDb.OpenRecordset("Tbl_MTR_Development_Testing_Detail") Rst.AddNew Rst!MTR = Me.MTR.Value Rst!Detail_Date = Date...

I am opening up a Form (Form2) based on data in Form1. When the user closes Form2, I wish a Yes/No field in the record on Form1 to be updated. I am receiving an error message: Run-Time error '7878' The data has been changed. Here is the code for closing Form2: DoCmd.DoMenuItem acFormBar...

Hello all. I am getting a data type mismatch error when I run the following code to pick up [Email] from a table "Tbl_Name" once a a piece of work has been allocated to a developer. Private Sub Cmd_E_mail_Allocate_Click() Dim SetName As Integer Dim GetEmail As Variant If...

Hello all I am having a few ideas about a new database, and one of the issues I've encountered has perplexed me. How would I calculate the number of days elapsed between [Date_work_assigned] and [Date_Work_Completed] but excluding Weekend days. Withnail

Hello again Once a user logs on to my database, they initalise a variable called Current_User. This will be their full name. In another part of the database, certain pieces of work are allocated to the various users by their manager. This is done by selecting a name from a drop-down menu. The...

Hello all. I've got a feeling this could be extremely easy to answer, but here goes. How do I open up a form displaying data where the UniqueID of the record matches a variable? I have a global variable MyUserNameIdentifier (stored as an Integer) which is the UniqueID of the user once he/she...