Search results

  1. texasalynn

    Need Help with this code!! Please Help!!

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

    Import Excel into table

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

    Import Excel into table

    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?
  4. texasalynn

    Select record to display on form

    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()...
  5. texasalynn

    Select record to display on form

    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...
  6. texasalynn

    Select record to display on form

    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?
  7. texasalynn

    Select record to display on form

    Can someone please help? Anyone?
  8. texasalynn

    Select record to display on form

    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...
  9. texasalynn

    Select record to display on form

    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 -...
  10. texasalynn

    Problem with summing fields

    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
  11. texasalynn

    Problem with summing fields

    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
  12. texasalynn

    Problem with summing fields

    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...
  13. texasalynn

    Problem with summing fields

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

    Problem with summing fields

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

    Problem with summing fields

    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...
  16. texasalynn

    adding tables to a form

    Do you mean that a form is already created and now you want to add another table? Because a form is only for 1 table. To add another table will require a sub-form texasalynn
  17. texasalynn

    Problem with summing fields

    I have been trying to figure this out and thought it would be a simple thing. I have a query that I need to sum all the fields preceding it. For example I have a calculated field 11/1/2004 that adds the previous fields from 12-31-2003 through 10-1-2004. The problem is when I try formula it...
  18. texasalynn

    Import error list

    Some workarounds: 1. I have found a way to fool Access is to open the text in Excel and move to the first line the data with the correct field type. Then when you import it works just fine. 2. Import the data into the table. Delete the records. Change the field type to text. Re-import the...
  19. texasalynn

    One to many (duplicates)

    I have a query with two tables that ends up with duplicates. I'm not sure how to explain, but one table will have multiple types of service for each account, but the other table only has one line for each account. How can I get the data to display all the data but only leave the duplicate lines...
  20. texasalynn

    Export says "read only"

    Found the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;250459 in case anyone else has the same problem. texasalynn
Back
Top Bottom