Search results

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

Hi All, Need some help from a FileSystemObject guru! In my playlist below (it’s a bouquet for a linux sat box) in textfile format, Is it possible to move the #Description so it appears below the service? Please see example below. If so, how can it be done in vba ? BEFORE...

Hi Bob, On the sales order, each unique line is represented as a line number etc line 10,20,30 etc. On my sales order report, there are occasions where i do not wish to display a certain line number(s). So easiest way to deal with that is to delete the line out of the table which is bound to the...

Hi Bob, good question. Please allow me to explain. Think of line numbering on a Sales order. I am trying to add a feature onto a current database I have that will delete sales order lines in a table based on the line number(s) I input in textbox (text1). The deliminator comma just seperates the...

Hi All, If I have a text box (Text1) on my form with comma separated values entered i.e. 100,120,250,300 what would be the easiest way to enter these into a table column with a button click event. I would like to enter these values into my table tb_test under column Values. Thanks

Hello all, I am trying to delete records from my table using selected records on my forms listbox. My code below doesn’t seem to work.. can anyone spot why? MachineModel and Serial are both setup as strings. Thanks Set ctl = Me.List0 For Each varItem In ctl.ItemsSelected...