Search results

I am completely stuck. I need the code to specify that the order that has been double clicked should open. This principle works fine for my products and customer datasheets without any need for additional filters but not so for the order double click code it seems.

Thanks I will look it up. What's strange is that the exact same code (with name adjustments) works for the products list.

hey can anyone please explain how to adjust the below code to open the specific order ID that has been double clicked? At the moment no matter which order is double clicked the same order is opened. Private Sub OrderID_DblClick(Cancel As Integer) On Error GoTo Err_OrderID_DblClick Dim...

My query keeps popping up with a dialog box for "beginning date" "end date" even though the query itself has no requirement for dates. There are no fields within the query requesting that information. Any ideas how to fix this?

that worked, thanks guys.

here's the event procedure. Private Sub View_Click() On Error GoTo Err_View_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "View Customer Orders" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_View_Click: Exit Sub Err_View_Click: MsgBox...

Thanks Gizmo, but where should I put that info?

Is there any fix? Here's the essence of the bug: I add a button that opens another form (form B) within my form (form A). Even though form B is set to datasheet view it always opens in single form. I go into the design properties of form B and make sure it is at datasheet view(which it is)...

Looks like all I simply needed to do was: "LessDiscount: CCur(([Order Details].[UnitPrice]*[Quantity])*[discount%])"

^ Any suggestions are appreciated.

Here it is, thanks. SELECT DISTINCTROW Orders.DeliveryName, Orders.DeliveryAddress, Orders.DeliveryCity, Orders.DeliveryRegion, Orders.DeliveryPostcode, Orders.CustomerID, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.Postcode, Orders.OrderID...

NB this field is within the Invoices query itself.

What's wrong with this query equation? it prompts me to enter a value for order details.totalunitprice instead of retrieving it from the appropriate table. I guess I am missing a marker. "LessDiscount: CCur([customers].[discount%]*[Invoices].[TotalUnitPrice])" [customers] denotes customer...

So all it it requires is a smidgen of VB - thanks Gizmo.

- after qty entry into order form. Hi, How can I configure my order form to do this, it will require perhaps a "post order" button? How would that work? Thanks.

Hi - I am struggling to put together a basic working Access stock, order processing and invoice system for a mock company in an elective that I unfortunately undertook. The System is based on the attached tables (the only part of the system that I think I have gotten right). Everything I have...

Exactly what I was looking for, thanks Pat.

Hi. I am having a hell of a time trying to make my order and invoice processing database to work properly with useful functions. Is there any online resource from which I can download a working example of such a database in order to use as a case study and examine how everything relates and...

Each employee is assigned to a customer and they receive 10% commission from the sales. Are the relationships workable? And in what order would I pull the fields from the relative tables when designing a form with the wizard? Sorry I get really confused at this point. :confused: Thanks again.

Thanks for the info. Below is attached the table relationships at present, how does it look? Any amendments?