Search results
-
M
SQl Varbinary(max)/MA Access OLE Object
I am nearing completion of a DB that records employees training that is linked to SQL tables (just a couple of more stages to go). Currently an employee signs a training document stating that they have understood the training received and the trainer signs stating that they are satisfied that... -
M
Solved Display text field on Main Form after text entered on SubForm
I have a main form ‘frmUpdateTraining’ and a sub form ‘subfrmTrainingTimes’ which is a continuous form. On the main form there are (amongst others) 2 fields ‘DateCompleted’ and ‘TrainedBy’ On the sub form there a 3 text fields ‘TrainingDate’, ‘StartTime’ and ‘EndTime’. When a user enters a... -
M
Solved IIF Statement
I am getting myself confused having spent too much time on an IIF statement I have a query where I want to create a column named TrainingStatus and have it filled with either 'Not Trained' or 'In Progress' or 'Trained'. I have used the following but get an error message saying that I have the... -
M
Solved Display name of person logged into DB not computer
I have a DB where various users create records. Before they can do that they need to log into the DB. What I would like to happen is that the person’s name who is actually logged onto the DB to be displayed on a form in a field named ‘SubmittedBy’. I have seen how to display a user who is... -
M
Create a report from a query
Hi, I am trying to open a report that lists all records from a query for a Supplier between 2 dates using a form to input the required parameters. The 3 parameters are; Start Date End Date Supplier These are on the form as unbound fields. In the query I have the following criteria; Date... -
M
Set Command Button Not to Work Unless Certain Fields Contain Data
I have a form where there is a Command Button to e-mail a report. What I would like to happen is that the Command Button will not function unless the Investigation and Root Cause fields on the form have had data entered into them. Command Button is named: View/Send Report First field that I... -
M
2 Forms & 1 Table
Hi, I have a table with 15 fields The first 5 fields are generic (including the KeyID) The next 5 fields relate to a particular scenario and the remaining 5 fields relate to another scenario. I have created 2 forms for the 2 different scenarios with the fist 5 fields being the same. The...