Search results

Hi, Could someone advise how if I group in a report by week, I can show the week dates ie the date for every Monday rather than the week numbers which access seems to default to. Thanks in advance...Linda

I have a report dialogue form where users can select a report to run (frmRptDialog). However I am having some errors when there is no data for a given report and the preview of the report is cancelled. The code on a given report is: Private Sub Report_NoData(Cancel As Integer) MsgBox...

Hello, I have a database which in one part records customer orders. What I would like to is identify customers who have not ordered for a given time period i.e. 30 days. I know once I have built the query, I will require a parameter for the time period i.e.30 days. I started by trying to...

Hello, I have a procedure which I undertake and wonder whether it can be automated in any way. I have a field on a form for Purchases (frmPurchases) for a Purchase Order number. To get the order, I click on a command (cmdpo) which opens another form and clicking a command on this form...

I have one form which takes some time to open. I did place a MsgBox "Please wait while the records open" in the OnClick to open the form. This does require the user to press OK from the message box before the sequence can continue an open the form. I was wondering if there was a way of have a...

I have placed a secured backend (be) db together with the workgroup file on a server. The directory as well as the be & workgroup files have full permissions. The frontend (fe) is on the cd of a pc. I have created a shortcut as follows: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"...

I have the following code used on a OnClick event of a control on a form: If IsNull(Me.ClientSurname) Then Cancel = True MsgBox "Mandatory. Please complete client surname", vbOKOnly + vbCritical, "Error" Me.ClientSturname.SetFocus End End If I want to ensure is that when the focus goes to the...

Hello, I have been looking at pasts threads concerning changing text colour in one field on a form, dependent on the value in this field. The fields (from a query) calculates an age at retirement. If this age equals or is greater than 65, I would like to show the answer in red. If not the...

Hi can someone help me with this query. I have a list of bonus amounts[BonusAmt]. What I now want to achieve is calculate an actual bonus sum[ActBonus]. For example. If the bonus amount is a negative number the actual bonus is 0. If it is between 1 and 20 it should be the bonus amount. If it is...

I have set up an expression to calculate the current contract length between start & cancellation date: ContAge: Format([ContCancDate]-[ContStartDate],"yy"" yrs ""mm"" mths""") It is important to have years and months shown. Works fine apart from those contracts which are cancelled from their...

Rather than use an input mask, does anyone have any code which can convert text entered so that the first letter is in capitals and the remainder is however entered by the user. Where would this be placed - 'upon update'? Many thanks for any help.

I have a Customers, Product Area , Customer Advisor and Product type tables. There are 6 product areas eg: A, B, C, D, E & F. What I would like to show is all Customers who have Product D in isolation ie they have not been sold any other products at the same time. I cannot get anything thing to...

I have a form based on a 'Customer' table. There are controls on the form which link to other forms such as products, contact history etc. When set up the controls link the forms by the CustomerID so I only see that customers information. So far so good. My problem is that if someone wishes to...