Search results for query: *

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

Dan....I'm sorry, but I'm not too familiar with VB or SQL. I am not currently using a form. So I created one, put all the fields from the Worksheet2QRY on the form, except for Employee_Name. Created a list box for the Employee_Name field, then created a Command Button, where I put your DoCMD...

Thanks Cosmo....That's great! I hate that parameter box, wish you could create a drop down list in the parameter box and be able to choose multiple names. But that's another day another problem. Thanks so much, I really appreciate your help! CindiN

Thanks 426Hemi, It took some doing, and some strange rearranging, but it works! I really appreciate the quick response. I turned it in this morning, and they're very happy! Again, I thank you!! [bigcheeks] CindiN

I posted this in Reports Forum without any response, I'm hoping to get some assistance here because this forum gets more hits. Please forgive me for doing this, I know it's bad, but I have to turn this in tomorrow morning. I have a query that includes a multi-value parameter and I'm trying...

If you're responding to this, thanks, but I got an answer on the Microsoft Knowledge Base, #210530 if anyone is interested. However, it presents another problem in printing a report for each employee name. I posted a question for this in the Reports Forum. If you can help, I appreciate it...