Recent content by Nizar

Hello everyone, I worked on designing and developping an access application for a specific need of a logistic service (fournitures purchase service). I uploaded it on net to everyone use. This is the link: http://rapidshare.com/files/82732934/PMP_Setup.exe.html Install it --> password: PM I...

Hello everyone, I worked on designing and developping an access application for a specific need of a logistic service (fournitures purchase service). I uploaded it on net to everyone use. This is the link: http://rapidshare.com/files/82732934/PMP_Setup.exe.html Install it --> password: PM I...

Good day statsman, jrmask, Mike375, boblarson, Thank you very much for your precious help. Its my first Access application and I learned so much! I found the support and help from this Forum, so from my heart, I thank everyone how answers my questions. Now Im focusing on learning the security...

Hello everyone, I've competed my Access Application...Finally! I spent 3 months developing it! Now I've finished it! I want to put it in work. I need someone to guide me step by step (Sorry I'm really get tired from searching :( ) how can I do to make my application working in a small network...

Hello I'm trying to apply filter on a selected item in listbox! I tried many times without a result! I want that the name of the Report is a variable from the selected item in the lstbox. Any Clue? Reports![strRepName].Filter = Me.strWhere Reports![strRepName].FilterOn = True Help is highly...

I tried these two lines: Reports![Orders Statement].Filter = Me.strWhere Reports![Orders Statement].FilterOn = True However, to compile them the necessity to open the report still remains!! Thanks in advance for Help, Best Regards,

Hello everyone, I'm trying to filter a report based on previous filter of a subform. I use this Code to Filter the subform Private Sub Filter_Click() Dim strWhere As String If Not IsNull(Me.Coordinator) Then 'Create Predicate strWhere = strWhere & " AND " & "Orders.[EmployeeID] = "...

Thank you johndoomed for your interest, it works now:) have a good day, Best regards

Good morning everyone, I use this code to filter a subform with multiple criteria. Private Sub Filter_Click() Dim strWhere As String If Not IsNull(Me.Coordinator) Then 'Create Predicate strWhere = strWhere & " AND " & "Orders.[EmployeeID] = " & Me.Coordinator & "" End If...

Good day for all of you, Thanks every one for his precisous help. I think that repairing and compacting the data base is helpful. However to ensure typical performance for the Access application there is another idea: auto-backup. It garanties security and size optimization. I am searching some...

Thanks Jdraw for your help, I've check it and it really reduces the size of the db. But is it sufficient to garantee the good work of the db when it will have the size of more then 1Gb for example? Best Regards,

Hello everyone, I've just finished my access application, but its size is 4 Mb. I expect that it will be much bigger once users begin to add records. What is the best way in Access to keep the size of the file as small as possible? Many thanks in advance, Regards,

Simon, That's what I'm doing now, I display the currency next to the Total amount upon selected supplier and it works. Now for further analysis (procurement, purchasing analysis) I must use the same currency to compare different suppliers for example. So, I have to exchange rates. Adding...

Thanks Neil, I'am working on it right now. Have a nice day:) Regards, Nizar

Brillant suggestions Simon,Thanks Very much! Have a nice day, Nizar