Microsoft ISV

Page 81




  • Topics
    Replies
    Last post
  • Registration Limits and Useage Rules
    by mikalyo
    1 Replies
    Last post by MS ISV Buddy Team
      • I recently downloaded Microsoft Visual Basic 2005 Express Edition, and have a few questions: 1.) How many computers am I allowed to install Visual Basic 2005 Express Edition on 2.) How long will each registrartion last 3.) Am I allowed to use the Express Edition for non-profit organizations with multiple users for an extended period of time
  • Size Form to fit user resolution
    by Gidjett
    11 Replies
    Last post by gordyjm
      • I have several multi-user Access applications. After much time-consuming research I have not been able to find anything that works on this question: How can I get my forms to automatically fit the USER'S screen with their set resolution with the OnLoad event of a form I have already tried me.height, me.width with no success. Anyone have any other suggestions Any help would be greatly apprec
  • How do I display the same modified embedded chart each time?
    by Steve. S
    3 Replies
    Last post by Steve. S
      • How do I display a modified chart when a command button (cmdShowTemp) is clicked on a worksheet I used the code generated from a macro I recorded creating a chart using the wizard - using the data and making the changes I would like to see i.e. wider chart area, fill color etc, for this command. But I notice in the code the line Charts.Add, which I assume is why every time this command is clicked
  • open Excell file from Access with dialogbox
    by Norbertus van der Lei
    2 Replies
    Last post by Norbertus van der Lei
      • Is it possible to open an Excell file from Access, but the file name is variabel. So I need to choose in a dialogbox open file Thanks, Norbertus van der Lei
  • CRM 3.0 Outlook Client
    by keithpsft
    18 Replies
    Last post by keithpsft
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • Disabling the X (close) button on a UserForm Reply
    by rabbitoh
    5 Replies
    Last post by rabbitoh
      • Does anyone know how to disable the X on the top right corner of a UserForm so that when a user clicks on it to close the form, they get a message saying "Please use the Exit button" (which is a macro button on the form itself)
  • putting shortcut for folders
    by BassHunter
    0 Replies
    Last post by BassHunter
      • hi, i want to put a shortcut into the access formular that opens a defined target on the computer, as everyone knows: like creating a shortcut on the desktop. but neither with command buttons, nor with adding objects, it hasn't work. does anyone know how i can achieve it thanks.
  • Problem with code: "Type mismatch" error
    by PyroJoe84
    2 Replies
    Last post by ADG
      • I'm writing a program to do some basic design for wood stud walls. The actual process really isn't important, but there is a part I am having problems with. The process involves many different equations and I need to end up solving for the total load, P. However, when all the equations needed are combined together (needs to be <= 1.0), 'P' occurs multiple times and is nearly immpossible to isol
  • calling sub within function. works fine as sub, but not in function
    by pacificwaters
    11 Replies
    Last post by pacificwaters
      • Using VB 6.3. Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work. But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
  • Problem between two domains
    by Ricardo Jorge Santos
    1 Replies
    Last post by MS ISV Buddy Team
      • Greetings to you all! I wonder if i can get help to my problem. I have two different domains on my company. One of the domain has all the resources to be used, and will therefore be designated as Resource Domain(RD). It supports all programs, printers, and most important, the group policies to apply to every workstations that logons to the RD domain. The other domain , that will
  • how do re-enable marco after it stopped?
    by sirpelidor
    3 Replies
    Last post by Andy Pope
      • Hi, I wrote some vba code within the Worksheet_Change sub. It supposedly fires whenever a cell value has been changed. Problem is...sometimes it fires, sometime it doesn't. Whenever it doesn't (probably because it encounted bug within my code), no matter what I do, I can't re-enable the marco again. So far, the only way for me to go around that copy my code into a clipboard, close out excel (not
  • Vertical text centering in label
    by une
    1 Replies
    Last post by Andy Pope
      • How do I make sure that text in a label's caption is centred vertically within the label Horizontal centring is easy to change, but I don't see a vertical setting in the properties window.
  • Inserting additional chars into a string....
    by Guustaaf
    2 Replies
    Last post by Guustaaf
      • Hi pals and gals, Could someone help me with the following problem I have a userform in wich the user types personal data of new employees. Now i want the text in the textboxes to automaticly change into the correct format at BeforeUpdate. example: Private Sub txtVoorletters_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) txtVoorletters.Value = StrConv(txtVoorletters, vbUpperC
  • Can I run a Sub in an Access Module from a button in Excel?
    by ADG
    3 Replies
    Last post by Mohamed Shifaz
      • Hi all, Can someone remind me if I can execute a subroutine in an Access module from Excel, and how. I have a button in Excel which is doing some work with the database, before updating an existing stored query in the spreadsheet. But, I have a need to do further complex processing which is already in a subroutine in the database. I don't want the user in the database as it is a fron
  • is there an alternative to ActivePrinter?
    by BrookeM
    0 Replies
    Last post by BrookeM
      • I'm looking for an alternative to setting a Word printer through the ActivePrinter command. Is there a way to set it in Dialogs or PrintOut or some other application method I know the work around to set the ActivePrinter and then reset to the default. I'd prefer to just set it temporarily for that specific instance and leave the default alone. Thanks!
  • Textbox Value does not display on userform
    by Nielvh
    1 Replies
    Last post by Nielvh
      • I created a userform in Excel where the user enters a customer number. It then looks at a Pervasive Database and collects information about that customer (Name, Address, etc.) in a ADODB recordset. Each record is then passed to a different textbox. Everything works, but on my userform I only see the value of the first textbox (tbCustName). The other textboxes are blank on the userform although the
  • hi all,is there some good book for learning vba?
    by todo01
    1 Replies
    Last post by Andy Pope
      • i just start to learn this language,i find there is some names i never seen before...any material to get a quick sense about vba,,just for building a framwork in my mind...thanks;
  • LCS 2005 SP1 (Outlook Contact pulled into MOC not Normalised by ABS)
    by DeonSt
    1 Replies
    Last post by DeonSt
      • Help , I am desperate to get this issue resolved. Setup LCS 2005SP1 SE with patch LCS2005-KB911996-x86-Usa1.msi installed to resolve issues including ABS Number Normalisation. Phone integration enabled for MOC users via Remote Call Control on LCS & PBX Desktop users have a variety of Desktops Vista Business and Office System 2007 XP Pro SP2 with Office 2003 The pro
  • Using a Check Box in Excel
    by aburnett
    3 Replies
    Last post by sjoo
      • I have never written any code before so I need some help. I would like to insert a check box on a sheet in excel. If that box is checked I would like to copy specific information from a range of cells from another sheet to the sheet with the check box in it. For example, I would like to copy data from cells D7 through CO7 in sheet 1 to cell D1 in sheet 4. I know how to insert the check box
  • Excel as ID database and ID assigner
    by truongn2
    2 Replies
    Last post by truongn2
      • Hi, I have an excel workbook with a few worksheets in it. Each worksheet contain part of an ID string that will combine with others to create a whole ID. Here is an example: I have a worksheet called "master", it contains a list of whole ID strings, for example "UNICOL1001". That whole ID string is composed of university names (UNI), colleges within the universi
  • Access Combo Boxes
    by Quarry
    0 Replies
    Last post by Quarry
      • Hi, I have an access form with 2 cascading combo boxes on it - cbo_market and cbo_competitor. Cbo_market has an union statement in to return '*', so when a user selects this it will bring back all competitors. However I need to know that when the user selects '*' from the cbo box it then restricts the 'other' value from cbo_competitor. If however a user select a certain market from cbo_market the
  • Imprting text file with no delimiters into excel file
    by Peck Chun Hua
    8 Replies
    Last post by Mezhick
      • hi anyone, i have a problem in creating a macros that will import an txt file into an excel file, the text file has no delimiters but every single different characters will have to be in a specific cell. For example in the first line, first 2 character belongs to excel cell A!, then next 10 characters is B1, then next 8 Character C1 and last 3 character is D1. Regards P.Chun
  • Coding MS Project 2003 VBA for multiple Languages?
    by John Talbot
    1 Replies
    Last post by John Talbot
      • I have been coding some macros to run in MS Project 2003 that works fine when run under English language version but when used by a user in say France using the French MUI option fails miserably. I have a work around for: ViewApply Name:="Resource Table", singlepane:=True By seraching for a view with right screen attribute eg ' Get first resource table view For Each viewObje
  • Excel Workbook corrupting
    by hobeau
    4 Replies
    Last post by Rod Wing
      • Hi, I'm having a problem with an excel vba project. I have 2 computers, both of which have windows XP pro and office 2003 (same service packs etc...). These computers are both connected to a Microsoft file server and have read/write permissions etc... I create an excel workbook, add a vba project and do some coding on computer1; I open the same excel spreadsheet on computer2 and its corrupted. Exc
  • Odd or even and converting Decimal to binary, octal, or hexadecimal and back.
    by silver6
    4 Replies
    Last post by Lgee212
      • how do I make an algorithm that asks the user to enter an integer number, then determine whether the number is odd or even.  How would you write that in Visual Basic code Secondly I need to figure out how to convert a decimal number into binary, octal, or hexidecimal.  It needs to ask the user to enter a decimal number and then ask if it needs to be converted to binary, octal, or hexide