Search results

I have created a form in which I record my daily postings Mon-Fri. In this form I mark which posts I have actioned with a check box (yes/no).Every Monday I have to extract the post I have received the previous week and total what I have received and the total that have/have not been actioned...

I have a sub-form within a form. On each record in the sub-form you should be able to double-click inorder to obtain more information, however I get an 'Enter Parameter Value Box'with the caption Forms![INDAMEX]![Westbound Ports].Form![Port]. For some reason this working well and now this box...

Many thanks for the reply. However after entering in your new expression I get the message about the expression containing invalid syntax. I copied the expression as it appears on this site. =[Account Ref] & "" & Format([Year],"yy") Any suggestions!

I have used the following code in the control source of a field to merge two fields: =[Account Ref] & "" & [Year] When I go to preview the report, I notice that the field is fine with the account ref part, however the year section is returned with the time and today's date. The field [Year]...

Within our database we have the facility to either print or view invoices which are reports. The report is made up from a query filter selected from the current record in the form. We need to create a unique number for the invoices whenever a new invoice is created with that record in the form...

I have a text box which is used to store e-mail addresses. When the e-mail address is entered in Access sets the Hyperlink to http://. Is there any way of setting the hyperlink to defalt to "mailto:"? I always have to go into edit hyperlink and change the setting myself. Shall look forward to...

Thanks for that and for the quick reply. I have an option group that does not work (It was an alphabetical index button)and also a command buttons that proceed to the next records. These too do not function. Is their anything I need to do te rectfy this?

I have created a label in a form that needs to be visible when the invoice due date has been exceeded I have used the following programme in VBA and it does not work. Any suggestions as to why? Private Sub Form_Current() If Invoice_Due_Date < Now Then Dues_outstanding_Label.Visible = True Else...

Whenever I use the & (ampersand) character in a label box, Access changes it to a _ (underscore) by default. Is there any way of rectifying this?

Whenever I use the & (ampersand) character in a label box, Access changes it to a _ (underscore) by default. Is there any way of rectifying this?

Within a form I have a combo box and a sub-form. If I choose a particular choice from the list available from the combo box, I do not want the sub-form to be visible. How do I go about it? Shall look forward to any comments and advices!