Search results

I have a database that has a linked table within it. I need to enforce referential integrity on this relationship but it won't allow me too. Does anyone know if this can be done? If so, could you possibly point me in the right direction Thanks

Hello everyone I am wanting to pull out only the month part from a date field, 11/10/2005. In the query I have made an expression to pull the month, eg 10 for October. I need to convert this number of the month to the Title of the Month. I made a combo box on the report based on the...

Hello there I have a problem when I try to open a report from to text boxes. It comes up with the Error 3079 which relates to the SQL. I have attached the sql that show's in the query, can anyone point in the right direction as to what is the problem: SELECT tblSchoolActivities.[Activity...

Hello I have created a cmb on a form which should activate a report eventually. I have tried to do SQL & VBA, but neither seem to work. I know the selection from the text box is getting to the report, but when the report is open I get all of the records in the db, not what I have asked in my...

Hi I have looked at the forum to see if I can find my answer, but it doesn't seem to be there. I have 3 tbl SchoolDetails, School Activities and Keystages The values from each table SchoolDetails ID & School Name SchoolActivities: Activity Title, Date, Start Time, No of Workshops...

Can anyone help with the following vba: I have a form with numerous reports that use the values from 3 text boxes. I now need to create more reports but this time based only on 2 of the values. The text boxes are called txtDateTo, txtDateFrom and cmbActivity. I now only need the date to and...

A form on my database has suddenly changed two date txt boxes to format american and left the third at UK. It is completely confusing the data, can anyone help please :eek:

Hello everyone Can anyone help pls. I am building a report and grouping the Start Dates of activites by month. I want the month to be used as a header and then to detail all of the activities below that section. I do not need to see the Month title when no activites are relating to this month...

Hello I am trying to get a 2nd combo working from the first . I have a table called Keystage (tblKeystage) and I have also named my 1st combo cboKeystage. then by following the vba below I created another 6 tables with corresponding names and combo's. Private Sub cboKeystage_AfterUpdate()...

:confused: Hello I am trying to get a 2nd combo working from the first . I have a table called Keystage (tblKeystage) and I have also named my 1st combo cboKeystage. then by following the vba below I created another 6 tables with corresponding names and combo's. Private Sub...