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

    Row height

    I have a table, that is exactly like many other tables that i have used, but when i view it live the row height is twice as high as any others, have tried coding the height but it still stays the same....any advice?
  2. redbay

    Repeat region

    Hi, i have my recordset set up and working OK but as soon as i put a repeat region on it i get either BOF or EOF is Trues, requires a current record....can anyone tell me where i am going wrong?
  3. redbay

    Recordset based on two filters

    Is it possible to base a recordset on two filters, at the moment it is filtered on ComplaintId and the URL Parameter set as ComplaintID, but i would like to filter on ComplaintID and then customerID. any help please?
  4. redbay

    Date auto inserted

    I have a checkbox and i would like if the box is clicked then the date field is automatically filled in as the current date.....any help please?
  5. redbay

    Search Pages

    I have a form with a drop down box so that when you select a category all the complaints within the category are displayed as such Category = Catering Short Description Poor service record 1 Poor service record 2 No variety record 3 No variety record 4 but what i would...
  6. redbay

    Month query not retrieving all records

    i have a query set up to show all records within a month. Between [Start Date] And [End Date]but when i input dates as 01/07/05 to 31/07/05 it leaves out the records for 31/07/05 but if i ask for 01/07/50 to 01/08/05 it shows the records for 01/08/05 and i would just like to see all records for...
  7. redbay

    If Statement

    I have 3 tables, tblComplaint, tblCustomer & tblAction. tblComplaint can have 0ne or more customers & the customer may have one or more action, each table has a status field but what i want to achieve is for example complaint no 102 has 2 customers (customer 1 & 2)& they each have two actions...
  8. redbay

    Warning message or email

    i have a field on a form called action closed and a date that the action has to be closed by (3 days later than date entered), can i get either a warning to pop up or an email sent to the user if the action hasnt been closed by the specified date?
  9. redbay

    Alert based on text field criteria

    i have an action form that has to be closed by a specified date, i would like an alert, message or warning to be activated if the action hasnt been closed by that date, is there a way of doing this
  10. redbay

    Validate form

    I have a text field on my form that is a list/menu and i want to validate this but i opened the validate form from the behaviours section and my list/menu field was not available. Is it possible to validate this field?
  11. redbay

    Search form

    second problem for today! i have a text field on a searchform that searches for names from the customer page, this works OK but when i apply the show region if recordset empty i get the page saying ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted...
  12. redbay

    Status closed…Help still!

    I’m still trying to get this to work I have 2 tables in my database, tblCustomer and tblAction; both have status fields in them. One customer can have many actions against them. On my Dreamweaver page I have a recordset from tblCustomer showing all fields, including status. I would like it to...
  13. redbay

    Font Query

    I have a CSS attached to my page that works fine but when i change a text field from single line to multi line then text changes to Times New Roman and i am unable to change it.....any ideas
  14. redbay

    SELECT DISTINCT

    Hi i am having problems with a distinct query, it want to show records in the query but if there a re more than one record with the same name i just want the name to display once. Here is the query SELECT DISTINCT tblFlowers.name, tblFlowers.productID, tblFlowers.nickname, tblFlowers.height...
  15. redbay

    How to show one record

    I have an update form on a page displaying data from tblComplaint, under this i have a table that shows all the customers that have complained against this complaint - rsCustStat (URL Parameter is ComplaintID)the data is taken from a query based on tblComplaint & tblCustomer & just shows the...
  16. redbay

    "IF" more than one record

    I have 2 tables in my database, tblCustomer and tblAction; both have status fields in them. One customer can have many actions against them. On my Dreamweaver page I have the fields from tblCustomer, including status, but I would like it to show closed when all the actions against the customer...
  17. redbay

    making a hidden field visible based on a value

    i have three hidden fields in my form that i would like to become visible when a user clicks pass to other, how should i do this please?
  18. redbay

    Concatenate fields

    How can i concatenate first name and last name fields in dreamweaver. please
  19. redbay

    scrollbars in tables

    Is theer any way that i can put a scroll bar in a table as i do not want to use record set paging?
  20. redbay

    Date problem

    Hi I have an input form and one of the fields is date (=Date()& short format-ddmmyy) this works Ok in the input form but i then have an update form and once that is updated the date is saved as mmddyy and then doesnt become the last entry. i have checked all my dates and they are set as they...

Part and Inventory Search

Back
Top