Recent content by christak

I am using SendObject to send a report made in MS Access. I am sending it as an Excel spreadsheet. Everything works fine, but how can I format the spreadsheet? I would like to put gridlines around the text in excel. I'm hoping someone can help me... Keep in mind, I DO NOT know code. I do...

I have a very old FoxPro database that I did not design that is in full use where I work. We are using MS access as our front end for this database. Is there a way to have MS Access keep the FoxPro version's Index up-to-date?

I'm learning! Please bear with me if you can. Here's the most pathetic question of all... What should I put in place of the Me in the code?

Thanks so much for the fast reply. I usually work through the properties box of the field, and the "On Exit" property requires a macro. How do I turn that code into a macro? The table's name is "Expedte", if that helps at all.

I'm sure that there is a very simple answer for this, but I can't come up with it. I have zero programming experience and teach myself as I go along. Anyway, I have a field called CO1. When a user enters the value for CO1 on the form, I want a field called Currentdate1 to automatically fill...

We have a couple of users in our network that are suddenly having problems with opening Excel files. When they double click on the file, Excel will open to show the toobars at the top and the blue border. However, where the spreadsheet itself should be, you just see the underlying desktop...

We are having the same problem with 2 computers in our network. Excel will open, but existing files do not. Where the spreadsheet should visibly appear, you just see the underlying desktop wallpaper. We can see all of the toolbars, but nothing below them. What causes this? Help, it is...

Sorry again. The user's PC is Windows XP. The server is also XP. Is that the answer that you're looking for? No, it does not matter which spreadsheet is opened first. No matter what, she can only open one spreadsheet at a time. When she tries to open a 2nd spreadsheet, she gets an error...

Sorry about that! I'm never specific enough. (I should not have MIS behind my name, it should really be technical user.) 1) Network - yes, domain - no 2) Windows 3) XP

We have a user that wil enter the password for a shared folder. She clicks to remember the password. Once she enters the folder, she can access only one worksheet. If she closes the worksheet (but not the folder), and tries to open another worksheet, it will tell her that she does not have...

Hi, Is there any possible way to limit character length in query results? I do not have rights to change the table structure, so I'm trying to get around that. Thanks! ChristaK

Thanks so much! It took a little bit, but I finally figured it out!

Duane, Could you explain that a little more in depth? I am having the same problem and I don't know how to go about your solution. Thanks, ChristaK

I am trying to create a report that runs for a date prompted by a parameter, which works fine. Problem is, I have the report grouped by part size, and some managers would like to see all part sizes, even if there was not activity for the prompt date. Can anyone help me??

This was very helpful! I've been trying to figure out how to do this forever! Now I have another question...How do I get this date to show on my report header? Thanks!