Search results

Hi I have a form with a command button that opens another form (DoCmd.OpenForm "from"). When the new form is closed all the forms behind it have become un-maximised (is there a correct term for that?) As standard on all my forms in the "onload" event, I include a DoCmd.Maxmise. Running the...

Hi I have a project I use most days, I haven't made significant changes to it in a while but today it's gone odd. On launching while it opens the main form it gives the error "File Not Found" and goes into debugging mode and the main forms code window opens. However, no line of executing code...

Hi I have db that produces my school's timetable, we are a specialist school and it changes a lot (almost weekly, it drives me nuts). Each time I make an amend I have a button that I press to output all the timetable documents (of which there are over 100) to PDFs on a shared drive, some are A3...

Hi when I run this code on an open Form the unbound text box called "txtBox" gets filled with the word "bob" Forms!frmMyForm!txtBox = "bob" but when I run this on an open Report Reports!rptMyReprt!txtBox = "bob" I get the error "Argument not optional" (also VBA editor changes "Reports!" to...

Hi I hope I am allowed to ask this on this forum, if not apologies in advance. Some years ago I created an Access db for the school I work for (this forum being my go to support - many thanks). The db has now grown in complexity and the school has grown in size and diversity. The basic problem...

Hi Firstly apolgies for the rambly-ness of this post - I not really after solutions just general pointers and links to materail that could help. I have (by my standards) a complex database which is split between a FE and BE, it has about 30 users who all have a copy of front end and access the...

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

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

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

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

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

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

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

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

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

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