Search results

  1. P

    Open folder from a form and import Excel file

    Hi! Could someone help me on how to create a form that contains a button which can open a folder to select an excel (.xls) file that will be added to an access 2003 table ? Thank you in advance.
  2. P

    #error in form field returning report value

    Hi all! I have a form that returns a value from a report with the following formula =Reports!CA_PB!Text64 In my report, I have the following formula =IIf(Report.HasData;Sum(([INDEX_fin]-[INDEX_DEP]-[RC])*[POD_TTC]);0) to avoid error in my form when the related query has no data. My problem is...
  3. P

    Converting my MDE file into .exe with Access 2003 Runtime

    Hello, I have a database that I want to convert into .exe for distribution to cumputers that do not have Ms access installed. I have the Access 2003 runtime and now I dont know how to proceed this action. Please, Can you help me? Thanx in advance.
  4. P

    Autofill form and subform from login form

    Dear All, I am working on a POS database and have a form to register the sales. This form contains a subform that is linked to a table VTE. This table should register all the sales done by each user. What I want is the following: 1- The field CAISSIER(E) to autofill the user_id of the user...
  5. P

    Copy one data from a sub-form to another

    Hi! I have 2 forms : Form 1 contains subform1 and form2 subform2. in Subform2 I have the field txtCBARRE2 that I want to copy by OnDoubleClick_Event into the same field in subform1. Please could you help on that? Thanks in advance.
  6. P

    Query calculations

    Hello, I am trying to launch three different queries that are suppose to return the same result in there respective reports for the same period but it fails to match. The firts reports sales per article and the second reports sales per family from the same article bases. Could you help me set...
  7. P

    Run update query from a form

    Hello, I have attached a database containing a table and an update query that I want to execute from an update button located on a form. On the form, I will just fill the controls "new purchase price" and "new sale price" and select a product. By pressing on the "update" button, I will set the...
Back
Top Bottom