Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JeffNolan1900

    XSLT Web Links Fine...Local Links Broken

    Like I mentioned, I am using a mapping program's internal browser. It works fine if I take it out of the mapping program's environment and send it into Internet Explorer. It is just that for some reason the internal program can not handle it. I have tried appending: file:// and file:/// and...
  2. JeffNolan1900

    XSLT Web Links Fine...Local Links Broken

    It does work remote. I changed the location of the </a> Actaully, it worked remote with the </a> in the wrong location, which is strange to tell you the truth...But it does not work local. No matter which location I put the </a>
  3. JeffNolan1900

    XSLT Web Links Fine...Local Links Broken

    Thanks for the input but that does not resolve the problem. Like I mentioned it works fine for html links, but does not work for local links. (C:\image.jpg)
  4. JeffNolan1900

    XSLT Web Links Fine...Local Links Broken

    Hello. I have an xslt file that processes an xml and I have use a xsl choose to conditionally format any of the properties that have the name LINK to show the path as a hyperlink. Easy enough. If the link is web related: www.google.com it works fine and opens the link. If the link is...
  5. JeffNolan1900

    Add dummy record to all tables in access database

    Hello, I have a database populated with about 500 tables, all of which are blank (as far as data goes). The tables are linked properly, have fields (ADDRESS_ID for example), and are set up, but completly empty of data. The database is auto-created thru a filter process using another application...
  6. JeffNolan1900

    DOCTYPE Removed from xsl file?

    Hello, I have an xsl file. <?xml version="1.0" standalone="no"?> <!DOCTYPE SOMEFilter SYSTEM "http://www.webpage.com/xmldtd/SOMEFilter.dtd"> <?xml-stylesheet type="text/xsl" href="http://www.webpage.com/xmldtd/SOMEFilter.xslt"?> <xsl:stylesheet version="1.0"...
  7. JeffNolan1900

    Write Form value into Criteria of Query

    Ok. This problem has been solved. Here is the updated code: Private Sub CmbGenerate_Click() Dim qryT As DAO.QueryDef 'for this you have to include "Microsoft DAO 3.6 Object Library" '(Tools, References, find, select and OK). Dim duz Dim SQLR As String Set qryT...
  8. JeffNolan1900

    Write Form value into Criteria of Query

    Here is the code I have: Private Sub CmbGenerate_Click() Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim Rsdb As DAO.Recordset Dim i As Integer Dim strWhere As String Dim strIN As String Dim varItem As Variant Set MyDB = CurrentDb() 'Build...
  9. JeffNolan1900

    Write Form value into Criteria of Query

    Thanks guys. Once again a key work from you and I am off to learning something new again... http://www.databasedev.co.uk/query_using_listbox.html Jeff
  10. JeffNolan1900

    Write Form value into Criteria of Query

    I am trying to store the value of a form text box inside a query criteria, but I do not want to load the value of the textbox when the query opens, I want the value to be written in to the query criteria, thru vba, permanatly. As in stored as the value, so when the form is closed, the value is...
  11. JeffNolan1900

    Load search from Form into Query

    That is exactly what I was looking for ProgramError. Perfect. I will have to look into that site further. What an amazing resource, like this place... You guys are the best. jeff
  12. JeffNolan1900

    Load search from Form into Query

    nevermind. That's not working now. Though it was, I thought.
  13. JeffNolan1900

    Load search from Form into Query

    Thanks for the advice. I didn't think it would be necessary to use filters, I thought I could get around it. And it seems like, every time, right after I post in here, I figure it out. I think this place is good luck. What I did was run a couple vba commands to close and then re-open the query...
  14. JeffNolan1900

    Load search from Form into Query

    I tried putting this in the query criteria box: [Forms]![frmXMLcreator]![ComboEntityName] I put this in the criteria box, under design mode of the query, for "Type" which is where I am searching.
  15. JeffNolan1900

    Load search from Form into Query

    I have a query called "QueryME" I have a Form called "FormME" Within that form, I have a search box called "SearchME" When the user enters the word ' air ' into the search box, I want it to pull all types that have the word air in them and refresh the query. The user should have the ability...
  16. JeffNolan1900

    Convert Access Database to XML - format

    Oops.. For instance, this query is called: DogCat_Report
  17. JeffNolan1900

    Convert Access Database to XML - format

    How can I get it to read a query from an external database? For instance, this query is called: Graphic_Report So I use this: <xsl:for-each select="DogCat_Report"> What if I had a seperate database that had additional properties that I wanted to pull in. For instance in the file...
  18. JeffNolan1900

    Convert Access Database to XML - format

    Ok. Got it working. Is there a way to append text to an attribute? What I mean is this: If the Database "Name" value is "Dog" How do I add _Text to the end of Dog? Before I hit Submit, I figured it out, so in case anyone is ever reading this, who does not know...here is the answer: xsl with...
  19. JeffNolan1900

    Convert Access Database to XML - format

    Thanks, So I would use something like this: <feature> <xsl:attribute name="Name"> <xsl:value-of select="Name" /> </xsl:attribute> <xsl:attribute name="Color"> <xsl:value-of select="Color" /> </xsl:attribute> </feature> Which would result in: <feature Name="Dog" Color="Red">...
  20. JeffNolan1900

    Convert Access Database to XML - format

    Hello. I have an Access Database, like this. Name Color Body_Type Age ------------------------------------------- Dog Red Fat Old Cat Yellow Skinny Young Using Access to create the XML file from the data. And Using Tranform, I need to...

Part and Inventory Search

Back
Top