I have several programs I have written in Clipper which I wish to convert to Access.
Can someone tell my how to control a printer on a pre-printed form in the same way in which you controled it in Clipper! ex. @ row,col say "This is a test", where row & col = the desired row and column...
Example:
Main form = frmMain
Date Field = dteDate
Command Button = cmdDate
PopUp Date Form = frmCalendar
Active X Calendar = acxCalendar
private sub acxCalendar_DateClick()
forms!frmMain!dteDate.Value = acxCalendar.Value
docmd.Close acForm, "frmCalendar"
End Sub
Hope this helps.
I want to bring up a custom form or menu upon right clicking on a field in a datagrid, without bringing up the standard Access popup box. I can program my form to pop up but how do I stop the Access menu from popping up
I would like to insert todays date and a blank line at the beginning of a memo data box by clicking a command button, while retaining the data already stored in the memo data box field. Any Help??
I am having trouble with a clipper application printing forms. The form prints fine until about 3/4 of the way through and then stalls for a few seconds then continues.
Any suggestions. This problem is only with Windows 2000 and Windows XP. Windows 98 & ME work fine.
Have you tried opening on of you forms in VBA, then click on debug, and compile your database. The compile should stop and point you to your error that is stoping you mde compile. Also be sure you are using the Option Explicit ing any modules or befor any code. This will help pinpoint your error.
I am having a problem with Access 2000 not being able to find various libraries. ex "Date" functions and even chr$() functions.
Is this a quirk with Access 2000 or some other error. This happens on more than one PC.
Kathryn,
Thanks for the reply. My error recovery code is:
Exit_btnPrintClick:
Set objWD = Nothing
Set wrdDoc = Nothing
Exit Sub
Err_btnPrint_Click:
MsgBox err.description
Resume Exit_btnPrint_Click
But this still leaves an instance of winword...
I am having a problem concerning the following code:
Dim strFileName As String
Dim wrdDoc As Object
Dim objWD As Object
Dim strSQL As String
strSQl = "c:\My Documents\Letters\TestLetter.doc"
Set objWD = CreateObject("Word.Application")
Set wrdDoc...
I am new to Access. I would like to print letters from data stored in richtext format in a memo field within a table. I am unable to print the letter from the field with proper text formating (bold,colors, etc). How can I recall the text from the memo field and properly print and format the...
I am a clipper programer migrating to Access / Visual Basic.I am converting a Service Traking program which has a built in letter writer/word processor.I am storing information (letter body) from a Rich Text Control on a custom Access form which I created.The Rich Text is stored in a memo field...
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.