Search results for query: *

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...

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, 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...

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...

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...

I have a query that includes a multi-value parameter and I'm trying to figure out how to create a separate report based off each value. The query lists courses taken by each employee, and I have a parameter that allows the user to type in multiple employee names. So in the parameter box...

Is there a way in a query to say "No Duplicates" in the criteria section? Thanks, CindiN

Is there a way to say "No Duplicates" in the criteria row of a query? Thanks, CindiN

How can I create a text box on a form that will use the result of another text box (on the same form) AND the result of a control (from another form) to look up a query and enter the result from these two other criteria's? Problem is that the query is not the same query used to create the two...

I have a table of employees. I have a table of courses by level, category and courses i.e., Level 1, (Category) Human Resourses, (Courses) Performance Management & Compensation and Benefits. Then I have a table that shows each employee, the courses they've taken and if they passed or failed...

Hi guys, I am trying to create a form or report (doesn't matter which) that will show my list of ALL classes, and then allow me to select an employee to see if they've taken this class or not and if they passed. I have a ClassesTBL, EmployeeTBL and Pass/FailTBL. I have even been able to create...

I was just wondering if anyone has created a boiler plate type document using just the Office Suite products, without getting into VB or XML? I'm trying to create a marketing brochure, in which the users can select from a menu the paragraphs they want inserted into their marketing document...

Hi, I have a spreadsheet(Sheet 1) that substracts a Budget total from the $'s spent(Sheet 2) to get the Budget Remaining. Each time a new $ amount is spent(Sheet 2), the cell(in Sheet 2), deletes the old amount spent with the new (which is what I want it to do), therefore giving me a Budget...

I have always been taught that it is better to make many smaller tables and relate them than it is to make one big table in Access. Is this correct? Why? Thanks, CindiN

TL ... I think I did the code the way you said, but this is what it looks like now. Did the system change things around? Now it doesn't search correctly even on one keyword in the form. WHERE (((PositionTitlesTBL2.PositionTitle) Like "*" & [Forms]![Form2]![txtPositionTitle] &...

Hello! I have created a form in which a user can type a keyword and the database will search all locations, problem is when user hits Enter or Search button, all or none of the records are returned. I have a table, with relationships built befween them so they can see charts and stuff. I knew...

I have a DB of Job Positions and I am trying to create a form that the users can enter keywords in multiple fields, then hit a search button to receive a report with all the Positions that match all their criteria. I've tried binding the form to the Table, the Query and not binding it at all...

I have a DB of Job Positions and I am trying to create a form that the users can enter keywords in multiple fields, then hit a search button to receive a report with all the Positions that match all their criteria. I've tried binding the form to the Table, the Query and not binding it at all...

I am working on a Form in which I would like to have an option group which holds 4 check boxes. I would like the user to be able to select more than one box, which would in turn update the table with option values 1-4 respectively. Each of the 4 check boxes can represent a different field in...