Search results

First this table is the source to the tabed form, so i can't break this table since it is the source table. In the form user enters the values of the meter readings. There are huge no. of buildings/readings and additional info. on each electric meter. The Access Specification says there is a...

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

Thank you very much guys... Mallinarc

It is asking me to enter the "[tblMeterInformation].[MeterNumber]:" with a text box. I was expecting it to read the table and match the values based on the tblMeterInformation and match with the Meter Number in Meter Information table then insert the value into tblMeterInformation 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...

Thank you ShadeZ The code needs little modification. The one below works perfect. INSERT INTO BuildingNumberName ( BuildingNumber, BuildingName ) SELECT [Master Data].[Building Number], [Master Data].[Building Name] FROM [Master Data] Thank you for your time. Mallinarc

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

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