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 TouchToneTommy 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: bill1one
  • Content: Threads
  • Order by date
  1. bill1one

    New Window not opening in IE

    I have been trying everything to make the following code work in IE. It works fine in Firefox. Any suggestions? This is in the head tags: <script language="JavaScript" type="text/javascript"> function newwindow(url) { window.open(url,'details', 'width=750,height=700,scrollbars=yes'); }...
  2. bill1one

    Display line of text from text field

    I am using the following code to display a few lines of text from a text field in my database. echo substr($row['item_text'],0,256) This works fine, cause at least it only shows only the first few lines of text, but really what I'd like to accomplish is only showing the lines surrounding the...
  3. bill1one

    Limiting pages in pagination links

    I'm trying to make navigation easier for users. I would like to limit the page numbers shown to +/- 5 pages from current page, whereas currently it lists them all. I've been trying to mess with the following section of my code, but to no luck, but it seems the answer is in this area of code...
  4. bill1one

    Changing variable values

    I have text boxes on my form for users to enter a range of numbers that they would like to see in the database. I would like to query to ignore the range if the user does not enter anything in the box. To do this, I basically said if the variables are empty to reassign them with the minimum...
  5. bill1one

    Passing variable to MySQL query

    In my form, I'm trying to pass the following values to a MySQL query. Sort by: <select name="sort" type="text"> <option value="Title, Author">Title</option> <option value="Lexile, Title">Lexile</option> </select> For some reason the MySQL totally ignores the values posted and does not...
  6. bill1one

    Event occurs when clicking on menu item

    I would like a certain event to occur when a user clicks on "Purchase Request" in the menu. Following is the script that generates the menu. "Purchase Request" is the second item in the menu. window.menu_0 = new Menu("root",130,16,"Arial, Helvetica...
  7. bill1one

    Confirm with Yes/No

    I am trying to make a simple confirm box that would display "Yes" and "No" on the buttons. All I get is the Ok/Cancel combination. How can this be done or can it be done? Thanks.
  8. bill1one

    Firefox and Javascript

    I have the following code that Firefox does not recognize: l.style.cursor = "hand"; In iExplorer, it works fine, but Firefox doesn't like the hand. I've tried switching "hand" to "pointer" and it still doesn't like it. Any suggestions. I've noticed that Firefox doesn't like a lot of my...
  9. bill1one

    Combining Conditional Statements

    I'm trying to validate a form. I want the value entered into the textbox, Patron ID, to be greater than 20000000 and less than 21999999. I also want it to contain only numbers. Following is the code I'm working with. function validate() { if...
  10. bill1one

    Problem executing script

    I have a script that I am trying to execute from my cgi-bin. I believe it isn't working because the server isn't recognizing the cgi-bin as executable files. I'm using Apache 2 for Windows. Here is the excerpt from my config file: ScriptAlias /cgi-bin/ "C:/Program Files/Apache...
  11. bill1one

    Syntax Error w/ Link in RSS Feed

    I am trying to use the following url in one of my items and I keep getting a feed error. http://www.opac.lib.us/TLCScripts/interpac.dll?NewestSearch&Config=PAC&SearchData=Videorecording-DVD&SearchField=17&PeriodLimit=30&SearchType=1&SortField=2&ItemsPerPage=100 The error is occuring at the...
  12. bill1one

    Form Values in a link

    I have a form that looks like this: <FORM ACTION="../TLCScripts/interpac.dll?NewestSearch" METHOD="post"> <INPUT TYPE=hidden NAME=Config VALUE="PAC"> <INPUT Type="hidden" Name="SearchField" Value="17"> <INPUT Type="hidden" NAME="PeriodLimit" Value="30"> <INPUT type="hidden" name="SearchType"...
  13. bill1one

    Leading 0's in number field

    I have an ID field in my table and 0's are crucial in the ID. Many IDs start with a 0, such as 0120743. Whnever I enter an ID, the leading 0's disappear, so 0120743 becomes 120743. Is there a way to stop that from happening?
  14. bill1one

    OpenForm action cancelled

    The results of a SQL statement are posted in a listbox titled, lstResolution. I want to open another form (frmEdit) when a user double-clicks an item from the list, based on the field tblResolution.Number. Here is my code for that: DoCmd.OpenForm "frmEdit", acNormal, , "[tblResolution.Number]...
  15. bill1one

    Command Button to Respond to Enter

    When ever I press Enter on my keyboard, the focus simply goes to the command button. I have to press enter again to get the command button to run. I've looked in the properties and options and can't find anything to switch the way the form responds to pressing the enter key.
  16. bill1one

    Item not in Combo Box Problem

    I have a combobox called cmbTitle. If a user enters a title not in the box, I want them to have the option of opening a form to add the title or canceling the action. Here is the code I have running: Private Sub cmbTitle_NotInList(NewData As String, response As Integer) Dim msg As String Dim...
  17. bill1one

    ComboBox controls Listbox

    I have a combobox (cmbType). After it updates I want the listbox (lstResolution) to show the any records that match the value in cmbType. I have an AfterUpdate event for cmbType that looks like this: Private Sub cmbType_AfterUpdate() Dim strNewRecord As String strNewRecord = "SELECT...
  18. bill1one

    Value from first form opened in second

    I have two forms, one simple form (frmNewTitle) where information is entered and another form that displays information (frmPeriodical). When data is entered into txtISSN in frmNewTitle and the user clicks save, I want the new record that corresponds with txtISSN value to appear in...
  19. bill1one

    SQL statement in VBA

    I'm trying to create a form that would include a listbox and a query would run depending on the result in the listbox. It would be similar to a filter by form, except I'd be providing the values in a listbox. I assume I need to use VBA to accomplish this, but I don't know how to include an SQL...
  20. bill1one

    OnChange event with multiple fields

    I must apologize, I am new to this. I am trying to create a form to search a database. If the value of the SearchData is "Books", I want the value of SearchField to be "15"; otherwise, I want the value of SearchField to be "17". This is what I've come up with thus far, any suggestions? <FORM...

Part and Inventory Search

Back
Top