Search results

Hey Guys Just curious is it all possible to create the equivalent of a combo chart in Excel in Access? What I need is a graph showing a certain dataset as columns but also a line showing the average for that set. As an example lets take an exercise programme in a school, each child performs a...

Hey All I have a Student Attendance table and it would be great if I could get some way of automatically determining if the attendance status is Absent - Unexcused for two or more consecutive sessions in order for someone to get in contact with the student. The table makeup is as...

Hey all We have using Bob Larson's excellent SendtoExcel module in our project http://www.btabdevelopment.com/ts/default.aspx?PageId=47 and are overall very happy. I however would like to stop it exporting the AuditTrail field (memo type). Can anyone one help? Thanks

Hey All I am using this http://www.peterssoftware.com/isd.htm in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further. I was wondering could anyone help me make a small modification...

Hey Guys Please see the attached sample database. I am trying to display upcoming events in an outlook style report, I found this formatting code somewhere on this forum. We have 5 rooms available for bookings, the report loads fine for 4 of these but for whatever reason the Board...

Hey all I am currently exploring the possibility of adding another element to our Database. Each of our courses has a scheme of work associated with it, and this is completed on a daily basis by the tutor for each student. These are currently just Word documents we print out. Example. I...

Hey Folks After initially developing our database and giving it to staff for some time they are starting to request things to assist them in their daily routines. What I am finding is not everyone is updating to the latest version when I send a new version out. The backend sits on...

Hey Guys I have a complete brain freeze this morning and cant figure this silly thing out lol See the attached example, I need to populate the Field B on the form from the associated value in SubTable for the data selected in Field A. Thanks

Hey All I hadn't originally envisioned adding this to the database so the structure may not be ideal. But to help a woman out at work I am trying to achieve this. See attached pic There are three main tables. Students, Courses and tblUnits The courses name field on the courses...

Hey Guys I recently deployed our new database onto PC's in the main admin area, out of 8 machines it works fine on 6 but on the other 2 there are different issues. On one machine the girl cant login to the database, for some reason it doesn't seem to be picking up the username correctly...

Hey All I have two ways to enter work placements for students, I need to refresh a subform on one form while closing another. The issue here is the form with the subform may not be open as mentioned above. So is it possible on closing one form to refresh a subform only if it's parent...

Hey All Just cant see the solution to what I believe is an easy question. I am looking to collate marketing data from different areas of our DB into a Marketing Hub. We have to collect various feedback at different times, if a client on a programme completes a course, they give feedback...

Hey all I am recreating some of our official documents as Access reports, and I have them matching perfectly but for one aspect. If the report has 23 records in the detail section it looks the same but any less than this and then the table has too few rows (fields right next too each other...

Hi All Is it possible to clear filters set on a subform using a button on the main form? If so could anyone please provide me with a code snippet? Many thanks Gary

Hi Folks Which method do you use for creating a help system within your DB's? Series of tabbed forms/reports Or compile a help file Any insight would be appreciated. Thanks

Hi Folks I have created an append query to update completed courses to a previous education table. INSERT INTO Education ( ID, [Qualification Name], [Level], [Date Achieved] ) SELECT Courses.ID, Courses.CourseName, Courses.CourseLevel, Courses.CertRecvDate FROM Courses WHERE...

Hi All I am in the midst of developing a new DB for work to replace our old one. The old one allows me to export data in csv format. The problem I have now is there is no easy way (that I can see) to determine which courses were taken under a certain programme. (See attached picture) The...

Hi Guys See the attached pic, I would like to update the Previous Education tab based on values on the Courses tab. The aim of this is to keep a clients previous education upto date in order to append it to a CV etc. Thanks for any help. Regards Gary

Hi Folks I have a form which I am using child/master fields to create a filter (see attached pic) For the date ranges I need these to be >= Start Date and <= Actual Finish Date How can I set the criteria for these two fields, so that when someone picks a date it knows it's from or...

Hey Folks Hope you guys can give me a bit of advice here, a few years ago a developer sold the organisation an SQL server Database. This database is now seriously out of date and is harming our growth prospects. The developer had been contacted to make changes to it but has since vanished...