Recent content by Phonik

Morning all...hope your not feeling the cold. I have a report that returns list of open tasks in a workflow management application I have built. In addition to the general fields on the report (Task_Number, Title, Date, Due_Date...etc) I would also like to include a listbox below (within the...

Hi all I keep running into a problem when I perform some basic validation on my form. Basically, when the user clicks an exit button, some code is run to make sure that they have completed all mandatory text boxes. The code I am trying to use is: If me.company_Name = "" then msgbox "blah...

Hi all.. I have a linked table to an Outlook folder (Inbox) and I have a list box on a form within my database that shows the contents of the inbox so that I can read emails to this mailbox from within my app. Unfortunately, as I have linked directly to an Outlook table (Inbox) I do not have a...

Hi all.. I have a linked table to an Outlook folder (Inbox) and I have a list box on a form within my database that shows the contents of the inbox so that I can read emails to this mailbox from within my app. Unfortunately, as I have linked directly to an Outlook table (Inbox) I do not have a...

Morning all I am using the following piece of code to send email via SMTP but I have a proxy server in the way. Can anyone tell me how to connect to the proxy server first please. I know the address and port of the proxy. This code uses a reference library I downloaded. Thanks...

I have just managed to get it to work!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You have no idea how much time you have just saved me!! Thank you so much!!!!

Thanks again.. So where you have writted (ControlName) do I just replace this with variable? DO I need to use the & symbol? I really appreciate you helping me out...

Hi What happens if I am writing the code in a module and I cant use the ME.?? Thanks

Thanks for your reply. Im not 100% sure that I can do what I want to with that but I will certainly try... If anyone else has any other suggestions I would be very grateful. Thanks Gareth

Hi all Is it possible to use a variable to finish the name of a control? e.g. Cell = me.A1 (where A1 is a lablel with the name a1) forms![Myform]! "Cell".forecolor = 65280 What I am basically trying to do is to have a variating control name that i can change the color of.....too long to...

Hi Can anyone please tell me how I look up the row number where the value of one of the columns is equal to something. e.e Name Paul John Steve Matt I want to find the row of the list box where the name = "Steve" I need the answer = 3 Please can anyone help... Thanks

Hi all I have a form which is used for entering holiday requests. It has fields such as name, type of holiday, date from and date to but it also has a list box value. This list box contains the number of days between the date from and date to and exludes weekends and bankholidays using data...

Hi all I am currently building a holiday planner for my employers and I would like to try and display the days of the year as rows and the staff as columns (Fields). When someone adds a new member of staff, I would like it to also add them to the calendar table as a new column and name the...

Hi Thanks for your reply. The job number is not text it's an autonumber

Are each of the seperate words in seperate fields? i.e. Field 1 Vehicle Type = Car Field 2 Owner = Tom Field 3 Colour = Red