Search results

I used the following code to enable alternate lines (ie alternate records) on my report to have a grey background. This worked fine in Access 2000 however, as I have recently upraded to XP it no longer works. Can someone please tell me the amendment I need to make. Thanks very much Here's...

I have a text box on a report which shows the number of hours and minutes a person has worked on a project in a day. This box is formatted to 'short time' and has as its control source a calculated field in the underlying query. I would like to be able to sum all of these hours at the bottom...

I have a combo box - cboSupplierName - which is synchronized to another combo box - cboProductCategory - on the same form - frmOrders. Thus suppliers only appear in the second box if they fall within the category selected in the first. The category is initially selected on the main form which...

Can anybody tell me how I disable a subform which is located on a tab control. I have used the following code on the AfterUpdate event of an option group which determines whether the subform should be enabled. The code is also on the OnCurrent event of the main form. If Me.grpDelivery = 4...

Hi Rich Thanks for the reply. The form is based on a table - tblDeliveryDetails - which does have all these fields.

I have a button on a form - frmOrders - which opens a popup form - frmDeliveryDetails. A relationship exists between the two via the OrderID field. I want this button to open the frmDeliveryDetails at the appropriate record according to that displayed when the button is clicked. At the moment...

Ritchie Thanks for your reply. Can you give a bit more detail on how I should change the modules. I don't have a lot of VBA knowledge. Most of the VBA on this form is based on the wizards or for code gleaned from forums like this one. I'm afraid I need a bit more basic information. Thanks...

Is it possible to link a pop up form to a main form. I have an order form on which there is an option group to select various delivery choices, one of which opens up a pop up form on which you can enter a delivery address. The tables behind them are linked by the OrderID. What I would like to...

Hi Robin Thanks very much it all works fine now - except its very slow - see my other posting. Don't suppose you've got any clues about this? Cheers Rob

Does anyone know why one of my reports keeps changing its margins and the page orientation from the settings I have created? I have set margins of 8mm on all four sides and a horizontal orientation. However, it keeps changing to 100mm!! margins and reverting to vertical orientation. This is...

I have a form in my database which has a subform and a large number of controls on it. It has become very slow to load up and when I jump from form view to design view and back. Is this simply because there are lots of controls and is there any way ( apart from reducing the number of contols)...

Robin Thanks for the reply. I'm afraid it didn't work. The quote marks are in this position in the other instances in which I use this code and it works fine there. I'm completely stumped. Thanks again anyway.

I hope someone can help me. I am trying to put some code behind a command button to tell access to print the current record as a report called rptPuchaseOrder. I have done this successfully on other forms in my database but in this instance the report prints out with no data whatsoever. I am...

Thanks a million RDH. It all works a treat. Rob

RDH Thanks again, heres the code so far: Private Sub btnPrintOrder_Click() If IsNull(Me.[ProjectID]) Then MsgBox "Sorry, but you can't print this order until you've selected a Project from the list." Me.[cboProjectName].SetFocus End If If...

RTH Thanks for the reply, I've done what you suggested, but now, the report does not print even if the particular fields are completed. Could you advise me please. Thanks again.

I have a command button which opens a report from a form. If a particular field on the form is not completed, I have a message box which pops up to tell the user that they can't open the report because they haven't filled in the particular field. This all works OK but the report continues to...

I'm having trouble getting a calculated control to work. I have an Order Details sub form (on an Orders main form) with a text box which calculates sales tax. It only need apply to those suppliers registered for the tax. Their registration is recorded in a check box on a separate suppliers...

AndyH Thanks for the reply. I think the answer to your last question is yes. All I need is for a message box to appear when the Products form opens which reminds users to select the appropriate Product Category from the combo box. This message must tell them what that category is and this...

DRananahan Thanks for your reply. Sorry but I do have another question because I can't seem to get this to work. Let me give you some more detail: I have a form - frmOrders - and a subform - sbfOrderDetails. On sbfOrderDetails I have a combo box - cboProductDescription - from which users...