Search results

What now? You may have duplicates that are not true duplicates because they contain unique information? OR- you only want the top ten entries for that company. if they have more entries, you don't want them?

Access Version? what version of access are you using?

My employer had used Access 97 to store a database for a consumer relations department. The database crashed often, would not let more then 10 users in at once without crashing again. It held thousands and thousands of records, and bogged down horribly The entire database corrupted when someone...

I was looking here in this message board for a beginners explaination of how Cascading combos work. I didn't find one... but I did find this link to this page. Very cool for beginners (like me!) http://www.fontstuff.com/access/acctut10.htm Cascading combo interdependent combo combo boxes Drop...

This was what finally worked- part of it my fault I wanted to come back and post what worked and why. I have learned so much from this board it is not funny. Learning from the mistakes of others is one of the things that has helped me along 1.) I had to change my subform -I had my sub form...

This may work It applys a filter... which does not allow my user to use my command buttons to go to the next record... however... Maybe I can work something in the command buttons for record navigation. for "new record" commands, I can turn the filter off and then add the new reocord... (if...

How it's used. My users are entering interactions they are having on the phone. The current record is displayed on the form On the bottom of the mainform, there is a subform (continuous form) of all the entries they have made previously. So- at a glance, they can see their stuff. If for some...

Hummmm No more error messages- but it doesn't work either. Just sits there. Ah, having the button there will just encourage my users to be lazy anyway.......... :p I'm going to keep at it. Thanks for your help!

You may be on the right track I gave that a shot and I got "data type mismatch in critera expression" The combinedmain field holds an autonumber. Any other thoughts?

You want the page number to show up on the form? or only when you print? I assume you want to print your form?

I posted before, I had not gotten a response Here is my code : CMID = Me.CombinedID Forms![FRMMAIN]![CombinedID].SetFocus DoCmd.GoToRecord acForm, FRMMAIN.CombinedID, acGoTo, CMID This is on the onclick event of a command button on a subform. the plan is to make the main form "Frmmain" to jump...

Heres my malfunction I just need to know the syntax. what am I doing wrong ? This is on a command button on the subform CMID = Me.CombinedID Forms![FRMMAIN]![CombinedID].SetFocus DoCmd.GoToRecord acForm, FRMMAIN.CombinedID, acGoTo, CMID The field "combinedid" is the same field/info on both...

I am a beginner to VBA, I know in general what to do (I think)- I just don't know the syntax. I have a main form called "frmmain" I have a subform called "history" History is a continuous form, showing all the records Frmmain has access to. Frmmain only shows one record at a time. I would...

Found it tmpStr = Trim(tmpStr) tmpStr = tmpStr & sChar 'build it That wiped out all the spaces too. Thanks!!!!!

Yes yes it does!!!! thanks! Now I just to get all the spaces out.. I did it by adding trim() somewhere...I can't remember where I put it ....

whoops sorry- quick reply there- the last was a reply to the first poster

I don't know.... I took code from the board here and modified it : Dim tmpStr As String 'builds string where CR exists Dim sChar As String 'holds character to add Dim counter As Byte 'std counter If InStr(1, [sorthotelinfo], Chr(13)) <> 0 Then 'only loop if a cr is in the field For counter...

I want to have a user copy and paste a block of text into a text box on my form, and then VBA would pick out the useful information , and place it in the various feilds in the record for the user. (so they won't have to read the text and pick it out manually) The information generally is in...

Import errors still- any other suggestions? My mock up at home works. Back here at the office, the real thing still gets import errors with a temp table. I can't see what is different. (Although I only attempted it with 1 column at home, and I have 3 columns that are giving me import errors)...

I was seriously considering placing the dummy row 2 in excel with "AAA" and then hiding it. Unfortunately, my users tend to be skittish and confuse easily. They would wonder why row 2 was missing, and then everyone would have to come ask..... If they didn't already make up some odd reason out...