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 Rhinorhino 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. punky001

    Database used in both 2007 and 2010 produces error.

    I am in the process of testing our Access 2007 databases for compatiblity with Access 2010. So far - all seems to be working well. All users are using Access 2007 until testing is complete EXCEPT for 1 user who is using 2010 (yes - there is always one!) FYI....I have a SQL backend - using...
  2. punky001

    Can a Keyboard Shortcut be deactivated?

    Thanks AceMan1!!! It works like a charm.....you got a star!
  3. punky001

    Can a Keyboard Shortcut be deactivated?

    I have a user that forgets and uses the ctrl minus sign (-) on an Access 2007 form which deletes a record - which he doesn't want to do. He uses this in Excel 2007 and it zooms out. Is there any way I can deactivate the Ctrl minus sign in Access?
  4. punky001

    Module code question - Access 2007

    Sorry AceMan1 and MazeWorZ.....stars are there now. Again thanks so much.
  5. punky001

    Module code question - Access 2007

    Finally!! Works Great!.....thanks to all ...especially to TheAceMan1 and MazeWorX.....stars to Both!!
  6. punky001

    Module code question - Access 2007

    OK....Here's what supposed to happen....and the legacy code worked great (look at first post) until I added the new Loc_cls field which defines the location. Private Sub form_AfterInsert() is supposed to call for the Update Qty_tot module - this will update the Toolcls_May.Qty_tot and Qty_OL...
  7. punky001

    Module code question - Access 2007

    Thanks PHV - I made that change and got the same error. The loc_cls field is located on the subform: Toolcls_May.loc_cls
  8. punky001

    Module code question - Access 2007

    OK Guys....Here's the changes I made...In the module - I changed the ploc_cls to match the field loc_cls in the event procedure. I still get the same error "Can't find the field 'Loc_Cls' referred to in your expression" pointing to the Call Update line. Module: Option Compare Database...
  9. punky001

    Module code question - Access 2007

    Module Code: Option Compare Database Option Explicit Public Sub UpdateQty_TOT(pType As String, pBarcode As String, pQty As Integer, pLoc_cls As String) Dim db As DAO.Database, sqlTable As String, sqlExpr As String, sqlWhere As String Set db = CurrentDb sqlTable = Choose(Val(pLoc_cls), "Update...
  10. punky001

    Module code question - Access 2007

    I tried adding Call and got the following compile error "Expected: end of statement" with the "I" highlighted.
  11. punky001

    Module code question - Access 2007

    Thanks to all for replies....Aceman - I tried yours first. Here's the new code: Public Sub UpdateQty_TOT(pType As String, pBarcode As String, pQty As Integer, pLoc_cls As String) Dim db As DAO.Database, sqlTable As String, sqlExpr As String, sqlWhere As String Set db = CurrentDb sqlTable =...
  12. punky001

    Module code question - Access 2007

    I made a change to a database I inherited and I'm having a problem getting it to work. I thought it was simple? Listed below is the originial code and it works without issue. All I need to do is add a location field (Loc_cls) to the selection. It does not work. Does any one see anything...
  13. punky001

    Adding SQL backend to 2007 database

    Thanks to ALL.....I made changes and it works great - PLUS - I learned something new. You guys are the best! Stars to all!
  14. punky001

    Adding SQL backend to 2007 database

    I've made the suggested changes and have attached a new copy of the code....I'm still getting the "Compile error - Method or Data member not found" - poining to :me.DESC1. Private Sub cmbBarCode_AfterUpdate() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL, DESC1, strMsg As String...
  15. punky001

    Adding SQL backend to 2007 database

    I changed the field to Desc1 in SQL table - linked back to Access - changed all queries / forms to reflect Desc1 and got the following error. "Compile error - Method or Data member not found" pointing to: me.DESC! = rst!Desc1. When I responded OK - pointed to "Private Sub...
  16. punky001

    Adding SQL backend to 2007 database

    I just tried that and still got the error "field cannot be updated" and pointing to Me.DESC=rst!DESC
  17. punky001

    Adding SQL backend to 2007 database

    I inherited a database originally created using Office 97, then migrated to Office 2003 then Office 2007. All has been working well in the database so I now want to put a SQL backend using the Access frontend. I have run into an issue and can’t figure out what the problem is. I get the error...
  18. punky001

    DMAX on form question

    Hey Randy007.... Here's the original: =DMax("[Number]","[RequiredReportTable]","[ContractNumber] =" & [Forms]![AddRequiredReportForm]![ContractNumber])+1 It hit me that "Number" is a reserved word and should not be used as a field name - so I changed the name to "RRNumber". So far....it has...
  19. punky001

    DMAX on form question

    Thanks MacroScope....It's being used as an "autonumber" for records for each contract. Example: cont 1234 = Last RecNr = 100 - Next RecNr = 101 cont 3333 = Last Rec Nr = 850 - Next RecNr = 851
  20. punky001

    Access 2007 Autofill questions

    Thanks again Hap007 - you found the problem. The last issue was my fault .... runs great now!

Part and Inventory Search

Back
Top