Search results

Thank you for this gem tip nigel! I am ultra poor in all things related with "networking" so this will be a big help to me if i can make it work! :)

Cool access 2010 article banana! thanks for sharing it. Makes access fans like us really excited about it. Whoa! i really didn't know access is one of the best front end out there. I only thought that the reason why so many uses access is because it's cheaper and easier to learn plus usually...

Thanks for your suggestions david, atomic and darbid! I'll take a look at vb6.0 and visual c# and compare which is more adaptable for me. My future target is I'll be using SQL server 2008 as backend and then whichever is more easier to connect/integrate well as frontend i'll stick to that...

wow! yes that's something iam looking forward too man. but i heard it's almost the same as 2007 except for some features like the capability to edit ribbons without using third party program anymore or needing to learn xml. Iam not sure though.

Great! I think i'll consider trying php combined with mySQL as my backend. I heard mySQL is easier to learn than sql server so i guess i'll go with that.

we only have 2 computers here and it's not even networked. :o btw, what frontend are you using together with SQL server as your backend?

Thanks for the clarification banana.I appreciate it. Maybe i am not clear on what i really want to learn. All i know is i wanted to broaden my knowledge on relational database programming one that is slightly step above Access 2007 that fits my current needs or situation. i don't want to...

Thanks man! I heard a lot of good things from php it's really really fun they say. But sadly, i think i can't do php now because we have no internet connectivity offered here.

Hi bob and thanks for suggesting! I'd like to know if the program above requires internet to harness it's power because if it does, it's unfortunate for me because i don't have internet connection here. Place is kinda far from modern world. So basically, i am looking at using the...

Been thinking about this for a few days. I think i want to try to learn new programming language besides Access 2007. Not that i found Access insufficient for my needs, in fact, it's the other way around. Access has been great so far and it's just right for what i need as of the moment. Maybe...

Dmax solution worked! Thank you for your patience bob. rep for you. ^_^

Tried this one but got a compile error: Syntax error I think subqueries cannot be used to update queries? because if i ran this without using a subquery it worked fine. like using SET TotalDays = date() - TransactionDate but my problem is getting the latest payment to be subtracted on the...

i think the quote above between "d" causes a syntax error. so i deleted it. after it compiled well i got this error after executing it. Error 3061 Too Few Parameters. Expected 1

Thanks bob i tried your solution number one adjusted space before AND but it didn't work i have a question with your solution number 2 though. How can i get the maximum date as per my example above using datediff?

Dim strSQL as string strSQL = "UPDATE tblReceivables SET TotalDays = Date() - (SELECT max(PayDate) FROM tblReceivables as rs WHERE tblReceivables.TransactionID = rs.TransactionID) WHERE TransactionID = " & me.TransactionID & _ "And Active = -1" Currentdb.execute strSQL The code above...

Oh i see! I remember i have this lngTrankey an autonumber Key ID which i extracted from a recordset. I was puzzled, because i know it's already been extracted but somehow i still can't use that key ID. So i thought i was doing it wrong. I just didn't continue that code because i thought iam not...

Thanks for this tip banana. As for that .Bookmark = .LastModified I don't know how that actually works. I tried adding it to my code and it just worked the same as not having to put it. So maybe there's a special purpose for that.

Thanks banana. Iam actually using the .FindPrevious as of the moment because i encountered an error when using .MovePrevious earlier. Specifically, when there is no datepaid value found(if client has not yet paid). so with .findprevious it sort of made sure that there is an existing value before...

David and Adam, Thanks a lot guys, I tried both of your suggestions and it worked great. By the way, I also tried.. dim rs as recordset set rs=currentdb.openrecordset("tablename", dbopendynaset) with rs .movelast rs.findprevious "TransactionID = " & me.TransactionID...

I know that: DMin("DatePaid","tblTransactions","TranID = " & me.TranID) -This will give me the first payment date from tbltransactions based on form's TransactionID. DMax("DatePaid","tblTransactions","TranID = " & me.TranID) -This will give me the last payment date from...