Search results

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.

This is one type of bar (there are many bars for use).

I have attached the mdb file. The table "tblCuttingList" the table that the macro should create.

The use of the excel file is for finding the best way for cutting bars in the quantity and the length that the user want. The bar stok length is 6000mm and the blade width is 5mm. The excel file has the macro for optimization the quantity and the length for each bar in order to have the minimum...

Hello, I have an Excel File that has a macro inside. How can I convert that macro in an Access file. For example 1rst table with fields "QUANTITY" "LENGTH" In that table is the data that the user insert 2nd table with fields "Length" "Blade Width" In that table is the values for running the...

Hello, I have a table named Table01 with three fields "AN" "DESCRIPTION" "QTY" 1 DESC01 2 2 DESC02 1 3 DESC02 4 I want to make a routine for creating a new table with four fields as below "NAN" "AN" "DESCRIPTION"...