If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mensaje de prueba
Saluti a tutto il team
Darly "George Walsh" escribió en el mensaje ... I want to understand how to use VBA code to gain programmatic control of the individual records of a field of data from a table in Access. In my pursuit of this knowledge, I have been reading the Access help topics relating to the recordset object - and I have been attempting to experiment with code using the Visual Basic code editor using a practice database I have created. I have a ToDo table with a date field representing the due date of the particular project described by the other fields associated with that record. All the records from this table are displayed in a datasheet on a sub-form. A main form contains the sub-form and has a field that displays the current date. I want to write code that executes upon the event of displaying the sub-form which evaluates the number of remaining days before the deadline, then I would like to have the specific records in the ToDo table which still have remaining days to go before the deadline - display with a background color that graduates from yellow to orange and eventually to red as the remaining days value becomes smaller. I used to write QuickBasic (VB) code, so I am familiar with the elements of VBA, generally. I also have lots of example databases and of course - the examples in the Access Help feature. Still, I am having problems. For example, I have recently been unable to debug the code I write by pressing F8. Sometimes it works, and in past efforts I have been able to use debug print and thereby display the values of my variables in the immediate window as my code executes. But sometimes the debug feature does not work; it's probably something I don't understand about the debug process. Is there some special requirement before the debug feature works? For example - does it only work when you write a Function? Also, if I use the Me.recordset command to reference the recordsource of the sub-form, how do I get the count of the number of records, and how do I display the ToDo date field's value for each record? Is there a good reference for learning the Access programming environment and how to gain a more refined control of the Access table data via writing code? Even with all the examples from other programmers and Access help, I still find there is such a vast amount of data to master about Access VBA Code - and that each piece I master takes a painfully slow process to acquire. Frequently, examples don't work, or require some unique adaptation that itself requires specialized knowledge to implement. It is especially distressing because I can do anything I want when I am using Microsoft Excel, I would like to have the same degree of expertise with Access. Why is Access so hard to master? Or is it? I know I could benefit from someone with expertise who is willing to set me on the right course and give me some direction. I am interested in knowing how others have gained their skills. Are there formal courses that are of benefit? How about a good book that doesn't reiterate all the simple basics about tables, queries, forms, reports, etc. I have already mastered the basics; it is the code writing that I specifically want to improve. |
#2
|
|||
|
|||
Beginner Using VBA Code Recordsource Object
I want to understand how to use VBA code to gain programmatic control of the
individual records of a field of data from a table in Access. In my pursuit of this knowledge, I have been reading the Access help topics relating to the recordset object - and I have been attempting to experiment with code using the Visual Basic code editor using a practice database I have created. I have a ToDo table with a date field representing the due date of the particular project described by the other fields associated with that record. All the records from this table are displayed in a datasheet on a sub-form. A main form contains the sub-form and has a field that displays the current date. I want to write code that executes upon the event of displaying the sub-form which evaluates the number of remaining days before the deadline, then I would like to have the specific records in the ToDo table which still have remaining days to go before the deadline - display with a background color that graduates from yellow to orange and eventually to red as the remaining days value becomes smaller. I used to write QuickBasic (VB) code, so I am familiar with the elements of VBA, generally. I also have lots of example databases and of course - the examples in the Access Help feature. Still, I am having problems. For example, I have recently been unable to debug the code I write by pressing F8. Sometimes it works, and in past efforts I have been able to use debug print and thereby display the values of my variables in the immediate window as my code executes. But sometimes the debug feature does not work; it's probably something I don't understand about the debug process. Is there some special requirement before the debug feature works? For example - does it only work when you write a Function? Also, if I use the Me.recordset command to reference the recordsource of the sub-form, how do I get the count of the number of records, and how do I display the ToDo date field's value for each record? Is there a good reference for learning the Access programming environment and how to gain a more refined control of the Access table data via writing code? Even with all the examples from other programmers and Access help, I still find there is such a vast amount of data to master about Access VBA Code - and that each piece I master takes a painfully slow process to acquire. Frequently, examples don't work, or require some unique adaptation that itself requires specialized knowledge to implement. It is especially distressing because I can do anything I want when I am using Microsoft Excel, I would like to have the same degree of expertise with Access. Why is Access so hard to master? Or is it? I know I could benefit from someone with expertise who is willing to set me on the right course and give me some direction. I am interested in knowing how others have gained their skills. Are there formal courses that are of benefit? How about a good book that doesn't reiterate all the simple basics about tables, queries, forms, reports, etc. I have already mastered the basics; it is the code writing that I specifically want to improve. |
Thread Tools | |
Display Modes | |
|
|