Search results

  1. K

    Noob having trouble getting value from query

    I am attemping to create a table in powerpoint from a command button in access using data from an Access DB. The following code runs just fine when using an entire table content as the sql statement. However, when I attempt to use an actual SQL statement it throws the following error: Run-time...
  2. K

    Command button to delete from multiple tables

    Solved: Once I posted this I relized my own error. I didn't properly wrap the where value as a string. Below is the corrected version sorry for wasting forum space. CurrentDb.Execute "DELETE * FROM TBL_APFT WHERE SSN = '" & Me.searchSSN & "'", dbFailOnError
  3. K

    Command button to delete from multiple tables

    I'm attempting to delete records from multipule tables with a single command button. However, I've so far been unsuccessful at getting it to work properly. My code doesn't throw any errors but it also doesn't actually delete the records either. I'm not posting the entire code simply because its...
  4. K

    Use unbound textbox to open form to correct record

    Works fantastic! Thanks for all the great info. I will definitly have to rethink the lookup methods that I've used and pay closer attention to ensuring the DB is optimized for performance. I have also normalized my DB... I had done so previously within the tables themselves but not thought...
  5. K

    Use unbound textbox to open form to correct record

    Creating the button and text/combo box isn't where I'm having the issue. The problem I'm facing is passing the value from the first form to the second. Though I do like your idea of using a combo box rather than textbox. Right now when I select the record in the combobox and press the...
  6. K

    Use unbound textbox to open form to correct record

    Hopefully I explain my intentions clearly. I have a form named MainSwitch which contains a unbound textbox named searchSSN and a button named open_SMoverview. What I want to be able to do is type in a SSN into the textbox and then click the button which would open another form named SMoverview...
  7. K

    Using module to modify form

    Thanks vbaInet... put that in my On Load event and it works perfect.... so glad I don't have to write nearly as much code now. Thanks everyone for the help
  8. K

    Using module to modify form

    boblarson....I've tried modifying your code a bit to get it to work for me but can't. How would I go about calling this? Function SetSec(frm As Form) Dim ctl As Control For Each ctl In frm.Controls If Len(ctl.Tag & "") > 0 Then 'access_level ctl.Visible = (InStr(1...
  9. K

    Using module to modify form

    Thank you all for your response. I've actually used a little bit of all the input.
  10. K

    Using module to modify form

    I've managed to create a form that accepts usernames and passwords and once a user enters a correct username/password the form closes and opens the mainpage of the database (simply has many cmd buttons to allow users to open reports, view/update data etc..). Each user has a different level of...
Top Bottom