Search results for query: *

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...

Hi, Wonder if i could get some help here. We have a company management database created using Access 03. I was asked to put on a form that would calculate an annual leave for all staffs. I know the formula how to work out the annual leave. However, what i'm stuck here is we really want to do it...

Hi, Just wonder if i could get some help here. I'm new to VMware. From my understanding, it allows multiple OS on a single machine. I guess my question here is the other day, i was trying to download it (thought it's an open source) but had to purchase it. Is that right? how do i install it...

Thank you JoeAtWork for your reply. Sorry for not leaving out some crucial information here. In the database, i have tables, "Job Register" and "SubJob Register". For example In the Job Register table, we may have records like 000100 - 00(Industry_No), 01(Client_No), 00(Job_No) In the SubJob...

Thank you JoeAtWork for your reply. That fixes the error message but it prompts for Job Register as soon as i get out of the designview mode. I then removed [Job Register] from the code as follows =iif([SubJob_Name] = "", dlookup("[Job_Name]","Job Register","[Industry_No]='" & [Industry_No] &...

Hi, Wonder if i can get some help here with the syntax. The following is the code i'm trying to put into a control source of a textbox. =iif([SubJob_Name] = "", dlookup("[Job_Name]","Job Register","[Job_ID]='" &[Job Register]![Job_ID] & "' AND [Industry_No]='"[Job Register]![Industry_No] & "'...