Recent content by SpankYou

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

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

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

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

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")...

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

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

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

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

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

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

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

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

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

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