ok, i have a question, there is a fair bit of code in this post.. i dont expect someone to trail through all of it and give me the complete solution.. i would appreciate however if someone could show me a single example.. and i think i can do the rest..
basically, i have a html template.. with...
hello.. i have 2 tables
CUSTOMER TABLE
customerid
customername
customerphone
BOOKING TABLE
bookingid
bookingdate
customerid
At the moment i have 2 forms.. one customer form based on the customer table and one booking form based on the booking table.
at the moment, my user enters a customer...
hi,
in my table i have a customer id number.
each job will have one customer id number.. and customers will have many jobs to their id
i simply want to display on my form the number of times that customer's id has appeared in my bookings table.
eg.. a customer has used our services 25...
a simple request i think..
when my form opens, i would like to add a value to a field automatically..
lets say my field is called 'field1' and the value is 'value1'
i presume it will be some kind of open form event or something..
how would i code that?
London Heathrow Cars...
if i create 100 records with autonumbers as primary keys (record_id)
then deleted 30 at random
could i update the record ids so they become 1-70?
London Heathrow Cars
http://www.LondonHeathrowCars.com
ok i have three tables..
Booking_Table
Booking_ID
Job_Date
Company_ID
Booker
Passenger
Company_Table
Company_ID
Company_Name
Address
Phone_No
Company_Staff_Table
Company_Staff_ID
Company_ID
Full_Name
Phone_No
each booking will only ever involve one company at a time
company 'A' will have...
there are annoying gaps appearing in my email templates..
my html template is built inside access.. the form button is clicked and the template opens in outlook.
it looks fine in outlook.. so i send the email.. when i receive the email in outlook, it looks fine..
here is what it looks like...
i realise that without html emails, the formatting capabilities are very limited.. eg.. you cant use tables or images.. to my knowledge
i believe the alternative is rtf, rich text format, which is just basic text
i have a button on my form that opens outlook and sends an email using the...
ok, i need to change the format of certain times
here is my code at the moment, PHV helped me format the date to make 21-21st and 3-3rd etc
now i need to alter the time format
in my db, the time is in two fields.. hours and minutes
infact, you can see the form here...
ok, basically im sending an email str8 from access.. here is my code.
Option Compare Database
Private Sub emailbutton_Click()
On Error GoTo send_Err
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = "London Heathrow Cars - Booking Confirmation"
If...
i want to place a button on my form
when it is pressed..
a message box opens and says
Please enter the recipients email address:
so you enter an email address
press ok
then selected fields and their values
(from the record that is opened obviously)
are transfered into a customized email...
http://www.airporttaxilondon.com
ok this site uses a booking form in stages. its php but im sure it can be done with asp.
you find a quote from their database.. that is simple enough.. then it shows the user what quote they have and they book it.. again, simple enough..
however, the actual...
hi, this is a strange problem and it is annoying me.. and it seems to be only happening in firefox and not in ie which is surprising.
http://londonheathrowcars.com/newest/index.asp if you look at this page in firefox, you can see that there is the time and date just under the menu.. the time...
ok.. i would like to display on my page what item my user has just selected from the form..
eg. which radio button they just chose, or which drop down menu item they have shown..
the page is here..
http://www.londonheathrowcars.com/ajax/blankquote.asp
u can see the
Pickup: Heathrow Airport...
go here..
http://londonheathrowcars.com/ajax/blankquote.asp
using ajax to load asp pages into a form on my blankquote.asp main page.
if you select the first radio..
London Postcode..
then choose a drop down postcode.. then choose a car.. then click get quote.. basically a price should appear...
i have a homepage.. it can be reached in several ways..
http://mysite.com
http://mysite.com/index.htm
http://www.mysite.com
http://www.mysite.com/index.htm
i also have another couple of domains that redirect to
http://www.mysite.com
should i use a 301 redirect on every page except the one...
hello, i have had much help from these forums and am forever grateful for the time and stress that they have saved me in the past.
i have a quote system for my website that i wish to develop.
i like the idea of pages that refresh instantly with new data if something is pressed and that is what...
ok this is a page that uses information from a form, searches the database and displays the results..
the 2 bold items i would like to send them to another page.. certain items would have to preload with these values already in them..
my question is what code do i place on page 2 to receive...
hi,
i need to know the best way to send a html email.
at the moment i am making a page in frontpage, copying it all and pasting it into outlook and sending it... i think for most of the recepients it works.. but occasionally it looks like a total mess...
can someone please show me an example...
hi, my website is
www.mysite.com
i have my link on various pages. my website statistics however dont always tell me where my visitors have come from..
is there any way that i can add a simple bit of code to the end of the url so i know that the visitor has come from a certain site..
eg..
in...
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.