Ben,
This section of your code:
strBaseMessage = MailItem.Body
'Empty The strChrPos String
strChrPos = ""
'While There Are Line Breaks In The String Remove Them & Then Exit The Loop
Do While...
K,
Something along this line should work.
Public Sub ReOrder1()
Dim db As Database ' current database
Dim recAssigned As Recordset ' recordset of items to order
Dim objOutlook As New Outlook.Application ' outlook object
Dim...
If I am posting this in the wrong area, please let me know.
I am having a problem with a specific PC that when starting any Access Db that has either an Autoexec macro or forms set to start in the Startup settings, is giving me the following error message:
MSACCESS caused an invalid page fault...
Here's a function that I use for this purpose. This is written for Crystal v8.5 and works great in Access 2000. You'll need references set for the Crystal Reports 8.5 ActiveX Designer Runtime Library (craxdrt.dll) and Crystal Report Export (sviewhlp.dll).
Also, appropriate error trapping and...
Graham,
Here's the entire function coding. Hope it helps you.
Function PrintIt() 'sFiletoOutput As String, sFaxTo As String, sFaxNo As String
Dim wApp As New Word.Application
Dim wDoc As Word.Document
On Error GoTo Error_PrintIt
Set wDoc = wApp.Documents.Open(CurrentProject.Path &...
Sorry Tom,
After posting I noticed typos. Statement should be:
me!txtIndustry = DLOOKUP("[Industry]","Client Industry", "[ClientId]=[forms]![frmEnterIndustry]![cboClient])
Scott
Tom,
You should be able to do this with a simple DLOOKUP() command associated with your text box statement.
me!txtIndustry = DLOOKUP("[Industry]","Client Industry", "[ClientId])=[forms]![frmEnterIndustry]![cboClient]))
Much easier than involving an SQL statement...
Following is a section of the code I have that works to print without user intervention.
'All setting of main document, etc is done prior to here.
' Execute the mail merge.
wDoc.MailMerge.Destination = wdSendToNewDocument
wDoc.MailMerge.Execute 'execute data merge...
First, I am not a VB developer, but am fairly adept at using VBA in MS-Access databases. While developing reports using CR8.5, I was successful in creating Access databases that contained forms using the CRViewer control along with coded instructions to the craxdrt.dll to open and view CR rpt...
I several fields in the detail of a report that are the result of formula fields. I am trying to then summarize the detail items either as SUM or AVE in group footers.
I am able to use the Insert/Summary command for some of them, but for other the option is not available. All results are...
I am trying to export a cross-tab report to Excel. The x-tab has a column header with Column #1 Name and Column #2 Name.
When exported to Excel the Column #1 Name data does not show.
Ex: In CR
INIT INSN
6/27/02 7/04/02
Excel only shows:
6/27/02...
I am pulling data from an Oracle database that is a varchar(300) text field. I have gotten around the size of the field by creating a view that breaks the data into smaller part so I can use Crystal formulas to check the data.
The main application creating this data allows for a CR/LF to be...
I have been working with v8.5 using the PDF export through RDC and really like it.
Does anyone know if there is a way to use the bookmarks feature that is in Adobe Acrobat in order to bookmark the groups in the Crystal report that is being exported? Are there properties of the ExportOptions...
Thank you for your suggestion. Even though it didn't quite work, it got me pointed in the right direction. I ended up recording a macro to see how Excel would write the code. From there I was able to adapt it to my code.
In the end:
objXLApp.Application.Visible = True
was replaced by...
I am using the following code to make formatting changes to an Excel workbook that is created by an Access export process. The resulting file will then be emailed as an attachment.
The problem I am having is that when the resulting file is opened in Excel, the file is hidden. I then need to go...
I am putting together a report that contains data for items listed in a catalog. I would like to show the detail level grouped by each distinct page number. As the next highest level of grouping I need to group two pages together and am having difficulties.
Example:
Group = pages 2 & 3...
Try this, it came from a Microsoft knowledge base posting and I have modified slightly. MS acknowledges issues with the SendObject command in Access and suggested this. Beware of text wrapping in this.
'This procedure allows the user to send email via the MS Outlook object.
'Usage of this...
You can then use the Specification in your transfer command as follows:
DoCmd.TransferText acExportDelim,"<specification name>" , QueryName, FileName, False
No need to use a macro command.
I have been able to do it both ways. The reason I was looking at VB (which by the way I am running as an Access module using the timer events) was that I was looking at how to automate the process so I didn't have to be at my desk to create the csv.
It should work by using the method you describe.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.