Recent content by Majid Umar

Hi Everyone, I designed couple of forms, one for applicant and one for Stats on that Applicant. Problem is Stats Form contains some fields which are same as on Applicant Details form. If user changes the details on Applicant Form they need to be changed on the Stats form. If it's a New...

Hi All, I'm having problem with a Combo Box, It's in a help form where user can select a Category and thus it displays certain topics on that category. Problem is when ever I call the help form form Main Menu or any other screen, I'm can't select any item from drop down list. It does not...

Sorry, Pat is right, I used it for a Text feild and just copied it over. Regards

If I'm correct U want to open reeport to fit the window in that case use the following; Private Sub Report_Open(Cancel As Integer) DoCmd.RunCommand acCmdFitToWindow End Sub

Do U want to have custom format or just want to output blank field if Value is 0 or 0.00. If so U can use IIF function i.e. =IIf([ItemName]="0","",[ItemName]) Cheers!

I'm Not sure if this is what U meant? Buttons with Picture! If yes than I would suggest to insert image/picture and set it's special effects property to raise and use the following code for OnMouseDown and OnMouseUp event! Private Sub Image_Name(Button As Integer, Shift As Integer, X As...

i have resolved the problem using PrtDevMode in VB. Thanks for your help anyway! [This message has been edited by Majid Umar (edited 02-10-2002).]

Try this, Private Sub ButtonToOpenReport_Click() DoCmd.OpenReport "Report_Name", acViewPreview, "", "" DoCmd.RunCommand acCmdFitToWindow End Sub

David is right there is still some gap between two fields and in office copy it didn't work as I had ref No on RHS. I do appreciate your help and time. Majid!

Hi, I,m not sure how you have set your design structure but try using IIF Is Null function i.e. IIF(IsNUll([Invoice_No]),"0",[Invoice_No]) See if this helps! Majid!

Hi, Is it possible to set a Macro or by use of Code, user can print duplex report i.e. two sided. I have looked in help and found this PrtDevMode, which contains duplex as member. I couldn't figure out how to use so, when user click on print licence it prints two copies of it using duplex...

Hi, i used a Macro to print letters and a Licence. Sytem is used by multiusers but problem occurs that every now and than page margin settings i.e. Top, Bottom, Left and Right are been set back to default i.e. 25mm. Which results in letter and licence been printed on severl pages! Is there...

Thanks That Works Fine! I tried that before but I was just applying it to the Address Field and never even think about the actual Detail Section! Thanks Again!

Hi, In Query Design, Add the Total Field Option i.e. Sigma from Toolbar and than Choose "GROUP BY" apply that on all the fields this should sort your duplicate probelm if there are still some records which are appearing twice than on payment date field or the link feild for Payment to project...

Hi, I created this report i.e. Letter to cutomers. In address fields the Address Line 3 can be blank and I was just wondering if there is a way to shift fields up, I know this sound crazy but worth a try! i.e. 12 Roadway Anywhere (Blank Address Field) St Peter Port Guernsey If there...