Search results

I have continuous form as sub form. This sub form has two combo box. 1) Defect Type 2) Defect Code The defect code based on defect type. This is what i want to do. When user select value from first combo box which is defect type then i want to rebind the defect code combo box. I have done...

I have Continuous Forms which display all items for one part number. The main form Part Info with with this Continuous Forms with key feild called "Product_ID". One part can have multiple items on sub Continuous Forms. I want to create way so user can add item in between two existing items...

I want a write small program which does follwoing three tasks. 1) Open master excel file from C:\Test.xls. 2) Save As the master drawing with c:\Test_Now().xls 3) Open new save as file and select tab "Data" and bind B6, B9 and C10 feilds from database. I know how to pull data from database but...

I have eight data entry feilds and one calculate field on my access form. Here are my eight data entry feilds. 1) Nominal 2) Upper Tolerance 3) lower tolerance 4) Result 1 5) Result 2 6) Result 3 7) Result 4 8) Result 5 I want a calculate the last feild as standard deviation. I found code...

I have a Access database. The table are link tables. They link to SQL database. I have a table called Images. It has ID, Account_No,Image_name, Image_Type and Image_data columns. Image type has type of file. All files are PDF so it contain value "application/pdf". Image_data has actual file in...

I got new task where I need to design one access form. The page has two sections. Section 1: I want a give option to user where they can click on button and select PDF file by using Application.FileDialog. After selecting the file, I want a transfer the PDF file to the Access/SQL database and...

I have a table and table has two column. ID Variable 1 1.1_D4.M 2 1.2_D8.TP 3 4_K9.D 4 6.9_L9.M 5 1.1_D4.M 6 6.9_L9.M I want a write query which will return all charcters before "_" and distinct value. Result. 1.1 1.2 4 6.9

I have page with one button. If user click on the import button. I would like to open the file dialog box. User select the text file and click ok then i would like to transfer the data from text file to access table. I wrote code which will open file dialog box and user can select text file...