Search results

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?

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

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

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

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

Hi, I am currently stuck on making a working one to many table relationship, I will post what I have so far, what I am stuck on is forming a proper working relationship. tblCustomers CustomerID Name Address(street) City Region PostCode Telephone Discount % tblOrders OrderID ProductID...