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!

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

Recent content by Lightbulb

  1. Lightbulb

    Form Alignment Problem

    Is there a way to align a form that inserts data on an ultra-dev web-page other than right, left and center? I am using a vertical panel on the left side of the web page that has links and other information. Therefore, everything else to the right of the panel is what would show up depending...
  2. Lightbulb

    Listing multiple values in a Drop-down list - HOW?

    I want to list multiple values per line in a drop down list in Ultradev. For example, I have an inventory database that has the users id number in the inventory table which is linked to a table called users by the users id number. The users table also has the users first and last name. The...
  3. Lightbulb

    Automatic screen refresh of browser from link to link. How?

    I have an active server page which presents the user with a drop-down menu to perform a database search. The user then makes their choice, clicks on search and goes to the results page which allows them to modify the same database field from the search page drop-down menu. After clicking the...
  4. Lightbulb

    Making a Drop-Down Menu Field Enterable. How???

    I have created a form that has a field which produces a dropdown list of manually created items. However, I would like the user to be able to type his own answer if it is not contained in the drop down list. Right now, Ultradev seems to provide no other choice except to choose from what's in...
  5. Lightbulb

    Want unpopulated fields when opening form. HOW???

    I have created a form that does inserts into a table. However, when the form is opened using explorer, existing data from the table to be inserted into shows up in the fields. I would prefer the fields be blank when the form is opened so as to indicate to the user that the form is ready to...
  6. Lightbulb

    Most Recent Dates When Using Group By and Max Functino

    Terry, My error. Your solution worked. Earlier (above) I mentioned that the first and last name fields were not in the assignment table as I indicated above. Therefore when I ran your query, I used the other table containing the first and last names from another table and the serial and date...
  7. Lightbulb

    Most Recent Dates When Using Group By and Max Functino

    Thanks Terry, However, when I run the query you specified, I get the following records back. Notice that duplicate serial numbers are printed and the date assigned was somehow erroneously duplicated; not completely reflective of actual data in the table. Interestingly, although the dates are...
  8. Lightbulb

    Most Recent Dates When Using Group By and Max Functino

    Thanks jebry. However, I tried your solution and ended up getting multiple records for the same serial number instead of the most recent date assigned for each serial number that occurs more than once. Any more suggestions would be appreciated, else thanks anyway.
  9. Lightbulb

    Most Recent Dates When Using Group By and Max Functino

    Someone help! In creating an inventory system I have been trying to query four fields from multiple tables grouping the records by the serial number (same one occurs multiple times in assignment table) and attempting to get the most recent record for each serial group by using the max function...
See more

Part and Inventory Search

Back
Top