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
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
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...
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...
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...
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...
In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the...