Search results

I have managed to get round it to by doing an append query and attaching the previous weeks data to tblpreviousAttendance and then a delete one to clear the information out of the tblAttendance... It works too... but it seems a little long winded to get something that should be so simple...

parameters Okay I did that I have put [week commencing?] in the criteria under attendance date and have also put [week commencing?] with data type date in the query parameters and have managed to get that part of the query to work but when I try and run it through the report it fails saying...

I am using a cross tab query to collect Late attendances across the week.... this is fine up until I do the report I have the student names down the side and Mon-Fri across the top and an L logged if the student was late against the correct day.... when I run the report though it is only...

I am using a cross-tab query to select information however I want it to only show me information within a specified time period... so before the query runs I want it to ask between which dates... I have tried putting it in the query but it wont recognise [Between which date?].. I have a funny...

I have report to create I work in a school and we are starting to use a database to log lates.... that isnt a problem but they want a report with all the student names down the side and monday-through to friday across the top.... witht here marks for the week against the days... I have main...

I know! Been busy busy... That worked brilliantly Thanks!

I know this is probably obvious but we have several databases at the school I work in and what we want is to have a database with a main screen that has buttons for opening each individual database... but I appear to be failing miserably in the Vb for opening an external database.. Any help...

I have a database that was created in access97 I am trying to transfer this to msaccess2000. I am having problems on the forms screen where instead of buttons labels were used that on the mouse move I have "=fSetFontBold("lblSessions")" and on the click I have "DoCmd.OpenForm "frmSession"...

I dont think I explained properly they need the check box because the certificates are run from the database as well through a report.. and as they arent all done at the same time and you might have to do 56 Effort certificates in the morning and maybe 23 Effort ones in the afternoon, so after...

Ok I have been asked to design a form for certificates for example Attendance, Effort, Attainment with check boxes for people to select depending on the certificates they are producing, that is done the problem I have is the queries I need to run to get it to work! And I'm so confused now...

You are an absolute Gem! That makes things much easier... and I am sure you dont need me to tell you that it works perfectly!

After much searching of the posts on here etc I cant see anything wrong with my code, however no doubt I am overlooking something quite obvious. I have a form based on a query which calculates the totals for each field.This is fine, however now depending on what is in the total boxes I want a...

Its Okay Now Sorry... all fixed... I had an extra table in my query that wasnt needed and it prevented the update query from working properly.... In future will wait till I have fully woken up in the morning before posting messages!

I want to update a table depending on an update query... Basically I have a screen to log Student Certificates... I want them to be able to click a check box yes/no and then run an update query... I have set the update query to update only records with Yes in the check box and in the update to...

Erm........ and how do I call the function in my check box? I thought it was just =the name of the function in the control source.... But obviously not! getting myself in a right mess here

I have a report with some unbound check boxes that I want checked or unchecked but I cant get my formula correct..... I have several check boxes with the same formula just searching for different ethnicity codes on the form... here is one below =IIf([Ethnicity-...

Thank you for your understanding :D

sorry Milo message with regards my diabolical database intended for Fizzio Message in thanks intended for you my sweet pea! :o

Its fixed thanks very much! Thank you milo for pointing out that might structure sucks!! I am aware of this it is diabolical! but am doing my very best on my own here... no training... learnt all on my own, with no help.. been shoved in the deep end without any armbands!:D Please forgive me...

What's the RowSource of the combo? SELECT [tblReason].[Reason] FROM tblReason ORDER BY [tblReason].[Reason]; What's the structure of the table you refer to? ReasonID - Autonumber Reason - Text What's the ColumnCount of the combo? ColumnCount = 1 What's the BoundColumn of the combo? 1