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 Mike Lewis 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. ImHuman

    On Closing form prompts to save.

    I still use Access 2000 and unless newer versions work differently, I don't understand why you'd have to open the form in design view, modify the rowsource of a control and close the form. Why not just open the form and change the rowsource of the control leaving it unsaved when closing it? If...
  2. ImHuman

    Problem using user-defined function in query run with Execute method

    Access to functions are in the local database only. You'll have to have the same function defined in your second database for it to work.
  3. ImHuman

    Invalid Argument from RunSql

    IT WORKS Thanks PHV I had some errors with your code, but I made it into: DoCmd.RunSQL "UPDATE Clients SET " & FieldName & "=""" & Replace(Me("f" & FieldName), """", "'") & """ WHERE ClientId=" & Me!fClientId So it seems that Access truincates the text when the query pulls it from the...
  4. ImHuman

    ocxCalendar Problems

    A combo box generally shows a value that is in its list, whereas a textbox will display what its told to display. I've had similar difficulties with setting and retrieving dates from an activeX calendar when I copy and paste the calendar onto another form, and even if the form was imported. I...
  5. ImHuman

    Invalid Argument from RunSql

    Hello, I know what the problem is, I've encountered it before, but the solution I implimented was too unorthodox to me. When I make a form, I unbound all the fields and use a generic subroutine to update the records where a single field gets modified. Access has never let me update a field...

Part and Inventory Search

Back
Top