Search results

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...

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...

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 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.

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"...

Hello, I have create a table with three fields. 1st and 2nd field is Single number the 3rd is text, The function i want to create is to take the text of the 3rd field and convert it to value. Example for using the function in a Query Example: 1rst Field 2nd Field 3rd Field...