Search results

What would be the purpose of using Crystal Reports within Access. The report structure within Access is strong. Crystal Reports is used as an add-on to programs that require a separate report writer, such as financial, visual basic, etc. (People use to use Caret Reports, which I found to be...

The easiest way is to make a Delete Query and have the query run on a Command Button or else on the After Update of the code for the transfer of the original information. Make a back-up before you do this to make sure that it is working the way you want it too. I would also put a warning on...

If you cannot see it within your reference window then do a browse and add them. Microsoft Word Office Library should be located within C:\Program Files\Microsoft Office\Office\MSWord9.OLB and Microsoft Office Library should be located within C:\Program Files\Microsoft Office\Office\MS09.DLL I...

Make sure that the following references are checked within your database: Microsoft Word Microsoft Office OLE Automation also, type the =MergeToWord() beside the On Click, it is not an Event Procedure. This is how you would call a function. Hope this helps you.

Copy and paste the function in a new module. You can call it whatever you like, but probably ModMergetoWord. On your command button on the form, on the On Click, place the following: =MergeToWord() This should get you started. Don't forget to recompile. [This message has been edited by...

Make your changes while in design view and save while in the same view. Also go into the main Tools menu bar and select Options. From there select the General Tab. Make sure that you uncheck the Perform Name Auto Correct option.

It seems to me that if you open up your report in design view and select page setup, and then the Page tab, there is an area where you can select a specific printer to always send the report to. I have used this to automatically have a customers shipping request report sent to the shipping...

Here is code that I used. You can change the names to correspond to your fields and tables. Make sure that you have a form letter already made up in word using a .dot template when using this function. In your form, make a command button that when clicked would reference this function...

In your criteria line for your query, include the "Yes" (without the quotes) in the fields that contain the checkboxes. When your report is run, it will only include the records that return the checkboxes checked.

Your best bet is to use Snapshot Viewer, as it will give you an exact copy of the report ready for e-mailing. The only drawback is that the receiver must have this installed on their end to read. It is on the Windows Installation CD and I think that you can down-load it. If you require it, I...

You don't want to insert this information if it is already contained within a table in your database. If you do, then you would have duplicate records. Bring the information together with a query, using a join on EmployeeID.

First make sure that the fax field is set up within your underlying table. Next look at the properties for one of the other fields in the form. You might be able to copy one of the existing fields, changing the name and then just changing over the underlying source for the field to capture...

If these option buttons were added after you had made the form, then it could be that it is not being picked up. I would suggest that when copying an option button to make an additional one, that you paste it onto the Option Group border, then you can move it to where you want to within your...

You could try the following: Private Sub CPRDate_AfterUpdate() On Error Resume Next If Me.CPRDate < "Date" Then Tab2.Visible = True ElseIf Me.CPRDate > "Date" Then Tab2.Visible = False Exit Sub End If End Sub

I tried your 1st code on a print button and it worked correctly giving me the correct report and reporting dates. Could it be that you are not asking for the field names of your unbound text boxes correctly. I am assuming that you have 3 unbound text boxes on your dialog form: 1 - WDate...

I agree with Chris. If you want to control the database, and have it secured, thereby, avoiding a multitude of problems with users making all there own reports down the road, then you must establish a set of rules and/or criteria. Set up a standard set of labels covering the basic needs. A...

I have many smaller pop-up forms placed within my forms at an exact position. To do this set the following properties: Auto Center - No Auto Resize - No PopUp - Yes Border Style - Sizeable Now open up your form and activate your pop-up. Set your pop-up exactly where you want it on the screen...

Dawn: You should get numbers as the result. These numbers represent the day of the week. In your report, your labels can be labelled the actual day. I have tried the query and my results are working out. Without going over the whole practice again, would you mind sending me a small database...

Dawn: In your value field, put in the "Where" clause. In another blank column, include the same field, put in Group By - Row Heading. This will solve your first problem. The next problem is making your date to turn out the weekdays instead of a full date. In another blank column you are...

You need to set up 2 Crosstab queries to make this work and then use both results in a Select Query to get the format you want. In both of your Crosstab queries, set up the Date field as the Column Heading. Make sure that in the properties for the query, you specify the Column Heading Names...