I'm designing a web page for a friend who is a car sales man, and he has a page where he'll list the specials he has to offer. I was hoping to have a form where the user can fill out the information and submit and have the results come up in a table in the 'Specials' page.
I can do this in ASP...
I'm creating a page with some links to outside pages...I'm using e.g. <a href="http://www.yadaya.com">Yadasdk</a>. Is there anyway that this link not be underlined? I can change the color properties of the links but can't get rid of the line. On some pages I've seen where a link is...
This is an excel question, I'm hoping that an Access user will be proficient in using excel. Essentially I'm trying to build a spreadsheet and I want to have pull down menu's on some of the cells that fill in the value, e.g. one column is for Quantity, and I want the user to be able to only...
I want people to be able to subcribe to a news letter. I'd like to create a form where the user simply puts in his/her email address and the user gets an automatic email saying that we've received his subscription request, and then send a newsletter via email in HTML format to all users who...
...the same e.g.radio_order and their values should correspond the field names that you want to order, (price, etc.)
for the sql statement try
SELECT *
FROM Tbl_LateDeals
WHERE Tbl_LateDeals.departure_date = 'varDate'
ORDER BY varorder
have the varorder with a runtime value of...
I'm having a problem using the jump menu...essentially it only jumps once...when it reaches the new page, the jump menu on that page doesn't work (and the new page has the same jump menu that the first page does -cut and paste-). I've put the menu's code below...i'd really appreciate it if...
What you could do is instead of the checkbox, replace it with a 'Details' (link). Highlight 'Details' and select the server behavior "Go to Detail Page". Fill out the fields in this behavior, you'll need a unique column identifier and it'll probably be your primary key from your...
Hi DougP,
I'd like the result to be returned in the query...I'm making a webenabled site and I want to create a recordset in ultradev and would like to copy the sql statement to ultradev.
Is there anyway i can return the result in it's own field in a query?
Jeevenze
I have the following query:
SELECT qryporeceived.job_number, qryporeceived.SumOfpo_received, tbljob_info.total_estimate
FROM qryporeceived INNER JOIN tbljob_info ON qryporeceived.job_number = tbljob_info.job_number
GROUP BY qryporeceived.job_number, qryporeceived.SumOfpo_received...
I have the following query:
SELECT qryporeceived.job_number, qryporeceived.SumOfpo_received, tbljob_info.total_estimate
FROM qryporeceived INNER JOIN tbljob_info ON qryporeceived.job_number = tbljob_info.job_number
GROUP BY qryporeceived.job_number, qryporeceived.SumOfpo_received...
It probably is 'odd'...but i'm trying to build an online time(sheet/management) and I want a pull down menu with dates and I just want the pulldown to display three weeks worth of dates. I did get it work like i wanted...I inserted the dates for two years in an access table and I used the...
I've a table with all the dates for this year. I've built a query where the results return all the dates upto the current date...what i need help with is that I want the query to return only 21 results or any other method that returns 21 dates prior to today. The current SQL statement i have...
I need help writing an SQL statement. I want to prepopulate a table with all the dates for the year and i want a query to select only the current date and 21 days that have passed. For example, today the query would select all the dates inbetween 06/27/2001 - 06/6/2001.
Thank you in advance to...
There's nothing wrong with the insert statement...the error only occurs when i'm trying to insert data into a field named 'date' in access. I changed the field name to 'zdate' and it works fine now. I also tried some test tables and the error only occurs when a field is labled 'date' in access.
I've been playing with the server behavior and the error only occurs when i'm trying to enter data in a 'date' field. I have various fields in the table, e.b. jobnumber, employeeID, etc...and when I try to insert data in any of the other fields it works fine...it's only when I include the date...
I'm not sure but something's wrong with my server behaviour for inserting a record. I have created several websites and have used it without any worries. Now when I use this and test it I get the following message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC...
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.