Search results

I have several pie chart reports. They look fine. However, I can't seem to make the values for the sections of the chart to show. Basically a % for each section (part 1 = 25%, part 2 = 50%, etc) or the actual value for each section. Any ideas how to do this as it is vital for statistical...

When you say you have set them as landscape I am assuming you mean during the wizard? The way I change the view of my reports is by selecting the report from the database window (not opening it), then go to file>page setup>page and select your preferences. Click OK and that does it for me. If...

I have a text field on a form. I am using it for the message part of an e-mail. At the moment the user can type a message, but only as one line. They cannot press return/enter and go to the next line - it takes them to the next form object in the tab order. How can I make the text field so they...

Brilliant, thank you - works great.

Is your database set as read only? Come out of the database, rightclick on the database icon and select properties. Make sure read only is unticked and tick archive. Click Apply and OK. Then try again. Scott.

It is not so much a problem as a query. I have a form where the user fills out a couple of fields and clicks a button and an e-mail is sent to a load of recipients. My query is nothing to do with this however. When the user clicks the send button I would like them to be prompted with a message...

I am a little confused. The first and last lines seem simple, but: DoCmd.GoToControl "differentcontrolName" What control goes here? My current code looks like this: Private Sub Command0_Click() On Error Resume Next Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail =...

Anyone know what references need to be turned on? I keep getting "Sub or function not defined" message with 'EnableIfNoNull' highlighted in yellow. I think this is because the reference is not enabled. Anyone help? Subzero,what did you do?

As far as I know you can only specify the text that is in the status bar, you cannot change its formatting properties, such as text type, size and colour. To my knowledge that is ... Scott

I have a form where the user types out an email message and clicks the send button to send it. I want to make it so that when they have clicked the button, it becomes unclickable for a second time. This stops them sending the message by more than one time accidentally. It needs to bedisabled...

I am not a programmer either, so anyone that knows a bit of VBA to change a tab or command button please let us know! I can help with command buttons - without using code. Simple create an image in paint that is about the same size as your command button (doesn't need to be too close) and fill...

I'm no expert but have you tried using a subform using the form wizard? Scott

I know there is no error handling, but in this case I would use a simple macro. Macro's rule! Scott (At work, but very, very bored ....)

Still makes no difference.

There are definitly no controls outside the 1 page area - it is a very small page anyway. I tried the second solution (the cycle property?) but it didn't make any difference. Any more ideas? Cheers Scott

Hi All, Hope everyone had a great easter! I have a form with a simple tab control on it. It has two tabs with a couple of fields in each tab. When the form is opened the first tab is the active one. When I click the other tab, the page moves upwards, so the top of the tab is at the bottom of...

Hi, I have created a simple Pie Chart based on one field of a table, using the wizard. It is fine, except that the first value on the legend says Slice 1. Why does it do this? All the other values are listed OK in the legend. When I look at it in design view the legend shows East, West and...

I have a report that is based on a query that filters out people, who's birthday it is in the next 10 days. Now, I want this report to only open if there is data in it. I.E If it is no-ones birthday in the next 10 days, do not open. Otherwise do open. I assume I need to put some code in the On...

Hi, I have a combo box on my form that lists peoples names. When a name s selected it displays their record below. Currently, it is listed in order of Person ID (keyfield). How can I make the combo list the peoples names in alphabetical. I am aware that you casn do it by creating a query and...

On my form the user has the option to print the record they are viewing. i know it is bad practice, but it actually prints the form - not a report. At the moment the form is a little too wide to fit on one page but not vewry long. If I could change the printout view from Portrait to Landscape...