Search results

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

Hi How are you generating 'feeding' your report with data? Are you using SQL string or a QBE? (Physical Access Query)

Hi I am trying to create an alert function so that when a user open up a form and displays a record, it will also display any alerts that have been created for that record. e.g. missed payments etc. I have created a table to store the alert data along with the job number to which the alert...

A very good morning to you all! Does anyone know if this is at all possible. When I wish to process a payment for a customer within my database, rather than visit paypal and entering payment information, is there a way by way of API or similar that I can automatically go to the site and have...

Thanks for that info. What about if we used a version of Oracel. I believe we have 9i. Would that then require a licence for each connection of a client to the Oracle DB BE?

Thanks for your replies. The users are adding, searching, editing but not deleting records. The most I have had at one is 75 but there could be more at any time. It's a complaints database so not everyone is using it at one time. They only use it when there is a complaint to log. I have a...