Search results

Thanks for the link dbguy i had tried this but had an error 91 object variable or with block variable not set at this line so thought i was missing something and was trying a different approach to manually enter the file and then try and insert it in under criteria Instantiate the parent...

Hi All, Hope all is well. Im trying to add an object selected from a dialog box into an attachment box on a form with the intention of then saving the object to the attachment field in the table. Ive read this isnt the thing to do, but im trying it for two purposes (1) I don't trust the few...

That's perfect arnelgp i had been looking at https://www.techonthenet.com/access/functions/domain/dsum.php, i appreciate your time on this , it makes a difference how code should be written instead of the patchwork i do. thanks again

thanks minty ill have a look

Hi mike its the pass and fail fields columns 6 and 7...the first columns of pass and fail are just the totals for that hour the second set is the cumulative totals

Hi, Could someone point me in the right direction here. From a query I've made a report that works ok and gives the relevant data. see below as you can see the pass and fail columns in the current total sum as new data is passed each hour using the the report function ..Running sum > over...

arnelgp, do you mean replacing Datepart("h",Timevalue(Format([field1],"00\:00\:00"))) as HourVal with Hour([field1]) As HourVal i thought the field data had to be formatted as the time is in the format 143612

Boom, used the code below and it looks to be coming up with the correct query results. I had written this query a while back and to be fair i was a bit fuzzy how it came together. I was just surprised it worked but couldn't edit it as it just locked up with the error i first stated...

Thanks for that , it works but doesn't sum the passes fails now for each hour just gives 1 for each timestamp. new code below and ive included before and after pics of the result change . The format just really has to pull the hour from the result and not the full time. SELECT...

Hi minty thanks for the quick response, will this code work for the data in field1 if the text is just unformatted text ie in the format 110845 where 11 is the hr 08 mins 45 secs ?

Hi all, hope all is well. Im putting together a new database to work out passes and fails an hour and resultant percentage yield and i've got a couple of quandaries just now im hoping someone more enlightened can pick up. The code seems to work and produce the desired results, but if i try to...

Hi moke123, i initially had the spreadsheet open by clicking a button on the form and this could be saved on the hard drive , the users then said they wanted it all on the one page to keep everything accessible and visible. Its getting used for quality audits .I've been given another to try so...

hi moke123, the spreadsheet that gets attached is on a server, i only put a snippet of the absolute path that is used.

Thanks to all for the info im trying to get more of an understanding of databases/sql/vba from the ground up, arnelgp ill try the new table idea for next db. The code i got working is below. Dim rsfile As Recordset Dim rps As String Dim sql As String rps = Me.Text191.Value sql = "select *...

ok thanks, the database shouldn't be getting too much info entered and i thought this method was more efficient as the user only has to add the attachment if required

HI Moke123...is there an issue using vba to insert an attachment?

i just saw the bottom part of your answer.....ooops thanks

Hi anrnelgp, thanks that works. It doesn't seem to update the way i thought as it only updates the first record in the table no matter if i open a new form. Probably have to look at updating the table by the record ID....thanks again

Hi, hope all is well. I'm trying to add a button to an access form that will add a more frequently used attachment to a table. I'm getting the following error . Run time error 3852 cannot update a multivalued field if its parent recordset is not in edit mode. To place the parent recordset in...

nicely done, that works well. Thanks a lot for that id hit a brick wall there