Comment A Whole Paragraph With One Click
Sep 27, 2006Hi,
I wonder if it's possible in Access 2003 to comment a whole paragraph of VBA code with one click instead of commenting each line on its own?
Regards,
B
ADVERTISEMENT
Creating A New Paragraph In A Text Box
Oct 4, 2004I have two fields ([Big Problem] and [Little Problem] that I need to output (on a report) as one field and have them appear as two paragraphs. I use a query to append them (BothProblems:[Big Problem] & " " & [Little Problem]) But I can not figure out how to put a line feed (chr(10) and chr(13) between the two lines to make a charage return.
Any ideas
Mike
How To Extract Just The First Paragraph Of A Memo Field
Jan 23, 2006Does anyone have an idea how to extract the first paragraph of a memo field of a table to be used in a query? Thanks...
View 5 Replies View RelatedUnbound Text Box To Get Long Paragraph..!
Mar 21, 2005Hi guys,
I’m working on a form on which I like to place an unbound text box to get a long amount of data. The text boxes in link to a field table having 250-field size. Now, I’d like to be able to use a text box, which will allow me to enter from 800 to 1000 characters. Is that possible in Access 2000?
Can anyone help me, please?
Thank so very much in advance.
Mosquetero
Create A Paragraph Using Field Values
Oct 25, 2012How can I use different fields values to compose a paragraph? I want to make a shipment notification letter using different fields. For Example,
Hi [ShipToName],
Your order of book [BookName] has been shipped via [Shipping_Service]. The tracking No. is [TrackingNumber].
Your order has been shipped to following address,
[ShipToName]
[Street1]
[Street2]
[City], [State] [ZIP],
[Country]
Then I also want to email it using outlook 2010 but that might be a different thread.
Use Multi-paragraph Text As Memo Type
Apr 23, 2006I have a website in Asp, which is connected to a MS ACCESS database.
In this database, there is a text field (Memo type) which contains text. But in web site, it just shows a continuous single paragraph.
What should I do to fix this problem?
Thank you
R. Ghodsi
Comment Code?
Jan 17, 2006Okay Stupid question, But I have tryed different things and have not got anything to work yet, So I am using Microsoft Acess 2003. I would like to be able to comment out block of code. Thanks
Sorry for the stundness...:confused: :confused:
Comment Out SQL In Access 2000
Nov 13, 2006Hello,
Really simple one this one. Though I can't find it in the help or in forums. So simple it doesn't rate a mention apparently.
Except that I would dearly love to know how to comment out SQL code whilst writing queries in Access 2000 SQL view. All that retyping and copy/pasting is causing me RSI.
In eager anticipation,
Tim
Message Box To Appear With Comment And OK Button
Dec 23, 2013I have a command button with the VBA code below. I'd like a message box to appear with a comment and an "OK" button that continues the code below . . is this possible?
Private Sub cmdDuplicateOverpayments_Click()
On Error GoTo Err_cmdDuplicateOverpayments_Click
Dim stDocName As String
stDocName = "qryFindduplicatesforOverpaymentsDetails"
DoCmd.OpenQuery stDocName, acNormal, acEdit
[Code] .....
Red Triangle Comment Popup
May 27, 2013Like in excel, when there's a red triangle in the corner of the field which pops up a small comment box, is there a similar functionality in Access that when a field.
Has either a comment associated with it, that a comment box can be made available?
Reports :: Comment On Null Field
Jun 20, 2014I have a field SSEEndDate. I have some records in which this field is empty. What I would like to do is add a comment to explain why the field is empty on a report if possible. Click on it or move the mouse on it or whatever and the comment would show up.
View 14 Replies View RelatedInsert Comment If Checkbox Is Ticked
Jul 10, 2015I am working on a database which will basically serve to be a massive Auditing Checklist. Lots of "Is this done" type yes/no questions to record, some with a comment.
Brief Description: I have many child-forms on a tab-control, each with a different heading/category of things to check for. When someone visits a store, I would like them to record their findings in this form.
In the above example, if the Floors are clean, no input is necessary. If the floors are not clean then the user ticks the checkbox and the text "Floors were not clean" should be automatically entered into the field: Cleanliness 1. The reason for this is that I wish to link the value from this field to a Microsoft Word document using mail merge for reporting purposes, and in the report it needs to state any problems in full sentences.
I have tried using this code in order to update the comment field when the checkbox is ticked, however, the problem with this is that I would have to insert code manually for every single checkbox in my forms, and I have about 150 checkboxes in total.
Code:
Private Sub Cleanliness_A1_AfterUpdate() If Cleanliness_A1.Value = -1 Then 'If checkbox is checked
Cleanliness_C1.Value = Cleanliness_C1.DefaultValue
Cleanliness_C1.Enabled = True
Else
Cleanliness_C1.Value = ""
Cleanliness_C1.Enabled = False
End If
End Sub
Can Remark / Comment Lines Increase Db Size?
Jul 22, 2006Hi,
Can someone tell me that more remark / comment lines in VBA might be one of the reason of increasing the db size?
Because now a days I am removing the queries from my db and started to use VBA code lines behind each forms and keeping some remark / comment lines to know what a particular set of code line means and what they are doing. So I put everywhere some remarks / comments line. Now my forms are faster than before but the over all size of db become heavy.
Are comment lines one of the reason in increasing db size?
With kind regards,
Ashfaque
ASP & MS ACCESS "Two Tables [one Article And One Comment]
Feb 19, 2005Hi please i have a problem withthis and i need some help,
i received some great help so far thank you So much Markoc.
and now i'm stucj here.
I have two tables :
one called reviews [rid, review]
and the comments [cid, rid, review]
the first two pages work fine, but whenever i click on submit on the second page it take me to the
third one which cannot be displayed.
here is the code on the pages, please if you can help.
------------------------------------------------
on the first page i have " reviews listing "
-------------------------------------------------
<%
Dim oConn, sConnection
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=xx" & _
"Persist Security Info=False"
oConn.Open(sConnection)
set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "select * from reviews" , oConn
%>
<center><table >
<%
Do while NOT rsUsers.EOF
getrid = rsUsers("rid")
getreview = rsUsers("review")
Response.Write "<tr><a href='viewreview.asp?rid=" & getrid & "'>" & getrid & "</a></td></tr>"
Response.Write "<tr><td colspan='5' width='541' height='25' ><font face='Trebuchet MS'>" & getreview & "</font></td></tr>"
rsUsers.MoveNext
Loop
rsUsers.Close
set rsUsers = Nothing
%>
--------------------------------------------------------------------------------------------------------------------------
the second page is viewreview.asp AND ALSO I HAD A TEXT BOX FOR THE USERS TO LEAVE COMMENTS
--------------------------------------------------------------------------------------------------------------------------
<%
Dim oConn, sConnection
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=xx" & _
"Persist Security Info=False"
oConn.Open(sConnection)
getrid = Request.QueryString("rid")
strSQL = "SELECT * FROM reviews WHERE rid=" & getrid
Dim rsUsers
set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open strSQL , oConn
getrid = rsUsers("rid")
getreview = rsUsers("review")
rsUsers.Close
set rsUsers = Nothing
%>
<center><table cellpadding="2" cellspacing="2" border="0" width="541" >
<tr><td>"<%= getrid %>"</td></tr>
<tr><td>"<%= getreview %>"</td></tr>
</table><table>
<TR>
<TD vAlign=top bgColor=#d6d6d6 colSpan=6>
<form name="comments" action="submitcom.asp?rid=<%=getrid%>" method="POST">
<textarea name="comment" rows="5" cols="50"></textarea>
<br><br>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
-------------------------------------------------------------------------------------------
THE LAST PAGE IS submitcom.asp
-------------------------------------------------------------------------------------------
<%
Dim oConn, sConnection
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\xx"& _
"Persist Security Info=False"
oConn.Open(sConnection)
Dim rsUsers
StrSql = "insert into comments" _
& " (rid, comment)" _
& " VALUES (" _
& "'" & Request("getrid") & "'," _
& "'" & request("comment") & "')"
'DEBUG SCRIPT
'Response.Write StrSql & "<br>"
'response.End
oConn.excute StrSql
set rsUser = nothing
set oConn = nothing
%>
-------------------------------------------------------------------------------------------------
General :: Looking At Certain Record And Populate Comment Field
Feb 13, 2015I have Field "BC1Chng" which requires user input. I want to be able to write a code to reference to "BC1Chng" if there is an input in that field for any record...I want to copy the Remarks into each record in the Remarks Field.
I was able to get the remarks1 field to loop through each record copying what was in that field into each record.
Now I want it to look at the BC1CHng field and only copy to remarks1 field if there is any input in that field???
Forms :: Comment Box To Copy To The Rest Of Queried Records
Jan 13, 2015Here is my code...if I take out the where statement..it copies the remarks all the way down my table to all the records...with the where statement..it's prompting in for parameters..
Private Sub Remarks1_Click()
Dim strMsg As String, strQry As String, strRemark As String
strMsg = "Update All Comments in the Current view. IMPORTANT!!! Will update a the Viewed records."
[Code].....
Modules & VBA :: Searching For Text Or Comment Inside PDF Files
Jun 21, 2014I just want to know if i can create a vba code or a module that will search text or comments in specific table that has attached pdf file.
View 1 Replies View RelatedQueries :: Pulling Comment Based On User Selection?
Sep 17, 2013I have a tblCommets that has 2 columns in it. The first is an identifier (1,2,3) and the second column is a comment associated with that identifier. Is it possible to use a query to pull that comment based on a user selection? So, if the user selects 1 then the comment associated with 1 is pulled, but if the user selects 2 then that comment results.
Code : =Select[tblComments].Column(2)
General :: Can Hyperlinks Be Permitted In Long Text Comment Box?
Aug 6, 2013I have a comment box that was just for text. I have been asked to adapt this to allow a web URL to be typed in which would then become a clickable hyperlink (like typing in a Word document). Is this possible?
View 3 Replies View RelatedCode Triggered From Label On Click Behaves Differently From Command Button On Click
Nov 7, 2006Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code.
The code below however works for a command button, but not a label button.
DoCmd.OpenForm "frmdatetime"
Do While Forms!frmdatetime!OKFlag.Caption = "False"
DoEvents
Loop
When this code is run by clicking on a command button, it works fine.
If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime.
If I remove the loop with the DoEvents in it, then the problem does not occur.
Can anyone enlighten me as to why this behaviour occurs.
Thanks
Richard
General :: Comment History Field To Appear On A Form - Change Sort Order Of Results
Aug 28, 2013I have after much stress gotten my comments history field to appear on a form.
The following code gives me what I needed
Code:
=ColumnHistory([RecordSource],"LastUpdateBy","[ID]=" & Nz([ID],0))
I have only one simple thing left, that is perplexing to say the least.
Some comment fields will be many short notes, spread over time.
My desire is to change the sort order of the results so the most recent (rather than the initial) comment is at the top.
If Field 1 Is Yes, Then Field 2 Must Have Comment
May 4, 2006I just can't figure this out..I have two fields in my database that I want to be able to have a regulation that if the user Enter Yes to field1 than they MUST enter some comment on field2. They can't skip it. However, Field1=No, they can skip field2..Is this possible? is this have something to do data validation? Please help..thanks in advance..
View 2 Replies View RelatedRight Click
Oct 28, 2005When I right click on a file in explorer or a drive in my computer my computer either tries to install a program or set up an Activesync connection.How can I stop this?
View 1 Replies View RelatedRight Click
Mar 18, 2005Is there a way to turn off the right click so I can have it show something else instead of showing the context specific menu. It does show what I want it to, but I don't like have the menu come up with it.
View 2 Replies View RelatedClick Event
Jun 7, 2006I'm working with a database with employess info in access, When I click on an employees name in a form, I want to fire off another form with there info, what I have now it does nothing.
View 4 Replies View RelatedRight-click Does Not Work!!! Help!!!
Jun 18, 2007I created a database in MS Access 2000 for the company I work for.
I sent this database from the US to our sister company in the UK, and the gentleman there has no right-click access within the data entry form.
Is there something that needs to be turned on or a check box that needs to be checked for right-click access within the program?
Thank you in advance.
Jason