Recent content by diakis

Thank you Gasman for the answer to my question, but this is not works. When I select more than one label boxes in form then disappeared the name from properties

Hi In a form in access 2002-2003 I have 100 label boxes with the names lab_1, lab_2 ... lab_100 I want to rename all these label boxes to etik_1, etik_2 ... etik_100 Can I do this all together and not one by one from properties?

I have a textbox that takes a lot of values. I want when I close the form or the application to save the last value and when I open the form or the application this textbox to show the saved value. Something like a high score in a game. Thank you

Thanks again. It works very well

I have a field with 3 records: 1=Henning, 2=Daniel and 3=Santiago. I want to do a field in a query to give me the number of letters in each one record but the same letter to sum once. The field in the query must give: 1=5, 2=6 and 3=7. Thanks

Dcrake, Perhaps it is very simple but I don’t know how to do it. If field2.record(m)=field2.record (n) Then field3.record (p)="Yes" Else field3.record (p)="No" Example1 field1 field2 field3 1 a No 2 b No 3 c No 4 a...

Hi, I work with Access 2003 and I am new in VBA. I would like some help with the following: In a query that is sorted by field1 (this is the primary key) I want to write this: If field2.record(m)=field2.record (n) Then field3.record (p)="Yes" Else field3.record (p)="No" field2 and field3 are...

lagbolt, unfortunately it does not work

Hi, in db of Access 2003 I have a Form “fr_lath” with a TxtBox “kim1333”. The control source of this TxtBox is “=Count([cοd_ame])”. [cod_ame] is a field in this Form. This way I have in “kim1333” the number of records in this Form. In another Form “fr_dask” there is a CmdBox “ent13” clicking on...

Can someone please tell me how to make a text box (or label) on a form in Access 2003 to look like a circle? Thank you in advance.

It works. Thank you ajetrumpet

Not having much knowledge about codes, I’m trying to make in ACCESS 2003 a form “fr1” with 4 TxtBox s1, s2, s3 and s4 in which I want to be placed automatically random numbers ranging from 1 up to 6. The code I believe that is suitable for this is the one below: Function YP4() Randomize Dim fr...

No they have not anything in common. I think that Pat Hartman answer is o.k. Thank you.

In a table with 5000 records there is a field named "products" with 800 differents products (product1, product2, … product800). I want to create a new field in a query and mark 100 of these products as "Not available" and the rest 700 as "Available". For a small number of products I can do this...

To Banana: the “NAME” was for example but I hadn’t thought that this would be a problem. Thank you for the interest. To Matt Greatorex: The use of “InStr” gave me a solution. I didn’t find the “Split”. You helped me. Thank you.