Recent content by drpkrupa

Thanks Steve. It works.

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 converted single to double and got result 0.0004743416 and excel return 0.000474342

I removed that line then it gave me result 0.0011619955 but excel gave me result 0.000474342 I uncomment line StdDev = Sqr(SumSq / (k - 1)) and comment out line StdDev = Round(Sqr(SumSq), 10) Now i got result 0.0005809978

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 am using sql database and sql table are link to access database. I want a store pdf file into access database. We are storing path as of today. We have an issue because the files get transfer during approval process. When we receive pdf file for customer we added into pending folder and upload...

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

Thanks for your help. I just tried and it works for me.

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