Search results

  1. P

    Exit From with required fields

    I'm reading through some of the old posts and it's starting to make little more since. These poeple seem like they're starting off about the same as me. I'll give it try again in the morning and see if I can get it...
  2. P

    Exit From with required fields

    Sorry for the newb questions. I usaully just create reports based on data that someone else entered already. On my form it seems the record is created as soon as I type something in any box, and at the same time it seems the primary key is created. My thought process tells me the only way to...
  3. P

    Exit From with required fields

    I have a failry simple data entry form that autonumbers the primarykey, and has a field for a name, date, and some text. All the fields are required. The form works fine if everything is entered as required. My problem happens when I try to exit the form when all the required fields are not...
  4. P

    Sharing Access

    Thanks for the replies again. That should solve my problem.
  5. P

    Sharing Access

    Thanks for the reply. Would the 2007 runtime work with the front end that i've created with 2003? I did type in back end in the first post. My mistake.
  6. P

    Sharing Access

    What I'm wanting to share are all the form and reports. We're are actually using a ODBC to link Access to SQL.
  7. P

    Sharing Access

    Is there a way to share the back end of an Access 2003 database with users that don't have Access? I've split my db into front and backend and it works fine if the user has Access 2003. This there another way to split that wouldn't require me to buy Access for everyone else. The database is...
  8. P

    Adding iif or maybe a lookup table to db

    1. I'll look up and see what the problem were people ran into on SSNs and then look into what I can do to switch the primary key. The reason I choose the SSN as the primary keys was to make sure there would not be people entered twice. 2. I did run into a few concerns with that myself. 3. I...
  9. P

    Adding iif or maybe a lookup table to db

    The cost will probaly change twice a year. Yes I would like to keep a history of it. What I do now is work with a summary of premium costs, or the plan costs. It is a pain to gather historic data and chart it so I haven't hold much with in other than on pen and paper once a year. I havn't...
  10. P

    Adding iif to query or table

    I think i see what you were doing with the subs. I'll see if I can recreate it tonight and post the outcome. Thank you very much.
  11. P

    Adding iif to query or table

    I attached a DB minus unrelated form, queries etc.. Thanks for taking a look.
  12. P

    Adding iif or maybe a lookup table to db

    Hello folks first post here. I tried reading through the boards to find someone with a similiar question, but not luck yet. I have been working with a basics of Access for about a year. I did take take a bit of programming in college but I don't remember much of it, so I looking for a little...
  13. P

    Adding iif to query or table

    Hello folks first post here. I tried reading through the boards to find someone with a similiar question, but not luck yet. I have been working with a basics of Access for about a year. I did take take a bit of programming in college but I don't remember much of it, so I looking for a little...
Back
Top Bottom