Search results

sorry to bring up an old thread but i was thinking of making more use of the record set function. does If rs.RecordCount <> 0 Then mean that if i set the 0 to 3 then if there is 3 or more records it will trigger the next line. ie. If rs.RecordCount > 2 Then msgbox this client has...

hi jd. i really do appreciate what users do for me on here. after all, 2 years ago i did not know a thing about access never mind vba. you have helped me aswell as paul. i made the comment about the other user as i was quite annoyed. why would he want me to go outside of the forum. the thread...

sorry about lads. paul, the message i am getting is Mouse Down Failed: invalid proceedure call or argument. (vbOK) then on click of ok cannot find the object 'cmdAppointmentRightClick' if 'cmdAppointmentRightClick' is a new macro bla bla bla..... the suggestion of typing the coded...

sorry. who do i make a compliant to about attitudes. i have been on here for almost 2 years and that idiot is going to see the wrong side of me. how the hell does he know that others wont find it interesting. he has 75 posts. unless he has been by another name on here i would suggest he let...

why would i do that.

sorry i was rushing and didnt want it to transfer over to mdb and it not work correctly. ive checked it and i still get the same result in mdb. thanks

i have a major problem with my database. the database is live and i need help quick(if someone can) the problem is easier to explain if you view it. i have added the database. unfortunately it is in 2010 so my help will be limited. on open if you type in s4ut21 into the password screen...

i am wanting to close all forms on timer event. all forms except one. also if any form is dirty then i do not want to even start running the vba. i have seen a thread that gives me the code to close all forms except listed but im not sure about getting access to look at all the forms first...

it wasnt that. it was a though you must not have looked at the images i provided. the two images are clearly different. the record source is what the report runs from. if the record source shows it and the field is in the report the report should show it.

i am aware that a report will not show multiples on Grouping. also if you look at the images you will see that the record source shows more dates. is it not the record source that the report gets its data from and just displays it in a nice way. im sorry but i wanted a serious reply to my thread

i am having a little trouble with a report i am building. i have got all the correct info in the record source and when i view the record source it queries as it should. building the report i added a group for Dates, a group for ClientDetailsID and then the details are whats left. when i...

thanks. it worked like a charm. ill have to remember that debug thing. can i just ask what the .Execute statement is. is it Set rs = CurrentDb.OpenRecordset(strSQL)

also i have put in the Debug.Print strSQL. dont really know how to use it. if the way to use it is to run the code then i get the same error as reported in my last post

just use the sql you provided, i got an error 3122 you tried to execute a query that does not include the specified expression 'tblOrderItemsType.OrderItemsTypeID = 1 AND tblOrdersItems.StartDate Between #06/16/2013# And #06/23/2013#' i also get the error 91 object variable or with...

should there be only 2(( here (((tblEmployeeList.EmployeeListID)

debug, i need to do alot of debugging. bit late to say that i suppose. my database is riddled with little bugs. its a task i will be tackling soon. the full sql SELECT Sum(tblOrdersItems.ActualCost) AS SumOfActualCost FROM tblOrders INNER JOIN (tblEmployeeList INNER JOIN " & _...

i am seriously struggling with this the errors are that too many ) and the 91 object variable or with blaock variable set i have tried to put in the # & " with the dates but every combination i try doesnt work. also i cant seem to find the extra ) anywhere. i spent about 2 hours on this...

is this another way of telling the record set what the sql is. before you had shown me a record set where it looked like the one i did and and this has strSQL = and then it refers to strSQL = to get the sql. i need to get what is a variable nailed down. is a variable something that is in a...

i seem to be having real issues with creating record sets. it started yesterday with an sql that had a date range. i thought that it was something to do with the sql. but then today i am trying something more simple. SELECT tblReportListOptions.ActualReportName AS ChosenReport...

for some reason the sql you put in works. the only thing is that i want to add a date range to it so i used the sql i posted and added a date range. pasted it in and it doesnt like it. whats different? Dim rs As DAO.Recordset On Error GoTo Err_Proc Set rs = CurrentDb.OpenRecordset("SELECT...