Search results

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...

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...

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] = "...

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...

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,

Hi everyone, What is the best solution to deal with different currencies in an Access Application? After creating a table that includes currencies codes I want to use them in the form to present and calculate prices. After choosing the currency from a combobox, the price field must be presented...

Hello everyone, To display images on a form (Access 2003) I used the same code of the Northwind database sample (Form Emplyees). when changing the Picture's location it returns a bug in the code (Couldn' open ...the file), or the ErrorMessage Label should have the value: "File not Found" here...

Hi everyone, I just want to have information about the concept of using an Access application with different users at the same time. Thank you for help, Nizar

Hello, I want to add a command button to my form that enables me to sort all records on the form into a Word document using mailmerge or automation as a "Purchase Order". This Word document will be saved with the name of the Order, then i will try to add another fonction to send this "purchase...

Hello, I want to add a command button to my form that enables me to sort all records on the form into a Word document using mailmerge or automation as a "Purchase Order". This Word document will be saved with the name of the Order, then i will try to add another fonction to send this "purchase...

Hi, Searching on this Forum and on net, I've succeeded to send my current record to word, but I still have a problem concerning the Order Details ( Items, Quantity, Price ...). I could not find how to include records of the subfom containing Order details. I've searched but i didn't get...

Hi, Searching on this Forum and on net, I've succeeded to send my current record to word, but I still have a problem concerning the Order Details ( Items, Quantity, Price ...). I could not find how to include records of the subfom containing Order details. I've searched but i didn't get...

Hi, Searching on this Forum and on net, I've succeeded to send my current record to word, but I still have a problem concerning the Order Details ( Items, Quantity, Price ...). I could not find how to include records of the subfom containing Order details. I've searched but i didn't get...

Hi everyone, I'm developing a small Access 2003 application for a purchase service that includes managing informations about Suppliers, Customers, Carriers, and Orders. With the Orders issue, I'v created a form to enter all the informations about the order; customer, supplier, carrier, orderID...

Nice day for all of you, I have a problem using Createcontrol method with Vba. In fact, i would like to add to my form a label once a desired value is selected from a combobox. here is my code, i didn't match where is the problem exactly: Sub NewControls() Dim iwb As Control Set...

Hello everybody! Im new in Access as well as in this Forum! Glad to be here :) Im currently developping a small application in Access 2003 and here is my problem: I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber" Where the SupplierID...