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 SkipVought 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: PPSAG
  • Order by date
  1. PPSAG

    Laptop doesn't see server

    No IP address, IPX. The printer is not ndps. I just found that out. Mooo... :-)
  2. PPSAG

    Laptop doesn't see server

    Thanks for the responses. The OS on the laptop is XP. I moved the laptop down two floors and plugged my own network cable into it. Still doesn't see the server. It sees other servers, just not that one. He does get the Novell login box. I don't know if it is a queue or ndps printer. How...
  3. PPSAG

    Laptop doesn't see server

    I am not a network person. But my boss fired the one we had, so I'm stuck with this problem... I have a user who up until this morning printed regularly to a network printer across the hall from his office. When he logged in this morning his computer didn't even see the server that the printer...
  4. PPSAG

    Changing table design properties with a module

    My code is exactly like yours, except of course with the correct field names. I did mis-spell 'column' the first time, but I corrected that and still get no change in my field. Since I work for a state government agency, we're behind in our technology. I am using 97, and thought maybe that was...
  5. PPSAG

    Changing table design properties with a module

    Thanks for the response. It isn't working though. I'm not getting any errors, but the field size isn't changing either. Am I missing something else? Mooo... :-)
  6. PPSAG

    Changing table design properties with a module

    I have a database with a field in 4 different tables that needs to be altered when data is imported. The field is text - 5 and needs to be 8. We can't just redesign the table, it has to occur when new data is loaded, the data comes in with a five character field and we add three characters...
  7. PPSAG

    Can I calculate in an Access2000 report?

    Found the syntax error, I missed a [ . Works great now. Your the best. I love this forum. Always nice to learn new things that make my job easier. Mooo... :-)
  8. PPSAG

    Can I calculate in an Access2000 report?

    Thats great, I have never reformatted a field like that. Of course now I'm getting a syntax error. Nothing can be easy this week. I've put it in my system just like you posted it. And I see nothing wrong with it. So I'm waiting for new eyes to look at it for me. I appreciate your help and...
  9. PPSAG

    How can I tell if the database that I did not create

    This sounds a lot like the situation I had when I started my job. The previous person never threw anything out. She had five or six copies of each database. Each with a slightly different name, but only one was being used. I found the one being used and/or the one with the most current date...
  10. PPSAG

    How can I tell if the database that I did not create

    I have found that compacting my databases is generally a good maintence habit. Your autonumber will not be affected by a compact. Is this a database that resides on a network server? Or is it resident on a PC? If it is the latter, then this is what I would do...do a search for the database...
  11. PPSAG

    Can I calculate in an Access2000 report?

    OK. Each record in the table has 6 fields. One of the fields is 'Swipetime'. This records the time a person swipes a card through a reader. The first time the card is swiped the system marks a yes/no field for 'Checked in'. the second time the card is swiped it unmarks the 'cheked in'...
  12. PPSAG

    Can I calculate in an Access2000 report?

    The time field? It looks like this: 10:15:48 AM Mooo... :-)
  13. PPSAG

    Can I calculate in an Access2000 report?

    I'm smacking myself in the head. I pulled the properties of the table and for the first time noticed that the time field is formatted as text. No wonder I can't do calculations. I cannot redesign the tables. Any ideas on how I could work around this? Mooo... :-)
  14. PPSAG

    Strange Errors - should I use compact and repair?

    Damn ASP! :-) Hope it doesn't happen again. Good luck. Mooo... :-)
  15. PPSAG

    Can I calculate in an Access2000 report?

    This isn't working. I have only one time field. For each set of records, there are two, an in and out, I need to calculate the total time. The original design and function of this database doesn't allow for a second field to hold the Checkout time. Does this mean that I cannot do the...
  16. PPSAG

    Strange Errors - should I use compact and repair?

    Compact and repair can be a good thing. But before you do that, are you sure this isn't a case of 'operator error'? The 4 and 5 are directly above the 1 and 2 on the ten-key number pad. I have pulled my hair out trying to figure out a problem with one of my programs only to discover that the...
  17. PPSAG

    Access97 Answers!

    This book and some by the same publisher on different topics have been very helpful to me. I have other programmers asking me questions often, and with this book I can simply hand them the book or help them look it up. It has made for much more independent and confident developers who are VERY...
  18. PPSAG

    Can I calculate in an Access2000 report?

    I have a report that currently shows the times a person checked in and then out of a class. My user wants a calculation showing the total time in class. I've looked for a way and can't seem to find one. Mooo... :-)
  19. PPSAG

    Access closing itself

    formating really wasn't an option on this particular system. I have corrected the problem though. I wish I knew what happened. I fixed it by running an uninstall/repair from the control panel. I did this twice last week with no success. This morning I used a different set of CDs and this...
  20. PPSAG

    Access closing itself

    Thanks for all the responses. Nothing is working. There are no screen savers or fancy pointers installed on that system. The database resides on that system, no network links necessary. I've done a virus scan with no virus found. I'm really not sure what to try next. Mooo... :-)

Part and Inventory Search

Back
Top