Search results

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

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

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

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

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

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

I have a "Browse" button on a form that works fine. I would like to add a Message Box that warns the user that if they click "ok" on the message box they will start browsing, and if they dont want to do that click "cancel" in the message box. ( I know its obvious, bu thats what my friend...

Is there a way to allow edits to the properties of objects/controls only in Design view and not in the Form View?

Here's the problem: I am working on a database (I am not a programmer, I am just doing it for learning, and this is for a non-profit), where each record would have a PhotoLog sub form. The PhotoLog subform would have information on several photos (that are linked and not embedded) for each of...

If I have a file path name on a text box (say Text1) how can I get just the file name (with extension) in another text box (say Text2) without using any complicated functions... probably an expression in the control source.

After some help from one of the threads here I managed to install a Browse button in a form that inserts a file path to a text box. What I need is the folder path from that file path in another text box. For example if the file path is C:\Documents and Settings\mixup\Sketches\owl.jpg I would...