Recent content by hardrock

Olek, I am trying to add a text box to this form that when it loads will show the supplier name. In my textbox (text1), I’ve set it’s control source to =Dlookup(“Supplier”, tb_supplier) but it never seems to show the supplier name when the chart form loads?? The suppliers name...

Great!! Thankyou Olek. I will have a play with this tomorrow :)

Hi olek that's exactly the kind of thing I am after. But I still a beginner with graphs and I'm lost. I use access 2007 also. Would you be able to make a sample report example for me with the data in the table above. I will then learn from it. Thank you.

This is my first attempt at doing a graph in MS ACCESS and i'm already struggling. I want to be able to create a simple bargraph showing Ontime and Late alongside each other by month. Typically data from table below. Also want to show percentage vs month as a line graph. Is it possible to...

Hi Paul StrBody is just a few lines of text at the moment

Hi All, I use this bit of code to generate an Outlook email body with the contents of strBody. How can I modify this so the HTML generated is in "Courier new" font size 11? I've looked everywhere for an example and failed. Thanks With MailOutLook .To = Recipient .CC...

@CJ London, Of course I could do it :) I was just wanted a helping hand. All sorted now and thank you once again.

@ CJ London I have to create this string. Can you help me create the string for this format. The string needs to contain Part number: 10 digits length Part description: 20 characters QTY: 6 digits length Price: 10 digits length No spaces between the 4 items. The QTY and Price need to be right...

CJ London your solution worked perfectly. Many thanks to you and everyone else who posted.

Hi Guys, In the bit of code below how do I set QTY to be right aligned using the Format keyword? Example of the output I am trying to get with my output strings is 1600.00 ***1.00 **15.00 *100.00 I've messed about with the format function but no quite there yet. Any help appreciated...

That's it !! Thankyou :)

Hi All, I have an old mp3 player that works off a USB stick. The player plays in the order of when the tracks are copied to the USB stick. I’m nearly there with an Access app that copies the tracks in the order that I want, but I can’t get the Filecopy to work. Can anyone spot where the...

any ideas anyone?

Hi pat thanks for the reply. Problem is i am struggling to find examples of cut and paste within text files in VBA on the internet. Everything seems to be for excel. just to make things worse what if the text file is in utf-8 format as there may be some russian characters in the txt playlist...

Bob, Thankyou ever so much! This was doing my head in.. your bit of code worked perfect...