Search results for query: *

Now that i read what you wrote i got it to give me multi selections (sorry about that ) the second thing is. its not showing Both Columns. how do i get that to work.

ok the message went away. i did something wrong. it works but it doesn't show the other feilds it just show the RiskCodes it does show the Risk meaning it only show the one column not both. now do i fix that. In the table i have the Risk code ex h100 and the next column i have what it means...

in using 2003

Im getting this message when i open up my report. Now its working I still get the message but it works. its a list box not a combo. The problem im having is that its not showning the muti selection its only showing 1 selection

Run-time error 2455 You entered an expression that has an invalid reference to the property itemsselected thats what im getting with the last set of codes you posted

The problem with me and the codes is that i dont know where i have to make my changed and where i have to place them.

@dhookom yes. I only want what is selected to show.

these comments of syntax are not working the way i was thinking. Now I might have my form setup wrong and if i do let me know. ok I have a form with a lot of stuff on it. Now what i need help on is a Listbox that shows the contents of a table called Riskschild in Riskschild i have 3 fields...

Gamm.... do I have to use all 3 of those or do i grab of of the 3 i tried using them and they didnt do anything. I think im doing something wrong

(Gammachaser)I tried that and it didnt work. ok First im not all that great in Access so I might of set something wrong. I have a combo box on my form the form is called PNchild. now i have a table called PN1224, in that table i have a table called Riskid Now I have another table caleed...

The combo box is tied to a Table that has all the information in two coloms. I want what ever they click on to show up on my report.

Hey I have a form that has some calculations in them and combo boxes that you can select multiple things. How would i get the calculation to show up on my report? And how would I get the combo box selection to show up on my report?

...Or IsNull(wghtInLBs) Then Exit Function wghtInKG = getKGfromLbs(CSng(wghtInLBs)) If ageInMonths >= 36 Then yearOld = ((year * 12) + months) / 12 End If Select Case ageInMonths Case 0 To 3 getKCAL = (89 * wghtInKG - 100) + 175 Case 4 To 6 getKCAL = (89 *...

I Builded a Access Form that users have to input information in feilds. I want the information they put in to generate a report. Do I have to put something in the Form to transfer it to the report or do I deem the report to go get the information from the form I have some Combo boxes that are...

wouldnt the only way to have that would be to have a birthdate field?? If a child was born 2 years and 3 months ago how would the computer differentiate from a achild born 2 years and 5 months ago??

...If ageinmonths > 35 Then ageinYears = ageinmonths \ 12 End If Select Case ageinmonths Case 0 To 3 getKCAL = (89 * wghtInKG - 100) + 175 Case 4 To 6 getKCAL = (89 * wghtInKG - 100) + 56 Case 7 To 12 getKCAL = (89 * wghtInKG - 100) + 22 Case...

...the right answer please take a look Option Compare Database Option Explicit Public Function getKGfromLbs(lbs As Single) getKGfromLbs = lbs * 0.45359237 End Function Public Function getMetersFromInches(inches As Single) getMetersFromInches = inches * 0.0254 End Function Public...

...hghtInCM = getCMetersFromInches(CSng(hghtInInches)) Select Case status Case 0 To 1 getAKCAL = (9.99 * wghtInKGs + 6.25 * hghtInCM - 4.92 * ageinYears - 161) + 300 Case 2 To 3 getAKCAL = (9.99 * wghtInKGs + 6.25 * hghtInCM - 4.92 * ageinYears - 161)...

the problem is i cant find any dups from the other coding i addes exstra letters to them.

Hey what does Compile Error Duplicate Declarartion in current scope means