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

    Complete Newbie - Please check a VFP expression for currency

    Thank you for all your help and support guys. Ive really been blown away. @jrbbldr - I have been using the !EMPTY check by itself and it is working as i had hoped. So thank you very much. My final final final question (i promise!): I have been adding this extra code to other currency fields...
  2. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    PERFECT! (Well nearly!) Thank you jrbbldr. I have ended up with: ALLTRIM(TRANSFORM(VAL(STRTRAN(<method>,',','')),'999,999,999.99')) Note: VALUE() was throwing an error, but googling around i found VAL() which works The only issue is now, where before if i had inserted a blank line for...
  3. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    Thanks for the continued support - i appreciate you all bearing with me! @jrbbldr - I used your code (and have backups!) and oddly it returned "U"?! What datatype is that?! As i said above, i can look into the data environment and locate the value of it_price which is not the same as the value...
  4. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    Thank you for all your help - i really do appreciate it. @MikeLewis - The problem with the code i had is that it doesnt always produce the right values when testing with old reports. VERY oddly it seems as though the value it_value stores a price in cents (i.e. when the currency being quoted...
  5. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    Thanks for the help jrbbldr Ive opened the FRX file with VFP 9 and it looks pretty much the same as from within the ERP (guess it has VFP editor inbuilt) - but i still cant find a way to look at the source code and find these class definitions? Am i looking at the right file (i have an FRT and...
  6. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    @OlafDoschke - Sorry i didnt see your reply before i posted. Thank you for the help. Im editing the code within our ERP system (which to my knowledge, i cant introduce break points / debugg / copy or paste), should i be using some Visual Fox Pro Studio of some sorts? What do you mean about...
  7. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    Thank you for the response. Is there any way i can find where the method (im guessing thats dispunit?) is defined? I see what you are saying, but the old expression certainly seems very over the top wouldnt you agree? I would really like to understand and improve it
  8. Bollard04

    Complete Newbie - Please check a VFP expression for currency

    Hello Guys, I have absolutely no experience with VFP but am trying to edit some of our reports (ie invoices, quotations etc). The expression i am looking at pulls a price from a table (as a number) and then converts (divides by 100) to a currency. I wanted to clean up the code (as to me it...
  9. Bollard04

    Windows XP Pro profile corrupt - status backup

    Thanks for the replies guys. I followed intelwizrd's instructions but ran into a few problems (when the user logged in for a second time there was an access denied message on logon). This was all complicated by the fact that Windows had created a temporary profile that it kept forcing on the...
  10. Bollard04

    Windows XP Pro profile corrupt - status backup

    Thanks for the reply. But how do i keep the same username? The computer is connected to a SBS 2003 network and so the username is important to retain?
  11. Bollard04

    Windows XP Pro profile corrupt - status backup

    Hello all, I have an XP Pro SP3 client with a corrupt profile. On right clicking My Computer > Properties > Advanced > Profiles, the profile has status "Backup" What is the best way to restore this? I know there are lots of guides online (which i have read), but they dont seem to go into much...
  12. Bollard04

    SBS 2003 RWW - User account connected as &quot;TEMP&quot; with default profile?

    Hello all, Having an odd issue. Setup my SBS 2003 server fine, and tested all RWW and Exchange etc. Now, im in the US for a couple of weeks, and when i logon on to my computer via RWW, i am prompted for my Username and Password, which is fine. I then select my personal computer and connect. I...
  13. Bollard04

    Event ID 1091 filling up XP Pro Clients

    Heya, This is really puzzling me... id really appreciate some help. Im starting to tear my hair out. Setup: Windows SBS 2003 R2 SP1 Server Windows XP Pro SP2 Clients Problem: There are hundreds of Event ID 1091's logged in the clients event viewer, and new ones seem to appear around every 2...
  14. Bollard04

    Best way to share contacts and have a shared mailbox?

    Hello, I want to achieve the following, and wonder if you could help: 1. A way that users can all have access to a shared mailbox (sales@company.com), where they can all send messages as sales@company.com and view the emails that are sent to that mailbox. 2. Setup a shared contacts folder, so...
  15. Bollard04

    Thousands of Event ID 7062 (Server offline)

    OK... i already had the openDNS IPs in my Forwarders tab, and i added the servers from cache.dns to the root hints (servers A to M i think) and i *think* that seems to be the end of my constant 7062's! Hooray! The only thing ive noticed so far is a couple of Event ID 113... is that anything to...
  16. Bollard04

    Thousands of Event ID 7062 (Server offline)

    Sorry about the myriad of posts, but i removed my server from root hints and then, did the following to try to repopulate the list: "right click the server name in DNS manager, choose all Task, configure a DNS server. The wizard will start up... click next then choose Configure root hints. It...
  17. Bollard04

    Thousands of Event ID 7062 (Server offline)

    Just checked. The MS documentation (http://support.microsoft.com/kb/218814) doesnt mention root hints... What should i do? Regards
  18. Bollard04

    Thousands of Event ID 7062 (Server offline)

    Thanks for the replies. Ive removed the default gateway in TCP/IP properties so it is left blank. However, im still getting the 7062s and i think i can see sort of why. Ive been google'ing around, and i see in my server's root hints the only entry is the server itself. Looking here...
  19. Bollard04

    Thousands of Event ID 7062 (Server offline)

    I ran dcdiag, and netdiag, and ive attached the results. DCDiag looks fine. Not too sure about NETDIAG though. I think the problem could be something to do with my defualt gateway or switch? The switch is a DLink DGS-1008D that i dont think has an IP address or management console. Would it be...
  20. Bollard04

    Thousands of Event ID 7062 (Server offline)

    Thank you for your reply. Ive run the wizard, and am still getting these errors. Ive checked in DNS and to be honest i dont know what im looking at. I can post a screen shot if that would help. However, there is an _msdcs in the forward lookup zone only. Im about to run DCDIAG and ill post any...

Part and Inventory Search

Back
Top