Search results

Bob: Thanks a lot. That should do it.

I have a select query from a few related tables, one relationship being many-to-many. The resulting query, when run would have several groups of records where each group has all but one field different (a text field). Is it possible to do a report where this group appears as one record with the...

I think I have finally resolved it. I have the subform based on the relate table, which would only store OwnerID (through a list-limited combo-box)which would be a foreign key against the PlotOwnerLinkID, an autonumber. Also, I will have two unbound boxes in the subform that will display the...

Thanks Doc Man abd Craig. We are talking cemetary plots here (So no splits/combinations etc. involved) and thankfully our clerk's office do not need to track ownership percentages. They just have to list the owners. While I will make it a requirement that the OwnerTable is filled out first, the...

I am enforcing referential integrity (for the PlotTable and PlotOwnerTable through the PlotOwnerLinkTable). But still I end up putting in the same information multiple times in the PlotOwnerTable that already exists in the OwnerTable. (I hope I am understanding you correctly).

This is a design issue: I have a database with a PlotsTable and OwnersTable (table) in a many to many relationship, connected with a PlotOwnerLinkTable (that includes the PlotID and OwnerID Foreign keys). There is also an OwnerForm to allow adding owner details to the OwnerTable. The main form...

Is it going to be a bound picture or an unbound picture?

What about creating a query with the tables and creating a form from that query?

I looked at several threads on this issue but am still unsure as to how to solve this. I have a cemetery database which is somewhat different from the other situations discussed. The main form is a record of "Plots" which is based on a query. "Plots" and "Owners" have a many-to-many...

Thanks! Thanks for your reply ortaias. I actually went ahead with my relationships there. (I had to retain the Place abd plots as numbers). I did limit the the options through a drop down (1-6 and 1-2). As far as the relationship goes, I managed to do a 1 to 1 by not allowing duplicates in the...

As always, I am back to this forum for guidance. I am working on a cemetary database and trying to figure out the best way to set this up. Here are the rules: 1. the Cemetery has several lots. Each lot has exactly 6 plots, and each plot has exactly two places. 2. Owners can by plots. One plot...

Bob: Thanks for the post. Can you explain it a little bit more how it would apply to my case? My Access and VB/A knowledge is pretty limited. Thanks again.

Thanks to some of the threads here, I have managed to automate inputting form data from a record into bookmarks in a word document template (a letter). What I am trying to do is to lock the letter allowing modification only to the form fields in that template. If the original template is locked...

I found some information (from a previous thread) and this article: http://support.microsoft.com/kb/328320/en-us Using that I can get the information on two Different Reports. I am still trying to find out a way to combine the two.

I have searched and searched for a thread before posting this, there are some discussions on related issues, but I could not find a solution. This is my problem: I have a table with Incident_Type (a total of 6 selections from a combo-box), Incident_date, Incident_SubArea(25 selections from a...

I apologize. I didnt quite clarify that. Basically, there is a table ("incidence") with three fields: "Init_date", "end_date", and "duration". "duration" is the number of days between "init_date" and "end_date". If there is no "end_date", "duration" is the number of days between "init_date" and...

One of the forms in my database has a calculated text box control. The calculation is conditional, one condition being based on current date. One of the queries display that calculation. If the the form with the calcualted control is not opened before running the query, the calculated control...

I have figured it out. I had to create a macro with the same expression and put it in the OnCurrent property of the form.

I have a form with two date fields: "Initiation_date", and "Correction_date". There is a third field called "Duration". I would like to store the values of all three fields in the corresponding table. "Duration" (Long Integer) would be the number of days from "Initiation_Date" to...

I have a form with two date fields: "Initiation_date", and "Correction_date". There is a third field called "Duration". I would like to store the values of all three fields in the corresponding table. "Duration" (Long Integer) would be the number of days from "Initiation_Date" to...