Khalid-
You could certainly create a crosstab query to feed your form, but it won't be updatable. Do you want this for display only? If you need to edit, you'll have to write custom code to load into unbound controls, detect any updates, and write the changes back to your tables.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jan 11, 2017, at 6:35 PM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I am copying my reply.
--------------------------------
John,
OMG! I have been trying on it for the last 2 days, but did not get in mind to change it to
Double. Anyways thank you very much it is now giving correct values.
Now coming to another issue.
Presently i am entering "DestinationRate" on a form "Add New Destination Freight Rates" on the
main form there is Unbound Combo box "Destination" asking user to select Destination. Its Row Source
is:
SELECT Destination.Destination
FROM Destination
ORDER BY Destination.Destination;
On the subform "Add New Destination Freight Rates Subform" selecting from Combo box "cmbProductID"
"ProductID" having Row Source:
SELECT Products.ProductID, Products.ProductNameEnglish
FROM Products
ORDER BY Products.ProductID;
Then displaying "ProductNameEnglish" on the Text box "cmbProductNameEnglish" having Control Source
=[cmbProductID].[Column](1) and then entering "DestinationRate" on Text box "DestinationRate".
In this design we have to feed seperately for each Destination for all ProductID.
What i need and the boss is demanding is that on a single screen the form should display all Products (ProductID with ProductNameEnglish)
and all Destinations something like Crosstab report.Like:
Product ID Destination1 Destination2 and so on...
1 DestinationRate DestinationRate DestinationRate
2 DestinationRate DestinationRate DestinationRate
3
.
.
.
At present there are more than 100 Products and about 10 Destinations.
Could this type of form be designed ?
Please help.
Regards,
Khalid
-----------------------------------------------
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Khalid-
John,
Please reply again and include the rest of the thread.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jan 11, 2017, at 6:10 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
That was optional just to show the user that for which "ProductID" he is putting "DestinationRate" what is its "ProductNameEnglish".
But what about my question for the design of form ?
Regards,
Khalid
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar