Search results

I have a form based on a table; I know that with "Me.undo", you can cancel updates made in the form. But when I add a new record in this form and after I try me.undo, the new record is still in the table, but even the changes made to the form are still in my table. The "Me.undo" doesn't work...

Hi Pat, I have a found a solution: when the data in the form is changing, I set a variable to "TRUE";So I know, if something has changed in my form. Thanks Daniel

I have a form based on a table. I am looking for a function showing that the values of the fields in the form have been updated. ( for example : changes have been made in the form =true, if nothing has been updated in the form =false) Thanks for help. Daniel

I have a form-continuous view- with dividing lines set to Yes. When I am using the property conditional formatting -for example in a Yes/no field, Yes in Blue, No in red, it is working well but the dividing lines disappear for this field. Why? Thanks for help. Daniel

Hi Mike, I have office 2000 and I have a full installation of access 2000. When you are installing access , there is no feature about converting Dbase files. It still doesn't work. Daniel

Hi Mike, I have checked MS VBA Extensibility 5.3 but it still doesn't work Daniel

Mike, I have as databases references : -Vba -Ms Access Object library -OLE for automation -DAO Ms Windows Common controls Daniel

Mike, I was trying to import a *.dbf table. With the menu, I can import it using dbase III, IV or 5. With the code , I am receiving the error message. I have tried with dbase III , IV, V code: DoCmd.TransferDatabase acImport, "dBase III", "c:\Path", acTable, "*.dbf", "name of table"

I have tried to do the same thing but when I am importing with code, I am receiving the error message :"dbase5 type isn't an installed database type or doesn't support the operation you chose". I have a full installation of access 2000 and with the menu command: Get external data, it is well...

I tried already this sub before but it didn' t work. My table is still changed. This is the reason why I am trying to find something else. I have found : DoCmd.RunCommand acCmdUndo and it works Daniel [This message has been edited by Danielf (edited 04-07-2000).]

I have a form based on a simple query; I am editing records in this form: no problem. But after having edited many records, I would like to have the possibility to cancel all what I have edited and returning to initial situation. Should I duplicate the query first and then modify the...

Hi Travis, Thank you very much I tried what you wrote and it is working fine Thanks again Daniel

I would like to append all the records of one field based on a query to a memo field in a table. Each record should come in a new line. I have no idea how to do this. Thanks for help Daniel

I have a form( based on a query) with 2 text boxes .In the first box, there are numbers; I would like to have in the second box; the partial total sum (In each Text box2, I need the sum of all text box1 till this record ); For example : tbox1 : 100 tbox2 100 tbox1 : 50...

I have the same problem as Muratas 2. Which references should be set? Thanks for answer. Daniel

It is a public variable coming from another table and another form I was thinking to write a function to see the result.

Hi, I forgot to write something This-about =[field1]*[field2]- I knew but my problem is : I would like to add to textbox3 the value of a variable like [var]+([field1]*[field2]) and this doesn't work Daniel

I have a form with 3 Text boxes. When I am adding a new purchase, I am filling in textbox1 the quantity, in textbox2 the price per unit. After having filled textbox2, I would like to see the total of (textbox1* textbox2) without having to use a query I have tried with Event afterupdate textbox2...

Hi Travis, Thank you very much, it works Daniel

I have two problems with variables in a form with record source: 1) I would like to assign a value to a combo box -like for example Dmax of a field; Where shall I write the code so that when I am opening the form , it is performing the Dmax and gives this value to the Combo box; I have...