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: *

  • Users: iccpm
  • Order by date
  1. iccpm

    FindFirst Method Problems

    I am using the finfirst method as an after update event to set the active record from a query recordset. I am connecting through ODBC to a SQL server, which is a new thing, and suddenly having big problems with this one form. The form also includes a subform, that looks at the related records...
  2. iccpm

    FindFirst Method Bookmark Problems

    I administer an access db that I recently migrated to a SQL server back end, but are still using the access front end. I have a form that is used to apply payments to jobs- the form uses a query which looks at the primary table for the recordset. The form also includes a subform that looks at...
  3. iccpm

    microsoft access 2000 replication and autonumbers

    Petermeachem: How? I look at autonumber field properties, and it will not let me change it to increment from random- Is there another place to set these characteristics? Tks
  4. iccpm

    Sum for aging

    I am trying to set up an aging query, to show me the totals for a currency amount invoiced in a date range as a function of the current date, i.e. less than 30, 30 to sixty..etc. I wrote a query to do a datediff to come up with the age. Problem is, my boss wants all the totals displayed...
  5. iccpm

    How can I set up a combo box to add the values typed to a table if not

    I need to make a combo box lookup values in a table, and also have entering data into the box write that dat to the table, while still saving the values to the table in use on the form. Is this possible? How? Thanks
  6. iccpm

    Locked Out!!!

    I administer an access db that has 8 to 10 people using it at once, and I keep getting a "unable to update, locked by----" message, but I have specified no locks in db options on all the terminals. What have I missed? What causes this lock conflict, and how do I stop it? ICCPM
  7. iccpm

    Writing records to two sources

    I have already split the database into the front end and the data file, but I am glad to hear I can make a third file for backup...Now can I have the front end table write to both the backup and the data files simultaeously, or will I need to append the records periodically?
  8. iccpm

    Writing records to two sources

    Is it possible to write a record from a form to two identical tables in two different files?<br>I would like to do this as a redundancy in case of data loss.
  9. iccpm

    Access Alternatives?

    I don't know that I was trying to make a point.&nbsp;&nbsp;I was asking a question.&nbsp;&nbsp;Is access at the bottom of the database chain?&nbsp;&nbsp;I am asking because i inherited an access database that is crucial to our production at my co. and is somewhat fruity.&nbsp;&nbsp;I am trying...
  10. iccpm

    Access Alternatives?

    What are the best alternatives, to step up to the next level in a database?<br>
  11. iccpm

    HELP WITH BARCODING IN ACCESS - WHO HAS SOME EXPERIANCE?

    I am also interested in doing the same basic thing.. Please let me know how you make out, and how simple/expensive it is<br>thanks<br>nate
  12. iccpm

    Should I abandon MS Access?

    I administer a database used for entering, tracking, and billing freight shipments.&nbsp;&nbsp;It is comprised of two files, one is the data and the other is the forms and reports, etc...<br>&nbsp;&nbsp;The data file is now about seventy megs, and crashes way too often.&nbsp;&nbsp;I need to...
  13. iccpm

    Autonumber using the date

    how about the code to simply look up a number value and add one to it?
  14. iccpm

    microsoft access 2000 replication and autonumbers

    Well, I know it seems odd, but I am in a situation where I inherited a DB that another wrote, and somewhat short-sightedly.<br>The database is for tracking shipments of freight, and the autonumber field is our Pro#, or in-house tracking number.&nbsp;&nbsp;I need then to stay in order for...
  15. iccpm

    microsoft access 2000 replication and autonumbers

    what is the syntax you would use to make a form find the greatest number value in a tsble, then add 1?&nbsp;&nbsp;I need to write this to avoid using an autonumber field, as replication wreaks havoc on my use of auto number(makes random instead of incremental)
  16. iccpm

    edit permissions

    not going to work- i need to continue to update other fields, but to keep the
  17. iccpm

    edit permissions

    I need to set up an access dbase so that it disallows editing of specific records after a yes/no field is updated for the first time. It would be nice to be able to override with a password, but not essential.&nbsp;&nbsp;How do I do this?-- will a macro allow me to change the properties of the...

Part and Inventory Search

Back
Top