Search results

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

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

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

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

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

HI, I've just been asked to add some information to a database I have partially built and would appreciate some suggestions on how I should go about it. Currently for exisiting projects I have a table that contains fields for up to 12 payments, for each of those payments I also have a related...

HI, I am building a database that records information surrounding grant monies given out by the department that I work for. Each grant is recorded as a project with an ID and description as well as the organization it was given to, the amount and various other data related to the grant. Some...

Hi, Last year I found a report somewhere on an access help site that would show a timeline. I copied the report into my Access 97 database and it worked fine. I tried exporting this report to my current Access 2000 database but it keeps coming up with an error. The error section that is...

Hi, I'm am trying to figure out how to do calculations for fields in a report. I've managed to get my report to show Consultant Project GrantAmount ConsultantFee Data Data Data Data Data...

Hi, I have a table of Organizations that I use a 5 letter code for the ID field which is the Key Field. I have a query on the Organization table and from that I built an Organization Form to make entering the information easier. The 5 letter code usually involved the initals of the...

Hi, I am building a database and would like to create a field in a query that totals several other fields. I haven't done any calculations before but understand that they can be done and the best place to do them is in a query. I did a search in this forum but could not locate a problem where...

I have the following lookup statement SELECT DISTINCTROW [Year] FROM [Year] ORDER BY [Year DESC]; I have a PROJECT Table that I need to indicate the year that the project commenced. Once all of the historical data has been input, the most frequent year used will be current year. My YEAR Table...

I have a database with several tables. I have ID fields for most of my tables. In my main table I have a field called GranteeID. Rather than have the ID number appear in the table I would like the Grantees LastName and FirstName to appear. At prestent in the Row Source box I have keyed in...