No Data in Subform?
Thu, 17 Jul 2008 14:35:01 -0700
Hello,
I am having great difficulties with a subform total being displayed on the
main form. I asked this same question yesterday but didn't give enough
information to help with answers.
So....I have a subform that sums a unit price as follows:
Name = ttlCashAdvances
ControlSource = sum([UnitPrice])
...
|
Run-time error 1004: Method 'UpdateLink'
Thu, 17 Jul 2008 08:46:01 -0700
When running this code in excel I am getting the following error:
Run-time error '1004':
Method 'UpdateLink' of object '_Workbook' failed
What's wrong? Here is the code I'm using:
Sub UpdateSelectedLinks()
Dim aLinks
Dim cLink As String
Dim i As Integer
Application.ScreenUpdating = False
aLinks = Acti ...
|
Button to break links, delete all vba code & save as
Wed, 16 Jul 2008 08:40:01 -0700
I have a workbook that needs to be e-mailed out to many people. I would like
to create a button that the user can click which would break all the links in
the workbook, delete all the VBA code in the workbook & open a save as box so
the user can specify where to save the file.
I have the break links code:
...
|
Major help needed!!!
Tue, 15 Jul 2008 10:54:00 -0700
Ok, here's my issue... I have 5 workbooks that users fill out. Each of these
5 workbooks are linked to a master workbook which holds employee salary
information. So when I open the 5 workbooks I can't choose to update links
because the master workbook is password protected.
Hope I haven't lost you... In th ...
|
Outlook 2007 stalls when switching to Admin mode under Vista
Tue, 15 Jul 2008 09:16:01 -0700
I am sending e-mail through Outlook from my Window program using COM.
- The solution runs fine in all tested versions of Windows and Outlook
except one.
- In Outlook 2007 under Vista with UAC ON and run normally (not as Admin),
the solution will occassionally time-out with no response from Outlook.
- Tur ...
|
Update links in Excel using VBA
Tue, 15 Jul 2008 07:21:01 -0700
I have a document that has links to 6 different source documents. I only want
to have 5 of them updated (the last one is updated by being "pushed down"
from that document when it's changed). Is there a way to do this? Please
help!!! I've been looking for an answer to this question for over 2 days
now...
T ...
|
Help with reading Excel tables in Word
Mon, 14 Jul 2008 16:51:45 -0500
Hello,
I have a word (2003) document that currently had Word tables, that my vba
macro extracts the data from and everything is just fine.
Well, the people who generate the word document are switching to excel
tables embedded (not linked) in the word document (actually, each is a
small worksheet).
E ...
|
|
|
Unable to change the Tab Sequence on a Microsoft Word 2007 Form
Mon, 14 Jul 2008 13:28:49 -0700
I'm using Microsoft Word 2007 albeit designing a form in compatibility mode
so other users with older versions of Word can use. Instead of using Form
Fields we elected to use TextBoxes. After we designed the form we protected
it for form fields and began to use it. Everything works except for the tab
order. ...
|
Project Server 2003
Mon, 14 Jul 2008 11:31:01 -0700
I'm having an issue with the 'UserName' and 'Name' properties of the Profiles
object. After connecting to a server, I launch the Visual Basic editor and
examine the profiles properties (username and name). I'd expect the
'UserName' property to be equal to my network login ID. However, the property
is blank. ...
|
VBA to VB
Mon, 14 Jul 2008 11:18:58 -0700
I have inherited an Access 2003 VBA app and tasked with making it run
without Access (or the runtime). My guess is that this will take some
considerable effort, but I'd like some advice as to how best to proceed. I
know of no tools to help me convert this to a straight VB app, but I'm very
new at VBA and k ...
|
