-
- Scorecard Manager Annotations
by BNavas
- 0 Replies
- Last post
by BNavas
- Hi, there,
I have a problem with the annotations on BSM 2005 server. I have the following configuration:
Win 2003 (English)
sharepoint 2003 (in spanish)
BSM server (English) *this forces me to use a manual connection string with locale_id for spanish, because AS was on another language.
SQL Server 2000 (English) SP4
AS 2000
NS 2000 SP1
The problem I have is that
-
- Outputting to a Listbox
by UniRyan
- 7 Replies
- Last post
by Andy Pope
- Hi;
I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user.
Ryan
-
- Newbie need help... Thank U.
by |OREO&#12
- 4 Replies
- Last post
by Cringing Dragon
- Hi all, I'm new to VB and currently, I've to assist my mates with a project. Below is what's happenin. Hopefully the seniors could assist Thank U. Aim: To design a VBA form in Excel which will take 3 or more values off a .csv file, display it on the form, and then using the values to plot a graph. The steps I've taken so far in assistin. Steps: 1. Form created. 2. Buttons for a regular update imp
-
- ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
by Claus Brod
- 12 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
-
- Order by in select statement not working
by RhysDavies
- 5 Replies
- Last post
by RhysDavies
- Hi there - i have a select statement that runs on form load that allows selection of appropriate company names from a combo box based on if the user is the owner of a company, which works great, syntax is below;
Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'"
However i want to sort them alphabetically by
-
- checkbox and enabling text fields
by StuartB10
- 1 Replies
- Last post
by Rick
- I am truly a novice when it comes to VBA and hopefully someone can help. I am trying to write some VBA code in Word 2003 for a document / form that contains a check box and a text field. All I need is for the text field to be enabled once the checkbox has been checked. I cant seem to get it to work. Any help would be appreciated So far I have come up with the following but it doesnt work If Se
-
- Macro stops running after a certain time, excel limitation???
by blackmamba
- 6 Replies
- Last post
by envi_ria
- Hey guys i have this problem: I have to run a macro for Excel that calculates some values for the entire 2006 year. To do that it has to open 365 daily files check for some circuits and calculate a sum. It opens a file does some checking, writes some values then closes it, opens the next one and so on. For a smaller number of circuits it worked fine and took about 10 minutes. Second time it opened
-
- Expression Has No Value
by PTBowen
- 2 Replies
- Last post
by bi-lya
- I'm using VBA in MS Access to open and export or open and close reports. I open a report, if it has records it is exported, if no records are found the report is supposed to close.
Code Block
Sub BHIJOBS ()
If Reports!rptBHIJOB!JOB.Value = False Then
DoCmd.Close acReport, "rptBHIJOB"
Else
Application.ExportXML _
ObjectType:=acExpor
-
- A simple list of words from a word document
by jnxd666
- 2 Replies
- Last post
by jnxd666
- I want to create a list of words from a word document. For example a document containing a sentence " The quick brown fox " the list of words should be - The quick Brown fox I initially thought I would use the Activedocument.words.count to find the total number of words in the document. Then use a do while loop to iterate through each word and generate a list. The solution was easy
-
- Compatibility Issue Excel 2000 and Excel 2003
by rcash864
- 11 Replies
- Last post
by Jon Peltier
- I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up.
So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
-
- WorksheetFunction Object help needed
by Rakesh Simpi
- 4 Replies
- Last post
by rakesh
- i am trying to use WorksheetFunction object to calculate R-Square (linear regression) value. Now, if i export my numeric data to cells of a worksheet and use Value2 function, i get an appropriate answer. But, if i try to use WorksheetFunction object by passing my arrays of integer, it gives me some spurious result which seems to be completely irrelavant. here is my sample code: dim Appp as new Exc
-
- Efficent Way to manage multiple textboxes (maybe a loop?)
by jeff_fire
- 3 Replies
- Last post
by Joe Dawson
- This might be really easy, or maybe it's really hard I'm
pretty new to VBA I'm using the VBA editor in Excel 2003 to automate some data entry into a
spreadsheet. I have several userforms all with various numbers of textboxes,
the largest having 34. What I am trying to do is use some sort of loop to clear
the value out of each textbox when the user creates a new record. I want to do
this most
-
- Creating and Editing Microsoft Access Reports using Visual Basic
by bennymacca
- 3 Replies
- Last post
by bennymacca
- Hi,
I am trying to create a report based on the selection from a combo box in a form.
i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button.
i have written the code below, but the report is only ever bl
-
- Load userform returning variable not defined error (91)
by Marty1
- 3 Replies
- Last post
by Leffrey
- Hi there,
I haven't previously had any problems loading/hiding etc userforms in vba, but I've just finished a project that runs fine when stepped through. However, when run properly, it returns a variable not defined error on the Load xForm command. The form is in the same templateproject and the load form command is the first to be executed.
Any ideas
Thanks in advance
-
- this problem is also troubling me now!! :(
by Moim Hossain
- 14 Replies
- Last post
by WebDev2000
- Hello everybody,
I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
-
- How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel?
by Sajagesh
- 8 Replies
- Last post
by Sajagesh
- How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel If the combo boxes are named using the cell reference on which these combo boxes are placed and linked. For example, a combo box, placed over the cell "G23", will be named as G23.
-
- How to turn OFF Simple File Sharing via Policy Editor in Server 2003
by TheTom
- 2 Replies
- Last post
by 1222256
- We are in the process of rolling out Sophos AV. One requirement is that you must turn off Simple File Sharing on clients (XP Pro). As we have 100 desktops to deal with, we'd like to do this via Policy Editor. I can NOT find any entry that will accomplish this in the editor. Any help out there Thanks!
TheTom
-
- User Defined Array Function in VBA
by Joe Dawson
- 0 Replies
- Last post
by Joe Dawson
- Hi, I want to write a user defined function that behaves like an array a function in Excel (the type where you have to hit CTRL+SHIFT+ENTER. Can this be done Say I want to convert the formula to a user defined function in VBA. The formula takes the minimum value in Column D for only cells in column A that equal Baa. {=MIN(IF(A2:A7000 = "Baa", D2 7000))}
=MIN(IF(A2:A7
-
- Zip and Unzip using Access VBA
by dssjon
- 1 Replies
- Last post
by Andy Pope
- Is there a way to zip and unzip files from access using VBA using the built in windows compression I have only found examples for excel and also that call WinZip. I dont have winzip on our machines so I need to use the built in windows compression.
-
- Need urgent help
by envi_ria
- 1 Replies
- Last post
by Andy Pope
- Can i protect and unprotect an excel file in VBA.
I need urgent help in this can any one help me out. I have to open some excel files copy all the names of the excel file from that folder and then a copy a corresponding coloum name also in the new excel sheet. But these files will be protected. i will have to open and the file unprotect it copy a data from a pertucular lable name and then lock
-
- Why is my Web Query Refreshing Inconsistently?
by bob135
- 4 Replies
- Last post
by bob135
- I have asked on several other forums (In Mr. Excel, a popular excel forum, my post got bumped to the bottom, I'll try posting it again but yeah...I'm looking everywhere now). Here's the issue: This is the code for my query: WEB 1 http://finance.google.com/finance fstype=ii&q=["Ticker"] Selection=EntirePage Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True
-
- 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
-
- Does Winqual accept WER reports from Vista systems?
by Claus Brod
- 14 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
-
- "Unable to record" error message
by Charliecfs
- 1 Replies
- Last post
by Peter Mo.
- As I try to enter a long formula (while I record the macro) I get a message that says "Unable to record". I'd hate to shorten my formula. Any ideas
-
- Toggle buttons
by une
- 4 Replies
- Last post
by une
- I need some help programming toggle buttons. I assume a toggle button can have 1 of 2 states and the state alternates when the button is clicked. Is this correct I am thinking about some code as follows;
Private Sub ToggleButton1_Click()
ToggleButton4(changeState)
If ToggleButton1.state = false Then
ToggleButton1.caption = "NO"
Else
ToggleButton1.caption = "YES