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

Thanks again! I was not sure on the formatting on creating an update query in Access basic but seem to get it now. The only problem I have now is with CSV which I'll open another query :-)

Don't worry I got the answer : DoCmd.RunSQL ("UPDATE Student INNER JOIN Student_temp ON Student.UPN = Student_temp.UPN SET Student.forename = [Student_temp].[forename];") Except I probably need to set all the fields in each table right?

Thanks mate, what does an update query look like in Access basic?

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?

Any idea guys?

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

Thanks Doc Man for your quick response. I understand what you mean if the organisation ID changes, but what if it never changes? Or would it be better to add a foreign key : [Club] - Club ID(PK), Name, Description, Organisation ID(FK) "C01, Yoga, Mild exercise, 01" "C02, Basketball, Med...

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 HiTechCoach, I haven't tried it yet as I don't have another PC. Probably the best way to do it is to uninstall Access from my PC which I don't really want to try. I don't quite understand how it works as it guides you through the setup of how to create a setup but doesn't include the actual...

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

I just realised something during testing, update seems to update the first record in the table and not the record that needs to be updated!! So the way for me to overcome this is to use : .MoveLast Since I'm only using this code to add new records and edit only these records when they are...

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

Thanks that did the trick. Had no idea what IFF was.

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

BTW, just thought I'd add 2 samples to demonstrate how easy the new method is for me : To insert a new record : With rs .AddNew .Fields("Activity_ID") = Activity_ID.Value .Fields("Activity_Name") = Activity_Name.Value .Fields("Club_ID") = Club_ID.Value...

Thanks guys for showing me the alternatives. Many thanks to shadow9449 for this easy code, so much easier than what I had!

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