Search results

I have a select query within which I want to add a calculated query (Expr1 below), that uses another calculated query (Kgm below) in it's expression. I have set the format of Kgm in the query to fixed and limited it to two decimal places. The problem I'm having is that Access isn't...

I would be really interested to gauge peoples interest/views on this topic. Food miles is a concept currently being batted around to try and represent the amount of transport that goes into a food product to get it into. The idea is that this approximates the carbon burnt and therefore global...

Does anyone know why Microsoft sometimes use such complex Help examples? Often I find the example code in which they have demonstrated a function is so complex, I can't see the wood for the trees. I thought a basic maxim of teaching was to demonstrate a principle in the simplest way possible?

I have a form that opens a query, a comob box on the form restricts records included in the query, to the department selected. E.g if I select "GradingRoom" only records for employees who work in the grading room will be included. The list of available departments is in a table which does not...

I am trying to speed up a data entry form, by adding input masks and autotabs. Box1 is a text code made up of two required letters followed by two required digits. The underlying feild is a text field, the field list surce ins a text field in another table I am using LL00 as the input mask...

Hi, Can anyone see what the syntax error in filter criteria in this code is? If CurrentProject.AllForms("TrainingRecs").IsLoaded Then Me.Filter = "Total Name =" & "'" & Forms![TrainingRecs]![TotalName] & "'" ElseIf CurrentProject.AllForms("ReportTrainee").IsLoaded Then Me.Filter = "Total...

Hi, I have a report which contains employee training records. It is set to only show records for one employee at a time via a criteria in the name field in the reports underlying query. (We use the printed report as an annual training record signed by employee and trainer). There are three...

Hi, I have a form which shows training information for employees. The main form shows the individual's details - name, job etc. The subform shows the various training courses the person has completed, and the level of competency attained for each. I want to prevent users from...

I am fairly new to developing with Access. I would really value some advice on changing text direction in crosstab query column labels. I have just created a crosstab query to function as a training matrix. It has rather long column labels (there are good practical reasons for this), which...