Recent content by A10Instructor

TheAceMan1, Thanks for the helpful info...exactly what I was looking for. Is there a quick reference guide or listing to all VBA functions that I can download? I am not extremely knowledgeable in all of the functions, commands, etc that VBA has to offer. A10 Instructor "The World is My...

All, Been looking through the help files, books and these forums and can't find an answer to my question/need (or I'm too dense and missed them altogether). I have a form that the user selects data from combo boxes. When the user clicks the 'Continue' button, this data is added to table...

TheAceman1, Thanks for the info and the great tip. I'll try to keep that in mind for future issues. I apologize for not being as thorough in my original post about what data types I was using. I'll try to be more thorough next time! Thanks A10 Instructor "The World is My Classroom

TheAceMan1, Thanks for the help and quick reply. Out of curiosity, why did the removal of ' (Val ( ' make everything work when that same expression is located on last two lines? Thanks again for the help! You are a great wealth of information. A10 Instructor "The World is My Classroom

TheAceMan1, I waslooking at the table that the code you furnished me inputs to. Three out of the five fields work great. The crscode and pdscode fields do not populate as the other fields do. I did some playing around and noticed that if the data for those fields begins with a...

TheAceMan1, Thanks for the quick reply and the code. I really appreciate it. I was really struggling with this one and the code works exactly as I wanted it to. Thanks for the help A10 Instructor "The World is My Classroom

Hi, Been away from access for a while and need some help with unbound text boxes. I have a form in which the header has several combo boxes that allow the user to select certain data (for example "courses"). Once they have made a selection, it then populates a corresponding unbound text...

Remou, That is essentially it. I'm not sure wether this should be a report or just another form that pulls from other tables? I'm new to access and am starting to get a handle on things but this is new to me. I also want to set up a loop so that if multiple certificates are needed with...

I have a class certificate that is currently printed on card stock and all pertinient data is typed onto it one at a time on a typewriter. I wish to use access to print student name and class info using a computer but do multiple students at the same time (ie enter 4 students and print all with...

Strongm Thanks for the link. It helped a lot A10 Instructor "The World is My Classroom

Hello, I have several cells on sheet 2 that are linked to cells on sheet 1. I have a macro that will clear the contents of those cells on sheet 1 and display an empty cell. However, the linked cells on sheet 2 will display the number zero. Is there a way I can make the linked cells on...

Skip, Thank you very much for the quick response and the suggested code. It worked like a champ. Thanks a whole bunch A10 Instructor "The World is My Classroom

Hello, I have an excel worksheet that has a cell (A4) that contains the text 'AUGUST'. I wish to use a macro, that when ran, reads the contents of cell A4 and then replacees the contents with the next month. For example, if cell A4 currently states AUGUST, when macro is ran, cell A4 will...

Missinglinq, You have a valid tip/suggestion. Your method would work just as well. I created the form in the manner that I did because I want the user to verify the data he/she selected prior to continuing onto the next phase which is printing the certificate. We normally print...

TheAceMan1, Thanks for the suggestion. Once you prompted me about forgetting the other part of the code, I figured out what I needed to do. Your reply confirmed and validated that I was on the right track and that it indeed did work. Thanks for the help A10 Instructor "The World is My...