Search results

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

I am developing a DB that is composed of approximately 50 tables. The primary key in every table is automatically generated byAccess. I understand that the primary key for each record in the table has to be unique. My question is: Is the primary key uniqueness applicable across the entire DB...

Hi: I want to automate the XML export function of Access and not sure if it is possible or how to do it. In going through the menu bar (File ->Export) interface, I must choose the root table, and then subsequent tabbed windows allow one to select what tables to be exported, if I want the...

Hi: I want to automate the XML export function of Access and not sure if it is possible or how to do it. In going through the menu bar (File ->Export) interface, I must choose the root table, and then subsequent tabbed windows allow one to select what tables to be exported, if I want the...

OK, care to enlighten me on HOW this is done? I don't want to put the combo box on form B because the table that is being modified by the combo box is being displayed in form A. For my application, even though the table where the combo box gets its data is seperate from the table that is in...

Hi: Some help is appreciated: What I want to do: On activation of a command button on 'Form A', I would like an existing combo box on Form A to be enabled (e.g. allow a user to select values in combo box), and once the user has selected the value in the combo box, copy that value to field in a...