Hi FishVal,
You must be wondering where have i disappeared. Actually i had to de normalize the db and make it to the hand off. I saw your form and i must say its a very good effort. It works nicely but the flaw is that i cant add rows which means that i am not able to add more stock or a new line of order....
vectorBS
Last Activity: Sep 10 '07, 11:15 AM
Joined: Jun 11 '07
Location:
-
Have sent the DB via email...Leave a comment:
-
Nice one!! Hopefully you shall set a precedent. Can i send you the db I think it will be more convineant for you....Leave a comment:
-
Hi puppydogbuddy,
Thanks for the comments and having a look. I am glad you agree with me now. Regarding your points
1. No the data input needs to be in a horizontal manner that was the whole point of me creating this thread. I have got reports for viewing the data which are via crosstab query.
2. I am really tempted. But this will de normalize my DB and its un professional :o( I am keeping this as my last option.
...Leave a comment:
-
Hi FishVal,
You mentioned spreadsheet control. Do you think that flexi control will be just as good? Could you please run me through how i would implement these controls for satisfying my purpose?Leave a comment:
-
I have sent it again.Leave a comment:
-
I have done as requested....Leave a comment:
-
Hi FishVal,
Thanks for your comments. I will look at spreadsheet control and see what it can do. I agree with the cost bit as i have already tried it and i can see there will be a lot of coding and intense queries.
Popup seems a good short term solution but there are three different sections of the system which need data input in this way and i dont want to have them all like that and this popup approach will not work with editing...Leave a comment:
-
You have lost me there. I really cannot grasp your concept. I have tried as well and its simply not possible. Here is the crosstab query.
...Code:TRANSFORM Sum(Stock.StockTotalQuantity) AS SumOfStockTotalQuantity SELECT Stock.StockDate, Stock.StockNumber, Stock.GarmentNumber, Stock.StyleNumber, Stock.ColourCode, Stock.UnitPrice FROM Stock GROUP BY Stock.StockDate, Stock.StockNumber, Stock.GarmentNumber, Stock.StyleNumber,
Leave a comment:
-
Ok if that is the case could you please facilitate me by giving me a small example. I am really stuck on this one. I have all the reports having crosstab queries as their source but forms are a pain and i dont blame the users for complaining about entering 5 rows of information for one record.
A sample form on a db will do. CheersLeave a comment:
-
I dont think you understood my problem. The DB is designed to have records in the following format
Garment------Style----Size----------Total Qty
UCPJ----------1----------32-------------12
UCPJ----------1----------30-------------55
UCT------------1----------S--------------25
UCT------------1----------L--------------100
User requirement is to change the data input into the following format...Leave a comment:
-
Sorry i dont understand. Are you saying that i will be able to create an editable form using corsstab query. I do have a data entry form which is not based on crosstab query and i have already tried creating one with crosstab but that doesnt allow editing as crosstab query in its nature is not editable....Leave a comment:
-
Thanks for the reply but as i mentioned in my original post, i need the data to be entered in the same manner and crosstab queries are not editable. How do i go about doing that?Leave a comment:
-
Hi,
You may acheive this by having 3 list boxes or any other controls. First to select client then on the change event you can run a query that populates the second control of the colours which your client orders and from here either using union or nested query you can display there quantities or have another query which displayes stock levels of the colour selected by the same event on the colour control.Leave a comment:
-
Crosstab Behaviour required for Data Input
I am facing a serious issue. The current data appears as follows and in entered in the same manner.
Garment Style Size Total Qty
UCPJ 1 32 12
UCPJ 1 30 55
UCT 1 S 25
UCT 1 L 100
User requirement is to change the data into the following format
Garment STYLE S/30 M/32 L/34 XL/36 XXL/38
UCPJ 1 55 12 0 0 0
UCT 1 25 0 100 0 0
Now this... -
I would appreciate if some one can comment as this is a requirement now. I dont want to alter the DB Design just for this. Any ideas will be appreciated.Leave a comment:
-
Then is it possible to some how replicate crosstab behaviour in nested queries so it becomes editable? The need is to add/amend sizes and quantity not in 10 lines but one.Leave a comment:
-
Editable form based on Crosstab Query?
Hi i know its not possible in theory but has anyone managed to find a way around building editable forms based on crosstab query! -
I presume you will be checking result set and making comparison inside while loop. The loop for you will look something like this
while NOT rs.EOF
.
.
.Your Code
.
.
rs.MoveNext
WEND
Hope this helpsLeave a comment:
-
Cheers for that i managed to do it through format function as follows
...Code:TRANSFORM nz(Sum(StockOrderDetails.Quantity),0) AS SumOfQuantity SELECT StockOrder.StockOrderNumber, StockOrder.StockOrderDate, StockOrder.StockOrderShipDate, Customer.CustomerFullName, Agent.AgentFullName, StockOrder.SeasonNumber, StockOrderDetails.GarmentNumber, StockOrderDetails.StyleNumber, StockOrderDetails.ColourCode, Colour.ColourDescription,
Leave a comment:
No activity results to display
Leave a comment: