Recent content by jjh

I created a form that has 4 subforms. All of the record navigation controls are situated one on top of another at the bottom of the form. I would like to do one (or more) of the following. I am looking for guidance on how to do all of them. 1. Add a label to the control to convey what table...

Works like a charm!...THANK YOU! John

Hi: I have a number of queries that run prior to exporting my DB into and XML file. I run the query in a section of VB code as follows: Dim stDocName As String stDocName = "flow_e_e_tbl_connection_name_id_update" DoCmd.OpenQuery stDocName, acNormal, acEdit The query executes as expected...

OK, TYVM...But, in thinking about this situation a bit more, I will have the results of the query in the dynaset before I do the append (correct?). My application will always result in exactly one record being in the dynaset. Is it possible do a query on the dynaset fields, get the piece of...

Rephrasing: I have a table that has a PK that is autonumber. As I add records, the PK number always increases, with the last entry always larger than the previous (but the PKs may not always contain the next number in the sequence, e.g. 2,4,6, instead of 2,3,4). I need to do a query on this...

Hi: I am looking for some guidance in doing the following: I have a tableO that contains a list of objects that have associated attributes, specifically a list of system_names (object) and the associated attributes (additional fields in the table) that include port_name, port_direction. Think of...

That worked... THank you...This worked fine in my environment. -John

Will this work within Access 2003, in VBA code associated with a control? Also, I am using xp-sp2. Thanks for the pointer! J

Hi: I have a control on my Access application switchboard that will export certain tables in my DB using the ExportXML method. It works fine. However, according to MS, the SchemaTarget, Datatarget, and DataSource have to be strings. I want to popup a typical MS file save window, let the user...

I have a table (TBL_B) that receives record information from a program that I wrote. One of the columns in TBL_B that gets input data is system_name. By design, the value of system_name is already in another table in the database (e.g. the system_table). At some point, I export TBL_B to an XML...

Thank you! works fine. -J

So the form layout will stay the same, cept each control will be mapped to the old table and I will need to click on each control (lable and field both?) to point them to the new table? Thanks for the help John

Hi! I am making a form that will be composed of two subforms. Each subform will be based on a differrnt table, however the tables are identicle as far as the number of columns. I designed form_1 to be based on table_1. Now, is there a way to copy form_1 (which will be changed to form_2 in the...

followup Hi: Thanks for your suggestion. Well, I have a 'developers form' that I am adding certain methods to, to do things on the database. For example, change the way certain controls work, import things in certain ways, etc. I want to stay in developers mode and try things, and not always...

Hi: Thanks for considering my question. I have developed a DB with about 60 tables, all related by one-to-many relationships. During development, I placed values in the tables, generated keys, etc. so things have gotten quite cluttered. Is there a way (vb program, access method, etc.) that I can...