Search results

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

Sorted it....... I think. I have to do a query on a query. Or at least its having the desired affect! I first created a query to bring in all the errors for the particular area concerned, once that was right I then created another query on that one grouping and counting the error type.

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

I am such a newbie! Cheers guys!! For anyone looking and not knowing the answer: messagemore needed declaring as a string and its vbYes/vbNo NOT vbaYes/vbaNo Thanks guys!!

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 Thanks for your response - I had worked out how to do it with trial and error but it is slightly different to the answer above however I will add this to my examples as this might work better than my version. Thanks Carl

Hi - thanks for the reply but this does not answer my query.... I know the listbox has a rowsource - it is the SQL to populate it that I am having issues.... I need the one list box to show: * Errors logged by the user looking. * Errors logged against the team the user belongs to I know I...

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

Mr. B Thank you very much - exactly what I needed I now fully understand what is needed! It comforting to know that I was on the right lines, just not hitting the mark. Thanks again. Carl

Mr. B, I am using Access 2010. Thanks in advance.

Thanks for this Mr. B Can you explain how I take a query/record and split it across controls on the form to edit and update the fields if needed? Thanks Carl

Found an example that can take values from a listbox and pass to another forms controls: Dim strDocName As String strDocName = "frmTest" DoCmd.OpenForm strDocName With Forms(strDocName) .Caption = "Caption set from FormA" .txt1 = Me.List16.Column(0) I would...

Hi - thanks for your response - I would really like to do it without binding the form to record source as I want to know how to do it anagrammatically. Is it achievable? Thanks

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

Managed to solve it with a little help from Google. Please see below for anyone that might be interested. In order to switch between the tabs in vba you need to do the following: DoCmd.BrowseTo acBrowseToForm, "Name of form tab referencing", "Name of form when navigation control...

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 Thanks for your response. I have tried conditional formatting and it worked for 5 minutes and stopped no matter how other DB I tried so found it unreliable. At least this way I get to practice writing VBA, albeit basic and have reliable code to do the job. Thanks again.

Thanks guys - the second option worked a treat.

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