Search results

works fine thanks

Once I have selected the value I need from a combo box I want it to go back to being blank - how do I do this.

I have this really silly problem that is very annoying. When I try to view or preview a report it is positioned in the top left had corner of the screen and it is so small that I cannoth access it. I have tried changing the X and Y coordinates and autoresize and saving it when I have it in the...

I'm now getting a type mismatch error on this code - where is the problem? rstCTD.Find "drawingid=" & MyDrawid MyCTD = DMax("CTD_number", "tbldrawings", "drawingid=" & MyDrawid) + 1 When I am doing this CTD_Number is "NCTD" and I want to change it to the next no in the sequence

I'm now getting a type mismatch error on this code - where is the problem? rstCTD.Find "drawingid=" & MyDrawid MyCTD = DMax("CTD_number", "tbldrawings", "drawingid=" & MyDrawid) + 1

Got it thanks

Can anyone tell me why this code keeps giving me the "line" value for the first rec in the recordset not for the one I have just found using rstQuote.Find rstquote.Find "id=" & Myid MyLineNo = DMax("line", "tblnquote_d", rstquote!line) + 1

Make sure the data in the mainform is saved before you move on to the tab to enable you to passon the id field automatically.

Rich This doesn't work I'm afraid. I'm getting the error method or data member not found

going from quote to estimate to contract etc just picking bits and pieces from multiple tables to make new rec in other table. Mostly id's etc that get passed to allow links to other tables. I'll try that.

what condition would I need to check for

Don't know if this can be done or not but hopefully somebody can help. I have a continuous form with a select button on it that puts the data from that record into another form and table. I would like to be able to show that I have selected that record by either changing colour or something like...

I have a similar problem with subreports except I don't have a group by. Any ideas ?

The report is main up of data from 4 tables all linked by id. I have it grouped by id and have data in the header then in the page footer I have 3 subreports. I had to put then in the footer to suppress duplicates.

yes they are all linked but they need to be that's the whole purpose of using a sub report isn't it.

I have it working excpet 24hours is shown as 00:00 which I know it is but I need to show 24:00

I have just created a report with 3 sub reports and I have a big problem with it. 1. Unless there is data for all three subreports I get no data at all. I need help !

I have a calculated field that gives me 1.333333 hours how do I convert this into 1.20mins ? Here is the code I have tried : SELECT EDATE, EMPLOYEE, OPERATION, DOWNREASON, JOB_ID, SUM(SETTINGH * 60 + SETTINGM) / 60 AS Setup, SUM(RUNNINHH * 60 + RUNNINGM)/ 60 AS Run, SUM(DOWNHOURS * 60 +...

Looks like this is a toughie. Having posted on multiple forums and I still have no answer. One more plea for help as I must get this working

Hi I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all works fine. My problem is that once I choose a record and look at it on the...