Search results

Is it possible to include a bound OLE object in Access in a mail merge using a Word document? If so, can someone tell me the procedure? When I include the OLE object as a merge field, and complete the merge, only a code shows, not the document it is linked to.

I apologize, I didn't realize the other links were posted, as the clocking process seemed to freeze up.

Thank you, that was very helpful, and solved the problem.

I would like to set a column in my spread sheet to change color 30 days prior to the date in the cell. I used the formula =value(A1)<= Today() + 30. It seemed to work for one cell, but I couldn't get it to work for the rest of the cells in the column. The procedure that I used was to highlight...

I have an excel sheet in which I wish to use conditional formatting . I would like to change a cell red 30 days prior to the date entered in the cell. I would like to use conditional formatting for all the cells in the column. Can someone give me the correct formula?

I have an excel sheet in which I wish to use conditional formatting . I would like to change a cell red 30 days prior to the date entered in the cell. I would like to use conditional formatting for all the cells in the column. Can someone give me the correct formula?

Thanks Scott, I appreciate your help. Ron

Thank you but my machine will not let me open the file. Is the process of disabling the X a complicated one?

I recently created a database and installed buttons to properly close the database to avoid coruption of files etc. However I could not find a way to eliminate the X button in the upper right corner of access. Today my dbase crashed, I presume because someone did not use the buttons I installed...

Thank you, it worked.

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift...

Thank you, that is kind of what I thought.

Hello, I have a new database with two tables, one of which is a linked table. I want to link the two using a one to many relationship from one table to the other. I have a primary key field in the main table which is an autonumber, and a foriegn key field in the second table which is a number...

Thank you very much. I'll try that.

Do I have to make the changes manually, one at a time, or is there a way for the application to make the changes in mass? Thanks

Hello, I am in the process of converting data from an excel sheet into Access 2000. I know the import procedure, however some of the fields in the Excel sheet have multiple data. Is there a way to sort out this problem, short of cutting and pasting or re-entering the data? For example one...

Thank you. Some things are so simple, but you don't see them. Ron

Hello, I have a delete query in my database which I would like to run from a command button on a switchboard. When I use the command button wizard, it does not show delete queries in the menu of available queries. If I create a command button manually I will need VBA code for the event...

Thank you, I appreciate your help. rbrule

Thanks, I'll try them both and see which works better in this application.