Recent content by aussie_user

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