Search results for query: *

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

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

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 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 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 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 Everyone, I've embarked on using a data access page for users to edit some information of a database. I have the page accepting input OK but when you hit enter the cursor doesn't move to the next tabbed field but tries to create a new line in the current field. If you hit the tab button...

Hi Everyone, I have the following query: SELECT tblJobCardProcesses.jobCardRef FROM tblJobCardProcesses WHERE (((tblJobCardProcesses.workcentreStop) Is Null)) OR (((tblJobCardProcesses.workcentreStop) Is Not Null)) GROUP BY tblJobCardProcesses.jobCardRef HAVING (((Sum(CLng([stage])))=5)) OR...

Hi Everyone, I have a report that I am trying to convert into a form. Since I can't group in a form I have a main form and a subform with each of the line records. I want to display the records the same way the report would, so in an ideal world I would set the main form to a continuous form...

Hi Everyone, I have a report that I use to print labels for about 100 products. There are 6 labels per page but I need a different number of labels for each product. The label details and the number of labels per product are stored in a table which I have been using as a source of the report...

Hi Everyone, I'm trying to get some code to run whenever a report is printed. The report is previewed first and then the user prints the report. I want to run a bit of code to confirm that it has physically been printed and not just previewed. However, when I put the code in the Detail_Print...

Hi Everyone, I'm using the code to get a variable that can be used in the criteria of a query. My problem is how its evaluated in the query i.e. I'm trying to build a criteria expression like ' "MCR" or "HL" ' but the query is seeing it as ' "MCR OR HL" ' . Is there some way to pull the "OR"...

Dear all, I have a continuous subreport in a report that has 4 text boxes per record. I have each of the text boxes set to cangrow = yes and canshrink = yes. All boxes are memo fields and depending on the contect txtBox1 may be taller than txtbox2 or visa versa etc. I was hoping to be able to...

Dear All, I understand the concept of late binding when dealing with references in MS Office but I'm not sure whether I'm doing it correctly. I've been using the following code in Excel to make an "email" button work correctly and different people have differnt office versions etc. Here's part...

Hi Everyone, I've got stuck on something I'm sure is relatively easy. I want to filter a form on opening to display a record only if the record has values in its subform? I hope that makes sense? For example I only want to display a sales header if there are items on the sales line. I don't...

Hi Everyone, I have a spreadsheet which uses DTpicker for people to select dates from a calender. On some peoples pc the control doesn't work and just comes up with an "X" even though they have they same version of Excel and same service packs. I've noticed that the people with the problems...

Hi Everyone, I have a spreadsheet that many users use that saves and emails automatically when a button is click. I use the following to save a copy of the spreadsheet: ActiveWorkbook.SaveAs ("C:\FD " & strDate & " " & strDepot) But I've noticed that afterwards if i open a new spreadsheet and...

Hi everyone, Normally if i was emailing a report I would use the following code to send a snapshot of it: ------------------------------------------------ DoCmd.SendObject acSendReport, "rptPurchaseOrder", acFormatSNP, strTo, strCC, , strSubject, strMessage...