Search results

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

This is off the wall but maybe someone out there can help me with my problem. I have several custom reports that are sorted in various ways. What I need to do is compile all my reports into one printable document. More specific, I need the report to look like it is one continuous document...

I have a form that displays account information. AccountName, AccountID, etc. I have attached a subform that displays transactions posted to each accountname. I have a combo box that allows me to retrieve each account and the subform changes to the appropriate transactions for that account...

Thanks David R. I am a little confused but will try to process your post over the weekend. Thanks for your time.

Thanks. Well I thought I was being smart breaking the data into three tables. Maybe not. One table is for the Club members. The second table are additional family members of the club members and the third table are the dogs of the club members. They all are linked by relationship to the...

I have three tables. Each table has a list of names and birthdays. I need to query a list of all birthdays from all three tables. Can this be done? Thanks, Tim