Search results

  1. S

    Dlookup Need To Select Random Value

    Got it working. I over complicated it lol. Private Sub shuffle_Click() ' create a random number that references the ID column from the table Inn and returns the corresponding Event column listing Dim sSQL As String sSQL = "SELECT Event FROM Inn WHERE ID = '" & Int((4 * Rnd) + 1) & "'"...
  2. S

    Dlookup Need To Select Random Value

    Based on your advice online google I have come up with this. Private Sub shuffle_Click() ' create a random number that references the ID column from the table Inn and returns the corresponding Event column listing Dim sSQL As String Dim rs As DAO.Recordset sSQL = "SELECT Event FROM Inn...
  3. S

    Dlookup Need To Select Random Value

    Here is what I have this looks up the first field in box and works fine. I am hoping there is some simple line I need to add. And not over engineer it. --------------------------------------------------------------------------------------- Private Sub shuffle_Click() str_table =...
  4. S

    Button to combox to table interaction issues.

    Sweet, thanks again for everything!
  5. S

    Button to combox to table interaction issues.

    Sorry! 1 last thing I promise. I changed my table like you suggestion and read the article. Now the code stopped working, what things would I need to modify in your code, I assume it would be simple?
  6. S

    Button to combox to table interaction issues.

    Alright, thank you so much again for all your help. I removed the whole select.value and it is working now. I will look into normalization, but I think we are all good to go! If you ever need help with anything Verizon Fios related, let me know ;)
  7. S

    Button to combox to table interaction issues.

    Sweet, you rock! So 2 things after implementing that. 1) I keep getting "Compile Error" Invalid use of property when I use the combobox. 2) The button displays a ton of blank values, since the columns have different amounts of lines, anyway to fix that?
  8. S

    Button to combox to table interaction issues.

    Sent, thanks!
  9. S

    Button to combox to table interaction issues.

    So good news, It started working... If I select a value in the combo box I get an error. Invalid use of Property Selectname.Value However if I press the button, it will generate a random name from the field selected. Almost there! Any ideas? My Combo box uses Rowsource Type : Value list...
  10. S

    Button to combox to table interaction issues.

    It is still over 2... Not sure how. I will put a random email on here that you can email so you don't give it out on the forms? I dont know why it is so big.
  11. S

    Button to combox to table interaction issues.

    Even after compressing and zipping it is 3.5mb :( Have an email?
  12. S

    Button to combox to table interaction issues.

    Getting invalid use of .Value. Maybe my combo box is setup wrong in Access? Would you be willing to take the accb file and tweak it real fast? I know it is asking alot.
  13. S

    Button to combox to table interaction issues.

    So my combobox is called Selectname. (i am sure this is wrong I am really new to this) ---------------------------------------------------- Private Sub selectname_Change() Dim selectname As String selectname = Me!cboselectname Me(selectname).RowSource = "" End Sub...
  14. S

    Button to combox to table interaction issues.

    So DLookUp("[Dwarven]","Gen","etc... This will generate Dwarven Names DLookUp("[ID]","Gen","etc... This will generate ID numbers. How do I get [?] to = selectedname (combobox) value?
  15. S

    Button to combox to table interaction issues.

    Yes, that is correct. But I keep getting expression errors, it cannot find my expression [SelectedFieldHere] because if I choose a column name like "Dwarven" it only shows Dwarven.
  16. S

    Button to combox to table interaction issues.

    I'm confused though. You say select field, but it is all the fields in the table not just 1 column that I need. How would I put that in?
  17. S

    Button to combox to table interaction issues.

    Thanks for the reply, so that goes on the Artbutton?
  18. S

    Button to combox to table interaction issues.

    I am working on a project (for fun) and am almost complete but stumped on this last little part. Any help would be greatly appreciated. This is for Access 2013 I have a basic Excel table with names. Artname, Dwarven, Elvish, Human. Button (artbutton) ComboBox (selectname) Text Box (arttext)...
Back
Top Bottom