Search results

  1. Z

    Show last weeks fields

    I want to show only the records that have the date from the last 7 days. the code that i thought i needed was >=DateAdd("ww",-1,Date()) However when I put this into the criteria for the query it also shows future dates. Basically i want it to only show sales from the last 7 days (their is...
  2. Z

    Validation to not accept numerical characters

    Hi, Basically i need to know what the validation code would look like to only allow alpha characters ( a-z and A - Z), I have absolutely no knowlege of VB and that is all that i can find when searching, Thanks Zac
  3. Z

    Submit Button

    I need to create a button that will run several query's and macros simultainiously. Thanks Zac
  4. Z

    Combine Buttons into less??

    Hi guys, From my form i need the following steps to happen New Record Previous Record Run Query (currently doing using macro) Run Another Query (query command button) Run Another Query (Query command button) Close Form Close Query Delete Record (currently using macro) Attached is a picture...
  5. Z

    Query based on forms data? How

    I want my users to select criteria in a form . I need a query to then search through a table and display the available results in a drop down box. I have looked at cascading combo boxes but i just can't seem to understand them. I appreciate your time and any help that you can offer
  6. Z

    Using form to display result in a drop down box

    Hi, How would i be able to search for XX using a form and then display the results in a drop down box on another form?
  7. Z

    Help needed urgently

    Hey guys, I have a database exam at the end of the week and just read the scenario and im dreading it!! The exam is based on a booking system for a train company. The train company is doing a 2 day promotional event where 6 trains will run (3 per day) I will break the scenario to usefull...
Top Bottom