Search results

Thanks Thanks Pat, Now that I understand that point I can fix the problem.

modified query I modified my query by adding DateReportDue (from Reports) Date Report Recd (from Reports) PmtDue (from Payments) PmtActual (from Payments) GST (from Payments) for the last 3 fields under total I selected SUM so that in various other reports that are tied to this query I...

HI, Wondering if anyone can suggest what I am doing wrong. I recently added some subforms with one to many links to a tabbed form that I have. Since adding the subforms the rest of the form will not let me update any fields. The subforms are working fine, but the main part of the form will...

finally got it... don't know why but finally figured it out.. and it was in my table structures in My Project table I had ProjectID indexed as Yes no duplicates I had the same in my Payments table. Once I changed it to Yes Duplicates allowed I was able to create the one to many relationship...

can't change to one to many I understand that I need a one to many relationship between the two tables but can't seem to achieve that. I need to relate the ProjectID field in both tables as that is where the link is. I've tried every combination that the join type will allow but it always...

screen shot or master child link here's a screen shot of the master child links

screen shot of relationships Here's a screen shot of the relationships

HI, I am very :confused: I created a database to record various projects. For each project there may be up to 12 payments. I had setup a table to record each of those 12 payments and related information (date, GST). When I was trying to solve another problem, which I have now solved I kept...

Thanks for your suggestions. As far as I understand normalization, my database is normalized. I have the data stored in separate tables. All the data pertaining to reports required is in one table, all the data pertaining to payments is in another table etc. I have to allow for the potential...

I have a similar problem and would love to know how to use VBA to get all of the forms on the same record. My records all deal with a Project ID number. Because there is so much detail (eg room for 12 reports,with 12 dates due and 12 dates rec'd and 12 payments, with dates due and dates paid...

I have a table called Grants. It includes the ProjectID which links the table to other information about the project. Fields in this table include GrantAmount, AmountRefunded, DateOfRefund, AmtAdjustedDown and DateAdjustedDown.

Hi, I'm having trouble getting a query to return exactly the results I want and was wondering if anyone had any suggestions on what I could do. I have a database for various projects. They are given various amounts of funding according to a schedule of payments set up at the beginning of the...

Hi, I'm not sure if this question should go under queries or reports so I am putting it here. I have a complex query that involves 2 tables and another query. Because there are so many fields I double clicked on one table so that all of the fields would be in the query. There are 40 fields...

DateApprove Sorry about that..that was my working copy of the code. I originally had DateApproved but tried changing the label name to DateApprove. It doesn't work either way. Earlier I had a problem adding one of the other fields (CommitteeNotes) and it finally worked after deleting it and...

HI, I was able to adapt code from a previous post so that I can have certain records in a report show up as shaded. It all works fine except for 2 labels that I have in the report. I can't seem to get them to shade. Can anyone offer suggestions on what I could try to get the labels to shade...

found the problem Don't know why, but I deleted both fields, then re-added them to the document and all the shading works fine now. Don't understand why. Just thought I'd leave this post here incase someone else has a similar problem.

HI, I am creating a report that when it is presented to the committee needs to have projects that were on the last report and haven't changed shaded. From searching the report forum I was able to figure out how to do it from a previous post. This is the code I came up with Private Sub...

HI, Something strange has started happening with my access. I have a form open and tried to cut and paste some information into one of the fields. It doesn't matter if I try Control V or use the Edit Paste menu or use the Paste icon but the data will not paste. A popup box that reads Paste As...

Hi, I have a database that tracks when progress reports are due (up to 12 different reports) and when they are received. My fields are FirstReportDue, Second Report Due etc and FirstReportRecd, SecondReportRecd etc. I need to create a report that will show what reports are due in a given...

tabbed form Just saw something interesting while looking through the Contacts database that comes with Access. The contacts form is a tabbed form and on the record source for the form it has SELECT [Contacts].[ContactID], [Contacts].[FirstName], [Contacts].[LastName], [Contacts].[Dear]...