Jump to content

malagasy

Members
  • Content Count

    60
  • Joined

  • Last visited

Community Reputation

0 Neutral

About malagasy

  • Rank
    member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, I have a portal that sum up all the orders a customer as made in my client's layout. I'd like to print a summary of that portal so I can see all the orders made so far but can't figure it out. How should I do ? Thanks
  2. sorry, but i'm really inexperienced...how should i do this ?
  3. hi, i'm pretty sure it's really basic to do but how do i make something that will automatically enter the city from the postcode. As in...I enter 98800 and the city will be NOUMEA...I also want the list to be evolutive so if i enter a new postcode for a new city, next time, it will automatically do it. regards
  4. "Why is this so difficult? " > Pretty silly and simple...I started this database from scratch with no experience whatsoever. I know for sure it has to be optimized and some changes need to be done but I don't really have the funds to get a consultant working on it. I also know from my short experience that everytime I have tried to make something work better by easier steps, it has had a lot of negative effects on other elements of the work I've done ! I'm totally open to help and improvement but no one will be bothered anyway...
  5. First, thanks for your patience... I'll try to be clear about it...we provide services happening on saturdays to customers... I have a 1/ Customer table 2/ Saturday table 3/ Order table 4/ Orderline table When a customer place an order for a service, he states how many saturdays the service will be provided and from which saturday. The order layout (order table) allows entry such as prices, ect... and also the details of the saturdays the service will be provided (on his invoice, he can clearly see this). On my side, with this system, i can go in the Saturday layout
  6. Alright, so far, my script is > Copy [select; Orders::First_saturday] Past [select; Orderline::DateID] Loop Go to Portal Row [select; Next] Paste [select; (OrderLine::DateID] Exit Loop if [(Count (OrderLine::DateID] = Orders::Number_of_saturdays)] End Loop My 2 big problems are 1> the loop never stops 2> the date in the portal row should be First_saturday + 7 then First_saturday + 14 then First_saturday + 21 ,ect.... depending on how many saturdays have been chosen on Numbers_of_saturdays. Hope someone understand and can help with a simple language
  7. Thanks for that solution Soren however, it doesn't seem to be working on my database. From what i can observe in your script, it deletes all the records when mine indeed already have a table with all the saturdays...and don't want these to be deleted everytime i use the script. It seems my problem comes from a set variable part of the script...just don't know how to stop the loop / and cant manage the rows in the portal to have 7 days between eachothers
  8. cheers for your attachment, looks pretty similar to what i want !! One more question, is there a way i could have the drop list appearing in first_saturday to only displaying current and future saturdays and not the one that have gone past ?
  9. i realised i had posted in the wrong section ! Reason I want looping (i know i gonna sound like a grandpa) is because i've used this system before and found it efficient... hope i won't get blamed for this -)
  10. hi, I have a portal in which dates needs to be entered automatically (only saturdays). I also have created a field first_saturday and another field number_of_saturdays. (these 2 fields are not part of the portal). What I'm trying to get is if i enter 02/06/07 in the field first_saturday and 5 (or 6,7,8) in Number_of_saturday, then in the portal 02/06 will be in first row, 9/6 second, 16/6 third, ect and this depending on the value number_of_saturday. I want to use the loop technique and believe i have to use set variable, ect... but quite bad at applying. Hope someone can
  11. oups, greatly reduce the chances of making any mistakes -)
  12. i reckon it's worth it since it greatly any mistakes (forgetting a saturday for exemple) and save me the pain of having to record dates in the portal individually...which takes ages
  13. hi, I have a portal in which dates can be entered (only saturdays). I also have created a field first_saturday and another field number_of_saturdays. What I'm trying to get is if i enter 26/05/07 in the field first_saturday and 5 in Number_of_saturday, then in the portal 26/05 will be in first row, 2/6 second, 9/6 third, ect and this depending on the value number_of_saturday. So far, I've only managed to automatically have 26/5 in portal (by copy and paste) and 2/6 with a calculation first_saturday +7... but don't know how to get the loop for the remaining . Hope someone can
  14. I'm still trying to make that thing working but I obvioulsy don't get the basic principle so no luck as yet -( -(
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.