Recent content by JimTheProgrammer

I tried it step by step... And it worked. The problem was on one machine I had been using Office2K where it worked fine but my laptop is running Office97. Works in 2K not 97. Thanks for the memory jog. Jim

Is there a way to copy a table from Word (2k) and past it into Excel looking just as it did in Word?

I'm after a automatic solution. I can highlite the record (after putting any character in the key field) and delete the record. The point is I don't want the user to have to do anything. If they enter a null, I want to exit the the input area with out further operator intervention.

I have a datasheet subform on my main form that gets this nasty message if you enter data into a field, delete it (or backspace it out) and then try to click on the main form. I know the causes and I think I know how to trap it, but I don't know how to tell it to give up altogether and let me...

Thanks for the help. Actually I found the best answer to be a subform. It being a datasheet from of a table. The user can then fill in the table from my form and use it in subsequent queries.

I know I'm overlooking something simple, but what contol do I use so the user can input a list of values? Namely, to input a list of employee numbers on a form for use in a query. I know how to use text boxes, and list boxes (to choose from a predefined set of data) but not an empty list box.

If I look at MWD what am I looking for. I see the tables and queries but they, by themselves are Greek (no offense to anyone) to me. This is not a database that needs security so I am avoiding it if possible. The net of it all is that I still can't run my query and I still get the message.

HELP! I'm getting the following error when trying to run a query. "the database has been placed in a state by user "Admin" on machine "ABC" that prevents it from being opened or locked". I've rebooted all the machines (Win98 peer-to-peer) and read the MS KB...

Sorry. Now that I re-read it I've left out a lot. There are 2 tables - IMF and SDIP-35. IMF has a part number with leading zeros to fill it to 15 positions. The problem is SDIP-35's Short # field has no leading zeros so you can't do a join on them. I've tried many ways to strip the zeros...

This query fails NOT MATTER WHAT I put in the "Where" clause. ITEM_NO and Short # are both 15 position text fields. This gives me a "data type mismatch in criteria expression" error. If I put a "is null" I get the same thing. I have tried >0. Same thing. SELECT...

I have succesfully made a report that contains a pie chart (one page per customer showing percent sales). The ONLY problem is on some charts the data labels for the pie slice overlaps other data lables and you can't read them. I've tried EVERYTING I can think of but some still overlap. HELP :-)