Recent content by sotiris

I think i find something similar, in http://www.access-programmers.co.uk/forums/showthread.php?t=229273&highlight=filedialog but any other suggestion will be interesting

Hello, I have a text field that store the path and the name of a file. Now the user must type the data for example c:\folder01\01.jpg. Is there a way that open a window dialog box the user select the file and then the path and the name of the file paste in the field of database. The name of the...

Hi, I have 3 fields, name1,name2,name3. I want to create a function that i will give a result of multy line field (like pressing ctrl+enter). for example, if in one record all of the 3 fields have texts the result will be name1 (value of the field) name2 (value of the field) name3 (value of...

OK, it works!!

Hi, I have a double click event that open a pdf file, stored in a field name "NOMEDOC". The routine work fine but if the data of the name of the file contain space doesn't work. Does anyone can help. ex. if the NOMEDOC is "30305gb.pdf" the command run ok but if the NOMEDOC is "5-50-0-01 dry...

Thanks for the reply, WayneRyan.

Thanks for the reply, WayneRyan. When I run the code firstly a get an error in line Dim i as Long [Duplicate declaration in current scope] Also when bypass the line with 'Dim i as Long I get an error in the line ReDim Table1(1 To rst.RecordCount) [Array already dimensioned] Have you...

I have a Table (Table01)in Access with one number field name Num (double) I want a routine to create a new table example Table02 with 2 fields the first with combinations of the numbers of Table01 and the 2nd field with the sum of the combinations Example: Table01 NUM 1 2 3 Table02 Field01...

I have a table with the fields below, ColorID-Color 1 White 2 Black 3 Blue ... ... I wonder if there is a way to appear in a form an unbound object which will appear the color in each record.

I have attached a database

I want the user of the database to select a color from a color palete.

I don't know what is the selection of the user. It would be better if there is a way as we select a color in design mode through a color palete.

I have a field name color, is there a way for the user to select a color and view it in the form?

I have insert the ActiveX Color Button Control in my form (for selecting and store the color in a field) and I cannot store the value. Usually when I use an ActiveX I use me!ActiveX.value to store the value of the control but this does not working.

Mr. Uncle Gizmo the Access file that I have attached is enough or there is something misunderstood. Thanks for replying to the post.