Recent content by malikge

RainLover.... Thank you sooooooo much... This is so dumb of me, not understanding this in the first place. After a month after seeing your last comment, I gave it a try again. Found out what I was not doing right. Thanks again... much appreciated

Sorry for the late reply. I am still stuck there.

Thanks a lot... That worked.

In second form's OnLoad and OnOpen event I have placed: OnLoad: OnOpen: but still nothing happened. If I close the first form and refresh the second form then it shows the last entered message number.

Hi, I have a form on which I have to enter a message number and date, after that on the same form I have placed a button which opens another form. On second form I have placed a drop down which shows the message numbers entered in the first form. But when I go from first form to second form, in...

Thanks a lot man. Much appreciated

After typing "Me." it gives me the valid selections. The valid selection is "Me.tblVehicle_vehicleID" Now it gives the error that: I think your code works with string. the 'VehicleID = '21' is the id of the vehicle at number 21. As mentioned at: http://www.baldyweb.com/wherecondition.htm I...

No, this gives an error message. Compile error: Method or data member not found

pbaldy I am totally stuck here. Nothing is getting through to me. I am using your code like this: the VehicleID is required on the second report, and tblVehicle.vehicleID is on the first report. I am adding this code on OnClick event: as you mentioned that, I am pointing my main report to...

I have found another way of doing this through [Embedded Macro]. In that macro's Action tab ---> OpenReport Arguments tab ---> Parametrized Report Name, Report, , , Normal In the main report on vehicleNumber OnClick enent I have placed this macro. When I click the vehicleNumber it shows the...

Can you tell me what is Me.ControlName? I am totally confused right now. 1. First I have to make a query which take vehicleID as parameter? 2. Create a report on that query? 3. On first report's vehicleID OnClick event place the above code?

Thanks for you reply. I am new to access, so could you please tell me how can I use I have found out the way to make hyperlink on the report. On the OnClick event of the vehicle Number I have to put some VB code. Can you explain me how can use that code in VB. Thanks

Hi, I am creating a small application in access 2007. I am tracking the working of the vehicles. I have created a query and on that query I have created a report. I want to know is it possible that in report there is a hyperlink on vehicle number and by clicking it, it will open another report...

Thanks for bearing with me... and sorry for not clarifying everything. I have created a new query. Added an extra Field and put: Days: DateDiff('d',[DeploymentFrom],[DeploymentTo]) I gives the days difference In report I added this: =Sum(IIf([VehicleType]="H.Truck",[Days],0)) When I run the...

DeploymentTo and DeploymentFrom are dates.