Search results

Hi All Looking for a little bit of help on a strange one..... I have an Access Database (mdb format) that users opening using Access Runtime 2010 (has to be this where I work). Within the main form there is a listview loaded with any number of records. When a user double clicks on the...

Hi Guys/Girls Im having a little trouble and I can not seem to fix it.... i'm tearing my hair out! I have numerous controls on a form including combo boxes and list boxes which are effectively used to build an sql statement based on values. I need to check whether any of the controls have a...

Hi All Hoping someone could help me with this as I can't seem to find anything by Googling... I have the navigation control on my forms (new control post 2007). I have numerous tabs on it. Within the tabs it shows the assigned form. My problem lies within the sub form. When a record is...

Hi Little query for anyone that can help. I have a table that has some details in. one field has an ID in it. In one field I have to add a http link to a file that will be uploaded to a file server. The http field will include: http://www.example.com/filename.pdf. filename.pdf will consist...

Hi I have a form with a text box on where a user can enter a value. Providing that value is in the right format it will change it. For example if the user enters 5 or 5,1 they will get the following output when exiting: 5 year(s) or 5 year(s), 1 month(s). What I need to do is ensure the user...

Hi All I am after a little guidance. I am creating a database for someone and for the first time I am being asked to provide functionality that will allow the storage of documents and images such as CV/Resume, scanned ID documents. Now I know its a bad idea to store the images directly to the...

Hi All I am hoping someone can help me with this one. I am developing an Access database for a company in London in my spare time. I develop these at work also. All the work machines are running XP with Access 2010 runtime installed, obviously my dev machine has full version of Access 2010...

Hi All I have a little problem I am struggling to work out how to do. I think I know the way it should be done (please correct me if I am wrong) but not sure where to start with code: I have an application that logs errors for my department, on the logging form there is a number affected...

Hi, me again! I have the following code that pulls the logging users area, team, manager and email so that it can notify them of the error that has been logged. It all works, which is good however it is sending the email twice!! I have tested the SQL in Query Design and it only pulls one...

I can not for the life of me see what is wrong with this, can someone else?? Dim LogError As String LogError = "INSERT INTO tblErrors (ErrorID, Description, LoggedBy, Date, Module, SubRoutine) " LogError = LogError & "VALUES ('" & mdlDatabaseActivity.ErrorID LogError = LogError...

Hi I have built a query in the design view in Access and the query works but when moving it into VBA it doesn't! I have a form that logs an error and the user can select two areas and two teams if they want. (Second is optional) When they log it I want to retrieve the email from tblUsers of...

Hi I need help with a query and vba if possible..... I need to create a query that selects all from a table where two fields are the values returned in a function residing in its own module. Once I have returned this query I then need to run another query to group and count the number of...

Hi I have a database that deals in logging errors within a company department. As part of this I want to add some trend analysis. In the logging form a user can select two causing areas. it is possible bonds might the team causing in any order or the team causing for both options. What I...

Hi I have a piece of code that when executed off the back of a combo box changing it displays a Yes/No message box, however it isn't doing what I want it to do. User selects combo box value, after update: message box appears asking if they want to add another area/team? User has yes or no, if...

Hi I have a table for logging errors, in this table I have two fields, TeamCaused1, TeamCaused2 and I have the individuals name. I need to be able to pull all the errors that the user has logged as well all those caused by the team the individual belongs to. For example: All breaches logged by...

Hi I am relatively new to VBA and I am gradually building my knowledge, know the basic of what most things do. What I am trying to do now is take a row from a listbox after double clicking it and open another form with numerous textbox and populate them with the different column values from...

Hi I have a DB at the moment that is making use of Navigation control. I guess this is alternative to a switchboard. I have a tab that has features only a certain number of people can use. Restricting the access by user has worked but what I need to do is where they are not authorised it...

Hi I have a DB at the moment that is making use of Navigation control. I guess this is alternative to a switchboard. I have a tab that has features only a certain number of people can use. Restricting the access by user has worked but what I need to do is where they are not authorised it...

Hi I am trying to create a module that changes the combo box back colour based on the value. I have it working using if statements but there is 15 combo box so I just want a module I can reference. This is what I have so far but it isn't working: Public Sub ChangeColour(cboControl As...

Hi I am relatively new to access and can do stuff to an intermediate level. I need to put months and year into a combo box based on the dates in a database. In one column I have the dates which can be anything over the last couple of years. What I want to do is allow the user to select a...