Search results

Hi Minty tried that suggestion but still the same. arnelgp, the field1 is date and time and records data as 25/09/2018 11:14:52 When the query is run field1 gives the hour that the passes are totalled to thanks again

Hi Ranman256 i tried using that new format in the pass query and it no longer gave me passes to the hour it just lumped all passes in 0 hour. hi arnelgp, after trying that code , i got a dialogue box stating that the expression you entered contains invalid syntax. thnaks for the replies

HI, Im trying to use some data i store in a database to give me running percentage yields to hours . What i have is a bit flaky. the code sometimes works and sometimes doesnt and when it does it doesnt tansfer to the report. The part i thnk i have the problem with is on the join in the query...

Again thanks for taking the time to feedback on the code. The field names aren't named yet as there hasn't been a decision made on the data being fed in(the data is brought in by a form that searches network locations and loads it into a table...it works for me but the coding would probably give...

Hi pat thanks for the tips on tidying the code up , is this the difference you mean? SELECT (Count(*)) AS [Fail Count], Left([Field12],25) AS [Fail Desc], JasJnrF2.Field8 FROM JasJnrF2 WHERE (((JasJnrF2.DateIn) Between (Forms![frmweekno]![Text14]-1+#12/30/1899 8:0:0#) And...

Well spotted static , running fine now..thanks

Hi JHB I tried adding in the space but still getting a fail. I've attached a screenshot as suggested by mark which shows the SQL at runtime. Thanks for the other tips, the fields will be renamed once the fields are agreed just now i'm just trying to get the code to work before adding it into...

hi, you've lost me. I've shown you everything for the strSQL. This string creates a query called qryPareto which is used as part of the report info

strSQL = "SELECT (Count(*)) AS [Fail Count], Left([Field4],25) AS [Fail Desc], JassnrF1.field3 AS Status " & _ "FROM JassnrF1 " & _ "WHERE (((JassnrF1.DateIn) BETWEEN #" & Msgstart & "# AND #" & Msgend & "#" & _ "GROUP BY Left([Field4],25), JassnrF1.field3 " & _ "HAVING (((JassnrF1.field3) Like...

heres a screenshot

Hi Ranman I tried adding the asterix but im still getting the error.. "HAVING (((JassnrF1.field3) Like 'fail*')) " & _

hello, im looking to seek some help in trying to locate an error (syntax error 3075 missing operator) that comes up when I try to run a SQL string in VBA. the problem looks to be the variables I am using in the string as it runs ok if I hard code in a date. The code takes a week number from a...

Hi JHB, id thought about the boolean angle, but i had wanted to try and flush the error to prevent it being flagged again(my thinking is if it keeps on flagging an error there's a problem that hasnt reset). My other concern is that the error mail doesnt indicate what text file has errored...

Hi Dave, yes the text files are being written to continually as they are updated evertime a unit passes, so should be every couple of minutes. The vba code runs pulls the text file in every three minutes and every so ofen an error occurs. thanks ian

Hi, My aim is to import text files from a server and put them in an access database, the code I have works for this task, but occasionally there are file read and write errors due to the text files being accessed at the time they’re being written by a labview app. This results in a message box...