Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. psvialli

    How to creatr a static calandar

    Hi, Can anyone please help me, I need to show a booking type of calendar that will show that dates have been booked out on my apartment. Nothing fancy as I will update the flash when the dates change , but not sure where to start SMTWTFSMTWTF etc.. Jan 1234567891011 Feb...
  2. psvialli

    Updating Child Records on Import

    Many thanks it works great ! Can I ask what does the SET do ? Thanks Paul
  3. psvialli

    Updating Child Records on Import

    Need some help on Import and updating some data I have two tables that I need to update I can update the main table fine using code below, my problem is updating the child records ITEMS. I have 2 tables MAIN & ITEMS main holds basic information and ITEMS holds items and notes. I import from 2...
  4. psvialli

    Grouping on a Report and Sum Total

    Many thanks Tamar, First for the explanation and then for the answer, it works Great and I understand why as well! Many thanks Paul
  5. psvialli

    Grouping on a Report and Sum Total

    Hi Stella740pl, I have a group co_pk on my report, The Cursor is not Grouped, as i cannot group by Co_PK as i need to show all the Invoices that relate to that company. I have tried what you have suggested above but i still get the Total sale , cets for all the companys not the grouped ones ...
  6. psvialli

    Grouping on a Report and Sum Total

    I will try and explain what i am trying to get done ! I have 2 tables Company & Invoices On my company table I have Company name, Total Sales, and total Certs. (Total sales is nothing to do with Invoice total) On my Invoice I am holding Details and Invoice cost. I have joined the tables so I...
  7. psvialli

    help with Scan

    Hi Jim, I just tried to use this code but for some reason I can not get it to work, it generates the Cursor, but then when it goes through the Certificates it only looks at the first record in the TestPremium Cursor. So it always reports a badpremium as it does not look through the Cursor ...
  8. psvialli

    help with Scan

    Another question on this if possible. All of the above coding works really good but i have just hit another problem that i did not think of. My premium table holds a Scheme FK VAlue Premium SCheme_FK £5000 £1.00 1 £10,000 £2.00 1 £5,000...
  9. psvialli

    help with Scan

    Many thanks to you all for you help it is much appreciated! Paul
  10. psvialli

    help with Scan

    Need a litter help on searching tables? I have two tables my main table that holds a certs and premium i.e. <cert> 00001 <Value> £15,250.00 <Premium> £3.00. I need to search another table <premiums> and check the premium to make sure it is correct, this table holds values and costs as...
  11. psvialli

    200r and web acess

    I have a symantec 200r and all is working fine, i now need to allow acess to a server running iis but am having issues ! on virtual servere i have set the Web server to 10.10.1.10 which is the server running iis on my LAN it all works and i can acess the IIS but when i use the static IP it...
  12. psvialli

    Currency Converter

    Has anyone do a currency converter before ? I need to add this into one of my Apps but not sure how to proceed ? Any advice welcome ! Paul
  13. psvialli

    Crystal Reports with fxopro 9

    Hi, I am fairly new to Fox but want to use crystal reports with FoxPro 9 is this possible if so how do i go about setting this up. Many thanks
  14. psvialli

    Replace in Relationship

    I think you were right the first time it now changes ALL to the same lnitemID. :( Any other ideas ?
  15. psvialli

    Replace in Relationship

    Hmmmm I am a little lost on this OlafDoschke I do not really understand what is happening where would I do the replace ? I did not think it would be this complicated to just update old the child records! Paul
  16. psvialli

    Replace in Relationship

    I hope you do not mind these newbie questions! I have set a relationship up between two tables,- one to many But I am having trouble with the replace - it only replaces the first records in the tempitems table, but there is lots of records. How can I get it to replace all the related records...
  17. psvialli

    ARRAYS - sorry newbie

    Many thanks for the help !
  18. psvialli

    ARRAYS - sorry newbie

    newbie question ! I have an array and I need to copy the array to a memo field but i only get the first line of the array, can somone please let me know where i am going wrong. Thanks use claims DIMENSION aMyArray(4) COPY TO ARRAY aMyArray FIELDS address1,address2,address3,address4 GATHER...
  19. psvialli

    200R and IIS

    OK so i was alittle to quick to post - it worked for all of 1 min before it stopped ! - If i plug the ADSL direct into the LAN the IIS works fine but as soon as i put it back into the 200r - nothing no IIS ! Could it be a DNS problem ?
  20. psvialli

    200R and IIS

    OK sorted it out Rip2 was disabled on the Firewall 200r ! DOH a whole say waisted !!!! :(

Part and Inventory Search

Back
Top