Search results

I have uploaded a slightly different design. I feel I have resolved one of my initial questions however 'TotalPackageCostPrice' in frmPackages does not behave as required. I want it to reflect the sum of ProductCost in frmPackagesSubform after update of either cboProductName or Quantity. The...

OK, I am working on a slightly different design... Thanks, Phil.

I have tried the following: Private Sub Form_Load() cboProductName.Requery End Sub This has not produced the desired result. I think I need a way to requery the Products table on form load? Set the ProductCost to equal tblproducts.Unitprice * tblPackageDetails.Quantity where...

Here is the event procedure code snippets: Private Sub cboProductName_AfterUpdate() Dim intTotalCost As Double Me.ProductDescription = Me![cboProductName].Column(1) Me.ProductCost = Me![cboProductName].Column(2) Me.Quantity = 1 DoCmd.RunCommand acCmdSaveRecord intTotalCost =...

Hi to all. Its been a while since I worked with Access. I have attached a sample database with some dummy data. frmPackages frmPackageSubform User Input: User enters Package Master Record User enters Package Details. The user can select a ProductID from a combo box. This then updates...

Cheers Bob. I have set to sizeable and all is good in the world. Thanks, Phil.

Hi to all. I have one form that is not displaying min/max buttons even though option is set to 'Both Enabled'. Every other form displays them ok. Any idea regards what settings I may be missing (Access 2007). Thanks, Phil.

Hi John. I agree. I merged an inventory database template i dowloaded with a sales one I developed. To have a standard naming convention i decided to rename my tables (as I broke the other one when trying to update to match mine :) ). I will leave as is. Phil.

Hi to all. I have been renaming forms after combing 2 separate databases. On rename of frmSalesOrders to Sales Orders on open I receive error 'You cannot open this form as a standalone form'? I want to rename: frmSalesOrders to Sales Orders frmSalesOrderDetails to Sales Order Details Sample...

Hi Paul. I run Access 2007 on my laptop, Access 2010 on my desktop. I have got it working in 2007. I added ActiveX Controls (Calendar) which when selected update unbound text fields txtClick1 and txtClick2 with date selected. Regards, Phil.

Hi Paul. Not quite, I have not added the text box controls that use Access's Inbuilt Calender. I did have a play by adding 2 txt fields, but when I launched the form the inbuilt calendar did not display. You understand what I want to achieve though. The from will have a drop down where they...

Hi to all. In the old days I had a form that allowed users to select values, click OK and then call a report. The underlying query criteria values as follows: #1 Like "*" & [Forms]![frmOrderAnalysisByServiceType]![cmdServiceType] #2 Between...

OK, I have worked it out. Option Compare Database Private Sub Report_Load() If Me.OrderBalance > 0 Then Me.PaymentDueLabel.Visible = True If Me.OrderBalance = 0 Then Me.PaymentDueLabel.Visible = False If Me.OrderBalance > 0 Then Me.ReceiptLabel.Visible = False If Me.OrderBalance > 0 Then...

I have tried the following in the 'On Load' event of the report. Option Compare Database Private Sub Report_Load() IF Me.OrderBalance >0 Me.PaymentDueLabel.Visible = False End Sub

Hi to all. I have a report with label 'Receipt' + 'Receipt Number' + 'Order ID'. I have added a label 'Payment Due'. When the order balance is >0 I want to hide label 'Receipt' + 'Receipt Number' + 'Order ID' and display 'Payment Due'. When order balance is 0 I want to display label 'Receipt'...

It looks as though I might have to revert to text box and use in-built calendar. Thanks, phil.

Hi to all. Many moons ago I implemented a calendar module written by a chap called 'Mile-O' from this very forum. I know it worked in Access 2003. In Access 2010 the calendar does not display (There is no object in this control). Is there something I need to enable under 'Tools' References' or...

I have just taken another look and the issue I reported previously is not present (which adds to the confusion as a new row WAS added to tblPackages)..... :) However I can no longer replicate it! So all appears well in the world after dropping the table lookup. Phil.

John I dropped the lookup and the table the expected value is now populated. However now when I select an existing package within the Sales Orders form a new row is entered in tblPackages? I have attached the DB with the Lookup removed. Thanks, Phil.

Thanks John. I did this database over 10 years ago and have not worked with Access for some time. I have been asked to knock up a database as a favour so I am attempting to modify what I have. So If I drop the lookup what will it break? Also at present the database simply allows selection of...