Search results for query: *

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

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

Hi, Suddenly, I am getting an illegal operation error whenever I try to open a specifica table that I have in my database. All old queries, forms, and reports associated with this table work fine, but any new things that I have tried to create also give me the same error when I try to run them...

I have several parameter queries that I have put into a macro. They are all date parameters, and I don't want to type the same date several times. Is there a way to just enter one date to satisfy all of the parameters? Thanks!

Is there any way that I can query two tables at the same time without having a relationship between the two tables? There is absolutely no way to make a common field that is unique, but I'd like the report to show info from 2 tables at the same time. Thanks! Christa

Hi, I'm not quite sure if the iif function is even the appropriate function to be using here, so please let me explain. I have a parameter query set so that you type in a report date, and the query will show all production for that particular date. However, it make take an operator 2 days to...