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?
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?
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?
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...
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...
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...
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?
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
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?
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...
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...
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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.