Recent content by sanjna000

Thanks Tony. Really appriciate u r help! Sanjna...

Thank you so much for u r help Simon... Sanjna...

Hi there, Does anyone know how to convert decimal value to time? eg: I need 3.75 convert into hh:mm format as 3:45 I really appriciate u r help... Thanks a lot in advance! Sanjna...

I used below code to use open dialog Application.GetOpenFilename ("Microsoft Excel Files (*.xls),*.xls") But i don't know how to display the file name in the open dialog box when selecting particular excel file. Any suggestions? Thanks, Sanjna...

Thanks Brian It works brill

Thanks guys, It works perfectly! Cheers, Sanjna...

Hi, i need to delete extra worksheets in my workbook. Sheets("Sheet1").Delete false this generated an error. Pls can anyone help me with this! I really appriciate u r help Thanks a lot for u r help in advance... Sanjna...

Hi There, i need to open up the main form when i double click on my work book. The code i used is as follows: Application.WindowState = xlMinimized Frm_Main.Show But the problem is once i double click on the work book the whole application is minimized including the form. Is there anyway that...

Hi there, I have 2 variables which are used to store from time and middaystarttime. for eg. from time = 15:00:00 middaystarttime = 16:00:00 If from time > middaystarttime then i need to perform a function only prob is if i give above values, the code does not identify 4 pm is greater...

Hi, I need to reference a particular cell in a different worksheet. I used following code but it doesn't seem to be working. ActiveSheet.Cells(invTotal_rno, invTotal_cno).Select ActiveCell.FormulaR1C1 = "=Sheets(1)!N24" What i want here is, i need to copy the same value in Sheets(1)! N24 to...

Hey PH, I was able to solve the prob in my UPDATE query. Thanks for u r help. You are a star for solving my INSERT query.

Cheers PH...You are a Genius !!! It works well. Do u have any idea of not working my UPDATE query.

Hi there, I am using INSERT INTO query in order to add records to the access db using VBA. My code is as follows: rivate Sub cmd_OK_Click() Dim wrkJet As DAO.Workspace Dim db As DAO.Database Dim dbname As String Dim rs As DAO.Recordset Dim strSQL As String Dim Q As...

I tried to use following code. But it gave me an error stating variable not defined. Is any reference needs? DoCmd.setWarnings False DoCmd.RunSQL strSQL DoCmd.setWarnings True I really appriciate u r help! Sanjna...

Is there any way that i can run UPDATE query without using query def?