Search results

  1. M

    How to verify data that is entered using a form.

    I have a form that is used to enter some data. The record source is a query based on one table. The fields on the form is: ServiceID, SerialNbr, CartStatus, CartDate, CartEvent, CartRepairType, Remarks Ok here is what i'm looking to do. When the user enters a number in the SerialNbr...
  2. M

    Adding Record With Field From Another Form, Access 2007

    :confused: Ok, let me try to explain my delima.... I have a form with several text boxes and combo boxes. One of the fields (ServiceID) is picked up from another form. There record source is a query with the following fields: CartID, ServiceID, SerialNbr, CartStatus, CartStatusDate, CartEvent...
  3. M

    Object Required error using Access with VBA backend

    Can someone please look at this code and tell me why I am getting the "Object Required" error: Private Sub cmdAddRec_Click() On Error GoTo Err_cmdAddRec_Click Dim rstServices As New ADODB.Recordset Dim fld As ADODB.Field Dim strField As String...
  4. M

    Deleting link in linked tables

    I want to delete a link to a linked table without deleting the actual table. The tables where linked when the application was designed by another user. So the tables links are pointing to C:\documents and settings\user name\desktop\database name. I want to delete the links to all the tables so...
  5. M

    Deleting a Record

    :confused:i have a form that has a add record, delete record and a close button. When the form is opened it is on the first record, the user can navigate to the record that needs to be deleted using the built in navigation buttons. Once they find the record to be deleted they should be able to...
  6. M

    Deleting a Record

    i have a form that has a add record, delete record and a close button. When the form is opened it is on the first record, the user can navigate to the record that needs to be deleted using the built in navigation buttons. Once they find the record to be deleted they should be able to hit the...
  7. M

    Error: Object Required

    I keep getting the error object required. Can anyone please look at my code and tell my why I'm getting this error?:confused: Private Sub cmdAddRec_Click() On Error GoTo Err_cmdAddRec_Click Dim rstFile As New ADODB.Recordset Dim fld As ADODB.Field Dim strField As String rstFile.Open...
Back
Top Bottom