Hi there,
It would be quite useful to have a help button on my forms which when pressed, showed a short help tag for each button etc on that form. SO the user knows exactly what each function does.
Im not aware of any built in function to do this? Is there anyway to show all the 'ControlTip Texts' on the page?
Thanks
Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup"
Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered.
I am not good on writing loops/next statements. But I am wanting to make an image visible to true when someone changes the value within the group.
This is what I have so far:
Dim ctlGroup as Control
For Each ctlGroup in Me.Controls
If ctlGroup.Tag = "UnitGroup" Then 'finds the smart tagged controls
If ctlGroup Then 'if any fields within group changes value then
Me.Image321.Visible = True 'show image
End if
End If
Next ctlGroup
I don't even know if I am close with my code - clearly it is not complete and lots of holes of wonderment!! Maybe it would be easier just to use the individual even (on change) with each individual field (9).
I have an Access template I downloaded which has smart tags. I want to remove all smart tags all of the forms but how.
It must remove all tags as other users will be using the same database on different pc's. So mustn't be a local client setting.
I produce visualisations for architecture companies and use a lot of 2d images of people, cars, trees, skies, etc. As it stands now, I have a folder that contains a huge amount of images that I flip through when I create a new image. I have seen that some websites, such as [URL] .... allow you to filter through an image database based on different tags.
I would like to create a similar database, but stored locally on my computer. I have actually never used Microsoft Access before, but I'm thinking that this might be the best program for me to use. Is this true?
Essentially I would like to organize my library of images of 2D people based on things like: 'staring', 'bicycle', 'looking up', 'back view', 'crowds', 'pointing', 'sitting' etc.
Default Searchable Tagged List...I'm trying to create a list of items that allows me to tag each item with essentially unlimited tags and perhaps a limited number of other fields. Later, I'd like to be able to search that list for specific items by the tags that they have. Finally, I'd like to either export or copy/paste the results.
View 4 Replies View Relatedhow to read / create ID3 tags for mp3's? I have found various snippets but they are mainly vb.
View 8 Replies View RelatedTextBox1 is Rich Text:-
I want to replace my String ("Evidence required of this please" ) in this code 1) following which works fine, with a variable (textToPaste) as in code 2) which doesn't work.
1) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">Evidence required of this please</font>"
2) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">textToPaste</font>"
Can I persuade the statement to accept "textToPaste" as a variable and not a normal string?
We use Access to pull data from data warehouse and this year they upgraded the new system on the back end and moved old data to the new one. Problem is that in some tables having big fields such as Asset Long Description, Work Long Description and when moved to the new database system, somehow there are certain some XML tags such as <br> </br, etc.. added into the description. So when we pull the data onto the table in Access, is there a way to remove those tags out of the descriptions fields? a macro or module?
View 1 Replies View RelatedI did not know where to ask this question or how to ask, so please excuse me.
We have an Access 2007 database that updates an Access 2003 database. My problem is, the data in 2007 is formatted and when the 2003 table is updated, it displays the html formatting tags. Is there a way to remove the formatting (convert to plain text from rich text?) during the update?
Hi,
I have a database which I can add to, edit and delete via an asp.net page, it also allows me to add html tags.
My problem is when the data is then rebinded to the page any HTML tags are changed from '<' to '<' and from '>' to '>' this results in the tags and contents being displayed on the page as text instead of being interpreted as HTML and then formatting the page - most frustrating!
Any help is greatly appreciated, this is a relatively new area for me so many thanks in advance.
Steve
I've question reqarding modyfying tags (metadata ) in jpg files.
I've found some code which allow to read tags from jpg files through vba but only read - editing is not possible.
So my question is: vba code which allow modify tags in jpg files? {Below code for reading tags, requires to turn on following reference in vba editor: Microsoft Shell controls and Automation )
Public Function getFileMetadata(fileFolder As String, fileNm As String, _
metadataType As String) As String
Dim objShell As Shell32.Shell
Dim objFolder As Shell32.Folder
Dim objFolderItem As Shell32.FolderItem
[Code] ....
I'm using Access 2010.
I'm trying to append some text to a field used for comments for a Team Member profile. I don't really want to create a comments table for multiple comments regarding changes to the profile.
Some comments already exist and I want to add some more information programmatically when the profile is updated using a batch update at the end of a reporting period.
I thought it'd be easy in a query,
New Comment:[EXISTING COMMENT] & "; Additional Comment" But I was getting HTML Tags when I tried to concatenate the strings. "<div><font color=black> EXISTING COMMENT HERE </font></div>" then a linefeed and <div> </div>; Additional Comment HERE.
I found a function to kill all the html tags but the visual linefeed and the " " tag won't go away.
I'd like to concatenate two pure text strings to get one pure text string to put back into the comments field which will just be text wrapped with no forced linefeeds.
I need a Query that grabs the lastest "newest" data from the 5 tag.table tags generated from the query below and Display them in a result,
SELECT FloatTable.DateAndTime, FloatTable.TagIndex AS FloatTable_TagIndex, FloatTable.Val, TagTable.TagName, TagTable.TagIndex AS TagTable_TagIndex
FROM FloatTable INNER JOIN TagTable ON FloatTable.[TagIndex] = TagTable.[TagIndex];
I am trying to import XML into access however have noticed that Access 2013 is not importing fields/parameters found within tags. For example:
<locations>
<locationelement description="Master Location" dns="tester.test.com" key="M0" lastupdated="Never Updated" pdport="5555" port="5551">
<monitoringperiodtimezone>EST5EDT</monitoringperiodtimezone>
<monitoringperiod days="Sunday" hours="28-95" />
<monitoringperiod days="Monday,Tuesday,Wednesday,Thursday,Friday,Saturday" hours="all" />
</locationelement>
</locations>
When importing, Access creates a table location element with fields for monitoring period timezone (containing EST5EDT) and monitoring period (containing nothing). I was wondering if there is a way to access fields such as description, dns, key etc or days, hours, ie fields that are within a tag.
When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.
The memo field in the table is set to Rich Text and so is the text control on the form.
Below is an example of the data I'm copying from Outlook email:
Fire Alarm Activation
Actual/Smoke Present
False
Planned Drill/Testing
Evacuation
2. Utilities/Power/Communication Failure
Now, below is what it looks like in my table or output in a report:
<ol>
<ol>
<li><strong>Fire Alarm Activation </strong></li>
</ol>
</ol>
<ul>
[Code] ....
How can I copy and paste and remove the html tags?