Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Trevor2008

    update a table cell on keypress

    I am trying to update a table cell on key press. I have a table that gets the selected row and column with focusGained() but I am having trouble updating cell on key release with the key event/key released. The cell will update if it losses focus and I then return to it. Is there a way I...
  2. Trevor2008

    Disable replace tab on Find Dialog

    I think I solved how to hide the replace tab of the find dialog while still allowing users to edit the fields they are suppose to be able to edit from the form by setting ailow edits on the form to "NO
  3. Trevor2008

    Disable replace tab on Find Dialog

    but Won't opening the db in read-only mode prevent field changes? I don't want the end user to be able to use the replace tab but there are fields on the form for the end user to update/change through the form.
  4. Trevor2008

    Disable replace tab on Find Dialog

    Hi I am trying to disable the replace tab on the find diaog in access 03, I have searched the net and found findtext.dlg but have tried searhing both my HD and the ms Office folder for the file with no luck, Does anyone know how to disable the replace tab, other then creating a custom dlg. my...
  5. Trevor2008

    copy contentents of subform to subform different form

    The only thing I can think is happening is what is beeing counted is the # of matches to the IDnumber on the form, Ie so if there is 4 IDNumbers in the DB alll with I081111 and the Form IDNumber Is I081111 the data base see's that only one 1number that matches tha form IDNumber in the table...
  6. Trevor2008

    copy contentents of subform to subform different form

    Thanks lespaul but my thaught of reversing my where clause was worse - the rs.count message is 0, so I guess I haveoo go back to my other select statment, do you have any Idea why only 1 record is being seen/selected?
  7. Trevor2008

    copy contentents of subform to subform different form

    It looks like I need to reperse my where clause to where Me.IDNumber = IDNumber, It looks like what is being returned is # of records in that query that have the same ID Number as the form IDNumber but I get error to few peramitors when I Try StrSql = "SELECT * FROM [VMSU-ILT-Sub]...
  8. Trevor2008

    copy contentents of subform to subform different form

    After adding a few msgbox's in to see where my code is erroring, my query appears to be looking at the correct table but is only seeing 1 record that matches the criteria but there are multiple records in the table that match The IDNumber is the linking field between the master and subform ...
  9. Trevor2008

    copy contentents of subform to subform different form

    the target form is blank on launch unless the repeat TO Number button is clicked, I just tried today code: Dim DB As Database Dim rs As Recordset Dim strSql As String Dim QryRS As Integer Dim ID As String Dim stDocName As String Dim stLinkCriteria As String ID = Me.IDNumber stDocName =...
  10. Trevor2008

    Access security

    Hi, thanks for your reply, I have tried your reply before (by accident, clicking to fast) and I can't seem to find a way back to design mode after I hide the db window and toolbars, I couldn't even find a successful way to rejoin either, all attempts would end in failure, I removed standard...
  11. Trevor2008

    Access security

    Is there a way to prevent users of an access DB without use of a logon screen or using the security wizard, to prevent them form altering the DB tables directly, if not what would be the way to do this. fyi: I can't make since of the security wizard. Question2 - Is it possable to rejoin a...
  12. Trevor2008

    copy contentents of subform to subform different form

    Hi I am trying to copy the contents of a datasheet subform on a button click to a blank subform on a different screen the purpose is for billing an indiviuale if the billing is the same but the individual is different this will eliminate repetitive typeing for the end user, my code will only...

Part and Inventory Search

Back
Top