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 Chris Miller 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: tonyx666
  • Order by date
  1. tonyx666

    format asp send email

    ok... im a little confused.. but i realise that i need to TRY and show some understanding if i want your continued help.. so here i go.. would my template look something like this?? <% @LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <html> <head> <title></title> <meta http-equiv="Content-Type"...
  2. tonyx666

    format asp send email

    ok the reason that i used that email was because my host gave me this specific example to use.. now i tried altering this code as you said to make the email format html.. so i used the w3c example here.. <% Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with CDO"...
  3. tonyx666

    format asp send email

    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...
  4. tonyx666

    basic query form, foreign key field

    ok, i have posted many times on this issue and im slowly trying to create the most efficient way of doing this.. i described my table layout as above: CUSTOMER TABLE customerid customername customerphone BOOKING TABLE bookingid bookingdate customerid (this is meant to be the passenger)...
  5. tonyx666

    basic query form, foreign key field

    yeah, that is it.. im gonna start developing this form now, i might have 1 or 2 simple requests shortly, thank you aceman London Heathrow Cars http://www.LondonHeathrowCars.com
  6. tonyx666

    basic query form, foreign key field

    OH, i see what you mean.. use the wizard, enter all the fields, and then do the subform. ok ok, let me try that London Heathrow Cars http://www.LondonHeathrowCars.com
  7. tonyx666

    basic query form, foreign key field

    im sorry, could you just repeat that.. are you saying create a query with the fields from both tables.. and then use the form wizard to create the subform.. or are you saying create two separate forms based on the tables themselves, and then create a sub form London Heathrow Cars...
  8. tonyx666

    basic query form, foreign key field

    yes.. lol.. i am aware of both of these solutions. however, is there not a way to simply include the 2 customer fields in the booking form.. without opening a new form.. and accomplishing the 2 tasks i outlined above? London Heathrow Cars http://www.LondonHeathrowCars.com
  9. tonyx666

    basic query form, foreign key field

    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...
  10. tonyx666

    field counter, display no. of occurences in a table on a form

    ok i have this "intX"=DCount("[customerid]","bookings") so far customerid is the field i want to count.. bookings is the table i want to search through.. but i want to search through the 'customer' field aswell.. how can i change the code to do that also do i put it in the control source...
  11. tonyx666

    field counter, display no. of occurences in a table on a form

    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...
  12. tonyx666

    auto add value to field when form opens

    i see.. well basically this database is for a cab office.. there is one main table - bookings. there are generally 3 types of booking, cash, account, and credit card so i have created 3 forms, each one with the relevant fields displayed.. i just wanted the 'jobtype' field to be populated...
  13. tonyx666

    auto add value to field when form opens

    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...
  14. tonyx666

    alter autonumbers

    hmm. ok.. well if i make the recordid an autonumber, but not have it as the primary key, have the refno as the primary key.. would i be able to do it this way.. London Heathrow Cars http://www.LondonHeathrowCars.com
  15. tonyx666

    alter autonumbers

    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
  16. tonyx666

    update combo list

    its funny that every now and then, a post will never be replied to.. it has outlived its own tolerance London Heathrow Cars http://www.LondonHeathrowCars.com
  17. tonyx666

    update combo list

    trying to make one combo requery another.. got object required error here: Option Compare Database Private Sub comp_combo_Change() staff_combo.Requery End Sub London Heathrow Cars http://www.LondonHeathrowCars.com
  18. tonyx666

    update combo list

    ok, i... deleted both the control sources of the combos.. changed the staff combo row source to this SELECT [staff].[staffid], [staff].[staffname] FROM [staff] WHERE [staff].[companyid]=Me.comp_combo; and put staff_combo.requery in the change event of the company combo. when i changed the...
  19. tonyx666

    update combo list

    ok, let me clarify things.. the ROW SOURCE for my COMPANY COMBO is this at the moment SELECT company.companyid, company.companyname FROM company; this displays the company names (and inputs the hidden id) and the CONTROL SOURCE at the moment is 'companyid' which is the field that the value...
  20. tonyx666

    update combo list

    have a look at the table layout so far.. is this wrong? http://www.londonheathrowcars.com/id.jpg London Heathrow Cars http://www.LondonHeathrowCars.com

Part and Inventory Search

Back
Top