Recent content by distinky

my mistake for not explaining in depth what im trying to do. at the moment im currently trying to create a work flow type of thing. im quite new to all of this with SQL, VBA etc. what ive done so far is a registry for employees, so we put in their name and job title etc, then we assign tasks to...

the table will be used to display information like a log, that then will be used to generate a report.

hi all, im wanting to create a macro that uses two append queries from two seperate tables to then generate a table with the information combined does anyone know how to do this?

hi, so ive created two append queries, one is called 'task_create_header' which when a report is generated it notes the employee, task date, start date, task id and the job type. the other one is called 'task_create_detail,' which brings over the job Id from 'task_create_header.' im wanting to...

i do have a 'add new' record as button and im not sure if that is a issue too. Private Sub Add_new_Click() DoCmd.GoToRecord , , acNewRec Me!Division_Combo.Enabled = True Me!Location_Combo.Enabled = True Me!Department_Combo.Enabled = True Me!Job_Combo.Enabled = True End Sub im a newbie...

hi, ive had a look at the form properties and its still not what im aiming for. ive been messing with code so on my Save button it has Private Sub Save_Record_Click() DoCmd.RunCommand acCmdSaveRecord Me!Division_Combo.Enabled = False Me!Location_Combo.Enabled = False...

hi, my main form is called Task_form and i have 5 other subforms under it. Also, the main form consists of 4 combo boxes. im wanting to be able to input data and afterwards saving it so then it cannot be modified. then i want a button that can allow you to update the data. thanks (: