Search results

  1. S

    Using select Statments to filter a subform

    I still need more help. I dont understant how the buttons in the Option Group reference the table. I am attatching the form that i am trying to complete for reference. please help.
  2. S

    Using select Statments to filter a subform

    ok, i understant what you are saying. could you tell me how to reference the option buttons to the table. there are 7 locations that i would like users to be able to select from. John
  3. S

    Using select Statments to filter a subform

    Thats great, thanks. my problem is with writing the code or SQL behind the option group and calendar. any suggestions?
  4. S

    Using select Statments to filter a subform

    Can some one please help me out. I have a database for customers to reserve certain locations. before they can reserve a location they have to check if it is available for the day requested. Im using a query right now for the customers to use, but they complain its to complicated. what i would...
  5. S

    display a query from optin box and activeX Calendar

    Please Help If Some One Could Just Point Me In The Right Direction That Would Be Great.
  6. S

    display a query from optin box and activeX Calendar

    Could some one give me some help with this. i am trying to let customers be able to check if a location is availible to reserve on any date. i would like to use a option box for the locations and a activeX calendar to select the date, a subform would also be on the form which would display the...
  7. S

    Prevent Duplicate Names

    Im not very good writing vb code, i know this isnt very difficult but i cant figure it out. I want to be able to stop customers from entering in thier name if it already exist in the database. i know it would be a comparefunction but not sure how to do this. please help.
  8. S

    Prevent Duplicate Names

    Can you help me with vb code so that if a customers name already exist in the customer table, they would recieve a message not to enter thier name and to move on to the next screen. :confused:
  9. S

    Insert 2 Feilds into another form

    I have a user form and another form were they type in reservations. is it possible toi link these 2 forms together with out puting the user info on the same form. i would like to be able to use a Querie to display individual reservations with the user's name and info. please help
  10. S

    Print Only The Current Record To A Report

    Thanks for the help. I'm still getting errors, "End of statement expected" and the ResourceTypeID is still creating errors. The resourcetypeID stores locations, so i know this works. please help. :confused:
  11. S

    Print Only The Current Record To A Report

    I'm trying to print out only the current record from my form to a report but each time i recieve an error and dont understant why. this is the code that i have: Dim strDocName As String Dim strWhere As String strDocName = "Resources" 'open report strWhere = "[ResourceID & ResourceTypeID...
Back
Top Bottom