Recent content by CindiN

Thanks Judge, I'll try it

Thanks Judge....That's great! I appreciate you telling me where I can look up the info. I sure don't mind researching for answers if I know where and how to look things up, and actually that helps me learn it better so I'll remember the next time. I'll let you know if I do discover the answer...

Thank you Judge, You're assumption of what I'm trying to do is correct. I'll try to figure out what you've written, but as I mentioned above, I'm really not familiar with VB. Someone else wrote this code. Thanks so much for your help. CindiN

Thank Dakota I'm not too good at VB, can you be more specific? Thanks, CindiN

DrSimon, Thanks for the response. I was just about ready to give up on this, so I didn't get specific. I'm afraid I've gone into a zone I'm not familiar with....VB. The code written above was done by someone else. Here's the code now with some changes: Function NameList() As String Dim Itm...

Hi all, I have a form that has a list box with all the employees names and a command button that when clicked, will open a report for each selected employee. Problem is that it only runs the report on the last name selected on the form. Can anyone tell me what I'm missing in my code? Function...

Thank You Missinglinq, Thanks for the info, however, I just keep getting more compile errors, so there must be more wrong with it. CindiN

I have a code, that is giving me a "Compile Error: Variable not defined". And it's highlighting "itm" in the code. I'm not familiar with VB, can someone tell me what I need to change? Function NameList() As String NameList = "(" For Each Itm In...

Hi JavaTurkey, Thanks for the response, I really appreciate it. I tried the dlookup, but it didn't work. Here's what I did: I created a query called "ForEmplCourseUpdateQRY" and put the 3 fields in it from the CourseTBL. I then went to the Form and in the Record Source I added to...

Hi, I posted this in queries, but got no response, so I hoping someone here can help me. Can anyone tell me what to write in the Criteria row of a query that will copy the data from one column into another? In other words, I have 3 columns; "Course_Code", "Course_Desc" and...

Hi, Can anyone tell me what to write in the Criteria row of a query that will copy the data from one column into another? In other words, I have 3 columns; "Course_Code", "Course_Desc" and Training_Units that all come from the CourseTBL. I have a 2nd table that is...

CTOROCK, Thanks for your response, however, I'm not too familiar with VB. I created a new text box in the Page Footer, then put the statement you wrote above in a module. I replaced my information as follows: Dim StrField As String Dim Db As Database Dim Rst As Recordset Set Db = CurrentDb...

Hi, I want to be able to look in calcResults field to find "Completed", then look to the Credits field to find the "#". Then at the bottom of the report give a total of Credits that have a calcResults status of "Completed". I have a text box in the Page Footer...

Thanks Dan, I really appreciate your patience, and I'll work harder at learning VB. You're the best!! [bigcheeks] CindiN

[surprise]Oooooo the answer to my prayers! Thanks Cosmo