Recent content by Wong

Linked Table Relationship Problem Thanks for replying Pat I have actually found some info which you had replied to earlier, so much for having a good look!! I have done as you suggested and imported the tbl from the FE into the BE and tried to create the 1 to Many relationship there...

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

Hi ScottGem and RuralGuys Thank you for the info, can you please give a bit more details - Sorry I have attached the vba and sql I am using. I know that the text box is getting to the report because the Title is correct, but it's not filtering to the Activity Title. If you wouldn't mind...

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

I have tried a Totals query, but it only totals the values for the Keystage ID and not for the actiitiesID, am I doing something wrong!

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

Thanks for your reply. I have had a good look at the Search function and this how I was directed to adding a further 6 tables. Originally I had 1 table for Keystage, 1 for year with the ID from Keystage in this table. Unfortunately this set up did not work. I will have another look Thanks...

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