-
- Access - VBA Script
by phpx2pperl
- 1 Replies
- Last post
by mnptl
- I have a sub form which needs 2 fields updated one is numeric and the other is text both are using text boxes as the control source. I have searched the web and my book references but stuck on getting the input from the user for these two fields and updating the input at my target table. One question is can I update my target table using the dynaset and form I used to build my resultant query You
-
- Add a customized Tab in Communicator 2005
by Gabriel Méndez
- 7 Replies
- Last post
by Ken Kosmowski
- Hi, i'm trying to add a new customized tab in Communicator 2005 to show an html page, i have a document titled "Planning and Deployment" which somehow explains how to do this... I tried to add a new entry on the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Communicator called "TabURL" and also under HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator wi
-
- Text jumps to next page after a table
by gazza-d
- 1 Replies
- Last post
by MS ISV Buddy Team
- I seem to be having great problems when editting a documant in that often the text following a table will jump to the next page leaving a large space. The cursor also jumps from the table to the start of text on the next page. I assume I'm doing something wrong here. (Microsoft Word for Windows 97 running on an XP)
-
- powerpoint automation via vb.net
by bikash
- 0 Replies
- Last post
by bikash
- Hi I am sending a list of records to each textbox in powerpoint. for each
text box if i find any text tahts in between # i need to make them bold. e.g.
"I want #this# bold."
here "this" should be bold when interpreting in powerpoint.
below is the code where i am able to capture the text thats in between #.
The problem is i want only selected text bold and rest norm
-
- Timer on macro execution run time
by une
- 8 Replies
- Last post
by Andy Pope
- I have written some text analysing code that takes a long time to execute if the text selection made by the user for analysis by the macro is too large. Therefore I would like to add the following functionality to the macro;
If after 15 seconds of execution the macro has not completed, I would like execution to halt and output a message to the user asking them to reduce the size of the sele
-
- Run time error 1004
by Donald Wm. Johnson
- 11 Replies
- Last post
by Phillb
- I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed."
The actual line causing the error is:
Selection.Delete Shift:=x1Up
where I have previously selected the ra
-
- Calculate hieght
by YaelS
- 2 Replies
- Last post
by YaelS
- Hi,
This method change the hieght and Width of the sub form in the form calling in
form resize event.
I don't know what is 6615 parameter meens ctrl.height = fHight - 6615 + DEF_H
Code Snippet
Sub sub_forms_hieght(frm As Form) Dim FLeft As Long Dim FTop As Long Dim fHight As Long Dim FWidth As Long Dim ctrl As Control Const DEF_H = 3850 Const DEF_W = 7335
Call GetFormD
-
- DAO can't connect to Access2007
by Haojun
- 3 Replies
- Last post
by Venkat M
- Hi all,
I'm using DAO to connect to an Access2007 database file. But it reports such an error "unrecognized database format". Does anyone know if MS supports using DAO connect to Access2007 Is there a new release of MDAC along with its Office2007
Thanks in advance,
- Haojun
-
- Excel VBA Worksheet Arrangement
by rodcon
- 1 Replies
- Last post
by Andy Pope
- Does anyone know how to arrange worksheets within one workbook I want to split the Excel window between Worksheet(1) and Worksheet(2) Can this be done
-
- Conditional Formatting Problem/Bug?
by FaV1105
- 8 Replies
- Last post
by FaV1105
- This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this:
I don't know if this is a bug in excel or if I am doing something wrong.
I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
-
- Product announcement for Empower for ISV partner
by BobL
- 1 Replies
- Last post
by H Patil
- Hi all,
We are an Empower for ISV partner and will be contacting Microsoft to tell them that we have our new product coming out very soon. We need to make the announcement on our website next week and I was wondering if there are examples out there on the Web that will guide me as to how the announcement should look. I know that there has to be some specific information in the announcement
-
- How to make a macro to copy some parts of a table to an email that it will create?
by kebever
- 8 Replies
- Last post
by kebever
- Hi,
I'm quite new to VBA but had some experience coding for Excel. I now require a macro to help me solve a problem in Word and email. I hope someone can help me here. Thanks in advance!
The issue is that I need to copy some parts of a table in Word to an email that it will create too.
For eg.
There are two columns to the table, with the 1st row, column 1 being "Na
-
- adding a non-adjacent cell to a named/defined range
by bilo_krewol
- 2 Replies
- Last post
by Andy Pope
- I have a set of data in a spreadsheet that I want to run a macro through that will:
1. test each cell against specified conditions;
2. depending on what conditions are met, add that cell to a specific, named range; and
3. run statistical analysis on the named ranges.
#1 and #3 I am OK on, but #2 - I have not been able to figure out how to resize the range to add a specific, non-adj
-
- Method 'SnapshotPrint' of object 'ISnapshotViewer' failed.
by dgmyers
- 4 Replies
- Last post
by MS ISV Buddy Team
- I have code that is printing a snapshot file. This code works fine on a number of PCs, but on others it does not. On those PCs where it does not work I get the following error:
Method 'SnapshotPrint' of object 'ISnapshotViewer' failed.
or
Method 'SnapshotPrintDirect' of object 'ISnapshotViewer' failed.
I found Microsoft article 224002 which says to add "File://" to the begin
-
- Outputting histograms and graphs
by une
- 4 Replies
- Last post
by une
- Instead of outputting data in text from in a message box, I would like it to appear on screen as a histogram or graph in a window (message box ). Where should I start to get this done
-
- Macro to Delete Rows
by GB Allan
- 6 Replies
- Last post
by GB Allan
- Hi, I am writing a macro that I want to do the following with:
1-Sort spreadsheet by column J.
2-Search for the first instance of the term "unbilled."
3-From that point and down, delete all rows below.
4-Delete specfic columns.
I'm having trouble with steps 2 and 3 - the search works, but for the deleting of the rows, it's picking a specific row range. I want it to del
-
- Open PDF file
by sweet-66
- 5 Replies
- Last post
by RhysDavies
- Hi everybody,
I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba)
thanks in advance. :-)
-
- Business Scorecard Manager to Sharepoint deployment
by Johanvdk
- 2 Replies
- Last post
by PopeR
- Hi, I have setup all necesary things in BSM and SPS, but when I deploy, the the pulldown with the "sharepoint site url" is empty, as well as the "document library" pulldown. Are there steps in Sharepoint necesary to maken the http://localhost site available for BSM deployment
-
- Bucket ID 8
by Claus Brod
- 14 Replies
- Last post
by DHON
- Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
-
- Automatically attaching a txt file to a sent form
by jdwilliams543
- 0 Replies
- Last post
by jdwilliams543
- I've got a form put together in Outlook 2k3 for our helpdesk. We use the Cerberus ticketing system, so having a form the customer can fill out and automatically e-mail to Cerberus just made sense. The only problem is, Cerberus doesn't see the fields from the form. (Click here to see a screenshot of the Form in question) There are two options I'm seeing that would fix this problem, unfortunately
-
- How can I change a seires chart type in Pivot Chart?
by lyp_sj
- 1 Replies
- Last post
by Jon Peltier
- CLV Export
CLV FN
CLV FNN
CLV Main Milk
Demand
SOC
Demand
SOC
Demand
SOC
Demand
SOC
1724
2000
644
2000
5603
2000
2192
2000
1720
2000
615
2000
5813
2000
2271
2000
2293
2000
604
2000
5476
2000
2161
2000
2156
2000
516
2000
6290
2000
2201
-
- using ado(msdaora) connect oracle 9i db server , long transaction block other transaction.
by globelin
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hi all,
I have an asp application use com+ (msdtc ) to handle a transaction.
I find something wrong with msdtc services.
The test code like this
Long transaction ..
<%@ transaction=Required%> <% Server.ScriptTimeout=5 dim strExportDataSQL strExportDataSQL= "Begin " strExportDataSQL=strExportDataSQL+ " DBMS_LOCK.SLEEP (120); " strExportData
-
- Trying to extract data from one sheet and list it in another...
by Scott Boyd
- 2 Replies
- Last post
by Scott Boyd
- Hi, i have a sheet with lots of employee data on it including the manager name. I want to loop through each employee and make a list of the managers and display this in sheet 2. I only want each manager to be displayed once no matter how many times he occurs. Here is what i have so far - probably very messy but its the best i can come up with!
Code Snippet
Option Explicit
Sub manag
-
- Error while editing Tasks\Announcements etc. in Sharepoint 2007
by Ashish Saxena_Sapient
- 3 Replies
- Last post
by Zhang Mingquan, Mike
- Hi,
I have Sharepoint Server 2007 beta 2 with TR installed. I created a a site with the Intranet Portal available, and created the required site hierarchy. All was going well and working fine, but all of a sudden I started getting the following error page while updating any content in my web sites
Go back to site Error
This Page has been modified since you opened it. You must open the p
-
- Post-Empower ISV Options
by brian_w876
- 6 Replies
- Last post
by T. R. Tinker
- Hi all, The company I work for has been in the Empower ISV program for almost two years. During that time, we have completed version 1.0 of a very large (about 800,000 LOC) enterprise application. We have made a few sales, but we're not rolling in the cash yet (hopefully that will change soon). We are still adding new features to our product, fixing bugs, etc, and as such we still need development