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 RepliesI've attempted to attach a Word Doc that shows fields I've labeled (customer, date, application & so on). Is there a way to put all this into an Access Document, and create a database that I could search by customer, or by serial #? I've got about 400 of these, but it's all in folders on paper now, would be much easier to do it in an Access database.
View 11 Replies View RelatedI want to create a database of my employees. I want it to include their name, an assigned number, a list of their certifications in certain areas, and a date certified/expires to go with each certification.
I also want to create a form that displays all this info the same for everybody, like a profile page that just draws the info from the database. I also want to be able to put it online and have someone be able to do a search, type in the assigned number or a name,and have the profile page be displayed. If anyone has any ideas or could help, it would be appreciated.
Thank you
hi
I'm currently designing a searchable ceramic gallery and have a problem with my SQL querying.
I have the artworks entered in the database as unique entries and have entered the artists forename and surname in separate columns so that they can be seached for by the first letter of their surname.
The problem is that when a user searches for an artist the results return as many results as there are artworks, rather than artists, in other words if 'harry potter' has 20 pots he appears 20 times.
Please can anyone advise me how to best ammend my query so that he appears only once!
Is there a way to make an MS Access database searchable and sortable when it is online? I have used asp to display records from a database, but would like to know if there is a way to make it sortable/searchable. For example: If there are 300 records displayed, how to make it so that an online user can sort by certain fields, or search for certain records? It would make it easier for the user to "group" things to suit their needs.
View 6 Replies View RelatedI have been tasked with creating a database but I have no previous experience using access. I will be using version 2007. I have to create a database of vendors. These are vendors from all round the world who sell my company different products. So far I have 9 spreadsheets with lists of hundreds of vendors from different sections of the company.
I need to create a database that allows someone to search for a vendor and all the details will appear. The excel sheets have columns for vendor name, country based in, commodity type, address, contact name, phone number, email address and which part of my company use the vendor (an abbreviation). Not all of the information is available for each vendor.
Ideally I would be looking for something with search buttons, filters and the option to just show all vendors.
We have a database that has the records of the artwork that we own. (We are a textile company). This database is used mainly to record any new artwork that we buy and to add information such as size, category, style, etc. We now want to be able to link all the scan images for this artwork to each record in the database. I know how to do one record at a time by linking it to the scan image, but is there a faster way to automatically do it because we have about 13,000 pieces of artwork? Each record has a unique artwork number that we also used to save the scan image and all the scan images are in one folder.
Then once we accomplish this, we need to be able to create a way that the design staff can quickly search the artwork. The goal is for the designer to specify certain parameters, like size, category and style and then have Access provide all the images that follow the parameters.
I am new to access and i found i am struggling to find out how to print record . I have a table with following field :
Name , Bank Account number , picture
I would like to make a form that can search for specific record suppose search for name and show the result in the form.
That result form can be printed in a report ( report only contain one record from the form ).
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
I have a table having fields, Group, Subgroup, Emails.
I want to make a searchable form that asks user to select Group and select sub group. And click on some Export button to export the results in to excel file.
As per my data in table, There are some subgroups in group and many emails in subgroups.
How this can be done in ms access 2010.
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.
I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it.
I am trying to create a message box that will display all inspections that are due within 5 days when the form loads. No luck so far, only broken dreams.
Is it possible for message boxes to use expressions and display information that fits the criteria?
how 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?
I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
View 3 Replies View RelatedHi, I've been trying to create an MDB file of my database with litle luck.
when I try and click the make MDE, the computer locks up and the processor goes into meltdown! I have to quit Access through TaskManager to bring it round.
I previously exported every element of the database one at a time to a new DB, and on each tested to see if the MDE would work. I identified 4 forms and 1 report which would prevent it making the MDE. I started the new database from there. Now I have re- created the forms and I get the same problem as before,
Does anybody have a clue what is going on or where i should look to resolve this , as I dont want to have to do all that exporting/testing again..????