Search results

Hi, My users have a small Excel spreadsheet that they mail out each week. Their own users fill in the unprotected fields and then email it back. This works just fine when the spreadsheet is sent as an attachment. But my users think it would be simpler and cleaner if the spreadsheet were in...

Hello, In my main workbook, Costed_Menus, I've set up a drop down list that references a second workbook, Menu_Items. (Yes, we are talking real, food-type menus here.) This works perfectly if both workbooks are open. What I want to do now is to set it up so that when my user opens...

Hi, I am pretty rusty at Excel, but I have been trying to create a menu application (real breakfast, lunch, dinner menus). The basic idea is to let the dietitians enter the date, meal period (breakfast, lunch, dinner) and the meal item on the first sheet in the workbook. There's an...

Hello: Need advice about whether to do something from Access or from Word. What I have is a large number of Word documents that have lots and lots of bookmarks. I need to list all of the bookmarks in each document and eventually compare it to a text file from elsewhere. I have VBA built in...

For a number of nasty reasons, I want to write a query in code, then use that query as the basis for my form. (OK, Ok, I'm trying to create an on-the-fly topvalues query...) I can write the query, no problem, but I can't seem to get the form to redisplay using the newly modified query. If I...

I have a form that displays the results of a Topvalues query. My user would like to be able to choose the number of records displayed. Is there a simple way to do this? I am running against an Access table here, no ODBC. The query and the form are pretty much plain-vanilla. If worst comes to...

I am automating an Access 2000 system and would like to know if there's a way to redirect error messages to a printer (or a file???) Right now I want to have message boxes when I hit an error. But once this is running unattended, I'd like to log the errors (to a file or to print) and shut...

Hello, I have a TopValues query which displays on a form. I'd like to give the user the option to say how many rows should be shown. Is there a quick & dirty way to handle this? I know that I can build the SQL in code to do it, but don't want to go through all of that if I don't need to...

Hello: Here's something that worked just fine in Access 95, but is giving me problems in 2000. I have an Access front end to an Oracle database, in a system that manages mailing lists. The user adds people on a form called "Recipient", then presses a button to bring up a subform so the person...

I never thought that I'd be asking this... I'm using Access 2000 to run an automated, scheduled daily process that emails a report. The VBA code does some file transfers, runs a half a dozen queries, then archives and sends out a very complicated report. The problem is that the email is now...

My Access 2000 system needs to send a weekly e-mail to each user who has open records in the system. Creating an open item report, with page breaks by user, is a piece of cake. But its there any clever way to separate the pages of a report? If I can write them to separate .txt files, that...