Microsoft ISV

Page 98




  • Topics
    Replies
    Last post
  • ACCESS - You do not have exclusive access to the database
    by agriff98
    4 Replies
    Last post by agriff98
      • I have an ACCESS application that is running locally on a user's machine. When they log in, they get the error "You do not have exclusive access to the database", then they have to click "OK" 21 times before the application will open up for them. The .mdw file is named different from the .mdb file, so they aren't locking each other out. Any ideas
  • Vba Excel 03 - Detect Shape Position and calculte related row number when sort / filter is activated
    by ajliaks
    6 Replies
    Last post by ajliaks
      • Hi guys, I have an excel datasheet where each row has on it a Shape called "myShape" + the Number of the Row where it is located, in example:
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • How can I make a chart with 2 x-axis categories?
    by lyp_sj
    1 Replies
    Last post by Andy Pope
      • Hello, I'm trying to make a chart with below data table. What I need is to show primary x-axis as years(2005, 2006, 2007, 2008). And in each year, I want to build bars by seasons(Vday, Easter, Halloween, Xmas). In each bar, I want to breakdown by Brand( skittles, starbust, jelly beans). How can I do that Thanks so much! Basically, I could not breakdown each bar with brand inform
  • Multiple series addition problem
    by bepenfriends
    2 Replies
    Last post by bepenfriends
      • I am not sure whether thisis the right place for this question. This is a problem which i am facing when coding in VB.net The problem is, I want to draw a line graph (3 series) in excel from the data present in designated positions in Excel. I worte a code which is as below charts = XLSheet.ChartObjects() ' Adding a chart chartObj = charts.Add(450, 200, 350, 200)
  • I need help modifying Sharepoint
    by mikeuscdallastx
    2 Replies
    Last post by mikeuscdallastx
      • I am trying to modify a few things in Sharepoint and I can't seem to figure out how. First off, is there a way to change the categories that are displayed on the homepage. I currently have announcements, links, and discussions displayed. I am wondering how I can have a list of my documents added as well. I also have a calendar but it isn't displayed on the home page. Please let me know if you can
  • Runtime Error '2001'
    by Mona_D
    6 Replies
    Last post by cobolisdead
      • I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Nam
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • Using DCount function in a Report group footer
    by LizF@RMIT
    6 Replies
    Last post by Cringing Dragon
      • Hi, I'm having trouble getting a DCount function to work on an MSAccess 2003 report. I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group. Here's what I'm using - which produces the result of '#Error' with no further help.: =DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM
  • Why Excel 2003 keeps PivotItems with zero record count after refresh?
    by johnson hk
    6 Replies
    Last post by Luise7x7x7x7
      • After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't min
  • Returning a custom object from a custom collection
    by MikeBos
    3 Replies
    Last post by Dick Donny
      • Hello, Am new to VBA object orientated stuff and have hit an early hurdle. I've created a collection of boat objects with an array of boats and an integer counter. Storing the boats isn't a problem however when I try to retrieve the boats I'm getting Object variable with block '91' not set issues. For e.g. In Main I'm calling Dim Boats as New BoatCollection ...Code t
  • VBA Help?
    by NWAprog
    6 Replies
    Last post by NWAprog
      • I'm new to VBA programming, while I understand Access a fair amount, I am continually running into the same problem. Can anyone help. I am developing a program for my job that tracks times. I have created forms that are supposed to make the entry easier and faster. On the first form the operator enters the information relating to the trouble call, when the submit button is clicked, the info
  • Echec Site etendu Microsoft SharePoint (score card manager)
    by louzar
    0 Replies
    Last post by louzar
      • hi when I set up score card manager I found this error Echec Site etendu Microsoft SharePoint how can I create an extended web site on sharepoint services 3.0
  • Help please
    by jovert
    3 Replies
    Last post by envi_ria
      • can i control any application or software using only VB program or how can i control any application using VB for example, i want to control the internet explorer then by using vb i can direct the website i want to go or write the address without manipulating,only the vb program to be used! Thanks a lot for the help!
  • Overflow (error 6)
    by une
    5 Replies
    Last post by Keithyboy1
      • I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line; startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now) startTime is declared as a double; Dim startTime As Double The value of startTime at this line (according to debugger
  • Can't change SourceFullName for linked object in PowerPoint
    by JStone
    2 Replies
    Last post by xpert
      • Hello to all, I need to change the linked info of about 400 items, because file names changed because the phrase "- Data -" had to be removed. Here's my code: Dim loSlide As PowerPoint.Slide Dim loShape As PowerPoint.Shape Dim sName As String '/ Loop through all shapes and find the linked ones For Each loSlide In ActivePresentation.Slides
  • Using ArcCatalog objects from ArcMap
    by CaRecycler
    0 Replies
    Last post by CaRecycler
      • I would like to use the objects available in ArcCatalog in a VBA routine I currently in ArcMap. What I want to do is to check on the existence of a table in a geodatabase. In ArcMap, I can use the Open FromFile object on the workspace but get a fatal error if the file doesn't exist. It looks like in ArcCatalog I could get an enumeration of geodatabase tables and check first but I can't figure out
  • Problem: Macro not deleting columns I select
    by Donaghy
    6 Replies
    Last post by Donaghy
      • Hi all, I have a section of code in my macro which tells it to delete a selection of columns: Columns("C:F").Select Selection.Delete Shift:=xlToLeft this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H. Any ideas why this could be happening
  • Refresh Data for large Pivot Table
    by IlicAlex
    0 Replies
    Last post by IlicAlex
      • Hello I had a VBA code that worked on Office 2000. The code automatically generated XLS pivot tables based on a changeable query and save each excel file separately. The original MDB file is 1.2 GB due to a large table used by query to generate year by year XLS reports. Per year I have at most 600.000 records. When I upgraded the code to Office 2003 I noticed the following problem wit
  • Random sort in Excel
    by MegamanSA
    1 Replies
    Last post by Peter Mo.
      • Hi I have asked this about four years ago and got sent the perfect code but have since lost it :-(. I have a list of items in the rows and prices in the columns, I have four different prices in col C,D,E,F. Eg. Item Code - Item Neme - Price 1 - Price 2 - Price 3 - Price4. Now I need to bubble sort columns C.D.E.&F so that it mixes up the prices in the columns without affecting the
  • How to open a folder through excel macro!
    by Harish Singh Adhikari
    5 Replies
    Last post by Peter Mo.
      • Hi, I am a new learner in Macro field. I want to know how we can open a folder using macro. The scenario is ---> I want to open a folder having a no of files . After that i want to open these files one by one.......
  • Validate
    by PYA_Ferro
    4 Replies
    Last post by PYA_Ferro
      • Hi! (sorry for my English) I'm storing the value of a TextBox in a variable named "i" I want to validate "i" so it can only store numbers (great than 0) and not letters. If i < 1 OR i "is a letter" then msgbox("wrong value...blabla") else code... end if How can I validate that "i" is (or not) a letter Thanks.
  • Excel edit mode
    by denisJaubert
    14 Replies
    Last post by denisJaubert
      • How can i detect "edit mode" in excel macros Thank's for idea(s)
  • Time Addition
    by MoPatel
    1 Replies
    Last post by sjoo
      • Hi all, I am facing such a horrible problem, i have tried everything and cannot find a way to solve it and it is now driving me insane. What i am trying to do is to calculate the amount of hours a member of staff has worked for the whole week, this is done through VBA on a userform and i just cannot do it. the main problem i am facing is how to add hour and minutes together to give me a val
  • Network Printing from EXCEL VBA - HELP
    by Mr Catton
    1 Replies
    Last post by ADG
      • This will probably be a no brainer for an experienced VBA Programmer. I can't seem to find out how to print to a shared network printer. I use the Visual Basic Editor in Excel 2003, and assign my macros to custom buttons. Heres the method I use to print. ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True (What I want to do is have the print go to a shared