-
- 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
-
- Error 1004 - "Unable to set the PaperSize property of the PageSetup class" in Access 2003
by Payback
- 1 Replies
- Last post
by Rod Wing
- Good Day, I am experiencing a '1004' error "Unable to set the PaperSize property of the PageSetup class" when I attempt to set this property to "xlPaperLegal" on an Excel spreadsheet in Access 2003. I am using the following code to set this property; xlwks.PageSetup.PaperSize = xlPaperLegal The code used to define the xlks follows Dim xlwks As Object Set xlwkb = xlapp.W
-
- Registration Limits and Useage Rules
by mikalyo
- 1 Replies
- Last post
by MS ISV Buddy Team
- Can I install & use Microsoft Visual Basic 2005 Express Edition on multiple machines within a non-profit organization
-
- Display a TextBox or Non-modal Message Box
by sg549
- 6 Replies
- Last post
by Andy Pope
- Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show
Alternatively, is it possible to put up a "non-modal" system
-
- macro for automatically creating data labels in excel chart
by Erik Houtriet
- 8 Replies
- Last post
by hysenlici
- Hi all,
I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field.
I use the following code:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C
-
- Is Office2003 still does not support passing command line arguments to VBA?
by Aleksey Nagoga.
- 2 Replies
- Last post
by Aleksey Nagoga.
- Hi All,
Back in the Office 97 days I tried passing command line arguments to VBA code within a doc file and it didn't work. In the end I found a workaround that was a bit of a hassle to implement but did what I needed.
Today, I found myself in a need of accomplishing a similar task in the Office 2003, plus the solution must also work in the Office 2007.
I was wondering if MSFT finally a
-
- Coaching in VBA
by shri577057
- 1 Replies
- Last post
by Shasur
- Hi,
I am planning to take VBA classes for redesigning couple of databases. I have basic knowledge in VBA. But I am looking for Advanced VBA coaching. Can anyone suggest me some good VBA trainers around Chicago area.
Thanks in advance.
-
- algorithms vba or c++
by magellan90
- 3 Replies
- Last post
by magicalclick
- i've been asked an opinion on number-crunching using algorithms - the question was whether c++ or vba was more adaptable and effective. i have used vba to construct algorithms in excel and have no technical knowledge of c++ to really evaluate the difference. essentially we're looking for conversion speed from mass data input.
thanks for any response.
-
- Table Caption Property
by swoozie
- 2 Replies
- Last post
by Workcover
- I am creating tables dynamically. I started out only creating them using the Field name and data type. However to facilitate my form building I thought it best to add a caption. Well, I can not find out how to alter, modify, add, etc... the caption property of a table.
I am using Access 2002 VBA
Thank you
-
- trying to highlight selection in a combobox on a userform
by yoshikatsu
- 3 Replies
- Last post
by yoshikatsu
- Hi,
I have a combobox embedded in a frame in a userform. I populate the combobox and make its initial selection in the userform_initialize() event and then set the focus to that combobox.
What I would like to do is for the current selection in the combobox to be highlighted (ie text and background inverted, like when you double-click on a word in text, so that the user knows that the first t
-
- How can I disable a command button under certain condition?
by lyp_sj
- 3 Replies
- Last post
by lyp_sj
- Hello:
How can I disable a command button under some preliminary conditions, for example, if I want to click button 1, I have to observe the result from clicking button 2 Thanks so much!
B.regards/Yaping
-
- need some help on how to update fields based on tab selection
by kee2ka4
- 0 Replies
- Last post
by kee2ka4
- I am using an access database and am trying to solve this function; I am pretty new to access and can¡¯t seem to figure out how to do it. Here is what I am trying to do
I have two tables called
1. tblExamType: in this table I have field called examTypeID as Primary Key
2. tblExamDetails: in this table I have a field called fkexamTypeID as a Foreign Key.
Now in my Students Fo
-
- How do I deal with files of more than 65k rows?
by chilehed
- 8 Replies
- Last post
by chilehed
- I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it.
I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one.
How is this done
Thanks.
-
- Variable declaration + assignment
by une
- 2 Replies
- Last post
by une
- I want to declare a variable and assign a value to it in one line.
I have Option Explicit turned on.
The following line will not compile, I get an error stating;
"Compile error:
Expected: end of statement"
Here is the code causing the problem;
Dim count As Integer = 1
However I found the following code caused no problem;
Dim count As Integer count = 1
-
- Recommend a book please
by une
- 3 Replies
- Last post
by Icekool
- I am in the very early stages of trying to teach myself VBA for MS Word. I have some knowledge of programming in Java and C++. I need a good book to get me started. I have found it is not the code itself that I am having trouble with, it is how the environment works that has me confused. I need to see how to implement solutions to some basic real world problems. Seeing code examples in isolation i
-
- Subscript out of range
by NutoVBA
- 6 Replies
- Last post
by NutoVBA
- I am new to VBA and am trying to create a copy of a sheet from one workbook to another workbook using the following code:
Workbooks.Open Filename:=bw_path & "\" & bw_file
'Opening the file from which I want to copy.
Sheets(bw_sh).Copy After:=ThisWorkbook.Sheets(3)
'Trying to copy the open worksheet into the workbook housing the macro.
I am getting the "sub
-
- Macro that deletes itself after running
by GB Allan
- 3 Replies
- Last post
by GB Allan
- Hi,
I created a macro that runs a routine on other spreadsheets and copies them into the workbook, one at a time (the same workbook that contains the macro). I have a small on-open routine in the macro spreadsheet:
Private Sub Workbook_Open() Sheets("DATA").Select Range("A1").Select Sheets("INSTRUCTIONS").Select Range("A1").Select End S
-
- SpeedUp a Macro in Excel - Disable Functions
by PYA_Ferro
- 8 Replies
- Last post
by PYA_Ferro
- Hi all, In my macro I used this sentences to speed it up:
Application.ScreenUpdating = False Application.EnableEvents = False
But I've also created some functions and they are beeing recalculated every time my macro do a change in a worksheet.
Is there any way to disable the calculation of functions
Thanks and really sorry for my English.
-
- Live Communication Server 2005 SP1 - Specified backend for the pool is current in use
by Jensan_Ahsay
- 7 Replies
- Last post
by Peter Gu
- Hi,
I have installed the Live Communcation Server 2005 SP1 on my x64 computer with Windows Server 2003 R2 SP2. I found that i have given the wrong name for the DNS, and therefore i am trying to re-install it. However, when doing the step "Create/Upgrade Existing Pool", it gives the error "[0xC3EC78BA] Specified backend for the pool is current in use". The error is unders
-
- VBA + TSQL - SQL script from VBA Excel to SQL SERVER
by ajliaks
- 0 Replies
- Last post
by ajliaks
- Hi,
I have a question related to both TSQL & VBA Excel.
Since I am not sure where I have to post it, I did it in TSQL. Below the link.
Thanks in advance for any help,
Aldo.
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2117223&SiteID=1&mode=1
-
- Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
by rjo2
- 11 Replies
- Last post
by andria72
- Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature.
-
- Using variable contents in a query
by RobinChadwick
- 4 Replies
- Last post
by RobinChadwick
- I'm writing a resource management database in Access 2003.
For the consultant status report, I need the database to ask the user for the consultants name, the starting date and ending date for the reporting period. I'm doing this through the use of input boxes in VBA. The status report makes use of 3 independant queries designed from the database window. One for deliverables, one for accomp
-
- FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
by damienm38
- 5 Replies
- Last post
by Andy Pope
- Hello,
I am implementing a lookup Method to find translation matches in XL tables.
For example, if I call the Method: Translate("world") in the following cells:
A | B
--------------------------------------------------------------------------
hello world | bonjour le monde
world | monde
-
- Setting Autonumber back to zero
by PSD
- 2 Replies
- Last post
by MadNes
- hi, can anybody tell me how to set autonumber in access back to zero. thanks, PSD
-
- Ways of sharing data between VBA and another non-dotnet application.
by Aleksey Nagoga.
- 4 Replies
- Last post
by Aleksey Nagoga.
- Hi All,
I need to share some text data between VBA and another non-dotnet application. The solution needs to be easily deployable as both application are on the client side and need to be hidden from a naked eye, meaning that I can't just create a text file in one app and read it from the other. (sensitive material like passwords may occasionally be sent as well)
I considered using shared me