Recent content by amoona

thanxxx :) it works fine now

HI, i have a text box which should have a default value of the current date. When i put Now() in the default value of the txtbox property and format of short date it gives me the date but when i try to change the date the time appears, so instead of writing Now() i entered Date() but when...

Hi, i'm not sure if i should display this q in the reports section or queries... is it possible to update a field in the table from the report or the query which generates the report? i have a field in a table which should get the date when the report is generated (the date should only be...

Hi, i've asked this question a few weeks ago and i got this solution from 'Rich' which works great for me: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim CtlDetail As Control Dim intLineMargin As Integer intLineMargin = 60 For Each CtlDetail In...

thanxxxx alot it works perfectly :D now i want to do the same thing for the headings of the table columns which is in the report header , but the problem is there are some labels which i don't want to include.. is it possible???

hi, i was just wondering if there is a way to seperate columns in a tabular layout report by lines?? ( i want it to look like a table) i tried putting lines from the toolbox but i get a spaces between the rows.. thankxxx

thanxx Tim... what i did was after undoing the main form i set focus on the sub form and then undid it. Thank you alot :)

problem solved :) i found a thread which explains how to do it

hi, i want variable that can be accessed in both main and subfrom.. what i have done is i declared my (boolean)variable in in the main form and changed it's value to 'TRUE' in the subform, then i used this value in the main form but for some reason the value gets reset to 'FALSE' is there a...

i know.. i was amazed my self coz i tried it before and it didn't work.. now when i am adding a new record and click on undo it deletes the record, when i edit a record and click on undo it undo's what has been written.. i don't know how it's doing it but for some reason it's working..

problem solved :) for some reason the undo is working fine now

the undo won't work for me.. because when moving from the main form to the subform the data gets to be saved into the table. when adding a new record and the user wants to cancel it i just delete that new record but for editing a record that's not possible.. i tried putting cancel = true in...

hi, i have a form with a subform, when the user edit the data i want these records to be saved into a temporary table before editing. and when the users choose to cancel the edit i want the data from this temp table to be retreived in my fields again and saved into my actual table.. can...

thank you.. i guess i'll just make all the pages landscape...

i solved the first part, i was able to put my subreport on a new page but i still don't know how to let it be viewed as landscape...