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

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

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

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

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

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

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

I have a DB with about 50 tables. I have arranged them in a particular order in the relationship viewer and would like to print out as much of the viewer as I can by choosing the paper size and/or setting a scale factor. Access does not appear to let one do either. When looking at the...

When I export my access database to XML I noticed that the XML elements for the table keys contain the key numbers themselves, not the table name (or a chosen field in the table). For an application I am working on, this presents a problem. What I have is: One table called 'Process' that...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I've managed to export multiple linked tables to XML via the Export feature in Access. In looking at the XLM that is generated, I notice that the data that corresponds to the key field contains the key that is autogenerated. If, for example, I look at the last table in the chain, and look...