Recent content by linanderson

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...

Thanks for your reply. I would however still have to open the form which creates the number (cmdpo) and then click on the command on this form (cmdgetpono). I was looking for a way of automating this whole process. Any suggestions welcome

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"...

Thanks for replying. I already have the code on the BeforeUpdate event on the form aswell and the same issue occurs. Wherever I place the Cancel=True part of the code, after the focus is set to a field, you can move to another field. What I thought would occur is that you could not move from...

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, Thanks for getting back and the example. I have now managed to get the correct results. My error was to keep the brackets around the colour numbers. I cannot believe I missed this. Best regards..Linda

Thanks for getting back. 1. Name should have been AgeAtRetirement 2. Entered OnCurrent event on the form and AfterUpdate event of the control: If Me![AgeAtRetirement] >=65 Then Me![AgeAtRetirement].ForeColor = 255 Else Me![AgeAtRetirement].ForeColor = 0 End If 4. Fine. It is the form...

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.