Recent content by manthiralaya

Thanks MailMan..... I tried the same as you said. It works well. Thanks for that. However, then I tried to do make query with 100 fields in Table1, 80 fields in Table2 and 90 fields in Table3. The error says that table are not related. I have attached the image of the error displayed. I...

Dear All, This is regarding getting values from different table. I have three Tables named Table1, Table2, Table3. Fields of Table1 are ID (Primary), MDate, Name, PerID Fields of Table2 are ID (Primary), MDate, Position, Address Fields of Table3 are ID (Primary), MDate, City, County I...

Thanks for the kind reply. I didn't relate the tables. Please advice me how to relate. The reason I made two tables is as I have around 200 data. As dont want to save 200 data in the same table, I splitted in to two tables. Any other way to do? Thanks in advance. Regards, manthiralaya

Dear All, Say for example, I have a Table named 'Table1' contains fields, ID (as primary), MDate, PersonName, PersonJob. Another table named 'Table2' contains ID (as primary), MDate, PersonName, PersonAddress. I have a Form contains a ComboBox named 'cmbbox1' and have TextBoxes named 'txtbox1'...

Thanks JANR......It works.....C U later.... Regards, manthiralaya

Dear All, This query is rearding Printing the forms. I have a Form which contains some command buttons (say Command19_Table1 and Command19_Table2) and 'Print Form' button. I have coded for 'Print Form' button using DoCmd. I would like to print the form when I click 'Print Form', I would like to...

Sorry..... here is the code....... Private Sub Command19_Click() Dim DBSS As Database Dim RSTT As Recordset Dim STRSQLL As String Dim I As Integer Set DBSS = CurrentDb STRSQLL = "SELECT * FROM Table1;" Set RSTT = DBSS.OpenRecordset(STRSQLL) With RSTT .AddNew For I = 1 To 4...

Hi Boblarson, Thanks for the info.... Instead of !Fields(strRef), if I use .Fields(strRef) its working...... As like you, one of other forum friends helped me..... I have attached the code for reference herewith..... Thanks for all who helped.... See you in future.... Best...

Sorry again.....boblarson. Nothing working out. For your reference, I have inserted the image of what you have said. If possible have a look. Still breaking my head..... Regards, M

Hi Boblarson, I tried that too.... as you said....but ends in vain........ I just want to assign a field variable. If I am using !Fields(), then there is no need of that thing........ ******************* Private Sub Command19_Click() Dim DBSS As Database, RSTT As Recordset, STRSQLL As...

Thanks Jamesmor...... Still the same error James........ And also if I add by the way of Fieldo, Field1 etc...., some times the fields are shuffled themselves when open the table. I dont know why it is happening. In order to more control over there, I wanted to add the data to the...

Thanks Boblarson for your kind reply. 1. In case my field name is abcd1, abcd2 etc......, how should it be handled? 2. I tried your way too but ends in vain and the same error encountered. Any other suggestion? Kind regards manthiralaya

Hi, This query is related to MSAccess-Forms-VBA coding to adding new records in to a table using recordset. Say for example, I have a table named as 'Table1' with fields F1, F2, F3, F4. In the Form, I have four TextBoxs named as txtF1, txtF2, txtF3, txtF4. I have a Command button named as...