Recent content by GPM4663

Hi Everyone, Kcmass, I took your advice and started doing some test queries based on what you had given me. I slowly started to build it up, testing it at each change to make sure I was getting results. I ended up with the same query that wouldn't run earlier and it ran perfectly! I don't...

Hi Everyone, Thanks for all you input. I've done some testing and the problem appears to be with LGDOCF. If I change the query to SELECT LGDOCA.UNIQID, Trim([NARR1]) AS ItemComments FROM (LGDOCB INNER JOIN (LGDOCA INNER JOIN LGDOCE ON LGDOCA.UNIQID = LGDOCE.DOCID) ON LGDOCB.DOCID =...

Hi Remou, Thanks for you response, you are correct that all the tables mentioned are linked to another database. They are in fact linked to a parallax database using ODBC. I have checked and rechecked the ODBC settings and they are identical to what I have on my PC. I even went as far as...

Hi Everyone, I have the following query containing a left join: SELECT LGDOCA.UNIQID, Trim([NARR1]) AS ItemComments FROM (LGDOCB INNER JOIN (LGDOCA INNER JOIN LGDOCE ON LGDOCA.UNIQID = LGDOCE.DOCID) ON LGDOCB.DOCID = LGDOCA.UNIQID) LEFT JOIN LGDOCF ON LGDOCA.UNIQID = LGDOCF.DOCID WHERE...

As far as I'm concerned you are both incredibly smart! Misscrf, loved your idea on creating my own msgbox to give me a lot more control over things....I think I might use that in some other places. Aceman, I didn't realise that about the parenthese and when I tested it you were absolutely...

Hi MissCrf, Thanks for your response, I have tried all those things but to no avail. The code won't let me set the popup property of the main form in runtime and changing the value of the subform to modal and then back again does not have any effect. Does it mean anything that everything works...

Hi Everyone, I have a main form and continuous subform with some check boxes on the subform. When the user ticks a check box I use the code below to display a msgbox if there is an issue. However the msgbox displays behind the main form and hence locks out the main form. The main form pop up...

PH you are a genius! That works brilliantly! That has been driving me mad for weeks. I'd been trying all sorts of refresh, requery and repaint to get it to work along with setting the focus from the main form to the subform and back again. I can't thank you enough. A well earned star is a...

Hi Everyone, I have a data capture system for a factory floor which is used to track "Make to Order" jobs and "Make to Stock Jobs". The interface is made up of a main form called "frmMainInput1" and a subform called "subFormProcesses". "subFormProcesses" is unbound until the user enters in the...

Hi Everyone, I have a main form with a tab control in the detail and each page of the tab control holds a subform. I have a print button in the main form to print the screen should the user have a query. The button triggers the following code "DoCmd.RunCommand acCmdPrint" For some reason...

Hi Guys, Thanks for all the input I really appreciate it but I've figured out the problem. I thought I was getting the error because I still had a sequence problem but I realised that when I was stepping through the debugger that the linkchildfields had the value "" before the line to set it to...

Hi MajP, I've tried the code you suggested but on the first line I get the error "Run time error 2101 - the setting you entered isn't valid for this property" I've tried swapping the lines around but it still comes up with the error on the first line where I am trying to set the linkChildFields...

Hi Everyone I have a form with a subform which source object is dependant upon information the user enters. I have set the "Link Master Fields" property to the correct control in the main form and then I use the following code to display the subform Me.subformCard.SourceObject =...

Hi MajP, No problem, I made the initial mistake by posting it in the wrong forum in the first place. I'm just glad Jamaarneen got a chance to see your solution. cheers, GPM

Hi MajP, Thanks for that, I had been playing around with code myself and was trying to do what you have done - your code is a lot neater and slicker. That works a treat, thanks so much for all your help with it, I really appreciate it. Those links are brilliant reading as well. Thanks again, GPM