Search results

Yes I've tried from the beginning, before posting this thread. But no solution and gives me the same message : "The Visual Basic for Applications project in the database is corrupt." Still need help

Hello again The Allen Browne doesn't work unfortunately I feel I'm lost Please I need help

Thanks for fast reply I'll see the link and get back to you with results

Hi brothers, I've a very bad problem with my MS Access files, suddenly corrupted and give message : "The Visual Basic for Applications project in the database is corrupt." The files could not be opened normally and when I click OK the buttons on forms are not working, in addition the modules...

What do you mean by "ONE Function rather than a multiple Subs"

You should put the code in Module and name it "abjMouseWheel" on the event : On Mouse Wheel ... put the code "Call DoMouseWheel(Me, Count)" Look at this : Assuming you are using Access 2007 or later, the steps are: On the Create tab of the ribbon, in the Other group (rightmost), click the...

Thanks a lot for your extreme help I think it will work with my database I'll try and inform you Thanks again

Thanks Jhon but regarding the code : How could I do it ????

Thanks for your help but I want the client search according to his need not according to static prices for example: There are flats with price : 15250 $ - 15500 $ - 16750 $ - 18100 $ may be the client need price in range 15000 $ - 16500$ so the results should give 15250 $ - 15500 $ only It's a...

Hi Brothers, I've a small database containing data about prices of shops, flats and lands all I need how to get results using price search between a range. for example : the client need to search a flat between : 15000 - 20000 $ Thanks for help

No Sir, it shouldn't be because the report is for calculation of procedures, so every one has to has at least one procedure in the same date : for example : 1- procedure "Medical Report" and procedure "Residence" in the same date 2- procedure "Renew Passport validity" in another date 3-...

Perfect it's working very nice I'll work more on it and will tell you Thanks Brother

Thanks for your help can you explain how to use it ??? I mean Getpenalty ,,,, is it Penalty or should I change ???

Yes, these the values are in the Procedures field If any one hasn't Residence : the field of ResidenceExpireDate will be empty

Hello Brothers,,, I'm afraid that I couldn't explain well ,, but I'll add some details : I've a problem with calculating penalties I've a calculation report contains : ID - FullName - EntryDate - ResidenceExpireDate - Procedures - ProcedureDate - Penalty *The Procedures are : IssuingResidence...

Hello Brothers,, I've a problem with calculating penalties I've a calculation report contains : ID - FullName - EntryDate - ResidenceExpireDate - Procedures - Penalty *The Procedures are : IssuingResidence - RenewResidence - Exit The penalty should be in some cases according to procedure ...

I mean the orientation But I couldn't achieve how to do it

Hello is there any body can help on this ??

Thank you for your advice, great appreciates

Thanks a lot