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 strongm 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: *

  1. mrobinson

    Email Notification in Access

    Hi, Please could someone advise if there is a way for an email being recieved in outlook 2000 to trigger an automatic update into an access table. I am looking for a particular word in the email to cause an access table to update with that days date. If this is not possible in Access, is it...
  2. mrobinson

    Deleting Links in Excel

    Hi, Could anyone tell me how to remove or disable the links in an Excell spread sheet. The manual update is grayed out and I can not find a way to delete them so I can forward the report on. Any help would be much appreciated. Thanks
  3. mrobinson

    Outlook 2000 shared archiving

    Hi, I am needing to archive large amounts of emails from a shared mail account as the size of the account is now over 20mb. The archived mail needs to be shared by up to 3 users at a time which means .pst files are of no real use as I understand that only one person can access these at any one...
  4. mrobinson

    Auto forward to form

    Could somebody please tell me how to forward from one form to another with no user input. for example, my form takes information from one form and inserts it into the database. once this is done, i want it to forward onto another form to start the process again automatically. Thus the form is...
  5. mrobinson

    form input values

    Could somebody please tell me if it is possible to run a form and then, when a user selects a value from a drop down list, the value can then be used in the same form for an sql querey which gives another list, on the same page, to chose from, ie submit does not have to be pressed and move onto...
  6. mrobinson

    radio button loop

    i am trying to create a basic attendance system that when an office number is selected it selects all employees from that office to the screen from the database. Besides each name i want a 2 radio buttons to select if the employee is absent or not and then in the following form to add this...
  7. mrobinson

    radio button loop

    i am using radio buttons as it is either or, does that sound the best way to go about it?
  8. mrobinson

    radio button loop

    I have created a php form and am displaying some html which includes radio buttons. The form takes information from a database then displays it in a list in the form and in the while loop that does this it displays radio buttons next to each data item. I can get this to disply everything ok but...
  9. mrobinson

    radio button loop

    I have created a php form and am displaying some html which includes radio buttons. The form takes information from a database then displays it in a list in the form and in the while loop that does this it displays radio buttons next to each data item. I can get this to disply everything ok but...
  10. mrobinson

    selecting data from a database with loops

    after putting $ before all the get_list_res i executed the code and while it out put all the surnames it gave a repeated error in the sql code: $get_list6 = "select concat_ws(firstname, secondname) as display_name from student where stuid = $group"; any ideas?
  11. mrobinson

    selecting data from a database with loops

    I am trying to print a list of information in a form from a database. The information i am wanting to print depends on the results from some froms and the takes a value from one table and the uses this value to find information from another table. is it possible to write a querey like this in...
  12. mrobinson

    getting information from a form

    cancel that, i just got it to work. Thanks again!!!!!!!!
  13. mrobinson

    getting information from a form

    yes, i see where i was wrong there now and can get the value to pint to the screen on the next page but i'm still getting an sql error whenusing the line: $get_list3 = "select mcode as display_name from module where ctitle =" .$_POST['sel_id']; any ideas? Thankyou both so much for your help
  14. mrobinson

    getting information from a form

    yes, i selected a value then submitted it and it opened the next page to which it keeps giving me an error or gives the 'sorry no records to display' message. If i write the value of what i have selected where the $_POST['sel_id'] is in the second form it selects the values into the drop down...
  15. mrobinson

    getting information from a form

    Im sorry, i can't do this as i am working on a stand alone machine whilst doing work with PHP and this machine doesn't have it installed. The full code for the page is as follows: <?php //connect to database $conn = mysql_connect("localhost", "root") or die(mysql_error())...
  16. mrobinson

    getting information from a form

    it come back with: Array([sel_id]=>[submit]=>Select)
  17. mrobinson

    getting information from a form

    i am trying to call the variable from the previous form into the current form. as far as i can see the variables are correct?
  18. mrobinson

    getting information from a form

    sorry, my mysql version is 4.0.15, my version of php is 4.3.3. I tried the above but still no joy. Thankyou very much for explaining about arrays. It is starting to make a lot more sense now. I have an example which does a similar thing and have literally copied that just changing the bits i...
  19. mrobinson

    getting information from a form

    you have an error in your SQL syntax. check the manual that corresponds to your MYSQL server version for the right syntax to use near" at line 1. the query works if i substitute the $_POST['sel_id'] for a value. I have tried printing the $_POST['sel_id'] to the screen but this just comes up...
  20. mrobinson

    getting information from a form

    i don't totally understand what you mean but i put the code in you gave me and played about with it but it keeps giving me a mysql error. Any other ideas. Thanks very much for the help, it is much appriciated

Part and Inventory Search

Back
Top