Recent content by jbranero

I did it already. In fact I added some stupid value to some records in the fields ("a") to check what was wrong, but nothing happen, I mean do not update. It looks like the Query works because it shows the records that meet the condition Is Null but they are not updated.

I try with the update query and the SQL look good but for some reason it doesn't update the field The SQL is: UPDATE T1 INNER JOIN T2 ON T1.ID = T2.ID SET T1.CUSTNUM = [T2]![CUSTNUM] WHERE (((T1.CUSTNUM)="IsNull")); What I try is to update the CUSTNUM in those records where is empty. I click...

Hi there, I have a table with some missing values in a field. I got another table with the values I need. I tryed to make a an append Query for update the values but this query add new record and I don't need that. Any idea over there. thanks

As usual with you, it works perfectly... thanks a lot!!! and congratulations for being named the best helpfull in Tek-Tips. j

Hi, I am trying to access the name of a field in a Recordset but when I try the following: SSField = LTable!Field_1 Where: SSField is a string; LTable a Variant (treated as Recorset) and Field_1 a variable containing the name of the field. I get a message: Item not found in this collection...

Also thanks to Skip! I think that in this case the suggestion from RoyVidal is easier.

Great! it works perfectly. Thanks a lot Mr. Roy.

Hi there, I am trying to populating list boxes with the names of the fields of the tables and I would like to make a SELECT in the Row Source property. Does anybody have an idea about or another way to do it. Thanks j

Hi there, I am in novice trouble again. I made a form, a very simple one, that have to combo boxes with names of tables. When the user choose the tables he want to work with he should make a click to start the proccess. The point is that I try to pass the name of the choosen table to a procedure...

PH, thans a lot, it works perfectly. i regret not to see this from the very beggining. I thought the other way was easier. Thanks again.

PH, I am sorry if look too novice, but is real. What will be Name and Type in your suggestion SELECT [Name] FROM MSysObjects WHERE [Name] Not Like 'MSys*' AND [Type] In (1,4) thanks

Hello there, I keep trying to read the names of the tables from the DB but I can not. I use the CurrentDB object (PH suggestion) and there is a Collection (or object) called Tabledefs and in TableDefs there is another one called Item from 1-9 (that contain the names and other fields) but when I...

No PHV, i was trying the one from SkipVought and didn't try yours. But this about the CurrentDB.tableDefs looks very good. I will try now. Thanks a lot.

Thanks SkipVought, it sound good the "AddItem". I have been looking the syntax and I would like to know how to get the names of the tables from the DataBase (I am in Access)

I need to use cambo boxes in a form to open tables... Does anybody know how to populate this combo boxes with tables names.