Search results

  1. K

    List box: combining columns from multiple tables where records not always cohesive...

    Hello, I have a form with a combobox (combo0) where a sample id can be selected from the drop down menu. In a list box I have the following code: SELECT DIVERS_pt2.sample_id, DIVERS_pt2.[1/(maxi/summe)] AS 1/(max species count/total count)], SHANN_pt2.proz FROM DIVERS_pt2...
  2. K

    how to highlight a row in a listbox?

    Hello, I have a form where i have a combo box where I can select a desired sample id. Then, I have a listbox which then shows all of the species that occur in that sample and their relative abundance. Would there be a way that I could highlight the record with the maximum abundance each...
  3. K

    possible to add a "select none" option to a combobox drop menu??

    Hi, Using a combobox, I have made a drop down menu of values from a table column. When an item is selected in the combobox, records show up in a listbox. I want to have a "select none" option in the list. Is there a way to add an entry to the combobox drop menu without altering its parent...
  4. K

    Hello, I just wanted to thank you for the help you have given me with my silly beginner...

    Hello, I just wanted to thank you for the help you have given me with my silly beginner questions thus far! This is my first Access project, and I appreciate your time and assistance very much!
  5. K

    Im stumped on a simple query! I need some help!

    OK so I revised it to this. SELECT DISTINCT TEST.sample_id, NANDAT.art, maxi, summe FROM TEST, NANDAT WHERE art Not In(66,88,90,95,94,131,132,133) AND TEST.sample_id=NANDAT.sample_id AND TEST.maxi=NANDAT.data GROUP BY TEST.sample_id, NANDAT.art, maxi, summe; This worked except that where...
  6. K

    Im stumped on a simple query! I need some help!

    Hello, OK. So I have a table titled NANDAT with the columns: sample_id, shipcode, cruisenum, corenum, depth, data, art I have a query written shown below: SELECT DISTINCT sample_id, max(data) AS maxi, sum(data) AS summe FROM NANDAT WHERE art<>66 And art<>88 And art<>90 And art<>95 And...
  7. K

    need help displaying record in listbox based on parameter selection in combobox!!

    OK, for my combobox (combo0) , my row source is : SELECT ANART_pt2.sample_id FROM ANART_pt2 ORDER BY ANART_pt2.sample_id; My After Update Event is : Private Sub Combo0_AfterUpdate() Me.List2.Requery End Sub My listbox (List2), has row source: SELECT ANART_pt2.sample_id, ANART_pt2.lat...
  8. K

    need help displaying record in listbox based on parameter selection in combobox!!

    tried what they suggested there, and no changes....
  9. K

    need help displaying record in listbox based on parameter selection in combobox!!

    Hi! Me again... So I was using Access 2002 yesterday when I was attempting this, and was in the end successful. However, today, I tried to recreate the same thing in Access 2007, following the exact same steps, and I'm running into the same problem as yesterday. The requery event does not...
  10. K

    need help displaying record in listbox based on parameter selection in combobox!!

    yaaaaaaaay!!!!!! Success! So, it wasn't working at first, because I didn't realize that when I was creating an event, for whatever reason a before update event would appear automatically... So I deleted that, and put in my after update event "me.list3.requery" and it worked.. Thank you so much!
  11. K

    need help displaying record in listbox based on parameter selection in combobox!!

    nah... same error! Although, when I type the command directly into the after update field, then reopen the form select my sample_id I get the error message "MS Access can't find the macro 'me'." I guess it assumes I'm building a macro. But, if I click the "..." and select "Expression builder"...
  12. K

    need help displaying record in listbox based on parameter selection in combobox!!

    OK, so I tried typing Me!Combo0.Requery into the After Update Event in the combobox properties, and I got this error: The Expression After Update you entered as the event property setting producted the following error: The object doesn't contain the Automation Object 'Me'. *The expressiong may...
  13. K

    need help displaying record in listbox based on parameter selection in combobox!!

    Hello, Basically I want to perform a parameter query with a drop down menu. To do this I have created a form with a combo box (combo0) and a listbox (list3). The combo box is a drop down menu of sample_id (from my query ANART_pt2) I want the listbox to display the full record from ANART_pt2...
  14. K

    How to "Export" query table in Access?

    Hello, I want to export my query results table to a specified folder as a .dat file. I don't want to output the whole database to file, I just want to output a query table to file... Using Informix SQL the equivalent would be: UNLOAD to "C:\test.dat" and Using Oracle SQL (I think?) the...
  15. K

    Problem importing from excel to access. My #'s get rounded!

    hello there, I am trying to import data from an excel spreadsheet into an access table. The problem is that all my values keep getting rounded up or down, and my decimals are not preserved. I have tried creating a table, setting the data types to 'decimal', then importing the data in, and it...
  16. K

    Simple Query giving error message... help please?

    thanks, ya sorry, I ended up realizing that right after i posted that. Sorry for taking up unnecessary space on the board!
  17. K

    Simple Query giving error message... help please?

    Hi, When I try to run this simple query: SELECT sample_id, sum(data) AS summe FROM REVDAT; I get an error message that says, "You tried to execute a query that does not include the specified expression 'sample_id' as part of an aggregate function" Does anyone know what would...
  18. K

    "Not responding" Help simplifying a query?!

    WOW! Actually, just adding those brackets: AND (nandat.art=98 OR nandat.art=45) ;worked. it ran fine! thank you!
  19. K

    "Not responding" Help simplifying a query?!

    hmmm... thanks guys! To be honest I don't even know what joins are , or how to implement an index, but I will do some research! I might be asking for some assistance later! thank you!
  20. K

    "Not responding" Help simplifying a query?!

    SELECT distinct area.shipcode, area.cruisenum, area.corenum, lat, long, waterdepth, (data/summe)*100 AS proz FROM nandat, indproz_pt1, area, sample WHERE sample.sample_id=indproz_pt1.sample_id AND sample.sample_id=nandat.sample_id AND area.area_id=sample.area_id AND nandat.art=98 OR...
Top Bottom