Recent content by kompkar

Hi - I've attached a sample DB with this post - just one button in a form, and one text box (Name) in the report. As you can see, when I press the buttton, the name is set as "David" - but when I "Print Preview", the value disappears

I checked out that link in the above post - but I couldn't figure it out, really sorry but I'm just starting out with Access. Could you possibly break it down for me - what is the "IIf" statement in the code in the link above. I changed my code to the following, but the report is showing an...

I'm using MS Access 2007 - MS Office 2007. The report is not linked to any tables or queries - I've code in the form which access the tables, does the calculations, and loads the final values into various text boxes which I've setup in the report. All works fine - the calculated values get...

I created a form which loads values into a report. When the report opens in 'Report' mode - acViewReport - I can see the values I set for the text boxes in the report. However when I press 'Print Preview', the values in the report disappear and all I can see are the 'label text' for the text...

Many thanks guys for the prompt response, very helpful and saved me a lot of time from trying out unwanted and unworking things in the field properties !! Figured out to do it using forms(after learning forms...god it is not that difficult as I initially thought it was going to be). Thanks...

allright then... allright then... so how about the best solution for the problem below...! In simple terms, I just want to setup an autogenerated column/field, that will produce values in the following sequence "FP001" "FP002" "FP003" ... ... I'm not using any forms, queries or macros...

I dont understand guys - why cant we give this guy the solution he is after, rather than just questioning his logic - we dont know precisely why and what he does with the thing he is asking for - Basic rule is everyone has got their own way of doing things and it necessarily does not have to be...