Is there a way to rotate text 180 degrees, i.e. flip it upside down in a CR
Text Field? The rotation property at design time only allows 90 degrees and
270 degrees.
Thanks!
2. Visual Basic code inversion
Is there a piece of code I can input to a visual basic macro that will enable
it to execute in reverse order? In other words, if line 1 of the code was
Sendkeys "C1" and line 500 or whatever was Sendkeys "{TAB}", I would want it
to run from line 500 to line 1.
This will allow me to fix a small 'glitch' in which the first bloc of code
in a series of macros always runs in reverse order when run with other
macros, when run alone it runs correctly.
Many thanks
3. Stretchblt API : transparency + color inversion
4. save text from text box into text file
Hi..
I'm trying to save query path which is in text box to text file. Below
is the coding that i'm using currently:
Private Sub SaveQueryPath()
'save to text file
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition",
"attachment;filename=Query1.txt")
Response.ContentType = "application/vnd.text"
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Me.EnableViewState = False
Dim oStringWriter As System.IO.StringWriter = New
System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New
System.Web.UI.HtmlTextWriter(oStringWriter)
Me.ClearControls(txtPath)
txtPath.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter.ToString())
Response.End()
End Sub
The 'txtPath' is the text box that contains a query path that I want
to save.
However, when i open the text file, after i run and save the query,
the result in the text file shows the query path (which i need)
including the properties of the text box which is unnecessary for me.
For example(text saved):
<input name="txtPath" type="text" value=" > STP > --Select One-- >
" id="txtPath" disabled="disabled" style="background-
color:WhiteSmoke;font-family:Verdana;font-size:X-Small;width:712px;" /
>
The only thing that i want to save is (the query path): value=" > STP
> --Select One-- > "
Is there anybody can help me on how to get rid of all the other
unnecessary info saved in the text file?
Hope to hear from you guys... Your help is highly appreciated.
Thank you.
5. Find text but excluding commented text in VBA macros
6. Find retrieve text from a text file through VBA
We have a proprietary system that generates daily processing logs in text files into a specific folder. These log files have a systematic naming convention i.e 鈥淭est_20080206 LOG.TXT鈥? 鈥淭est_20080207 LOG.TXT鈥?depending on the date. I am building a system in Access/VBA that will search for a line with a specific error message in the most current log thereafter store that line item into a table for reporting purposes in Access. Example of error line in log: 鈥?9:51:37 I Processing stopped by user.鈥? I can identify the most recent file and point to the location on a daily basis in vba but can鈥檛 seem to find any solid information on opening, searching and pulling text from the said log file. I鈥檝e heard that there are methods for going through a text file line by line but have no clue where to start. If someone can give me a little direction I should be able to pull things together from there. Thank you in advance for your assistance.
7. Problem with appending text to VBA Text box
8. Average a text box, text box populated with VBA
I have a report that uses VBA to calculate the number of weekdays between 2 dates and assigns the number to a text box called ControlsDays. The report works fine for the detailed information, I get the values correctly displayed when I run the report. In the footer, I built an averaging expression based on the ControlDays through the expression builder. The text box for the averaging information is called AvgControDays. When I run the report, a dialog box pops up and asks me for the AvgControlDays value. It will not calculate the average based on the data that was generated through VBA. Any suggestions?