Recent content by Malcolm17

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 =...

Sorry, I have been playing with this for 10 or so years and I'm learning all sorts of new things tonight How do I Debug.print strSql? I have a new problem, I have it updating and working with the following code, we are just sticking on the last part now (Reloading the Subform, I'm assuming...

I tried single quotes and I get a couple of errors - am I putting them in the right places? strSQL = " UPDATE tbl_Net_Checklists SET CatOrder = " & Forms!frmBackground!subfrmChecklists!txtCatOrder strSQL = strSQL & " WHERE Checklist = " &...

Hi Pat, whilst I don't disagree with you, I was just trying to avoid a second table just for a sort order on what is going to be a really small table. While working with your code Minty, I have run in to to a small problem. I get an error message: Run-time Error 3075: Syntax error (missing...

Is is a subform, when you say Unload and Store the SQL Statement, what do you mean by that? I have just been making subforms visible and not, is there a line of code I can use to unload then reload? Would I just copy the data that I need to use to make visible and requery to the main form...

It would make sense because I am changing what I am displaying on the form. How would I go about changing the values that are on the form please? Form looks like this below, so with this data the 5 would change for all First Floor and 90 would change for all Second Floor

Hi, I have a continuous form that I use to filter out checklist items, I am looking to change my category number for each category\heading when I update one of the textboxes on my form, so all other textboxes with the same heading will be the same, I am using the following code however I then...

Fabulous, I have been looking at it for hours - turned out to be an issue with the bound column. Thank you, Malcolm