Search results for query: *

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

Hi Everyone, I posted this on the forms forum but I think it might be better suited here. I would like to use the mousemove event to move to that record on a continuous form. The reason being so that the tooltip changes to display informatio about that particular record and not just the record...

Hi Everyone, I would like to use the mouseover event to move to that record on a continuous form. The reason being so that the tooltip changes to display informatio about that particular record and not just the record that the cursor is in. Would anyone have any advice? Thanks in advance, GPM

Hi There, I've not been having any success using selstart and sellength with vbscript in Data Access Pages. Could you give me a couple of examples of how I should be using them in DAPs or if you have any other ideas I would really appreciate it. thanks GPM

Hi Everyone, I have what I think is a really simple problem on a DAP that I am developing. I want the cursor to select the existing text when the user tabs into a certain field so that they can just type over it instead of having to delete what is currently in there. I have tried to use the...

Hi, It works!! You must have been right about the embedded control characters because when I repeated the exercise I'd carried out earlier it was finding an error on an allegedly blank line. Once I cleared the line it all worked a treat! Thanks for all your help and all your patience, I...