Recent content by brum_rich

plog, thanks for the response although can you clarify a bit further? If I create the third table called assignments with the team ID and Process ID then how do I pull in the ID data from the Team & Process Data tables? For example for each Team ID I need to be able to allocate one or more...

I have a table (tbl Team Info) which contains names and codes for teams within my business (>400 records) and another table (tbl Process) which contains a list of high level tasks (30 records). I need to create something where for each team name 9in tbl Team Info) I can map them to the tasks...

In my database I hold employee details and each record has a unqiue employee reference. In addtion I also hold the reference of the employee that each employee reports to (i.e. manager). I would like to be able to create an organisation chart that show reporting lines (see attach pic for...

I need some code to close a form once i frmSelectEmployee contains a combo box and when the user selects a value from the list they will click on a command button to launch another form frmEditEmployeeDetails which displays the related record from the combox box. On the command button I am...

Thanks for the response. Soted the combo box...cheers Fine with the Docmd,open form code although not sure how I link this to teh Where" and "Filter" options you refer to?

I have created a form which contains an unbound field which is setup as a combo box. I want to display concatenated values from two fields (Surname, Forename) from tblEmployee in the combo box from which a user can select Once the user has selected the record they want to view there will be...

Do not have any forms yet - is there anyway that I can enter this validation against the fielld(s) or table?

I have two tables that are linked by a common ID tblRole contains a field called Vacancy which is set up as a Check Box (yes/no data type) tblEmployee contains a field for Surname. I would like to set some validation to stop the values in these fields being populated at the same time. For...

I am trying to link data from Access to Excel. I am using the following code to declare the Excel application. Dim myXL As Excel.Application Dim myWkb As Excel.Workbook Dim mySht As Excel.Worksheet When I run the code I get a compile error stating user defined type not defined. I have used...

I need to display a value from a table in a text field on a form based on another text field on the same form. The table has records as follows: Month/Year xx Month No xx Year No xx Month ID (xx shows break in columns) Jan-06 xx 1 xx 2006 xx 24 Feb-06 xx 2 xx 2006 xx 25 Mar-06 xx 3 xx 2006 xx...

Matt Thanks for the reply. However, that does not quite return the value I wanted. I need to display the field ID - for example in your Test56.mdb you have a field ID number 1-6. This is teh value that I would liek to return to the text box. So for my example... txtPreviousMonth would...

Return value from a table based on a text field (more help required) I have created a text field on a form that uses the DateSerial function to return the value of last month e.g. Jul-06. I have a table that contains months (e.g. Jul-06, Jun-06 etc) and a corresponding numeric value (e.g...

I have created a text field on a form that uses the DateSerial function to return the value of last month e.g. Jul-06. I have a table that contains months (e.g. Jul-06, Jun-06 etc) and a corresponding numeric value (e.g. 1,2,3). I have another text box on the same form that I want to display...

Many thanks mhartman

I have used the following function to return the date of the previous Sunday in a text box when I open a form.. =Date()-Weekday(Date()-1) In a different text box I would like return the pevious month based on the date in the text box. For example the above function would return date 20/08/06...