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 TouchToneTommy 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: Fazee
  • Order by date
  1. Fazee

    Open Form in Expression Builder?

    I have a form whereby a user clicks on a field and depending on the value of the timeofday field it opens either one form or another. i know what i want but don't know how and where to implement it. i.e IIF([timeofday]="allday",openform1,openform2) can this be done in expression builder, if...
  2. Fazee

    Time Between Query

    lespaul i tried the greater than less than method but this doesn't work, i use the query grid but in sql view ur solution looked like this: WHERE (((course_session1.startdate)=[Forms]![new_session_only_Courses]![course_session1Subform]![startdate]) AND ((course_session1.trainerid) Is Not Null)...
  3. Fazee

    Time Between Query

    i have a DB which allows users to allocate trainers to course sessions, they fill out date, start time , end time and other fields and when they click on the trainer field I have a pop up which shows the AVAILABLE trainers, i.e. it checks the existing session times and only shows the ones who...
  4. Fazee

    Displaying record selected from Drop Down List

    Hey what about me and my problem guys!!? :-(
  5. Fazee

    Displaying record selected from dynamic list

    IT WORKS the problem was that there was no action for it to submit the request! i added an onchange behaviour which works instead of pressing a button but now i have another problem. I have one page but need about 4/5 DD boxes on the same page (because this will finally be a booking form) but...
  6. Fazee

    Displaying record selected from dynamic list

    This doesn't work Cheech code looks like this now: <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <!--#include file=&quot;Connections/localBookingDatabase.asp&quot; --> <% Dim rstest__MMColParam rstest__MMColParam = &quot;Room&quot; if (Request(&quot;MM_EmptyValue&quot;) <> &quot;&quot;) then...
  7. Fazee

    Displaying record selected from Drop Down List

    Please can someone help as i have been on this problem for two weeks and i know i'm close to getting it to work! I'm using dreamweaver ultradev with ASP/VB but use server behaviours, data bindings as opposed to hard coding. I have a dynamic drop down list and depending on what the user selects...
  8. Fazee

    Displaying record selected from dynamic list

    ok here goes - it may be a bit of a mess because i've been messing about with it trying different things to get it to work: <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <!--#include file=&quot;Connections/localBookingDatabase.asp&quot; --> <% Dim rstest__MMColParam rstest__MMColParam = &quot;Room&quot...
  9. Fazee

    Displaying record selected from dynamic list

    when i create a variable giving it the runtime value of that in the drop down list, i get this error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or...
  10. Fazee

    Displaying record selected from dynamic list

    I am very new to Ultradev ASP and VB and am struggling to perform the simplest task (well seems simple in theory). I have a list box which is displaying dynamiv data from my access database but when the user selects an item (room) from the list I would like to display the record for that...

Part and Inventory Search

Back
Top