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!

  • Congratulations Mike Lewis 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. Keberhard

    Operation Invalid Without Current Index...HELP!

    Right. When I try to import from the back end I get the same error. The only thing we've found to be somewhat successful is when we run make table queries. We then delete the links and essentially have a new back end. However since this database is so big we are having a hard time getting...
  2. Keberhard

    Operation Invalid Without Current Index...HELP!

    I read the previous post that dealt with this issue, however I didn't understand the reply. Basically what happens is this...I open the back end of our database and none of the table show up in the database window. When I click on the tab to display other objects in the window I get the...
  3. Keberhard

    Operation Invalid Without a current Index?

    I'm getting this same error and I'm afraid that I don't quite understand the reply. Can anyone help me? Thanks!
  4. Keberhard

    Can I change the Icon of my Access Database?

    Remember though, if you install the database on another computer and the icon you have chosen does not reside on that computer it will not show up.
  5. Keberhard

    Subform is not showing up...

    We have a database demo that can be downloaded from our company's website. We have a runtime version, a version for Access2000 and a version for Access2002. We suggest that customers who do not have any version of Access installed on their computer download the runtime and then the demo...
  6. Keberhard

    Remote access for Access DB?

    hmmm...this is something that i've been looking into as well...i'm trying to learn data access pages or asp so that i can put a few databases online. i'm not having much luck with the learning process. the only thing i can think to tell you now (and i don't have much experience with this) is...
  7. Keberhard

    ASP vs Data Access Pages

    I am just getting started with the onine database stuff. I am wondering when it is appropriate to use ASP and when it is appropriate to use Data Access Pages. Is there anyone with some examples. Thanks!
  8. Keberhard

    Remote access for Access DB?

    I don't know if this is what you are looking for, but could you use the database splitter and put the back end on the server and the front ends on each user's computer?
  9. Keberhard

    Possible to use more than one table in a form?

    if they tables are related you can create a query containing the tables, join them, and add the field that you want to use in the form. then base the form on the query that you created.
  10. Keberhard

    HELP! Data Access Pages

    We have an access database that is connected to our SQL Server. I would like to put this database online via Data Access Pages. I have created a page that is exactly the same as a form (look and data source) that we use in the database but I cannot get the data to update. My main questions...
  11. Keberhard

    Beginner Needs HELP!

    We are learning to use SQL Server. We know that Access and SQL can be used together but we are getting a write error. Is there any other way of designing a user interface that is more efficient that Access or is there a way to use Access that will not result in the write error?
  12. Keberhard

    Creating a table based on user defined fields?

    I need to know if there is a way to let the user decide which fields they want to show up on a form. For example: When entering inventory each user probably has different information needs and may wish to specify which fields they need and also which order they should appear in. They may or...
  13. Keberhard

    HELP! References

    I have created a database using certain references. I use: Visual Basic For Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Visual Basic For Applications for Extensibility 5.3 Microsoft ActiveX Data Objects 2.5 Library When another user runs...
  14. Keberhard

    Record Count

    I am needing to display the current record number and the number of records on a form. Ex: Purchase 1 of 5. I know that setting a text box =[CurrentRecord] works to get the current record but how do I get the total number of records. I've tried * =[RecordCount] *creating a query that gets the...
  15. Keberhard

    "F7"

    Thank you. I actually figured that out just after I posted the thread. I thought it was very strange that the combination of keys worked the way I needed it to but is intended for Spell Check. I found a better, more reliable way to accomplish the task. Thank you.
  16. Keberhard

    "F7"

    I am wondering if anyone knows what F7 does in Access 2000. I needed to write a record to a table and make sure that the current record kept the focus. F9 works to write the record to the table but it sets the focus back to the first record making it impossible to run the next portion of code...
  17. Keberhard

    mdb vs mde

    That's kind of what we thought I just wanted to make sure. Are there any other ways to protect the source code without having to create the mde file? Creating the mde file seemed to be the answer to all of our questions until we realized that we would need two different versions.
  18. Keberhard

    mdb vs mde

    I have done that and it works just fine. However, we are trying to find a way to create an mde file that will run on both 2000 and 2002. If the 2000 and 2002 mdb files work on my system why won't both mde files work?
  19. Keberhard

    mdb vs mde

    My question has to do with mdb files vs. mde files. I have created a database in Access 2000. I then created the mde file to protect my source code. While developing this database my computer was upgraded to Windows XP and Office 2002. I can still run the 2000 mdb file however, when I try to...

Part and Inventory Search

Back
Top