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 TouchToneTommy 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: pepperca
  • Content: Threads
  • Order by date
  1. pepperca

    Delete file in My Network Places

    I have a file located in a library on our server. It is linked to My Network Places. I can go into explorer and delete the file and it is removed from the server. Does anyone know how to do this programmatically? I have found code to remove the link, but this is not what I want to do. I...
  2. pepperca

    Database locked

    I have a split database in Access 2003. Users were able to use this database yesterday and 1 person used it this morning. Now the frontend will not allow them to get to any data. I checked the Backend and when I tried to open it I got the message Could not use databasename.mdb file already in...
  3. pepperca

    Data corruption

    I have a database in 2003 that has a front end on the individuals pc and the back end on a server. I have one user that has had the same problem a couple of times. When editing data the record she is working on looses her data and fields display ## or error or numbers that don't make since for...
  4. pepperca

    Slow on Server

    I have an Access database that is loaded on a pc but links a couple of tables from a server. Most of the processing does not use these linked tables. When I run this program from home with no links in runs in about 1 hour. With links to server it takes 4 to 6 hours. My machine at home is...
  5. pepperca

    Importing Spreadsheet

    I have the following piece of code attached to a button on a form. It works great if you only have one sheet in an excel workbook to import. However, the particular workbook I am trying to import from has 2 sheets and I need to import both of them. The sheet names will change from time to...
  6. pepperca

    Pass data to Mapquest

    I have a form with a customers address. I would like to pass this information to Mapquest. Is there a way to do this? Any help is appreciated. Thanks, Cindy
  7. pepperca

    Losing records

    I have a client who uses a program in Access XP at multiple sites. Occasionally, they say they are losing records. They enter an order one day and the next it is gone. They say they are not deleting the order. Does anyone have any ideas why this would occur? I appreciate any help. Cindy
  8. pepperca

    Pass data from form to internet

    I have an Order Delivery AccessXP database. When someone calls in for an order there is a delivery fee if they are more than 10 miles away. What I want to do is pass the customer address entered in the form along with our business address to something like MapQuest to get directions and...
  9. pepperca

    Unrecognized database format

    Does anyone know how to retrieve the data from a database when you get the following error when you try to open it? Unrecognized database format <path of database>. I would appreciate any help. Cindy
  10. pepperca

    Maximum Records before system slows down?

    I have a database with about 12 users. About how many records can you have before you start to see a noticable difference in the speed the database runs. I have about 6 tables, 3 of them are linked, they contain the most data. One is Customers, the other two are Orders and MaterialOrderd...
  11. pepperca

    Running multiple versions of Access on one machine

    I need to have 3 versions of Access on my machine, 97, 2000, and XP. I am currently running 97 and 2000. I have a new client who has XP. Are there any problems with loading Office XP on this machine as well? And is there a particular way this needs to be loaded, like when you load 97 and...
  12. pepperca

    database needs to be repaired or isn't a database file

    This is for an Access 2000 database. It is a new database and on a network and just has a few records. They got an error that the database needs to be repaired or isn't a database file. I have written another database in 2000 that has also had this error several times. To my knowledge the...
  13. pepperca

    Database isn't a database file error

    This is for an Access 2000 database. It is on a network with about 5 users. They enter any where from 2 to 20 orders a day. This database is also a replica, with 2 people from laptops syncronizing. Also they have a remote office that uses netmeeting to use this program. The data is stored...
  14. pepperca

    email with Lotusnotes

    Is there anyway when sending email with lotus notes to view the mail before it is actually sent, and allow user to add more addresses or text in the body if they like? Similar to using the True option in the sendobject command. Thanks for help. Cindy
  15. pepperca

    sending email using Lotus Notes

    I'm setting up a database for a client who uses Lotus Notes. I want to use the sendobject command to send email through program. I have been told this is not easy. I am using Access 2000, I'm not sure what version of Lotus Notes. Does Lotus Notes need to be open when command is run? Can you...
  16. pepperca

    problem sending report to word

    I am using Access 97 and I have Word 2000. Now the problem, my report has a subreport at the bottom. The field above the subreport is a memo field with can grow option selected. When this field ends up at the bottom of a page, a portion of it prints, then on the next page the subreport prints...
  17. pepperca

    Problems with chart

    I have a chart in Access 97, all the data looks fine but on x-axis it only displays everyother label. It plots every piece of information, it just doesn't label it. I would appreciate any help. Cindy
  18. pepperca

    Select query showing duplicate records

    I am doing some work on an Access 2000 database. I have 3 tables which are linked by a field called orderid. I need data from all 3 tables. The results of the query list each record twice. I have tried the query propertied Unique Values and Unique Records but it still displays the same record...
  19. pepperca

    can't use wizards

    I am using Access 2000. When I try to create a form, report, or anything using a wizard I get the following message. This feature isn't installed. To install this feature, rerun the Microsoft Access of Microsoft Office setup program or, if you're using a third party add-in, reinstall the...
  20. pepperca

    Error when trying to print from form

    I'm using Access 97. On a few reports that are executed from a command button on a form I am receiving the following error: The instruction at &quot;0x77fca927&quot; referenced memory at &quot;0xfffffff8&quot;. The memory could not be &quot;read&quot;. Click on OK to termimate the program...

Part and Inventory Search

Back
Top