-
- Making connection from one Access database to another.
by mikeym82
- 2 Replies
- Last post
by leo romero
- I have a mdb file called the CustomReportsModule.mdb, and a Data.mdb file.
I am trying to create a module within the Customom Reports Module to connect to the data.mdb (which is used only for data storage), and execute a select query. Then I want to create a table based on the query's results.
I've been trying to use ADODB, but can't seem to really wrap my head around what to do. I have been
-
- Directss Install
by Edday
- 4 Replies
- Last post
by AzmathMoosa
- hey i have written a program in Excel using VBA and it used a module called DirectSS which is like the application.speak but is much more customisable (speed, tone, visual) which is why i used it. When i got home, i went to work on it and DirectSS isn't installed on my computer. I have googled quiet abit and found next to nothing on DirectSS. Does anyone here know how to install it or where to get
-
- Need to link two word documents together.
by Lunar Beam
- 3 Replies
- Last post
by Shasur
- Hi,
I have two documents which have roughly similar tables that need to be filled in Microsoft Word.
I would like to have a macro that updates a cell in a 5-by-5 table in B.doc when a cell in a 5-by-5 table in A.doc is updated.
1) A.doc is updated.
2) B.doc is opened, then updated.
3) Both documents save themselves.
It would be best if steps 1-3 are completed with
-
- Pivot Table Macro
by GB Allan
- 3 Replies
- Last post
by GB Allan
- Hi,
I have set up a small macro to create a pivot table from a spreadsheet:
Sub CreatePivot() ' ' CreatePivot Macro ' Macro recorded 3/14/2007 by Gary
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _ "Data!R1C1:R656C90").CreatePivotTable TableDestination:="", TableName:= _ "PivotTable1", DefaultVersion:=xlPivotTableVersion10
-
- Vlookup in VBA
by crainsworth
- 3 Replies
- Last post
by mnptl
- Hey eveyone,
I'm have a lot of difficulty using a vlookup in a macro I'm creating. If anyone could help it would be greatly appreciated.
Here is the code:
'**********************************************************************
Sub proScoreCard1()
Dim rng As Range Dim tradeDate As Date Dim confirmDate As Date Dim t1mDate As Date Set rng = Range(
-
- Summing up hours on form based on parameter query
by RhysDavies
- 6 Replies
- Last post
by RhysDavies
- Hi there - im finalising my new activity system but i have one issue.
on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the
-
- Newbie in VBA Drag and Drop..
by den2005
- 8 Replies
- Last post
by den2005
- Hi,
Do not know if this is possible drag and drop effect of items in dropdown control inside a word application
The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done
Thanks in advanced.
den2005
-
- How to run a SQL Server Job in VBA
by HMote
- 8 Replies
- Last post
by Melissa H
- Does anyone know how to run a SQL Server Job in a VBA macro Thanks!
-
- Vertical scrolling in VBA
by FWR
- 2 Replies
- Last post
by FWR
- Dear all,
Vertical scrolling using the mouse wheel does not work in the code window (the window where I write program code) of my VBA.
In other cases, vertical scrolling using the mouse wheel works just fine (for example, there are no problems scrolling in the project explorer or properties window of VBA). So, I don't think there is anything wrong with my mouse or the way it is insta
-
- CurrentRegion Property to Specify SourceData in PivotCache Method
by jbrcks
- 3 Replies
- Last post
by Jon Peltier
- I'm fairly new to writing VBA macros to create pivot tables in Excel, and I could use some help. I would like the macro I am writing to be able to use the Currentregion property in order to specify the SourceData for the PivotCache method, where the source data is located on a sheet named "macro". Any feedback warmly appreciated.
-
- CRM 3.0 Outlook Client
by keithpsft
- 7 Replies
- Last post
by PFLIK
- 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
-
- need help writing a vbscript to open a spreadsheet and run a subroutine in a macro
by ronald cole
- 2 Replies
- Last post
by Shasur
- Actually, I need help coding the "running a macro" part. I have a spreadsheet with a macro called "snafu" on sheet2 that contains a private subroutine called "runme" tied to a button. I just need to script up something that opens the spreadsheet and runs that subroutine and closes the spreadsheet. Sounds simple, huh Six hours of googling and reading the Microsoft Exc
-
- Problems displaying VBA Help
by twaltz
- 2 Replies
- Last post
by twaltz
- Within all of my Office products (Excel, Access) and VB6, the HELP within VBA is not displaying properly (graphics do not display and I am seeing boxes with a red X) and I am continually getting Internet Explorer Script Errors. I think that I first noticed this occuring just after I installed VB 2005 Express.
Has anyone else noticed this problem And more importantly can anyone tell me how to co
-
- Access Forms
by PC Geek
- 4 Replies
- Last post
by stlarmon
- hi, Ive got a form, in MS Access and its a group control, which means it can only output integers. I need a little code to attach to the form, so that the text field which its bound to, actually gets the text. eg, if i select "before 2000" on the field, then the database would get "before 200" instead of somethign like 6 etc. i hope im explaining this clearly. Im wondering if s
-
- Application.ScreenUpdating Problems
by SethEden
- 6 Replies
- Last post
by SethEden
- I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55,000 lines of code, optimized down from more than double that of course.
Everything seems to be working nearly perfect and I think I've even solved my problem with the call to Application.ScreenUpdating, but I'm not really sure why, and I couldn't find documentation
-
- users appear to be offiline in LCS 2005 enterprise edition .
by senjoy
- 2 Replies
- Last post
by MS ISV Buddy Team
- Dear Friends ,
i have installed SQl 2000 with its service pack on Win 2003 Enterprise edition server .which is acting as a member server along with LCS 2005 enterprise edition With Sp1 .
now the issue over is most of the users are able to login to Office communicator 2005 with the User id & password provided but they cannot send message to other users logged in to the same domain ..
-
- API and OpenGL in VBA for Excel
by Spinor
- 7 Replies
- Last post
by @sanya
- How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).
-
- CRM 3.0 Outlook Client
by keithpsft
- 9 Replies
- Last post
by DavidJennaway
- 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
-
- Target Multiple Cells
by DinnerPlates
- 2 Replies
- Last post
by DinnerPlates
- Hi
I'm new to coding macros and have had great help with this forum in the past so thought I would give it a shot with another problem I have encountered.
I have created a macro that looks like this (thanks to the help of Andy):
-
- Subscript out of range with a simple sql :-( [newbie to VBA]
by Maximus
- 14 Replies
- Last post
by Andy Pope
- Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers!
Code Snippet
Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
-
- installing business scorecard manager
by harry_cof
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hello, I try to install it on windows 2003 server with SQL server 2005 but I can't find this :"Fournisseur OLE DB Microsoft pour OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)" Can you help me
-
- CurrentRegion Property to Specify SourceData in PivotCache Method
by jbrcks
- 3 Replies
- Last post
by Jon Peltier
- I'm fairly new to writing VBA macros to create pivot tables in Excel, and I could use some help. I would like the macro I am writing to be able to use the Currentregion property in order to specify the SourceData for the PivotCache method, where the source data is located on a sheet named "macro". Any feedback warmly appreciated.
-
- Vertical align the contents of a text box
by vsyam
- 4 Replies
- Last post
by vsyam
- Hi,
I am working on a project where textboxes are used to hold different types of content like normal text, fields and shapes. I want to vertically center-align the contents of the textbox w.r.t the textbox itself. Any ideas
Thank you.
-
- 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!
-
- Creating a dynamic hyperlink to a worksheet cell in Excel using VBA
by Justus Beek
- 6 Replies
- Last post
by Cringing Dragon
- I would like to add a hyperlink that refers to a cell within a worksheet and I would like to do this dynamically.
As an example:
Sheets("Sheet1").Hyperlinks.Add Anchor:=Sheets("sheet1").Cells(1,2), Address:="", SubAddress:= _ "'sheet2'!A1", TextToDisplay:="Back <<"
This works.
But now I would like to assi