Search results

hi no error message just does not assign (save) thanks shane

hi all right lets get started I have form call frmmasksetup which holds records of the types of masks I have and this contains serial numbers from the masks ETC... I have another form called frmemployee that hold all my employee's detail's name,last ETC now my problem on the frmmasksetup...

Thanks again Gina it worked!!:):) Shane

Wonder Women could you have a look at my thread when you have minute http://www.access-programmers.co.uk/forums/showthread.php?p=1359824#post1359824 thanks in advance shane

yes it using primary key from the sub form to make the link it bound to tblplantservice see my attachment cheers shane

hi all I have three tables see below tblplantitem tblplantgroup tblplantservice so I have frm called frmplant which holds the plantgroupname I.E plant type (airblow,leads) then I have subform call plantitemtblsubform which holds the plant item serial number, value...

Thanks!!!!!!!!!! Gina Works Great!!! sorry if i have been bugging you to death!!!!! Thanks again Shane

right there error message See Pic. im getting it because it doesnt seem to be generating the "temp" Query it will only work if i make query call it exposure Grapth1 but does not filter the id it just copy over the query i generate manually thanks Again Shane

thanks, gina thats not my database. Mine Called "Database trail " or was i ment to be look at this one cheers shane

hi it still exporting all the records e.g my trail database has 2 employee's the id's are 1 and 2 say i'm on employee 1 i only want to export the date linked on the exposure records that are linked to employee 1 but it still exporting all exposure record of all employee's thanks again shane

right I have manage to get it to work :):) BUT! its still export the whole query not filtering by employee. id I'm on I have attach a strip down version of my database so you all can have a look see if you can make out what's going wrong thanks again you all have been so helpful :):)...

so would qryDef be Dim qryDef As String cheers shane

thanks I have now put the sql in place but still getting error run time 424 object required here the code now Private Sub Command77_Click() Dim strSQL As String strSQL = "SELECT tblemployee.employeeId, tblExposure.Dateexposure, [Valuef/cm]*[Durationofexposure] AS...

sorry but im very very lost havent got clue with sql so your saying the problem is WHERE Statement is after the group by so would my where statement be WHERE = strwhere then I guess it would then look @ the WHERE Statatment First to be honsest I m way above my head now don't no where...

cheers namliam for the tip im still getting run time error 424 can t see why, error line is in red Private Sub test_Click() Dim strSQL As String strSQL = "SELECT tblemployee.employeeId, tblExposure.Dateexposure, [Valuef/cm]*[Durationofexposure] AS [Total Ex]...

right here my sql SELECT tblemployee.employeeId, tblExposure.Dateexposure, [Valuef/cm]*[Durationofexposure] AS [Total Ex], tblExposure.[Low ex] AS Expr1 FROM tblExposure INNER JOIN tblemployee ON tblExposure.ID = tblemployee.ID GROUP BY tblemployee.employeeId, tblExposure.Dateexposure...

right I have put the code on my command button see below Dim strSQL As String strSQL = "SELECT tblemployee.employeeId, tblExposure.Dateexposure, [Valuef/cm]*[Durationofexposure] AS [Total Ex], tblemployee.firstname, tblemployee.lastname FROM tblExposure INNER JOIN tblemployee ON...

thanks Gina! right I have found the problem the command button is on my sub form called frmexposure on a tab on my main form frmemployee yes the only parameter it requires to run is employeeid from frmemployee [Forms]![frmemployee]![employeeId] this is in the criteria but both forms are...

right I have put the code from post #7 from namliam post in to module in access http://www.access-programmers.co.uk/...d.php?t=259994 im calling it from access using SaveQueriesToExcel "C:\Users\Dell\Documents\Exposure Grapth - Copy.xlsm", "Excel Exposure Grapth" but im getting error...

Thanks Guys I will post back how I got on Thanks again Shane