• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. O

    Using Access remotely online

    Does anyone have any experience running an Access application online. The problem I have is I run an Access database that is central to the running of our school for children with significant emotional difficulties. All was great back in prehistory (February) when all staff and students were on...
  2. O

    Solved Search for all uses of a key in entire database

    Hi I'm doing a bit of house cleaning on a project I use to manage school data. I have come across a duplicate record in my student table (i.e. same student entered twice each with its own auto number PK). Obviously I want to delete one but before doing so I wish to check the PK hasn't been used...
  3. O

    Access Relationships can't see them all

    Hi I have a database that has grown to have over 60 tables and a considerable number of relationships. I want to review the relationships as when I started this project I didn't really know what I was doing and want to go back and check it is all robust. When I go to look at relationships I...
  4. O

    Report with CrossTab query with parameter as Recordsource

    Hi I have a report which I want to use a CrossTab query with parameters as the recordsource. I have found that the only way I can get the parameters into crosstab query is in code (no problem there), but I cannot get the SQL accepted as recordsource. e.g. me.RecordSource = strCrossTabQuery...
  5. O

    Columns with different WHERE clauses.

    Hi, hope this is clear. I am trying to write a query for a school time table database, this is a simplified version of what I am attempting which hopefully gets to the problem. table data is - tbl_lessons lessonID subject dayID unit staffID 47 Current affairs M1 1 1 3 48...
  6. O

    Display concatenated strings as RTF on form text box

    I have a table which has several text fields that I want to concat together in SQL with some formatting but after I have set the data source of text box to the concated string it will not allow me to set the format to RTF. So the text is unformatted and format tags are shown as plain stings...
  7. O

    Random problem

    Hi I have a fairly complicated database, I have about 12 different users using the same clone of the front end accessing the same back end on a server. One user (and only one user) is experiencing several unique problems. At least half my others user are using the same model Laptop with the same...
  8. O

    Select from mulitple Backends

    Hi I have a split database I use to manage my school's timetable. What I want to be able to do is work on new timetable while still being able to access and tweak current one. The easiest way I see to this is to able to switch between different backends. This is effectively what I am doing at...
  9. O

    Report printing too wide for paper

    I know this is much talked about and I have read many threads on this to no avail. I have a Report 280mm wide (as seen on ruler in design view and on 'properties sheet'). The header, footer and content all fit snuggly on this width. No items extend over this width. Page setup is A4 landscape...
  10. O

    New member in UK

    Hi New member, have read many threads on forum which has helped me as a novice greatly in a project I'm doing to build a database for the school I work for. Thank you for all the help you have given me so far. Richard
Top Bottom