I'm not sure if this discussion is a better fit for the Access or XML forum and I don't want to double-post, so I'm starting in Access because you've been so helpful to me here.
I am preparing a presentation comparing using a relational database vs. a native XML database within a content management system to manage XML-based documentation. The point I am trying to make is how difficult it can be to reconstruct the XML hierarchy/tree...
lwwhite
Last Activity: Sep 14 '07, 08:22 PM
Joined: Dec 1 '06
Location: Georgia, USA
-
reconstructing an XML tree from RDB data
-
open different forms based on the results of a count query
When a user clicks OK on form "SelectDefaults ," I want to open form "Welcome" if the results of query "qry_todo_overd ue" = 0 or form "OverdueToD o" if the results >= 1. First, I assume that I need to run the query in "SelectDefault' s" OnOpen event, right? But having done that, I'm not sure how to incorporate the query-checking into an If...Then statement on the OK button's OnClick event.
... -
Link front end to back end at run time based on user input
Access 2003. I am maintaining 5 almost identical databases (long story). Each of them is split into a back end and front end. While individual maintenance of the back ends is inevitable, I would really like to maintain just one front end that users could use to link to the back end of their choice. The problem is that they would not be comfortable using Access's table-linking function and I would not want them to. I have an Enter Defaults window... -
Value auto-calculated via query doesn't "stick" in field
Access 2003. I have a form (form view) with a subform (datasheet view). The form has a map_id field and each record on the subform also has a map_id field. I want the fields on the form and subform to automatically display the next available number in a defined sequence when I add a new record to either. I have been able to successfully generate and display the next available number in the form and datasheet (using a query), but I can't make the... -
Eddie,
Can you give a little more information about your db? For example, from what you say here, it sounds like a given container can have X number of cartons in it and that's what you're trying to capture. But it seems that there is a larger entity that can encompass multiple containers as well and that's what the Unique# refers to, maybe? What are the "1 to 15" entries that you refer to? If you can provide more details... -
By "link," I assume you mean that you want a field in Table B to look up values in Table A. For example, Table B is a list of employees. Table A is a list of statuses. For each employee in Table B, you want to be able to select the appropriate status from a list that in turn comes from Table A. To create such a scenario, you will need to create a relationship between the tables. To do so, you will need to have a field in Table B that can...Leave a comment:
-
lwwhite started a topic Subform datasheet built using SELECT DISTINCT query does not allow record updatingin AccessSubform datasheet built using SELECT DISTINCT query does not allow record updating
I've got a a datasheet subform that gets its data from a SELECT DISTINCT query. The data is not editable. When I remove the DISTINCT qualifier from the query, the data is editable, but of course I get a much longer record set. I understand why Access doesn't want to let the data be editable in this situation, but I'm hoping there is a way to circumvent this restriction. Thanks for any suggestions. (Access 2003) -
You want to set up a Students form containing a Table Assigned subform, built off the tables of the same names. Your Students form would be a single form and your Table Assigned subform would probably be a datasheet. After selecting the student on the main form, you'd select each subject the student is taking as a separate record in the subform. This keeps the current student in focus and you can associate as many subjects as you need with that student...Leave a comment:
-
Thank you all for your suggestions, and especially thank you, Nico, for the code. I think this will do exactly what I need.Leave a comment:
-
Associate form events with default record navigation buttons
Another question. On one of my forms, I have two radio buttons: Topic and Window. Beside each of them is a drop-down to select the corresponding topic or window. When Topic is selected the window drop-down is disabled, and vice-versa.
But what I'd like to do is give the appearance of one field only. So I placed the topic drop-down directly on top of the window drop-down and set their Visible properties using the On Mouse Down event... -
Move items up and down in a datasheet sub-form via buttons?
I'm trying to reproduce functionality I've seen in some other (non-Access) applications. On one of my forms, the master record is a document. The subform consists of a datasheet list of the topics within that document--a kind of table of contents of the document. Problem is, the records in the datasheet list are not in the same order as they are in the document; rather, they're in the order that people added them to the database. I've tried various... -
Copy field contents using DblClick action
(Access 2003) Here's what I want to do: enable users to double-click a field in a datasheet-view subform and thereby save the contents of that field to the Windows clipboard so that they can then paste it into another field. I tried to set it up as a DblClick event on the field with this syntax:
DoCmd.DoMenuIte m acFormBar, acEditMenu, acCopy, , acMenuVer70
However, when I tested, I got a message that the Copy action... -
Method or data member not found--but it's there!
This is driving me crazy and probably has a simple solution. Access 2003 Win XP. On a form, I have an unbound text box named "drive." I have an unbound combo box called "version" that looks up values in a table. I have a button that calls a shell statement that concatenates the values in these fields plus some other fields and some hardcoded text to create a complete path to a document to open in in FrameMaker. This is working... -
Update table with contents of a directory
I'm using Access 2003, Win XP. I want to update a table with the contents of a directory and subdirectories. I have a directory structure like this:
FolderA
Subfolder1
[multiple XML files]
Subfolder2
[multiple XML files]
I want to place each of those XML file names into two fields in a table called tbl_sourcedocs. I'd like to place the path into tbl_sourcedocs. sourcedoc_path... -
Perfect! Thank you so much!...Leave a comment:
-
Open a file specified in a field using Shell function
I'm working with VB in an Access 2003 database. I have a form, called "EditWindowsFie lds," that contains a field called "sourcedoc. " I am trying to use the Shell function to open the XML file that is specified in the "sourcedoc" field. I've created a button on the form with this as the OnClick event:
Shell "C:\Program Files\Adobe\Fra meMaker7.1\Fram eMaker.exe C:\Sourcedocs\M e.sourcedoc", vbNormalFocus...
No activity results to display
Leave a comment: