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!

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

Recent content by SpankYou

  1. SpankYou

    Using Variables in an append query

    Ok so I never managed to figure out the second option, and even came across a third option, but I got the first option working, why were the dates messed up you ask? Because there was no darn #'s before and after the dates, having never written an Append query using SQL and dates, it didn't...
  2. SpankYou

    Using Variables in an append query

    I have an append query which I am trying to implement as part of a loop, so I don't have to write 10 or more different Append Queries and load them as necessary. Now I have tried this several way, and I'm not having much success. My first attempt is below.... ''put into variables...
  3. SpankYou

    Change Default Printer, But Reports Not Working

    Hey Simey, Yeah I am doing this in access. I don't put the printer name in the line that prints out the report, to tell the truth I didn't know that was possible. I'll have a play around with the code above and tell you how it goes. Thanks Sam "You couldn't fool your mother on the...
  4. SpankYou

    Change Default Printer, But Reports Not Working

    Basically I have a search, and depending on what you search by, you can print of a number of reports. Now, I wanted to bring up a print dialogue box, so that you can select which printer you print to, but I have a problem. Basically I can be printing up to five reports sequentially, and of...
  5. SpankYou

    Currency format in code Not recognised

    Hey, Thanks for the idea PHV, i've just tried it but the result I get is "£.4". But Cor Blimey Guvnor jges example, gives me the format apart from the "£", so I've mixed them together and it works... strPricePerShare = Format$(Me.PricePerShare.Value, "£0.00")...
  6. SpankYou

    Word read from Access

    Hey, This page has an excellent example to get data from access to Word, it might give you a starting point... http://www.helenfeddema.com/CodeSamples.htm Hope this helps Sam "You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling...
  7. SpankYou

    Currency format in code Not recognised

    Hey, This problem has me baffled. In a textbox, which is bound I display a price per share. I have set the format to currency, and everything displays fine. But in code I am trying to copy the value exactly as it is displayed in the textbox. Now I have tried the following methods. The value...
  8. SpankYou

    Access 2002 Cannot Access Fields

    Hey, Worked a treat BuGlen thanks for the help, and hope you enjoy the star! Cheers Sam "You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling machine." - Homer
  9. SpankYou

    Access 2002 Cannot Access Fields

    I have this code which I have adapted from the microsoft website, basically this should put all the tables names in one listbox and all field names in another. The table names work but the Field names doesn,t. I'm not quite sure what I'm doing wrong, the code doesn't error, but when I put the...
  10. SpankYou

    Alt Gr and Arrow Key?

    Hey, Cheers for clearing that up bcastner, i did find out that a program call HKCMD.exe which configures keyboard hotkeys was running, and once I stopped this running the screen no longer flipped around. I was just surprised I had not come across this before. Cheers for your help Sam...
  11. SpankYou

    Alt Gr and Arrow Key?

    Hey, Yeah, sorry I did mean a wxp on a w3k network. Basically if you hold down Alt Gr and the left arrow then the top of the screen will be on the left hand side of the screen, so in a effect the screen image is on it's side, if you press it with the down button then the screen is flipped...
  12. SpankYou

    Alt Gr and Arrow Key?

    I'm using Windows XP on a Windows 2003 server, if I hold down Alt Gr and an Arrow Key (any direction), the screen changes dependant on which arrow I press, I don't have XP at home so I can't test this any other way, does this happen on all XP machines? is it an Easter Egg? (one of those non...
  13. SpankYou

    Auto Resizing Nearly Working

    Hey, I am using the Auto Resize MDE file supplied by Getz, Litwin, and Gilbert (Sybex). Now I have entered the code onto my forms as necessary, and it works great. Apart from on 1 form. Basically this for has a subform. Now the sub form does not contain the resize code just the parent. When I...
  14. SpankYou

    Get Domain Name Of Windows 98 Computer on Server

    Hey, (This is an office 2000 database built using Access XP, on a Windows XP system) How do I get the Domain Name from a Windows 98 computer on a Server. I have tried many different functions available on the net including, Set net = CreateObject("Wscript.Network") sDomain =...
  15. SpankYou

    Developer Runtime Not Working

    Hey Everyone, I have found that this problem has arisen due to the way that windows 98 holds Username and Domain Name details, so I have to have an alternative login, Cheers Sam "You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling...
See more

Part and Inventory Search

Back
Top