Recent content by texasalynn

shouldn't the "+" be a "&" I'm still learning but that looks suspect

Solved Ok - I figured it out :D Attached is the end result

I have a form that I am trying to setup to click on the button and it opens dialog box to select file, then it transfers/appends the data into an existing table. I got the button to open the dialog box and select the file, but nothing is being added to the table. Can someone please help?

Thanks Peter but I couldn't get your suggestion to work. I have made some changes based on suggestions from others and have it working better, but the last part now is getting the selection from the combo boxes to only display the records for that choice. Private Sub Cmb_Sic_AfterUpdate()...

Thanks razorking! That helped with the duplicates, but still trying to sort out how to get the records displayed to be all those that are within the choice selected. Right now it brings up the first record for that choice, but if I click on the navagitation button for the next record it isn't...

Yes this is what I am looking to do. But a little different in that they will look all customer's within the selected state. So if there are 20 customers in say "TX" I only want those records. SO the navigation buttons would show 20 records. Does that make sense?

Can someone please help? Anyone?

I tried putting you suggestion in my code but it doesn't like it. What am I suppose to do with what you gave me?!?!?! (Sorry I'm not the guru you guys are) And you BTW comment - it's suppose to clear the data from the box once the record is displayed. Of course it does but it also clears the...

I am trying to get a form to select records from what choice is selected. On my form "Log calls..." there are three choices. The first choice lets you select the "SIC" but the record briefly displays then is replaced by the 1st record. Also I want the drop-down to summarize the choices -...

Ok Jon I tried it and put into the next place your fix but still get the error "Query Too Complex". I left it this time in the query. Attaching the DB with error Thanks . . . texasalynn

Thanks Jon - I will give that a try. But I'm thinking that same process will have to be done more than once since I need to go all the way to 2007? Don't you agree? I'll let you know how it works out. Thanks . . . .texasalynn

Thanks Jon but that is not quite what I need. I'll see if I can't write this out in length. I will use the first line for my example. I have class5 with $15 and a term of 5. The first calculated field = 12/31/2003 which is compared with class5 data = 1/31/2003. If that date is less than the...

So now I'm a rocket scientist???? Thanks for that vote of confidence - but I don't even know what that means Rich. texasalynn

No one knows??? I must not be asking the question right. texasalynn

I had tried that but also ran into an error. My query is going to be rather large because a have fields that start 12-2003 and go to 2-2007 (with a field for each month). What then happens is that I take a field "Amount" and put into the first 2 (12-2003 and 1-2004). Then in 2-2004 I add...