Search results

I made the following update query with the following sql statement, is this the most efficient way? UPDATE Inv SET Inv.Area = [Forms]![Hostveiw]![txtupdate] WHERE (((Inv.Hosting)=[Forms]![Hostveiw]![Hosting]));

Thanks for the help, The selection is made from the form Main, you click on the hosting field and it opens the continuous form (Hostveiw) with the matching hosting name , and it is that selection which I want to update

Here is a copy of my database

Hello, I am trying to update a continuous form with multiple records with a unbound text box. I have tried the following on click event and I am only updating one record on the continuous form. Here is my on click event vba: Private Sub cmdarea_Click() Area = txtupdate End Sub Any...

Thanks, That's a great idea, I just built a form and subform, is there a way to make it in data sheet format as a continuous line

Thanks for the help, Basically, I want to import the data to a tbl called Lease and then compare it to the Inv table by serial numbers and be able to edit both on the query. Table Lease will always be imported data, it comes form a different dept. the field SerialNum (will have serial numbers...

Hello All I have a question. I currently am using Access 2007. Basically I have a excel report I receive from another dept with incomplete data. I import the excel to a table I call Lease. The Lease table has 3 fields, ID (Auto-Number) Equipment (Hardware Description) SerialNum...

I have tried the different ways to create the table relationships but I not had any success allowing the query to be updated is there a bypass feature in access?

Thanks, for the help and the references. I have been studying them, and I have a question. Basically I have a excel report I receive from another dept with incomplete data the table I call Lease. The field SerialNum is always missing some data, but it gets updated as the excel sheets come...

Thanks, for the help. Here is some more data.

I have tried to looking on my properties settings but I have not yet found the cause of why access won't let me update my records

Here it is thanks

Thanks for the help, Here is my database

Hello, I am trying to edit my query and keep getting the error Record set is not updatable. Is any one able to assist me with this issue Here is my sql SELECT Inv.[ID], Inv.[Area], Inv.[Hosting], Inv.[Type], Inv.[Ser_num] FROM Lease INNER JOIN Inv ON Lease.Serial = Inv.Ser_num; Thanks

Thanks so much, this helps me greatly

Thanks for the reply, The data does display as Serial 1 2 3 4 5 6 7 8 9 10 11 12 I just cut it off for the post. Anyone able to help me with issue?

Hello all, I have a question I have table with the following fields listed below Inv () ID Area Hosting Pc_SN Montior_SN Montior3_SN 1 Houston d13 1 5 9 2 Houston d18 2 6...

I tried the exact same code but, I used a Table for instead of a Query as the subforms' record source and it works, but is there a way for me to use a Query instead?

Thanks again for the help, I set the footer to visible, and I tried the long way to name my sub-form (Forms![form name]![control name].Form.[control name]), but I still get the same error.

Thanks for the help, FrmLookup is the name of the subformcontrol. I am not to sure what you mean, can you provide me a example. Thanks