Search results

I have a club and activities tables which I need to tally in a report for the total number of clubs to be listed on top of the page and the list of these clubs with their activities (including the total activities). I can list the total activities per club but I can't seem to get the total...

Hi, I'm trying to import some data saved in CSV format delimited by comma. In fact it is the same file exported with the same database. This is what I use to import data to my Student table : This will add new records that doesn't exist in the current student table but will not update the...

Is there a way to edit field column headings or highlight certain values like conditional formatting?

I have a graphs that simply looks up a table and counts the number of students present and absent with the following code : The table has a toggle field (yes/no) that I use to mark attendance. This works very well and I use 2 colours, yellow for students present and purple for absentees. The...

Hi folks, I'd like to get some advice based on the above question, is it ok to create records with primary IDs based on time/date/random number/other factors? Here's a case scenario of why this might occur : I have a main database that collates information from several different...

Hi folks, I'm having a tremendous amount of problems trying to align my pie charts properly : I'm trying to move the pie chart upward to give the bottom legend more space, but I can't. It just tries to resize the pie by exploding it. I can move the title and legend somewhat but not the...

Hi folks, I have a continuous form and my totals in my form footer, however the scroll bar is positioned unevenly, like it scrolls inside the footer as well. Is there a setting where I can just scroll inside the detail section? I would create fields outside of the subform but I can't seem to...

This is my query to look up ethnicities of students based on attendance : TRANSFORM Count([Activity Attendance].AttendanceDate) AS CountOfAttendanceDate SELECT [Lookup - Ethnicity Code].Eth_name FROM ([Activity Attendance] INNER JOIN Student ON [Activity Attendance].UPN = Student.UPN) LEFT...

Hi folks, I have this crosstabe query : TRANSFORM Count([Activity Attendance].[Activity ID]) AS [CountOfActivity ID] SELECT [Activity Attendance].AttendanceDate FROM [Activity Attendance] GROUP BY [Activity Attendance].AttendanceDate PIVOT [Activity Attendance].InClass; Where InClass is a...

I'm having some great difficulty with an SQL statement which is very long, I'm not sure if I'm using the right characters to continue the SQL statement to the next line : strsql = "INSERT INTO [Activity Details]" _ & "(Activity_ID, Activity_Name, Club_ID, term, [session teacher], [Number of...

I have the latest version of Access 2007 with the developer edition. I see how this works by creating a step by step installation guide for my database application, however when I burn the files onto my CD, it doesn't include the actually MDB/ACCDB itself. How do I do this? I need to make...

Hi folks, I know that there is an escape module that can be created to determine different errors and print out a custom message instead of the system message like in the following : On Error GoTo Err_End_Click Err_End_Click: Select Case Err.Number Case Else MsgBox ("There is no...

I need to add a bunch of record from table 1 to table 2 provided that they don't already exist in table 2. I originally had an action query to append records from table 1 into table 2 plus some additional info, but this doesn't check for duplicates. I will need to do a separate process to...

Hi folks, I am using checkboxes for a table that I use to toggle yes/no. It is being used in a continuous form however the checkboxes are a little small so I would like to use buttons instead but still check these boxes. Any ideas?

I have a query that looks up a table and also makes count from another table. I'd like to change the field title from "countofxxxx." to something more user friendly, how do I do this?

Hi folks, I'm trying to create a subform that will list weekly attendance for each students of a class. The previous method was Excel where you list the students by rows and the dates by columns. Dates have to be created weekly until the end of its term. I would like to replicate that...