Search results

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.

Tried that, did not work. And yes, I have removed those spaces. Thanks.. will be waiting for your reply

Sorry for being a dumb... I am just started learning Access. In the table I have a "Deployment From" and "Deployment To" columns and in query I calculate the Days by Days: ([Deployment To]-[Deployment From]) In report footer I place a "text box" and in the unbound area of the text box I place...

Sorry..., After rereading DSum I knew about that. Problem is this I have a query which takes data from 3 tables, and that query also takes the start and end date as parameters. So I think DSum cannot be used now. Yes vehicle type have space, but after removing the space it still shows the dialog...

RainLover: I tried Dsum, but it didn't work. =DSum("[Days]","[Vehicle Type]='H. Truck'")Plog: =Sum(IIf(VehicleType= " H.Truck ", Days, 0))When I use this expression and run the report, it shows the dialog box asking for Vehicle Type and Days and did not show the total days.

Hi, I have a situation, in reports I want a summary to count the total working days of each vehicle type. Here is what I want. VehicleType VehicleNumber Days H. Truck GA 3434 2 F.B. TRL AS 3222 7 F.B. TRL HY 34324 1 L.B. TRL DD 3434 2 Summary: H.Truck = 2...