Search results

  1. P

    Export/Copy field properties to Excel

    I need to list all fields within each table and include each of the fields properties ie Field Name, Data Type, Description, Field Size, Indexed etc, etc. I would like to do this in Excel - is there a way to get this data? Any help would be greatly appreciated
  2. P

    Form opening in add mode

    I have a form with subform that was launched in two modes (add & edit). I used a separate form to enter search criteria that then opened the main form with items that matched the data enterd in the search form. All worked very well, but all of a sudden my main form now only opens in add mode...
  3. P

    If statement conflict

    I have a form (header) that has a subform (items). I have some code that takes information from the header and populates the item table as default values when a new item is added> Private Sub Form_Current() If Me.NewRecord Then On Error Resume Next 'It should never occur, just to be sure...
  4. P

    duplicate record & requery problem

    I have a form that has a "duplicate record" button which allows the user to copy a selected item and create a new record. This works well and even selects the next item number when adding the copied record. All was OK until I added a requery command on controls that appear later in the form...
  5. P

    default value in subform from main form

    Please can anyone help? I have a form (Sales Header) with a subform (sales items). It is possible to have 100+ sales items within an order, so to save input time I need to be able to add a value in the header form that will be the default value for a field in the subform for each new item...
  6. P

    find on subform and display mainform

    I have a sales database and one of the forms has the sales order header table as the main form with the sales item details table as the subform. I need to be able to allow users to search for records in the details form (subform) and when found, display the relevant information in the main form...
  7. P

    Snapshot of database for mobile users

    This is a real long shot and I am possibly asking the impossible, but here goes. I have created a MS SQL7 database with a MS Access front end. Forms and reports have been created with Access and I have used the developer software to create the runtime versions for users. I have now been asked...
  8. P

    Form to search for record

    I have created a form that prompts the user to enter a contract number. This then searches the contract table and opens up another form (contract) with all of the contract details ready for amendment. The problem that I have is that if the contract number entered does not exist, it opens up the...
  9. P

    Data Validation from another table

    I have two tables (Suppliers & Orders) I have created a form to input the orders and I want the form to check that when the user adds a supplier id (to the order form) a lookup takes place and verifies if the supplier id exists in the supplier table. If it does input continues, if it does not...
  10. P

    Date Picker

    I have used the date picker control to allow users to select a date and then have the date stored in a table. The problem that I have is that when the user clicks on the date it does not populate the field until the user clicks on another field. Is there any way that the field can be updated on...
  11. P

    #Error in calculated field

    I have a calculated field that calulates the last day of the following month based on a value from another field. The formula used works very well - =DateSerial(Year([itprininvdat]),(Month([itprininvdat])+2),1)-1 The problem I have is that if there is no value in the [itprininvdat] field the...
Back
Top Bottom