Recent content by tanski811

Are you able to use a "mail merge wizard" under "tools"

Thank You It works fine!

Where and how do I write in this code that is a command button to open up a form to set the Echo off. I know how to do it in a marco but not how to write it in VB code. Below is the VB code for my "open form" button... Private Sub LookUpOpenFormButton_Click() On Error GoTo...

if no one responds... attach a copy of your dbase and I'll adjust your print button to select the specified record you want to print.

Printing Report On my form I attached the macro to a command button named Print Report. But basically the macro should reference the report you want to print. [ID]=[Forms]![frm: Respondents]![ID] the ID (identifier from the report) = the [form]! (name of form you place the macro on) [frm...

Creating Macro to View specific form record This is how I do it

There may be more than one way to do this The way I link an Access Table to an Excel worksheet is to... 1) Open Excel file 2) Under Menu option Data select Import External Data 3) The import external data dialogue box appears 4) click on the properties first 5) On the external data range...

sorry it took so long my pics were to big. After you append the information you can use and "update query" to attach the appropriate primary key instead of appending the primary key.

Matching Fields In the query design for "Append Table" you do not have to match the names to each other. You are able to select which column to append the information. I will send you an example. You can use an ID number as the primary key or you can use the person's name instead.

Report Graphs Can you send sample data in an excel graph that represents how you would like it to look in Access.

Merging Excel In the interest of saving time you should "import" your excel file to Access and then "append" the appropriate fields, in a query, to each of your tables you have predefined in Access. You will still need to identify your primary key you want to use to link your tables together.

what if... you just typed...*work* does access change from "like" to "alike"

Like "*work*"... the sting has to have an astrick before and after the word.

I understand I also use .tiff files to copy my reports to powerpoint as pictures. The only way I found to create a .tiff file is to convert the access report to a .pdf file. Adobe Acrobat has trials you can download from their site for free. Once you create a .pdf in Adobe Acrobat you can save...

Stopping the Mouse Wheel from Scrolling Search the forum for Jet46 "Another Mouse Wheel Option" he has a simple code you can copy and paste into your database that will stop the scrolling. I've used it and highly recommend it.