Search results

RuralGuy, I am really not sure there is an SQL statement with what I am doing. I have the table that is the record source for the query, then the form is based on the query. In the Active (Yes/No) field of the query I have an IIf statement that chooses wether to show active (Value of -1) or...

I have a form that is based on a query, on the form there is an option group with two options (show all and show active). This option group is the criteria for the query the form is based on. My hope was to have a requery on the after update of the option group and have it show approptiate...

Thanks, is there a way to make it work without basing forms on queries? I not saying I don't want to do that, I am just trying to learn other options also. In the mean time I will give it a try.

I would like all of the text in my database to appear in upper case. I used the > symbol in the format of all controls and in my tables also. However, on my form's lookup combos it doesn't work. When I click the dropdown it shows all selections in upper case, but after I select it turns into...

Well I found my problem, I had messed around with an activeX calendar, then decided it was very buggy and removed it and all files associated with it. However, I checked the references in VBA and it was still listed, this actually stopped all of my code from running properly even though I can't...

No it doesn't work. I have two columns, the combo is bound to column one which is the RankID field (the autonumber that I don't want to show), column widths are set to 0";1" so the user only sees the second column witch is the Rank column that I want the user to see. I can't even get any of...

When I type =[cboRankID].Column(1), access automatically converts to this; =[cboName].[Column](1)

Rich, did you mean to put that in the label (or textbox) or are just correcting the VBA code that ShaneMan posted.

I was unable to get the code to work in the control source of the text box, it kept changing my code by putting brackets around it. I think I will just use the VBA option, thanks again.

I am trying to avoid using too much code since someone with even less experience than me may have to work on this database in the future. This does work but is there a way to do it in access instead of code so it is easier for someone down the road to figure out? I do appreciate the help so...

This is pretty much what I was doing, but since my combo box bound column is acutally the autonumber instead of the rank abbreviation that goes with it, I am passing that to my label (or textbox) instead. The user sees TSGT in the combo box but it passes the number 6 since that is what they are...

Well, that would explain my problem then. I was trying only use the table as my record source since all of the data I need for this form is in one table with lookups to other tables (kind of). Anyway I see how using a querry would fix it! Thanks Now my curiosity has me wondering if there is...

I am attempting to place a label on the top of a tabbed form and I am having a problem. Here are the important parts of my database: tblInstructors InstructorID Autonumber PK RankID FK to tbl Ranks LastName FirstName tblRanks RankID Autonumber PK Rank I have a tabbed form with a combo box...

I need to build a form based on the following tables: tblCourses CourseID Prefix (Part of composite PK) Text Number (Part of compoite PK) Text Title Text Video Number Media Text Type Length tblUsers UserID PK Autonumber LastName FirstName Office Phone EmployeeNumber tblSession SessionID PK...

Thanks for the advice, it is nice to have someone with your experience helping me learn. I think I have everything I need FOR NOW, but I am sure you will see me needing help agian in the near future. Thanks again!

I was in a hurry typing that and didn't mean it that way! I had posted regarding this database before and was told I was going TOO FAR with normalization??? I was trying to say this is as far as I knew how to take it. Anyway thanks for helping! I discovered the root of my problems was I had...

Sorry if it came accross that way, that was certainly not my intent. What line in my post gave you that impression? I am certainly open to suggestions and help of any kind.

I see several people have looked at this post, but no replies! So now I must ask is this really that complicated that no one knows how to do it, or is it so simple that no one wants to bother with helping me? Do I need to include more information or clarify my question? I did reseach on this...

This will be a definate newbie question but here it goes.... I am new to Access and fighting my way through building a database to learn. I have broken my tables down to as normalized as I am willing to go, mabey a little further than needed. So now I have several tables that are related. I...

That was one of the ways I tried but I didn't think it was right, I guess it seemed too easy! Thanks for all the great info.