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 Wanet Telecoms Ltd 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: sweetp
  • Content: Threads
  • Order by date
  1. sweetp

    Expression in Default Value

    I have: =DateAdd("y",+[Days_Due_To_Expire],[Date]) in my Control Source of a form and it adds the two controls together fine and shows it on the form. But to get it to insert into the database, I need to move the expression to Default Value and bind the Control Source to the database field...
  2. sweetp

    Connections Conflict??

    I have 2 database connections on my server (using jsp and iPlanet with Dreamweaver). Everything is fine if users only use one of the programs (it never locks up), but if I make both available, after someone uses one, then the next time a person goes into the other jsp program, it hangs. I have...
  3. sweetp

    Connections Conflict??

    I have 2 database connections on my server (using jsp and iPlanet). Everything is fine if users only use one of the programs (it never locks up), but if I make both available, after someone uses one, then the next time a person goes into the other jsp program, it hangs. I have the...
  4. sweetp

    MX Dynamic List/Menu Doesn't Work!

    I can't get Dynamic List/Menu to work. I'm using JSP and MX. I am using Dreamweaver's Server Behavior which generates the code below (for a dynamic list of Personnel) but it always fails and I get a "Data Not Found" error on my server. Anybody know what's wrong? This is just Dreamweaver...
  5. sweetp

    Using ORDER BY with a time field ignores am and pm

    Hi everybody, I need to sort on a time field: ORDER BY StartTime ASC but it ignores AM and PM and instead sorts just on the numbers, so for example 04:00 pm comes before 12:30 pm, but that's not the way it should be. What do I need to do?? Thanks a bunch!
  6. sweetp

    multi-user "adds" into db won't work

    I have an Access 2000 database on an NT server running iPlanet Server and using JSP. My web app (designed in Dreamweaver) lets users add a conference room reservation, delete, and view existing reservations. When 2 users attempt to click Submit at the same time (to add a room reservation), the...
  7. sweetp

    multi-user conflict caused by ODBC setting???

    I have an Access 2000 database on an NT server running iPlanet Server and using JSP. My web app (designed in Dreamweaver) lets users add a conference room reservation, delete, and view existing reservations. When 2 users attempt to click Submit at the same time (to add a room reservation), the...
  8. sweetp

    data fomat for "Time"??????

    I have a field I'm trying to display (from a recordset) that shows "start time". How do I format the field to show time like (11:32 am)?? If I choose Format under bindings I only get choices to format date. If I choose None, then it shows up as: 1899-12-30 11:32:00.0 I'm using MX...
  9. sweetp

    Time Field won't consistently insert into Database

    I have an applet (I got off the web) that lets a user pick a span of time to reserve a room, and I can pass that info to the next .jsp page to view the choice. However, when I use the Insert Record command in Dreamweaver to insert the time into an Access database, sometimes it works, but most...
  10. sweetp

    auto fill a form field based on another inputted form field

    Hi - I want three fields to automatically fill in information when another field (combo box) is selected. Example: User chooses peanut butter from a combo box on the form. Next to that there are three fields labeled: brand1, brand2, brand3. I want the brands to automatically fill in when...
  11. sweetp

    Help inserting values from one table into another

    Hi everybody. I'm excited that someone might be able to help me, since I'm a newbie here. I have a table EMPLOYEES. It has a column EMPLOYEES.SUPERVISOR (which is blank right now). Another table has the list of SUPERVISORS. I would like to put each appropriate supervisor's last name...

Part and Inventory Search

Back
Top