Change recordsource of susequent subforms-TJ
Thu, 28 Aug 2008 12:12:01 -0700
I have a subform with a combo box containing User ID's ("CKENT"). The next
suform will be the user profile with listbox ("Coordinator" or "Inspector")
etc...based on the user id and a check box to show the current profile of the
selected user.
The next subform will be Contract number which shows the current c ...
|
In a report -Using a calculated field in Select Case causes Error
Thu, 28 Aug 2008 12:02:02 -0700
I am trying to have certain boxes become visible or not based on the value of
a calculated field in a report. However, it gives me Error 2424 and points to
the calculated field Me.calcOverallRating as the problem. Any ideas why or
how to fix this?
My code is as follows:
Select Case Me.calcOverallRati ...
|
Access to Outlook Via Excel
Thu, 28 Aug 2008 10:12:14 -0700
Hello,
I am using Ms Access 2003. Per user requirement, I need to format the data
in a table and paste the same in outlook in such a way the gridlines etc do
not appear.
So i have written code in VBA (MS Access) which takes bits of information,
copies it to an excel sheet, formats it per the requirement ...
|
Word Difficulty
Thu, 28 Aug 2008 09:39:01 -0700
I want to export records from Access and create a Word Document in Access
2003 that I can email to a variety of people. I then want them to make
changes to the individual records, reimport the records and add any
additional records they may have added. Does anybody know how to do this?
--
M. Shipp ...
|
Name AutoCorrect Save Failures
Thu, 28 Aug 2008 09:06:06 -0700
When I run a TransferSpreadsheet command, a [Name AutoCorrect Save Failures]
table is created.
Object Name: BidTabData
Object Type: Table
Failure Reason: Could not save the object
Time:
Code:
...
Tble = "BidTabData"
Path = ahtCommonFileOpenSave...
CurBid = 1
Do While CurBid <= 7
Rnge = "Bid" & ...
|
Parse Table Names from Query Def SQL
Thu, 28 Aug 2008 08:45:01 -0700
I would like to be able to determine all the tables that are referenced with
in a querydef (and any subqueries within it, too). Is there a written
library for this or has someone written a routine to do it?
Thanks for any help,
Leon
...
|
If Else Statement in VBA
Thu, 28 Aug 2008 08:33:01 -0700
Unfortunately, it's been 9 months since I've really worked in access and now
for some reason I can't get a simple statement to work! Help! What am I doing
wrong?
I took a date field, calculated month from it, which is a numerical value
and am now trying to translate it to quarter. What am I doing wrong?
...
|
|
|
Duplicating records in a form and subform (Allen Browne)
Thu, 28 Aug 2008 08:04:01 -0700
This question is towards Allen Browne, but if anyone knows the answer, please
let me know....
I took your script for duplicating records on forms and subforms. everything
is working well actually. What is not working is a loop that I have. I am
getting two sets of records when I try to duplicate a form.
...
|
Setting Options in VB
Thu, 28 Aug 2008 06:54:01 -0700
Can anyone show me how to change the "Options" in visual basic. I can open
the options box in VB but don't want to do that, I want to change certain
options when opening the database, like turning of error checking or setting
"Cursor stops at first/last field"? Any help would be appreciated... ...
|
Text Box not updating?
Thu, 28 Aug 2008 06:38:55 -0700 (PDT)
Am I'm going crazy, what am I missing here?
My form has 3 text boxes: StartDate, EndDate, PromoNumber. StartDate
and EndDate work fine. When I add PromotionNum, its contents are not
passed to VBA.
If I type ? [StartDate] or [EndDate] in the immediate window, I can
see the dates I typed into those textboxes. ...
|
