Search results

Thanks moke123, i hadn't thought of that.

It was something i was trying to work out initially it was just a query that a report called and I had it at a default of 10. Then tried to see if I could make it more flexible and tried the QueryDef. The code now sits on a standalone mode and is called from the button on the form . I didn't...

HI , i doubled up on the double quotes and it seems to work, is this the proper way to do this in this situation?

i think its to do with the double quotes? when i change " HAVING(((qryFailcode.[fail code]) <> "") to " HAVING(((qryFailcode.[fail code]) <> '') The error goes but still doesn't produce a query

Hi Moke sorry i used the wrong version there i sent the the code without the parameter being used. Gasman i tried the quotesto but no joy ive attached the fail i now get at the error handler. thanks all

HI Guys thanks for the replies, i modified the handler code to Error_Handler: strMsg = Err.Number & vbCrLf & Err.Description MsgBox (strMsg) ' sModName & "/CreateQry", _ ' , True Resume Error_Handler_Exit and it gave a 3075 error in the string code [/CODE]

Hi, hope all is well. I was trying to extend a query that I had for getting the top 10 results by making the selection variable i.e. top 3 top 7 . The only way i could see to dit was taking the query and using QueryDef and VBA to run a module that would allow the SQL to be modified reading from...

Hi , thanks to both to you for your time, when i sifted through the data after the first query to find the days open i noticed the last two entries didn't have a removed date entered and there were to error entries the the days column., looks like that didnt help. Noticed also two Days values...

Hi CJ_London, thanks for the reply i tried the above and still get a data mismatch.

Hi Hope all is well, I'm hoping someone can give me an explanation please to what I'm doing wrong here. I've got a query that I was using to calculate the days open on an unclosed entry. I then found a database from pat hartman that excluded weekends...

Hi Arnelgp, with regard to the query2 SELECT TimeValue(DateAdd("n",[num]*30,"1/1/1899 7:00")) AS [Time] FROM tblNumbers WHERE (((DateAdd("n",[num]*30,"1/1/1899 7:00"))<"1/2/1899")); I was trying to figure out without success how to filter out the full hours that have had the x mins added to...

MajP, arnelP,Thanks to both of for the time and expertise here. MajP that was a great explanation of breaking down the queries and being able to use the range, answers what i was thinking about next if the hours monitored weren't in a uniform standard eg between 8 and 9 am then 9:45 am and...

HI Thanks again for the reply MajP, That is a better way of getting the data . I don't think I've explained too well what I was trying to do. In the original query I pull a variable called HourVal and this field from the query is used on a form that shows fails and passes for that hour, but...

Hi GPGeorge, I was just replying there and you beat me. They're entry times brought in from a text file . MajP, Thanks for the reply. That adds the 30 mins but I'm tying to group the the first column by the time specified, as in the screenshot the hours between 7 and 8 yields 10 then between 8...

HI, Hope all is well. I have a query that is fine if I was to use the start and stop times on the hour, I'm trying to learn a bit more and try some changes so I've been trying to alter it to try and stop and start at separate times e.g. instead of between 7am to 8am trying 7:30am and 8:30am. The...

Hi Gasman and Eugene-LS for the replies. After gasman saying to try DateAdd i found this code Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Number As Integer Dim Msg As String IntervalType = "d" ' "m" specifies months as interval. FirstDate = InputBox("Enter a...

Hi, Hope all is well. I was wondering if someone could help me out with a date formatting issue I have. I've been using a bit of code for date formatting and now that I'm trying to use it to find the previous date I think I'm doing something wrong. Dim DT3 As String DoCmd.SetWarnings False...

Thanks arnelgp, that looks to give me the combined data on the chart I was looking for , I was trying to find a way to add two series and got well confused in the process with modern charts and wasn't sure it could be done on modern charts. Thanks also June7 the overlay transparency idea has...

Hi All, hope all is good. I have a question I cant seem to get an answer on and I was wondering if it is possible . I've attached two charts I produce on a database showing cases still open and cases closed. My question is can I combine the two charts into one and keep the formatting i.e. closed...

It did thanks