Search results

Very good, Am gona try that! Thanx so much!

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.

I don't have the on load event in my report properties. I'm using access 2000.

Hi arnelgp, This is what I have on Open in my report but still not working, I've the same error. Private Sub Report_Open(Cancel As Integer) Tempvars("varReportCA_PB") = Me.Text64 End Sub thanx fir your help

Hi arnelgp, I have a compile error on Privatate sub report_open() : sub or function not defined

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

Good, Thanks so much!

I have to confess that I am not expert in development. So cannot convert my database the way Galaxiom explains above. Can you explain a little bit in details on how I have to use the runtime? Do I have to send the application to the end user with the runtime to be installed before opening the...

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.

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

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.

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

hi John, I have a problem, in case I have 2 lines for the same item in the table, I cannot update them all at the same time. Could you set up that function for me? thank you

Hello John! Thanks so much!!! It works fine!

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