Recent content by aquinox

Hi, wondering if anyone might be able to help me here. I'm a beginner to Visual Basic 2005 Express Edition. Initially i thought it would not be much different from VB Application for Access as i'm a bit more comfortable with it now. But because i want to move our database to SQL Server, i...

Hi, wondering if anyone might be able to help me here. In the report, most of the text-boxes have been set with "can grow" properties to "yes". This way, regardless of how long the content of the relevant fields, they would show all the content. If they are too long, then they'd push down...

Thank you PHV, It works now :)

Hi, wondering if anyone might be able to help me here. It may be a trivial question here but I just couldn't solve it. I would like to replace the "return carriage key" with something else but just don't know how to put it into code. In the table, i can see that there are some that look like...

Thank you, PHV It works now. I don't know what i did before. i certainly did try to use requery but it didn't work back then. Anyway, all matters is that it works now. Thank you for your help.

Hi, I have a problem with refreshing a form which has two subforms in it. For example, Form AForm has subform1 and subform2. In the form, there is a button called "Add New". When clicking the button, another form BForm will pop up allowing user to enter relevant fields. What i'd like to happen...

Hi, I was wondering if anyone might be able to help me here. This is what i would like it to happen. I would like to be able to produce PDF out of Access reports as well as naming the file out of the records automatically. For example, When clicking on a button called "Get PDF Reports" on a...

Hi Dhookom, Thank you very much. It works now. Sorry for taking up much of your time to get this resolved because of my poor explanation. You're a legend :) Thank you

Hi Dhookom, Sorry about confusing you with my explanation. Ok, i can explain that. The report has the Record Source coming from a query (which i'm not allowed to touch). In the query, there are a number of fields in there and some of them are the years - 2008/9, 2009/10, etc. In the design...

Hi Dhookom, I found that in the event of sub Report_Open as follows Private Sub Report_Open(Cancel As Integer) InitialYear = Form1.myYear.Value MyYearValue = Val(Mid(InitialYear, 3, 2)) startYear = Left$(InitialYear, 2) ... Me.Ctr_Year1.ControlSource = currYear MyYearValue =...

Thank you, Dhookom, for your reply. I actually did try it yesterday but wasn't sure what i was doing according to your suggestion. Yesterday, this was what i did but got the error Cancel = (Nz([Me(Ctr_Year1)], 0) + Nz([Me(Ctr_Year2)], 0) + Nz([Me(Ctr_Year3]), 0)) = 0 Then, tried what you...

Hi Dhookom I sort of don't quite understand how it works with the variable as control name. Sorry for being too slow to catch what you suggested before. However, i just realised what you meant by saying + is for numeric addition use. so now i understand how the code you gave works now. Cancel...

Hi Dhookom, Previously, i didn't use Option Explicit and now i do. supposedly, they're all of type "string" - myyear1,myyear2, etc. I changed the following code Before: Cancel = (Nz(["'" & myyear1 & "'"], 0) + Nz(["'" & myyear2 & "'"], 0) + Nz(["'" & myyear3 & "'"], 0)) = 0 After: Cancel =...

Thank you, Remou and Dhookom for your helps. I tried the following code but got run-time error #2465 Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) InitialYear = Form1.myYear.Value MyYearValue = Val(Mid(InitialYear, 3, 2)) startYear = Left$(InitialYear, 2) currYear...

Hi, Just wonder if anyone might be able to help me here. I have a question on Access report. I have a database built using Access 03. I have a report that has a several subreports whose control sources are based on queries. Sometimes, there are occasions where in the sub-reports, there are a...