Search results

Why can't Access do what I want it to do and not as I code it to! Thanx! That of course worked like a charm.

Any help on this would be appreciated. I still cannot get this form to work properly. I am trying to have the combo box pull a specific claim record and it's related fields, then be able to change those fields. Every time I save it though it overrides only the first record and not the...

The update is triggered by a save record button that the user will press after they have filled out the information.

Thanx David. That worked for those two issues. I am now seeing another problem. When a record is selected and the fields updated by the user, Access is updating only the first record in the query and not the record that was selected. How do I fix that?

I am trying to have a user update several fields when a particular record is chosen. I set up a multi-column combo box for the record selection and it populates the other fields just fine when there is data in them. My problem is that if the field is blank I get a runtime error "cannot be zero...

Thanx Paul, I had started with that but couldn't get it to work, went back and did it again and it's working. Apparently I messed up the function the first time I typed it out.

I have data in text field as "yyyymmdd" I simply need to convert this to "mm/dd/yyyy". I have looked at Access Help, and through these forums. I can't seem to make anything work. I'm sure it is something simple that I'm missing. Can someone please enlighten me.

new phones just annouced at Apple's WWDC. I know several people with them and they all love theirs.

Chris, Thanx for the reply. I tried creating a sub-report. Came across two problems. 1st, I am apparently creating it wrong because I am not getting all the results. Using your example I am actually only getting the last number referenced. 123 John } 124 Jim...

Acer recently annouced that they will offer Google's Android operating system in their netbooks. More players are joining the field. Microsoft needs to wake up and realize that they won't be able to corner the market much longer.

We should find out next week about the new phones. I will be getting mine when the new ones come out. Rumor has it the camera will be at least a 3.2mp with autofocus, 32g, more ram, faster processor, etc, etc The new software is a free upgrade to iPhone owners. Only iPod Touch owners will...

I have a report that lists rejected claims along with the reason they were rejected (by group). What I want to do is at the end of each group to have the claim numbers listed in that group appear horizontally as one long string. From searching the forum I figure I'll need to code this but I...