Search results

Hi to all I need your help. I have 2 tables Material_IU and Material I want to read all the records in the table material_IU and if the records exist in the table Material perform update else perform insert. I have to work in access 2003 about 5 years and it is very urgent.... Thanks for...

Thanks again for your time arnelgp. Finally i did what i wand and i forget to inform the forum. The problem is with the iif in the query. Because the office is in Greek Language i have to use ; instead of , PS: Also ofcouse your example work like a charm...... Thanks and regards...

Thank you arnelgp for your time. Can you make this in the access i have already upload?? Thanks and regards.

And with a new screen. A wand to do the same in my new screen!!!!!

First of all ridders i really appreciate all your help The point is : my form is (I use Greek Office) table and they will have a lot of records. How can i do this. PS:Look in my access where i want them.

Another huge favor. Can you send the file for office 2003?????

Thanks for your answer ridders Can you please help me do this in a query??? If also you can send me an example it will be great. To me more precisely is the flag has value 15 then i want the work field take the value Best Before if has the value 17 the work field take the value Expiration...

Hi to all. I have in my table a field called 15_17_flag This field take only 2 values. "15" and "17" I want if the field has value 15 to show in the form in a work field "Value 15" if has the value 17 show in the form in the same work field "Value 17" How can i do this. Thanks and regards.

Thanks Uncle Gizmo..... It work like a charm :)

I'm try to return some values from a record in my access database but i can't i use this code Private Sub Find_Desc_Quan() Dim con As ADODB.Connection Dim rst As ADODB.Recordset Dim sSql As String sSql = "SELECT * FROM Material WHERE ITEM_BARCODE= 1234567890" Set con =...

Finally i found the solution but wright now i have to go. I return later with the solution i found.

First of all thanks for your time. Ranman after the requery the first form goto the first record. What i want to do is. Let say i see 20 records From record 21 to record 40 If i select a record from 21 to 40 and open the detail form do anything i want and when i close the detail form i want...

Hi to all. I have 2 forms. Form-Header that takes the data from a query Form-Detail that takes the data from table. I want to know if it is possible when i close the form-detail (the form-detail open from a button in the form-header) make requery in the form-header and show in the first line a...

I upload a test database with only one form with a button and in the top a fdr(first display record) field I want when the user press the buttol the fdr fill with the first display record. Thanks and regards.

Hi to all I have a continues test form. The form is able to show 20 records My table has 52 records. Now let's say the form show from record 22 to record 41. The user open a subform at record 31 for example I want when the subform close and after the requery the first form show again the...

Thanks again for your time. No. When i try to run the only form that access had i'm not face any problem. I'm sorry but i don't know why this happend. PS: I use Office 2003!!!!!

I upload the specific form as you suggest

Thanks for your time... I had already try to crete a new control but i face the same problem. The field hasn't any extreme properties. Only it is a date and a date mask (99/99/0000;0;_) nothing more nothing less. Also if the middle field is date i add with dateadd some years with this code

Hi to all. I have a form with 3 date fields. If the last date field is empty and the mibble date field is date then on exit a add XXX years in the last field. The point is when the last field take the focus i'm not able to read the date because the whole field is black. If the specific field...

First of all thanks for your time. sneeuberg the code you send work like a charm!!!!! static to be absolutely honest i dont even try your code