Search results

Argh! Sorry I really should read my post before I post it. I commented out the line: !fkStudCourID = Me.fkStudCourIDremember you are dealing with a newbie so please be gentle!!!

Hi There, Newbie here, trying to help out a school who have MS Access 2003. I usually program in C+. They want a button to add a new record however I am getting the error mentioned in the title above. The table shows: DailyReportID autonumber (Primary Key) fkStudCourID number (derived from...

Thank you very much. That is exactly the help I needed. I tried to explain to them exactly what you are talking about with dates but they insisted this is the way they want to do things so they are the client ... Thanks again.

Yes, I have had "typical" answers before like the one above. No disrespect meant but I just need an answer to the question: What is the syntax for writing in VBA to increment a number on to the next record? And secondly why am I getting a 3164 error? To explain a little further, this is for a...

num_of_days is defined as a number and the initial value was someone who put in the number 1. I hope that helps.

Hi There, Yes, I am a newbie especially because I have been tasked with updating an old MS ACCESS 2003 database. The school wants to add a record to a students file by clicking on a button which will add a new record but also increment the daily record number. In other words, when adding a...