Search results for query: *

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

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

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 am trying to update one of my tables using VBA. My code is as follows: Sub UpdateChildAccounts(selItem As String) 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 DAO.QueryDef dbname...

Hi, I've got a list view control and i need to add items to this list view. what i did was the following simple code: Dim list_item As ListItem Set list_item = LV_Members.ListItems.Add(, , "VBA Testing") list_item.SmallIcon = 1 But it generated an error stating "Type Mismatch", when...

Hi , Does anyone know from where in the additional control dialog box i can find date time picker. I tried AccalendarDctrl class, but didn't workout since that control was unknown. Presumbly i have to install it. If so can anyone give me the default location? Thanks, Sanjna...

Hi there, My VBA program is uses to copy data using 2 different workbooks. At the moment i am using a form to activate this code, and once i click OK button to start copying it opens up relevant work books and copies data. But the problem is it takes lot of time since i ve got lots of data in...

Hi, I need to open up the main form in my vba application once i double click on the excel application. I mean the excel application should not open up the excel spreadsheet instead it should open up the form. Can anyone help me with that? Thanks a lot for u r help in advance. Sanjna...

Hi there, I have a very big problem. I am currently doing an invoicing system. The excel spreadsheet looks as below. client|add|late|mon|tue|wed|thu|fri|sat|sun|hours|charge visit |||| MONDAY TO SUNDAY columns are sub divided into theree columns (for morning, lunch...

Hi there, In my program, i need to open up a template, copy its layout into a new workbook and then close the template. When the template is closing, the excel application pops up save dialog box. I really need to get rid of that just b cos i don't like user to see that my program opens up the...

Hi there, I've got a problem with the following query. It raised an error and i cannot figure out what is wrong. This is the first time i used subqueries. I don't know whether my syntax is wrong. Could anyone help me with this? strSQL = "SELECT Client.[Client Forename], Client.[Client...

Hi, I need to add a query result to combo box. My query is as follows: "SELECT InvoiceCode FROM InvoicePeriod;" I need to add InvoiceCode to the combo box. How can I do that? Sanjna...

hi guys, I need to add a menu bar to my form. but i cannot find the control in my tool box. How can i do it ? Really need u r help guys Thanks, Sanjna...

Hi, I need to check whether a comment is available in my active cell. If it is already exist in the active cell then I need to add a string to the exisiting comment. Otherwise need to add a new comment. This is what i want: If ActiveCell does not have a Comment ActiveCell.AddComment...

Hi there, In VBA how do u check whether a particular cell value has a string value in it? I need to check my current cell value has a 'character value' in it. If there is a string value, i need to replace with a number, otherwise need to add the second number into already available number...

Hi guys, I need to get rid from my loop when a particular statement is executed. Usually I use "Break" keyword in other programming lang. For VBA what we can use? I am new to VBA and I really need u r help! Thanks guys, Sanjna...