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!

Register Log in
  • Congratulations derfloh 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: *

  1. erictheman

    how do you make a database read only

    what we want to do is make our database read only to some user and make other users have full control over the database. How would this be done? Thank You for your time
  2. erictheman

    Making a template for a report ?

    How do you make a template for a report. ex we have more than one report but want them all to have the same style and formatting.What we want to do is make our own modified template that can be used for all the reports. The reason we want this is because all our tables have the same fields but...
  3. erictheman

    Keeping default value for a list box

    Yes. I made it using the list box wizard and had two values. It's being store in a table as well.
  4. erictheman

    Keeping default value for a list box

    I need some help. I have a list box field with two values in it. "Active" and "Deleted". I use code for the form on current property. [Jobstatus] = "Active" It works fine. Every record I go to it shows Active. But the problem is that if I choose Deleted on a record...
  5. erictheman

    Keeping a list box default value

    I need some help. I have a list box field with two values in it. "Active" and "Deleted". I use code for the form on current property. [Jobstatus] = "Active" It works fine. Every record I go to it shows Active. But the problem is that if I choose Deleted on a record...
  6. erictheman

    How do we clear out a field?

    Yes it works! Thank you for your help CajunCenturion! :)
  7. erictheman

    How do we clear out a field?

    Hello, what's the code to clear out field(s) in Access? (Take note I'm using Access 97) What I mean is that say if you had 4 fields. Employee name, Address, Phone, and Position. You want to keep the employee name, address, phone and clear out position field when you click a button. Exp. Clear...
  8. erictheman

    Transfer Data and then store it

    Hi, I'm using DAO. So some of the ADO codes that you gave me bring back sytax errors. Is there a difference? Take note I'm using Access 97. But I did manage to use my update button and transfer the data. As soon as I click it the fields go into the history table. Here's the code I used. Dim...
  9. erictheman

    Transfer Data and then store it

    How do call a sql to open a empty recordset? What's the code and were do you do it? In the history button? Thank you.
  10. erictheman

    Transfer Data and then store it

    Sorry. The question is how do you do this? That you take those fields and store it to other table. And clear them out from that record. Do you do this throught VBA?
  11. erictheman

    Transfer Data and then store it

    Hello, I just have a question. Say if you had 6 fields. Exp. SSN, ID, CCP on the top of the form and name, address, notes, gender on the botttom. And we make a history button that as soon as we click it, it will clear out those fields (name, address, notes, gender) and it will take that same...
  12. erictheman

    help on add new record button

    I have a couple of fields that i want to stay the same once i press the add new record button so i can see it on each record. I dont want to press ctrl+; or enter it in manually how would i do this?

Part and Inventory Search

Back
Top