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 bkrike 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: *

  • Users: BFP
  • Content: Threads
  • Order by date
  1. BFP

    Form to XML Output PHP snippet

    Hi all. I have a very basic question: how can I take the values in a PHP/HTML form and export them to XML? For example, suppose I have index.php, which is a job submission form as follows: <form id="jobSubmit" name="jobSubmit" method="post" action=""> <label>Title <input type="text"...
  2. BFP

    Pulling data from a MS SQL Server dB into an HTML form?

    Hi. I am using a CMS-based website that was built on top of Apache, MySQL, and PHP (i.e. Drupal) and I would like to build a bunch of form-based pages that integrate with a pre-existing Microsoft SQL Server database that contains customer data. Thus, a typical scenario might be as follows...
  3. BFP

    Language translator tool supporting HTML

    Hi all. I have a help system developed in HTML and a new requirement has been added to support French as well as English. I have been using Dreamweaver, so an add-on would be ideal. Most of the tools I have seen so far can open an HTML file, but the translation is to text, which doesn't do me...
  4. BFP

    Tool tip definition populated from glossary file

    Hi all. Total hack here creating a HTML-based help system for an HTML-based tool that has hundreds of screens with similar fields (e.g. "Company Name"). Since there are so many fields that are repeated throughout the tool, I wanted to create a single glossary file with a name anchor for each...
  5. BFP

    Can not seem to override a:link behavior in CSS for a given div

    Hi All. I have a footer in my site <div id="footer"> I have set up an a:link style that just happens to almost exactly match my background image, so I attempt to override it using two techniques #footer a:link {color:fff;} or a.footer-link:link {color:fff;} with the appropriate...
  6. BFP

    Basic Update Query Question

    Hi All. Our database is updated every night with new data. One of the columns in the main table that is updated nightly is called FileName and another is Date (in the format [MM/DD/YYYY HH:MM:SS AM/PM]). I would like to be able to automatically populate another column called Owner (Not part...
  7. BFP

    Automatic data assignment when dB opened

    Hi All. Our database is updated every night with new data. One of the columns in the main table that is updated nightly is called FileName. I would like to be able to automatically populate another column called Owner (Not part of data dump) based on the FileName, where Owners are assigned to...
  8. BFP

    Regular Expression to find the start and end of a javadoc comment?

    Hi. Is it possible to use a regular expression (in TextPad) to find the following? /** * Some comment * ... */ public foo(foo); That is, I want to start finding the "/**", then "*/", then ";" Is this possible with a single regular expression? Thanks in Advanced...
  9. BFP

    Update query for total occurrences of a string

    Hi All. My main dB table is based on a linked Excel spreadsheet. In the table, I have a column called FILE_NAME that contains a web page file name. Each file has one or more unique IDs that identify a comment. I also have a column called "# Coms". I would like to 1) Calculate the number of...
  10. BFP

    Listen for right-click event

    Hi all. Access forms have ApplyFilter listeners, but no listener for the opposite, both of which can be applied by right-clicking in a combo box. I use the ApplyFilter to set a lable to visible, and would like to set the same filter to invisible when the filter is removed using right-click >...
  11. BFP

    What's up with the details section?

    Hi all. What's up with the Detail's section of the form? Is this something that appeared after Access 97? Is there a way to get rid of it? The reason I ask, is I have a form MouseMove event, which only triggers outside the Details section of the form, which is annoying since I have to have a...
  12. BFP

    Best event or method to make a label invisible after a short time?

    Hi All. I am trying to implement a status label that appears when a filter is applied that returns 0 records. Now I seem to have no problem getting the label to become visible, but making it invisible again is an issue. Here is my code to make it visible/invisible, which is run on a button...
  13. BFP

    Getting rid of a status message

    Hi All. I have a status message that appears (becomes visible) if a filter returns 0 records. Only problem is, I am not sure what's the best way to make the message become invisible. I am not even sure what the "standard" for such a thing is. I am guessing the next event (whatever it may be)...
  14. BFP

    Link from Access to Excell produces &quot;#Num!&quot;...How do I get rid of it?

    Hi All. I have linked a table in Access (2003) to an Excel spreadsheet. Sometimes, I get #Num! in some of the cells in my Access table, which causes queries to fail. What is the best permenant solution for this (as I will be updaing the Excell Spreadsheet)? Thanks, BFP
  15. BFP

    Getting rid of null values in a table

    Hi. I have a table linked to an Excel doc (which, in turn was linked to other Excel docs). With all the linking going on, I managed to get nulls in the table, which shows up in Access as #Num! or something similar, but I can not search and replace on this. So, how do I do a mass search and...
  16. BFP

    Want to remove filter automatically if filter removes all records

    Hi all. I have a simple question: since my form blanks out if I run a filter and the filter removes all records, how do I prevent that from happening? Here is my code: Private Sub btnApplyFilters_Click() DoCmd.ApplyFilter "Query by Parameter" End Sub Thanks in advanced, BFP
  17. BFP

    Issue with query using Date originally in Excel, linked in to Access

    Hi All. I have created a table in Access (2003) that is linked to a spreadsheet in Excel. I have tried to tell Excel that the format of a the date column is indeed a date (m/d/yyyy h/mm/ss). (I have even tried to recreate the table in Access only so I could attempt to ensure a date format was...
  18. BFP

    Issue with query using Date originally in Excel, linked in to Access

    Hi All. I have created a table in Access (2003) that is linked to a spreadsheet in Excel. I have tried to tell Excel that the format of a the date column is indeed a date (m/d/yyyy h/mm/ss). (I have even tried to recreate the table in Access only so I could attempt to ensure a date format was...
  19. BFP

    Update data from form based on dynamic table creation from query

    Hi all. I have an Access table and associated form linked to an Excel Spreadsheet that will be used by about 10 people. I am wondering what would be the best way to accomplish the following: 1) Allow each individual to filter the data based on about 6 different criterion. 2) Automatically...
  20. BFP

    Excel: Automatic row grouping

    Hi. I have a column called "File Name" (1st column) in my spreadsheet and I would like to automatically group rows when the text string matches in the cells of this column. Thanks in advanced. Dan

Part and Inventory Search

Back
Top