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

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

Hi Can anyone give me some ammo to tell me boss what a safe number of users of an access database is. It is a well built database that runs quickly and effiecently but I need to know at what point this will be put at risk. 100 users? 200+? I am running the database a FE/BE with the client...

Hello Can anyone tell me how I use a variable I have defined within a SQL string. e.g. ***code start *** Dim ComputerName as string Dim Sqlstr as string ComputerName = Environ("ComputerName") Sqlstr = "INSERT INTO ComputerName ("ComputerName") SELECT ***This is where I need help including...

Hi I have created a small form that hold a cube of 9 boxes on it. The idea is that it will act as a small icon that indicates the system is loading. (Purely cosmetic) I have triggered the boxes to change colour on a loop when the form loads but the problem is that the loop function is being...

Hello all...Happy New Year!! I have obtained some VB code shown below which adds an icon to the windows task bar as I intend to put some additional code behind this that displays messages near the clock when something happens in the database. The problem I have is that the code does add an...

HI all I have managed to populate a treeview with some menu items I required and it looks great but I now need to get it to do something. How do I get a tree view value (selection) to act as a variable in routine. e.g. if my tree look like this. Menu ¦ - Compaint management I...

Hello to you all... I am just after a bit of assitance if anyone can kindly help? Basically, I need to redevelop a Complaints database for my employer as the current one is no longer fit for purpose. The current database is a FE/BE database and users are required to login with a username and...

Hello I am aware that there are a lot of existing threads relating to compacting and repairing but I cant seem to find what I am looking for. Basically, I developed a complaints database for my employers and it is used by around 45 people at any one time. The database was one of firt I built...

Hello people. Im just after a bit of advice please?? I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is...

Hi all I have a database I built for my employers that is accessed by up to as many as 50 users at one time. It is a relational database. I did a compact and repair this morning which changed the BE from 215MB to 45MB. I went to lunch and came back and the database is now 58MB. Does anyone have...