Search results

  1. M

    Table fields

    Having 143 fields in a table is a problem in Access 2000? i was trying to create 144 th field and i get a message saying too many fields. How to get arround with it without breaking the table? mallinarc
  2. M

    Inserting data from one table to Another Table

    Can anyone help me what is wrong with this code? INSERT INTO tblMeterInformation ( Designation, PrimaryAmps ) SELECT [Meter Information].[Designation], [Meter Information].[PrimaryAmps] FROM [Meter Information] WHERE [Meter Information].[MeterNumber] = [tblMeterInformation].[MeterNumber]; I am...
  3. M

    Insert data from one table into target table

    Hi I was trying to write the following code in SQL window in Access 2000. It seems like i am doing stupid mistake some where (the help is not very helpful). insert into BuildingNumberName (BuildingNumber, BuildingName) values (select Master Data.Building Number, Master Data.Building Name...
  4. M

    table bound Form Open upon query from different form

    I am trying to open new form (which is bound to a table) from another form ( in which i have code as follows). Private Sub Edit_Reading_Click() On Error GoTo Err_Edit_Reading_Click Dim stDocName As String 'Dim stLinkCriteria As String 'Dim db As Database 'Dim rs As Recordset...
Back
Top Bottom