Recent content by 112nokia

I tried to enter the code to the calendar properties on "updated", and & or,also on the VD text box. But its not working. The name of the calendar is calendar3. Both the VD text box and FTR reside on the same form.

Hi this is what I have on the code Private Sub Calendar3_Updated(Code As Integer) Forms!FTR!VD = Me!Calendar3 End Sub this time I have place both the calendar and the text field VD on the same form FTR. It still not working. I am trying to make this database more user friendly. It has a...

Hello, I tried Forms!FTR!VD=Me!calendar0, under the event tab of properties under the calendar form. Its not working? FTR is the name of the form, VD is the name of the text box. Maybe the right side of the equaation in the syntax is wrong??! I have tried both forms engaged, also. What am I...

Hi I have created a Calendar form, using the toolbox active x control. I am now trying to link the date that I press in the calendar form to display in a date field in "another" form. How can I achieve this. I am reading the Access bible, it says by using its Control sourse property, but I can...

Hello, I have one report consisted of two pages. I woul like to print from a button (one click) the report after preview as following: The first (!)page has to be printed in one printer on the network, and the second (!) page to be printed in completely different printer in the network as well...

Thank you it works!!

Unfortunately, Saturday is valuated on Thursday, ie Date()+2. For Thursday, the next date should be Monday.

Hi I am trying t0 calculate two working days (starting the system time)from thursday and Friday for one date field. Date()+2, seems to work for Monday to Wednesday, but on THursday and Friday I need the two working days, are taken into account when calculating the date field. So for Monday to...

Hi, How can you calculate the weighted average using a query. The weighted average should be calculated from table Dataentry, Field name "Amount", weighted by the FIrate in the same table, and than sum("amount"). --- in MS excel the formula is roughly Sumproduct( column A,Column B)/ sum(column...

Hi The FX table contains the fields EUR/USD and EUR/CHF, autonumber, and Date. I would like to be able that in a form to validate the data using the table for the specific field [FX]![eur/usd], but the data in the FX table has to be the last data that the form will use for validation, ie the...

no, I do not understand how this function works, how do you select the last record?

Hi, I am trying to validate data in a form, though the criteria is based in a record, to be more correct the last record on a different table. How can I validate data in a form, so that once the last record in a different table is updated, the validation checks the entry in the form using the...