Answer Questions

• John Clark AppHung in SQL Server (SQLEXPRESS)

  Good morning, the below is the error I keep getting each time I try to create/connect to a database using Visual Studio 2005.  I upgraded from VS 2003 Professional to VS 2005 Professional.  My OS is XP.  Programming language is C#.  szAppName : devenv.exe szAppVer : 8.0.50727.42 szModName : hungapp szModVer : 0.0.0.0 offset : 00000000  Hi Brent, The engineer needs more detai ...Show All

• LeGonzo Crying like a baby

  Hi there. I’m an MCSE. I became an MCSE because I felt that Microsoft products truly allowed me to help my clients with their needs. And the lapel pin makes me look cool. I have been doing a lot of simple VBA programming lately, and have decided to really take the programming plunge. This means even more waving the Microsoft flag and converting consumers to Microsoft believers. It also means another lapel pin, and ...Show All

• Stefano B app_sheetbeforedoubleclick exists?

  Hi, I'd like to capture doubleclicks on cells in all workbooks so I assume I should use a class module. (my app_... procedures work well for other purposes) I'd use the procedure: Private Sub App_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, ByVal Cancel As Boolean) according to the help, but when I try to compile it says: 'Procedure declaration does not match description of event or procedure having the sam ...Show All

• cehlers Access 2002 Error 2455 - invalid reference to the property Form/Report

  How can I refer to ControlSource property of textbox control of a subreport The reference below ended with the error 2455 - invalid reference to the property Form/Report. It was written in Report_Open event of the main report. or, cannt we refer to the control in a subreport Reports![report_name]![subreport_name].Report![textbox control_name].ControlSource Original object was to set ControlSource of a textbox in a subreport at runtim ...Show All

• Benny Lam Access Link Table with Outlook Problem

  Hi, I'm having problem in create a link table that retrieve task from Outlook. It can create a table. But with nothing in it, except the %Complete data. The rest of field were empty. Does any have any idea about this Or, Would you mind to show me on how to create a link table in access that retrieve Task from Outlook , which including start date/end date Regards, David I don't think is possible as you can see from the above reply. What ...Show All

• mccloed need help for VBA code(MS Access)

  Hi all, I need your kindly help. My MS Access Form needs a function like this: I have three text box and one button. When I click button first time, the 1st text box will display the current time . When I click button second time,  the 2nd text box will display the current time. the same with 3rd text box . Does VBA code can do this It would be greatly appreciated for any help reagrds, Nancy assuming your text ...Show All

• Kresten How Can I create an UDF I can use in a cell?

  How can I insert a managed function in a cell For instance I have a created a function Public Function test( ByVal myRange As Excel.Range) As String 'Some code..... test = "testing" End Function If I put in a cell of the wordsheet the formula =test(a1:a2) I get an error. Is there a way to create a UDF as is possible in VBA Daan I've moved your question to ...Show All

• Jeffn Problem with XP SP2

  I ran the below program in a machine with XP SP1 and Word 2000 it took only 2 or 3 seconds to insert the bookmarks into the word document. But in a machine with XP SP2 and Word 2000 it took 18 seconds in an average. I am using the similar kind of program to insert the bookmarks into a letter at the runtime. Could please anyone help me out. Private Sub Command1_Click() On Error GoTo err Dim obj As New Word.Application Dim bk As Bookmark obj ...Show All

• Son I need help figuring out what is crashing my VBA for Access 2003

  Access VBA keeps crashing on me... I know why, but can't figure out the cause. I go into code view... and type something like "Me" then when I type the '.' which should bring up the list of possible options... it crashes VBA... this only happens in access, I can open up excel and do the same thing and it works fine. I've tried re-installing but it still occurs. Can anyone provide me with some insight Thanks, B ...Show All

• MADLAX Fastest Processor for Running Excel VBA Macros

  i have written a series of complex VBA macros in excel as part of a system to generate hundreds (even thousands) of data reports from large data sets. on my old desktop (p4 @ 3.2; 3gb ram) some of the macros take hours to execute - i even let them run overnight. i wanted a new computer that could run them in much less time. so we invested 5k in a new desktop (dual core xeon @ 2.8; 4gb ram; twin 15k rpm hard drives). i ran a simple macro ...Show All

• VMan work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael hi, I wouldn't recommend the approach your taking. Although this ...Show All

• stubs Ms Access form creation

  Hi I have problem with form creation wizard. During first step wizard doesn't show the fields of my tables. Only primary key field is shown. And in next steps I face such alerts as "Invalid use of null" What I should do Yes I use it. In short I follow all instructions in the way to create form or report. But...no result Are you using look-up fields (Fields with a table or query feeding a pull-down list). This could ...Show All

• AngryRichard Trouble signing up for the Microsoft Empower for ISVs

  Knowledge Mgmt. Solutions, Inc. wants to be a Small Business Specialist Partner, so we went to our Microsoft partner page and enrolled and paid the $398.64 on September 6, 2005. We then started looking for a place where our techs could go and take the courses which we were told was either Dallas or Redmond but they were not sure of the courses or course numbers being available. On October 14, 2005, they sent our money back to our bank - no expl ...Show All

• AlexLancaster 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!   Thank you for your information. Well, what we need is: VSTO to support all Office apps, bring the rest up to the level that Word and Excel have (especially Access). I remember a rumoured "VSA.net" (Visual Studio for Applications) that was to ...Show All

• Tareq1176 WORKING ON WORKBOOK WITHOUT OPENING IT

  I am doing some changes in a workbook. The first thing I do is to open it. Then I do the changes. Then I save it and close it. Is it possible to effect the changes without opening the workbook This is the code: directory = "c:\Documents and Settings\Antonio\My Documents\Client " Workbooks.Open directory & "Geroa\Geroa Inventory.xls", 0 Worksheets("renta variable").Activate Worksheet ...Show All