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. ...
|
use vba to create new code module in access 2007
Thu, 28 Aug 2008 06:23:01 -0700
i can't remember how to create a new standard or class code module using vba.
i did it a long time ago, so i know it's possible. can anyone help? ...
|
Appending results of loop to a table
Thu, 28 Aug 2008 06:22:02 -0700
Hi all,
I want to loop through some object collections (objects in the collections,
to be precise) and get system values, and then append the results to a table
in the current db. Right now, the best I know how to do is create a text
file, loop through and append the object/value combinations as a new line ...
|
Drive path vs. Network Path S:\Shared\Folder vs. \\NETWORK\USER\FO
Thu, 28 Aug 2008 06:09:01 -0700
Searched my bookmarks and couldn't find where I had read this conversation
before.
I am working with a linked database. (My copy of) the Front End contains a
Module that runs a query to refresh data in a table on the Back End. My
problem is I need the path of the Back End Database; currently when I run the ...
|
|
|
Trouble previewing report from Subform/Form
Thu, 28 Aug 2008 05:44:00 -0700
Hi there!
This discussion group is a lifesaver and I'm asking for a life ring one more
time....
I have a Form with a Subform of invoices. The form is linked to a table with
ReferenceID being the Key. The Subform is linked to a table 'Invoices' with a
key InvoiceID and is linked in relationships with a on ...
|
VBA script to send a filename (drive/path) and launch to play WMP
Thu, 28 Aug 2008 02:10:01 -0700
Hi everyone,
Sorry if I post this in the wrong forum - please direct me if it's.
I would like to know how to write a VBA script to send a filename (e.g.
"c:\My Documents\My Video\MyTest.MPG") to launch Window Media Player
(wmp.ocx) as output.
I can see lots of these OCX files from the VBA Editor's Tools | ...
|
Sending email from access - Reference Stephen Lebans code
Thu, 28 Aug 2008 01:58:03 -0700
I have used the code and dll files after downloading from Mr. Stephen Lebans
website for converting the report to pdf (which have also dynapdf.dll &
strstorage.dll) . The following code I used which worked perfectly :
Private Sub Label59_Click()
RepoToPdfWC
End Sub
Function RepoToPdfWC()
Dim blRet As Bo ...
|
