Microsoft ISV

Page 67




  • Topics
    Replies
    Last post
  • How to show dates in forms by the order of time?
    by QianChen
    8 Replies
    Last post by QianChen
      • Hello, all, I have a little database which deals with patients paper work. I have two tables. One is patients' basic information like name, race, age, and so on. The other is the patient's paper work including the date when the patient finishes the paper work. So I have two forms. One if for the patients' basic information, the other form is a subform of it to show the paper work information
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • Macro running slowly when run from button
    by Gus the Snail
    4 Replies
    Last post by Gus the Snail
      • Hi there I have a curious situation. I have written a macro in VBA for excel 2003 which, from a master workbook scrolls through 46 other workbooks, opening each one in turn and copying/pasting a number of ranges. It then saves and closes the workbook and moves on to the next. When I execute this macro from within the VBA editor, it runs quite quickly (about 5 seconds per sheet, which is acc
  • How to determine the cursor position to Excel range
    by Perry Choy
    6 Replies
    Last post by Perry Choy
      • I want to get the cursor position of excel application range A1
  • Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp
    by kpcnatraj
    5 Replies
    Last post by PaloMisik
      • Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open)
  • Excel CheckBox - Enabled "False" but I don't want it grayed out
    by suznal
    6 Replies
    Last post by Andy Pope
      • Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality. I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.
  • How to run *.vbs or *.bat in Excel VBS?
    by CCpluses
    3 Replies
    Last post by MyLady
      • Hi I am new in programming, I'd like to ask a basic question. How to run *.vbs or *.bat in Excel VBS I tried the code but it didn't work Sub Test() Set ws = WScript.CreateObject("WScript.Shell") ws.Run ("Notepad") End Sub thanks~
  • format conditions in excel
    by nbert
    1 Replies
    Last post by Andy Pope
      • I have an excel sheet. In this sheet i check if a cell is equal to a certain formula. if thats the case i say it has te be yellow.(thats commandbutton4_click) NOw that works fine. But after that i made a new button(commandButton5) that has to make the sum of all the yellow cells. ANd that one doenst work. Cause he cant see the yellow of the format condition. For the program its still whi
  • Live Communications Server tab does not show up
    by K-Mile
    14 Replies
    Last post by DLGrubb
      • I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no
  • vlookup
    by eds000
    2 Replies
    Last post by Peter Mo.
      • I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error DestCity = WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) _ And WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) If I use the first part before the "And" it wi
  • Heap dump (dmp) in cabinet file
    by paso
    5 Replies
    Last post by Jason Hardester - MSFT
      • I have configured the error reporting so that the reports are stored on a shared volume iso being sent to Microsoft. When the crash occurs I can see that there is not only a mdmp file but also a hdmp file on the temp directory. Howerver the cabinet file on the local share does not contain the hdmp file. Is is possible to force the hdmp file in the cabinet when using a local share for report
  • .mdmp files not being created
    by David Ching
    14 Replies
    Last post by JPSA
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • Copy ADO Recordset to Acces table
    by tewald
    0 Replies
    Last post by tewald
      • I have an ADO recordset within Access 2002 (XP). I need to copy a field from it to a table. I don't care if I have to create a new table or copy it to an existing one; whichever is more efficient is fine. It will always be the same field. My goal is to create a record source for a combobox that will reflect only unique ("distinct") items within the recordset. TIA, Tom Ewald
  • Edit the Recordset
    by Tantani
    5 Replies
    Last post by Tantani
      • Hellooo, I use Access VBA 2003 with DAO. Does anyone know how can I move to the first record of an Quantity attribute in order to change or Edit it like this: Quantity 0.50 1.40 0.70 ..... Goto first field (0.50), if it is lower than 1, then change it to 0 Goto second field ( 1.40), if it is lower than 1, then change it to 0, otherwise change it to 1. Thank you in advance!
  • Edit Record Error
    by GetCode
    1 Replies
    Last post by GetCode
      • Bachground:I have an access data base front end, who's tables are linked to an sql server backend. In turn the tables are connected to the Forms Dinamically. For example: ME.recordSource = "SELECT * FROM tblCustomers WHERE loc = '" & location "'" Theres one main form with about 5 Subforms connected to it all placed on tabs. About 3 of the forms record sources refer to th
  • ComboBox listing on Startup
    by Philsophaie
    8 Replies
    Last post by Philsophaie
      • The ComboBox1 doesn't initialize the list automatically. It only puts up a blank ComboBox . Here is the code I am using: Private Sub Form1_Load() ComboBox1.Items.Add ("Open App1") ComboBox1.Items.Add ("Open App2") ComboBox1.Items.Add ("Open App3") ComboBox1.Items.Add ("Open App4") End Sub
  • Using events in Excel VBA
    by NemoTheBlue
    3 Replies
    Last post by NemoTheBlue
      • So someone in the office said they wanted to keep a workbook more organised, instead of having to manually make changes to several worksheets to reflect the same information. Naturally, being the helpful soul I am, I volunteered to have a go at it. Then I realised just how basic my knowledge of VBA was! I've done a lot of Googling and trolled through forums and come up with the following so far, b
  • Macro to only copy visible filtered rows
    by GB Allan
    1 Replies
    Last post by bi-lya
      • Hi, I have an excellent macro that I wrote, but it has a slight hitch. I have it first filtering the data, then copying out the records that show up after filtering, to another workbook. The problem is if there are no filtered records. It then copies over the field headings (which I don't want). Even when I put it at range ("A2"), it still selects and copies the column headings
  • Email Form from MS Word
    by agill
    6 Replies
    Last post by agill
      • I want to be able to automatically attach a MS Word protected form and email from within Word. Need the email address, subject line and attachment to be done automaically, and will have to turn document protection off and then back on after email has been sent. Help! This is what I have so far... Sub SavenEmail() ActiveDocument.SaveAs FileName:= _ "4-7 3-2 New_Change Produ
  • Scroll Wheel in Microsoft Visual Basic 6.3
    by SHolst22
    1 Replies
    Last post by Andy Pope
      • I am currently using "Microsoft Visual Basic 6.3" and am accessing it through Excel's View Code option. Currently the Scroll Wheel does not work within any of the code windows. I have no problem with the scroll wheel in any program other than VB 6.3 Does anyone know of a fix for this problem.
  • Listbox scroll problem
    by DeathSurfer
    3 Replies
    Last post by Dan6845646+5414532
      • Duuuuudes: I have a problem with scrolling to the bottom of a listbox in excel '03. I'm using the listbox control in vba, not the excel forms control. Anyway, when I scroll to the bottom of the list, it won't let me see the last item in the list box. It will stop one short and will actually have a space below the scroll bar that looks like it could scroll down one more list item but won't.
  • vb.net certification
    by Ralph_Ai2x
    1 Replies
    Last post by MS ISV Buddy Team
      • where can get the reference and guide to vb.net because im going to take vb.net certification. please help thanks..
  • How to ues variables in a VBA sum formula - range(A1).Formula = "=sum(Var1,Var2)" ??
    by Question-52
    1 Replies
    Last post by sjoo
      • I need to sum a list of costs whose range will change as more entrys are made to the list. Can't I use variables showing the start and end addresses in my Sum formula THX!
  • a big thank you!
    by MS ISV Buddy Team
    5 Replies
    Last post by KenCubs
      • Hi All, I just wanted to express my thanks to Derek and all of you who have stepped in to help your fellow coders! It takes some time on my end to escalate these questions and I'm so glad that many of you are getting answers to your questions more quickly with the help of other community members. - brenda (ISV Buddy Team)
  • Converting a string to an Array
    by DeathSurfer
    2 Replies
    Last post by DeathSurfer
      • Duuuudes: Is there an easy way in vba to convert a string to an array of integers. For example: I have this particular array of numbers in the element <column_data_types> in a xml file: <column_data_types> 1, 1, 1, 1, 1, 1, 1, 1, 1, 5, 5, 5, 1, 1, 1 </column_data_types> I have a function that will grab the array of numbers but the function returns a string. ("1,