Search results

Thank you so much for the help guys, I have a slight problem, it says I cannot change or add a record as it is required in the staff table, however, I have checked and the values in the list box exist in the staff table?

The following script is being used to add two items from the listbox into a table using the double click event. I am faced with: 3265: item not found in this collection I am using a pre-written script and modifying it to the best of my VB knowledge:) The two field names are: Session and...

An exam requires 1 invigilator per 30 students. If there are 120 students (a calculated field will work out the number of invigilators). I require one row for each invigilator required.

I want the user to select the number of 'entries' required' from a comboxbox, lets say the user selects 3, after clicking a button , it will add three empty rows to the table. I'm guessing this can be achieved through VBA? Any pre-written script will be appreciated.

Thanks isladogs. I am currently only working on the blocks, once this is done I can assign the classes rooms etc I have found a temporary solution, adding a search field in the cross tab allows me to display more than one value!

thanks isladogs I achieved a similar report to yours, Is there any method to create a report that looks like a cross-tab (with the column heading and row headings and multiple values)

Thanks guys, attached is a zipped copy of the database. Mike- Will try your suggestion The DBGuy - not sure how to concatenate the values in a cross tab

Is there any way of producing a crosstab query with multiple value fields? I'm producing a report that will list the subjects for each day of the week by period. At the moment it is only pulling one set of values from the query. E.g. it is only showing Science and Not maths which is also...

Despite the use of the round function and the textbox control set to fixed to 0 decimal points, still showing ### and not rounding =Round(Sum(IIf([Year_Group]="2013",[A])),0)/[Text73]*100 & "%" :banghead:

DoCmd.OpenReport sRpt, acPreview, , "[First_Name]= '" & List13.Column(1) & "'" And [Progress] = "Me.[Combo26]" Can someone please help me fix the syntax error in this line. I have a form with a listbox and a combo. I have added the second search criteria And [Progress] = "Me.[Combo26]", I am...

OK, so I'm not sure where the error is in this VBA script applied to the after update property of the combobox: Option Compare Database Private Sub Combo6_AfterUpdate() Dim SQL As String SQL = "Select * From [qry_email_addresses] where [Post_Code] = " & Me![Combo6] Me![List2].RowSource = SQL...

I updated the relationship settings and re-opened the report. There is still a split in some data.

I have a report where data is grouped by region. The data for the region at the bottom of the first page is split over two pages. I want to avoid split data on any part of the report. Is there a method to avoid widows and orphans?

realised my silly mistake, was running the query with no value in the combo. works fine now!

works well, thank you all!

It is set to date/time and short date; sample data: 06/09/2018

When adding the date criteria, it returns no results :confused: DoCmd.OpenReport vRpt, acPreview, , "[Name]= '" & lstEAddrs.Column(1) & "' And [WeekEnding] = #" & Combo12 & "#"

I require the report to open using two conditions (one condition using a listbox and the other from a drop down). I am getting a data mismatch error: DoCmd.OpenReport vRpt, acPreview, , "[Name]= '" & lstEAddrs.Column(1) & "'" And "[WeekEnding] = '" & Combo12 & "'" Combo12 holds a date.

Thanks CJ. Do you have an example I can work from?

I have 10 columns in a cross tab query each representing a month jan to oct. I want to add a column to calculate the difference between the numbers in two adjacent columns For example the difference between jan and feb results Feb and march March and april etc