Search:

1. I have a series of reports that I want to automaticly email by either macro or visual basic using a command button.
2. I have no problem with this if there is data to send with the...

Background: I am using CACHE to interpet an old flat file database. CACHE puts the data into tables and views for me. I then use the "Enterprise Manager" Import Wizard to define the table and fields...

Several things.

First, you can move to a tab page by setting the value of the tab control to the proper value. I make sure I rename each page to something meaningful. So if for a customer form I...

Is it possible to use a GoToControl to open a page on a tabbed form from an open tabbed form? I have some tests that when a wrong answer is selected a material review is opened. I have been doing...

I know this probably belongs in the Word or Outlook section but I know how versatile the Access gurus are and thought if anyone their mutidiscipline thought process would serve well. I have an old...

When I set up my weekly roll up report the wizard is very good about labeling the week for me. The problem is that the week grouping value is formatted to print "Week 40" for example.
Is there a...

Thanks for the help, I used your procedure and called it from a button on the calendar tab. To get all of the dates whether or not there was an event, I modified my query. I add a table with the next...

I think I am getting myself wrapped around the axle.
Based on using your SubFunction 'Update Calendar', I have the following questions.

1. Do I call the function in the B1 column in the VLOOK...

Thanks Dean,
The "qry" is just static for now but in the final version it will actually be linked to an access data table and will refresh upon opening the spreadsheet. The work sheet will retain...

Here is the concept. 1. The actual data work sheet containing the data table is going to be linked to an access table which will "refresh" when the spreadsheet is opened. 2. The calendar work sheet...

I am by nature an access guy but my boss wants an excel spreadsheet to do the following. (See attached). In the first column of the 2nd work sheet I have a date, then name, rank, position and action...

I have a small work order program. At the end of filling out the Work Order the user has the option to send an alert to the technician who will be working the problem. At first I used the the form as...

I have several apps that use a table with a yes/no field to select multiple criteria. The user opens a form and can check one, several or all of the values available in the table. The next step the...

I to have had my share of problems with using dynamic queries requiring user input and mail merge. My solution has been using a "make table query". The end user sets what criteria is needed on a...

I to have had my problems working with Word mail merge. I especially had problems when I needed to set criteria for queries. The solution that I normally use is a "make table query" and have the mail...

I get so busy at work that when Hans posts me a solution to a design problem I just grab it and run. I rarely take the time to say "Thank You". This goes for all of the other staff members as well. ...

I have an IT Work Order program in Access 2003. I have been asked by the IT staff if there is a way I can add a button to the On Line Work Order Form whereby the user can immediately see and/or can...

I need to calculate an age value but with a twist. I need to have anyone under 2 years to have a value in months with an "M" character attached. For everyone else just a year number is fine. Since I...

Me too.
When this happens I usually just cut the record out of the table and recreate it. At first I thought I had to redo the whole table as you suggest, but I found that if I can delete the record...

The records are entered/edited right into the table from an input form. The input and edit forms are powered by queries limited by date criteria. You are correct in your assumption that it only...

I have several shared access aps running on a LAN server. Occasionally (fortunately not often) a record will shift in a table. It appears that only a portion of the data in first field gets posted...

Looks as if it has SP2 fro the service pack.

Version 5.12600 Service Pack 2 Build 2600

When importing an excel spreadsheet I was not able to select the type of field that I wanted a column to import as. Nor was I able to turn off the wizard to do it manually. I went to the help files...

Thank you, looks as if you nailed it again.