Recent content by Malcolm17

I went with this for now :) If [cboEarlyDutyManagerActive] = "Yes" And [cboEarlyDutyManagerStatus] = "Waiting" And [cboEarlyDutyManagerHour] = Val([txtNowHour]) And [cboEarlyDutyManagerMinute] = Val(txtNowMinute) Then Then the next line I change the Status to Running I run the Process for...

Hi All, Much appreciated, thank you. I have gone with Gasman's solution for now - I appreciate the help from everyone tho. Thank you, Malcolm

Fabulous, thank you for that :) I will hopefully sort that problem my getting it to change the status before it does anything else and then they will all be updated again at midnight for the following days tasks to run. Thanks again.

Hi Gasman, nested Ifs wasn't the plan, I moved them around when I was trying to make it work - do you know where I am going wrong with the timing issues please? Pat, thank you - do you have a link? Thank you

Hello, I am trying to build an automated task scheduler for my system where every day it will run a report at the selected time each day, or run some process. Currently I have a few small access databases running in windows task scheduler that open, run whatever then close - works well...

Hi all, Thank you both for your help, Sonic8 thats exactly what I needed - thank you!! :)

Hello, I am trying to update a field in a table, the field to update is variable based upon what the user selects on a form, but the field to update is created in a textbox - its a mixture of the day of the week selected and the name of the field to update, so at the moment I am trying to...

Fabulous! That worked, thank you :)

Hello, I have created a query from 7 other queries; each one sums the data from a day by product and then it shows it on a 8th query where all the products are displayed with the daily\weekly\date periods selected from a form. - Not really explaining it well I know, its like a Crosstab query...

Brilliant, thank you all for your suggestions. Isladogs I think this might be my best bet, I'll give all a go tho. Many thanks, Malcolm

Hi Gasman, Thank you I have tried that but sadly the till system doesn't recognise the accdb file, only mdb. When it is collecting sales etc it looks to put it in to a file called (eg.) Sales.mdb Malcolm

Hey All, I am trying to link to my data in a very old system (Total Control Till System) to my accdb database. I used to be able to use Windows 7 and MS Access 2007, however I am looking to use MS Access on Office 365 as I use for other databases as my old computer has died. I can probably...

Sorry I'm not sure what you mean by container? The main form is called frmBackGround the subform is called subfrmMaintenance and the combo that I would like to get focus is called cbxRoomSelect Nothing happens. There is no error or anything. I will have a look at the rest of the code...

Hello, Please can you help, I feel like I am missing something simple here. I am trying to click a button on a main form and then the subform is made visible and a combobox gets the focus on the subform to type in for a search. I'm using the following code, but what am I missing please...

Fabulous, we have it fixed - thank you all!! :) Code that works is: Dim strSQL As String Dim strSource As String Dim lCatOrder As Long Dim sChecklist As String Dim sCategory As String lCatOrder = Forms!frmBackground!subfrmChecklists!txtCatOrder sChecklist =...