- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
108 Posted Topics
 | Hi, I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating …  |
| | Hi, I am running a batch file to generate a report. A command similar to the below one is put in the batch file. [url]http://localhost/XXXX/XXXX/Test.asp?format=EXCEL&cqs=N3-FMIJTUVMUTPO-QQEWQ3MP[/url] Test.asp contains the below <%@ Language=VBScript %> <% select case Request.QueryString("format") case "EXCEL", "Excel", "excel": Response.ContentType = "application/vnd.ms-excel" case "WORD", "Word", "word": Response.ContentType = "application/msword" … |
| | Hi All, I am updating a column in a table through SQL+ using Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual; The same field when updated through an application has a time offset of 4hrs. Select dbtimezone from dual; returns DBTIME ------ -04:00 I want to form a statement which will update the field with … |
| | I am encountering the error attached "UnicodeEncodeError: ASCII codec can't encode character u'\0152' in position 124: ordinal not in range(128)" Please help me solve this.....  |
| | I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column. I want to know the SQL statement to find out the base tables of th view and also the base …  |
| | Hi, Im working on a stored procedure to get monthly reports from a table. For that i need to develop a logic to perform the following function: suppose i give a start_date and end_date, i need to get the months split up between these dates. for eg) if I give … |
| | Can somebody help me with the code to read file names from a folder? curretnly i'm using the below code. Dim files() As String files = System.IO.Directory.GetFiles("c:\myfolder") this is not working please help me.  |
| | Hello Friends, Through python I am able to generate an excel report. In one of the cells I have populated an e-mail address which shows up as a hyperlink. Can I make this hyper link to launch outlook with the e-mail address present in the cell in the "To" and …  |
| | Hi Friends, I need to write a piece of code to identify if an Excel session(the process which is listed in the Task Manager) is already running or not?. Can anyone guide me with this? Any help will be much appreciated! Regards, Dinil |
| | Hi All, How can I increase the time for which the ToolTip is displayed. I currently have a radio button for which I have set a tooltip and the content is large. There is not enough time for the User to read it completely. I dont want to use the … |
| | Hi friends, I want to copy few cells of an excel sheet and paste special(picture) in ms-word. I want to develop a vb code code for this. Please help!... Regards, Dinil |
| | Hi All, I am using the below code to write into a text file [CODE] # Write into log file inp=file(Doc\Log.txt, 'w') inp.write('Log file start') inp.close()[/CODE] The text file 'Log.txt' is present in 'Doc' folder inside the application folder. Now I want to create a text file with a time … |
| | Hi All, I am using the following code to write data into an excel sheet: [CODE]# Open the Output Spreadsheet objExcel = win32com.client.Dispatch("Excel.Application") # Creating object to write to Spreadsheet self.xlApp =Dispatch("Excel.Application") # Creating Workbook self.Wkbk = self.xlApp.Workbooks.Add() # Get sheet count intShtCnt=self.Wkbk.Worksheets.Count # Creating worksheets wsObjReport = self.Wkbk.Worksheets.Add() # … |
| | Hi All, I am using the .search function. [code=python] strValue="XXX" strTemp1="YYYXXX" strTemp= strTemp1.search(strValue) [/code] Python is not able to recognise the .search function. AttributeError: 'str' object has no attribute 'search' What should I import for this? Please help!  |
| | Hi All, I have two frames.viz., frm1 and frm2. On click of a button on frm1, I want frm2 to pop up and frm1 to hide. Presently I am using the following code: [TEX]self.Hide() self.frm2=frm2.clsFrame2(self) self.frm2.Show()[/TEX] clsFrame2 is the class present in frm2. The above code if written on the … |
| | Hi All, I have the following string: "AND Category 07|Spec 01|ABC 01 AND Category 07|Spec 02|XYZ 02 AND Category 07|Spec 03|PQR 03 " It is stored in a string variable. I want to remove only the "ABC 01", "XYZ 02", "PQR 03", etc from the original string. The new string … |
| | Hi All, I have created a grid and want to implement the following idea:  |
| | Hi All, I have created a grid and want to implement the following idea: The user should be able to enter only numeric values in any of the cells in that grid. I could not get any property of the cell which can check for the entered data. Please guide … |
| | Hi All, I am developing a GUI in Boa Constructor. I am using a grid for displaying some data and want to change the names of the column and row headers in the grid. Please help me in achieving this. Regards, Dinil  |
| | Hi All, I would like to create new rows dynamically. When a user clicks a button, a new row should be added in the grid. Please guide me as to how can I achieve this. Thanks, Dinil |
| | Can anybody please help me with the code to read file names inside a zip file using VB6. I am able to open(not extract) the zip file. |
| | Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, … |
| | Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, … |
| | Hi, I would like to insert a background image in an excel sheet which is generated through VB code. The image should be inserted in such a manner so that any data in the same cells can be seen over the image. (i.e the image should be in the background … |
| | hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could … |
| | I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr] |
| | hi, I want to put a textbox over a bitmap in MS Excel sheet and populate the textbox with a value from VB code. Please guide me in acheiving the same. Regards, Dinil  |
| | hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could …  |
| | I am calling the below function on the click of an 'OK' button to set the attribute of a cell of a table (attributes for <td> tag), however i am not able to set the 'style' attribute of the <td> tag with the code below. Please help me in achieving …  |
| | Please help me in positioning the scroll bar at the bottom of text. Please help me by providing the code snippet.  |
| | Please help me in automatinng the following in my EXCEL sheet using VB. I want to make my first two rows as Repetitve in every page of print.In excel it can be done as PAGE SET UP->SHEET -> Print titles -> "Rows to repeat at top". here i can choose … |
| | I am coding in VB to add 3 fields of MS Access back end. If there is no value (or blank) in a particular field, I want 0 to be considered in addition. Following code is not working for checking the blank field. If IsNull(DE_hours) Then DE_hours = 0 End … |
| | IN MS access FORM i have a list box column which is filled with colour names. Once the form is loaded i want to make backcolour of that record same as the one mentioned in that column. Regards, Dinil  |
| | I want to populata records into a list where i can have the following functionalities. 1) Multiple selection of records 2) Back colouring of individual reords. Among Flexgrid and Datagrid which one would be less complex and easy to code and serve both my purpose. Regards, Dinil |
| | hi, Through VB i want to set the first 3 rows of my excel sheet as HEADER so that those 3 rows will be common header for all the pages when i print them. Regards, Dinil  |
| | HI, Please help me in colourin the text frame with 2 different colours. With ppSlide1.Shapes(3) .TextFrame.TextRange.Text = "Wing PRR :Total Weight: " .TextFrame.TextRange.Font.Bold = True .TextFrame.TextRange.Font.Color = vbWhite .TextFrame.TextRange.Font.Size = 26 .TextFrame.TextRange.Font.Name = "Arial" End With "Wing PRR:" - in White colour "Total Weight" - Yellow colour Regards, Dinil |
| | hi, I want help in developing the following code. step1 : match Todays date with string in Paragraph. Step 2: if Date matches, extract from Date to EndOfLine. Step 1 code If InStr(status_array(i), Format(Now(), "mm-dd-yyyy")) <> 0 Then Step2 code End If Please help me developing code for Step2. Regards, … |
| | please tell me how to format text in a SINGLE cell of a table. Once the following text is added. i want to format it in followinfg way. ---------------X_------------------------ Title : ball cat dog ---------X_------------------------ Title : in BOLD and Underline rest of the data in BULLETS. |
| | hi, I would like to generate ppt where data from my back end MS ACCESS dynamicall changes with record.I coded for connectin to back end. I want the code to generate Power point using VB 6.0 where i can dynamically change data.Please help me developing the code. Regards, Dinil |
| | Hi, Please help me with Expression builder for my FOrm. Weight_likely - back end DB Column I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated. =IIf([Weight_likely]="",0,[Weight_likely]) Please help me on … |
| | Hi, I have a checkbox on click of which I'm calling a JavaScript function to disable another checkbox. The onClick event is not working in both Firefox/IE. I am capturing onChange event of the checkbox1 as of now which works in Firefox, but not working in IE. Please suggest a …  |
| | I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides. Please … |
| | I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides. Please … |
| | On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box Please help me in setting focus to that particulat text box. [code]Private Sub Form_Error(DataErr As Integer, Response …  |
| | hi, in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern. What might be the reason. Please help me. Regards Jagadeep |
| | Hi all, How can I declare a global variable inside a module and use it across other modules for throughout the lifecycle of the program? Regards, Dinil  |
| | Can somebody help me with the code on how to capture the line number at the current cursor position?. |
| | Hi All, I am using the following code to populate a tree control. The dictionary currently I am using is ‘dictFolders’ and its structure is defined below. lstFolders=[] lstFolders = ["A","B","C","D"] dictFolders={} dictFolders = {"A":["Obj1","Obj2","Obj3","Obj4","Obj5","Obj6","Obj7","Obj8","Obj9"], "B":["Doc1","Doc2","Doc3","Doc4","Doc5","Doc6","Doc7","Doc8","Doc9"], "C":["Link1","Link2","Link3","Link4","Link5","Link6"], "D":["Obj1","Obj2","Obj3","Obj4","Obj5","Obj6","Obj7"]} # Setting the root node text to the Action ID entered self.treeAction.SetItemText(self.treeAction.GetRootItem(),”Parent … |
| | Hi all, How can I split a Progress Bar(wx guage) into two parts?. I want the first part to function normally and in the second part I want to display the percentage. I have attached a snap shot of what I am trying to achieve. Is this possible? Any help … |
| | I have a variable/flag in a PHP file and depending upon the value of this flag i need to execute a set of code in another .js file. Can you tell me how to access the variable in .php file inside a .js file? Please find attached the sample js … |
The End.