Recent content by PPSAG

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

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...

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...

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...

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... :-)

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...

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... :-)

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...

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...

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...

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'...

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

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... :-)

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

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...