Post reply

Is this possible?

  • May 5, 2006 at 7:59 am

    #68796

    Can i have an input screen where the form returns information based on what is inputted or can the user only search through the recordset using the arrow buttons?

    I would actually like to restrict them from looking through the recordset and force them to only be able to query the information they need.

    For example, I would like for users to input the last for digits of their SSN, and maybe a name, and it outputs the SickTime, VacationTime, and PersonalTime that person has accummulated.

    Is this possible?

    Thanks!

  • May 5, 2006 at 8:31 am

    #636261

    This is absolutely possible. The actual mechanics for doing it depend on your set-up.

    If you're using a .mdb file with linked tables, create a query with the various search fields as parameters. Be sure to make allowances for null values, if you have more than one parameter allowed.

    Otherwise, create a parameterized stored procedure in SQL Server. Once the user has entered in their search criteria, they click a button. You pass the contents of the search fields to the parameters, then set the recordsource to the output of the stored procedure.

    You can also create a solution in which you use the ADO Find function to move around in the recordset. But, as that means initially loading the entire recordset, instead of just the record you want, that's generally significantly less efficient.

  • May 5, 2006 at 9:31 am

    #636290

    Thanks! This is a small project. I wasn't really planning to use SQL Server on this one. Just Access.

    What do you think?

    Thanks!

  • May 5, 2006 at 9:38 am

    #636296

    Oh. In that case, use the first suggestion. Create a field on your form for the user to enter the search criteria. Set the recordsource of the form to a query, that includes a reference to that field in its WHERE clause. Either add a button to the form to refresh the recordsource after the criteria has been entered, or just add that as an AfterUpdate event to the textbox.

  • May 5, 2006 at 10:29 am

    #636320

    I've ordered an Access book. MS Access Inside Out, but I don't know how long it will take Purchasing to get them for me.  Do you have any clue where i can read more on this. I know absolutely nothing about Access forms.

    Thanks!

  • May 9, 2006 at 12:49 pm

    #636849

    Try this one:

    http://www.functionx.com/access/index.htm

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply