Recent content by tmulrooney

I think I am understanding it. So my code has told my combo box, go get the data. Then it says to pull my data in the format it is defaulted to, as in Order By Projects.ProjectsNo Now I am going to insert a line that says something like: My user has check the option group option two. The...

I kinda understand the two options. Can you give me a little more detail on the first option. The option gives a value of 1 for by number and a value of 2 for by name. So How do you in the source line change the order by property? This is my current source text: SELECT DISTINCTROW...

I have a form with a combo box at the top. This box has two columns. Next to the combo box I have an option group. The option group has two choices. Option 1 (By Name) Option 2 By Number. I would like for one of this to be default sort order. I would like the user to be able to click the...

I like the case function but I am new to modules. I have not been able to get it working. Is this the exact code for the module? fSomeFunction(field as Integer) Select Case field Case 1 fSomeFunction = "Active" Case 2 fSomeFunction = "Not Active" etc... End Select...

I have a point group on my form which stores a value into my table. It is setup to store 1,2,3,4,5, or 6. On My report I would like to show the results. BUT, instead of showing the number, I would like for "1" to show "Active" and "2" as "Not Active" and so on. Can I write an IF Statement? If...

Thank You, Thank You, Thank You! It is working!

Your example is very similar to what I am trying to accomplish. I am going to play around in it for a little while. Thank you!

I am feeling like a complete"re-re" I am not sure why I cannot understand this. In my employee table I have EmployeeID Lastname FirstName In my Projects table I have ProjectID ProjectNo Projectname In my junction table I Have EmployeeID ProjectID My relationships are right. How can I make...

I have an employee subform using the employee table as its source. Should I link the employee subform to the junction table? If so, I don't have any employee information in the junction table. How do I copy all of my data from "employee" and "projects" into the junction table?

The new setup is working but I am back to the same problem I had before. Everytime I assign an employee to a project it stores another entry in my employee table. I really don't care except when I open my employee form to edit information about each employee I now have several entries for one...

I am on the right track. Thanks so much. I have to figure out how to setup a form to pick from the employees and assign to the projects. The tables are linked and look right. Thank you so much! Tim

In my "Employees" Table I have: Employee - Autonumber Lastname - text Firstname - text In my "Projects" Table I have: ProjectID - Autonumber Projectname - text Projectnumber - number In my juntion table "projectjunction" EmployeeID - Autonumber? ProjectID - Autonumber? Do I make these...

I have created two tables. One is call "employees" the other is called "projects". I setup a form that links the two tables by setting the master and child fileds to the same field. The form is working correctly. AS I scroll through my projects I can see the assigned employees to each project...

I have a report when opened from my menu it calls the form "Selecthandler". The form has a combo box which references back to the table where all the handler info is stored. The Table is called "Registration" I have a command button which contains the code: Dim stDocName As String Dim...

I want to make a report with several subreports. My report file will call back to a form which will have the parameter box. For example: My form will have two combo boxes side by side. The first combo box the user will select from a list of data. The second combo box will be a sort order...