Search results

Hello I have a form called Input Orders which has a sub form called Orders Details sub form. The Input Orders form is opened via a button on my Customers form. The code for the button is shown below. Private Sub New_Order_btn_Click() On Error GoTo Err_New_Order_btn_Click Dim stDocName...

Yes - I know there are several responses to this on the forums and as such I have followed the advice given but am struggling. It's in respect of opening an email in Outlook from an email address in a field. The code below opens Outlook and populates the To: Field, however after the email...

Hi I have searched through the forums and can't find exactly what it is I am trying to do. Essentially, on my Customers form, I have a command button which 'on click' opens the Input Order form - so far so good - however, what I want it to do, is open the Input Order form so that it goes to...

Hi I have been working on a database structure for some time now and the test data I have been entering has generated Order Numbers using the Autonumber function. Once I get to the point where I am happy that I have got the database to a condition where I can start to use it in anger, I want...

This refers to a basic Customers / Orders database. I have a form Orders, with a subform Order Details, the order details subform has a field called ReSaleValue The Orders form has a field called Order Value, which I want to be populated by the sum of the ReSaleValue from each order. I have...

This is driving me nuts - despite several emails and calls to BT Tech Helpline, I am still unable to send email via Outlook Express. Allow me to explain: Outlook Express is set up with a mail account via BT Internet - I can receive email via this server but cannot send. I have checked...

Hi, In A97 is it possible to rotate a field name through 90 degrees in order that fields with longer names don't hog the width of the page so much ? ie the field name sideways above the data cell.

I am sure I have seen this posted before but cannot find it. There is a way of calculating the days remaining in a month less weekends. Please point me in the right direction Many thanks

Hi, At the end of each month I import data into my A97 db which via an append qry updates a table with with new data. The attached SQL shows what is going on. The problem I have is that at the start of a new month I have to go into the qry and alter the month, in the code area, [Alloc...