Answer Questions

• Andreja extract office file's title into excel

  hi guys! I have a folder which included many office excel and word files. these files have a file properties as "QMS-DOCUMENT-NO", which is created by myself when I create the file. New file will be add into this folder frequently. two questions: 1. I want to creat a excel file consolides what i have in this folder. it shall shows the file "name", "Title", and "QMS-DOCUMENT-NO". is there an automa ...Show All

• Madhu.Babu Source Object as a query

  Hi i have a form that contains 2 text box's and a subform what i really want to do is to run a query and not have an input box popup i would like the dates entered into the 2 text box's to be used in the query of the subform and display a table that shows all records that are between date 1 and date 2. SQL code: PARAMETERS [First] Text ( 255 ), [Second] Text ( 255 ); SELECT Equipment.* FROM Equipment WHERE (((Equipment.[Date Installed])>[Firs ...Show All

• Allan Stirrett Simple question on FrontPage / Internet Explorer

  I have just learning FrontPage 2003 using the Step by Step book. When I look at pages with ActiveX items in design view I see the item, if I switch to preview I dont see the item just the area it occupies. I suspect that I need to change a security setting in Explorer, but I don't know where to start looking. Can anyone tell me which setting needs to be changed and the likely consequences If the Web site is ...Show All

• O_er Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• DeFreitasM deleting record

  Do Until rst_local.EOF CurrentLevel = rst_local("Level") CurrentDeptId = rst_local("DeptId") LevelUp1 = "L" & CurrentLevel - 1 & "_DEPTID" LevelUp2 = "L" & CurrentLevel - 2 & "_DEPTID" Set rst_pplops = dbs.OpenRecordset("SELECT " & LevelUp1 & "," & LevelUp2 & ",Dept_Level,EFF_STATUS,DeptI ...Show All

• JamesQMurphy Exit problem

  hi all i have an urgent problem , if any could help me in any way i would be thankful i have a system that uses ms sql server as back end and ms access 2000 as fron end in one of the ms access 2000 form i have created two combo boxes such that the user select the product type and the next combo box will display only those items of the user selected product type in the same form i added a button to exit with docmd.close ...Show All

• theguy204 How can I change the font of some of the text in a cell? (Excel)

  I need to change only part of the font and color of a cell in Excel - not the entire thing. I can easily change the font and color of the whole cell, but is it possible to do something like this inside a cell First Line in cell Second Line in cell I haven't had any luck with any searches. Anyone know if this is possible in VBA, and if so, how can it be done Thanks in advance! Should be possible I thin ...Show All

• Webbee How print picture

  Hello, I have small question about printing graphic file. How send to printer picture ( graphic file) under VBA Per our support engineer: Hi, you need a container in office to contain that picture, then print it out. For example, you can insert that picture into a word file, then print that word doc. Here is a sample code for you. === Selection.InlineShapes.AddPicture FileName: ...Show All

• Hibri Marzook Help with Run-time error 1004

  When I try to activate a cell, or paste to a destination, I get a run time error 1004. Both shaded lines below cause the error. The below code is from Access which is updating an open Excel file. The activate line before the shaded lines works fine For ColNo = 3 To 10 If .Cells(57, ColNo).Value > 1 Then .Range(.Cells(5, ColNo), .Cells(138, ColNo)).Copy MyXL.Application.Worksheets("Tracker").A ...Show All

• vimaru_org VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   No, nothing specific. Apart maybe from making it work with the Scroll wheel on a wheel mouse. I just have a concern that a lack of development focus on the IDE (as is betrayed by my somewhat trivial example) will mean that in the end the language will be allowe ...Show All

• nolim8ts Lack of mouse scroll wheel support in VBA

  Folks The mouse scroll wheel does not work in VBA.   This has always puzzled me as to why this support does not exist since Office 2000. This problem was originally caused by a MS Mouse driver change that I'm told was communicated long in advance to other MS folks. This problem has existed for several versions of Office.  As far as I'm concerned this should've been fixed in the Office SPs. And yes, I'm quite aware of the workaro ...Show All

• Marc-Andre Extracting Text from body of Outlook email into excel

  Can anyone help me to finish off this code I am extracting text from the body of email messages in Outlook into Excel. The email messages are standard format and look like this: Questions answered by: joy smith ID #:25555 Total number of questions answered: 20 Total number of incorrect answers: 3 Grade as percentage: 85 % List of question(s) with incorrect answers. The incorrect choice is in brac ...Show All

• djehmli Application.FileSearch in Excel 2007

  There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\SecondSet" Set rg = Range("MyFiles&quo ...Show All

• masterlegolas3 Adding windows forms

  Can anyone help me. I am trying to use a button on my form one to click and open form 2 and so one. How do I enter the code to do that. New to express. Thank-you Scottzrn, to open the form named (form2) form2.show to close the form unload(form2) thanks ...Show All

• DannoMontano Linking tables to databases in code

  I have a database designed in Access 2003 for which I used the 'get external data' option to link (not import) data files. However, I would like to save the database 'unlinked' and have the code link the tables when it's run. This is so that when I run it on another machine, I can specify a path for where to find the tables with the database in runtime mode. Can you help Ollie VB Ok this isn't a complete solution but I'll give ...Show All