Search results

Compacting my database cleared up my problem. Much Thanks

I am trying to modify a query that is a subreport to a main report, but when I try to save my changes, I'm getting an error message that says your changes cannot be made because you and another user are attempting to change the same data at the same time. I am the only person who has access to...

Is there anyway to refer to a font type, such as bold in a query. I want to create an iif query to say "need ltr 2" if text in a field is bold type. Thanks in advance.

How can I use one of the date functions to return the date for every saturday in a year. I have a timesheet report and the weekending date should always end on a saturday. Thanks in advance.

How many tables are too many? I may have to create a new table this time around because I have discovered that contractors and borrowers can have many different names for companies but have the same address and telephone number. Right now I have a Borrower/Contractor table with a field for...

I have an access data with 15 tables. Because my program has projects that can have several different situations per project, I have to create several many to many tables. My question is can a database have too many tables? It appears that I have to create yet another table with a one to...

I have a report with a footer which appears on the bottom of each page of the report when the report has more than one page. Is it possible to have a footer printed on the bottom of the last page of the report only? Thanks in advance.

Hi, Is it possible to separate results of a query by tab stobs. I have a query which give me a list of people to distribute a memo to. I need each person on the list printed across a report separated by tab stops. Thanks in advance.

You are right I cannot enter titles as I want using the Pagesetup method. I do not know how to use subreport. Can you explain how to create my labels using subreports. Thanks.:confused:

Hi everyone, I do not know if this is possible. I am trying to create customized labels by creating a report. I need the report to have two equal columns with ten rows. I want each row to have specific titles that I type in and then fields from a query. I want the titles and a project field...

Hi, I have a Borrower Table with a Phone# Field. The Input mask is set so that the data displays like (000) 000-0000. The primary key field which is a combination of letters and or numbers was changed for some of the records. For records that have new Primary Key ID# the Phone# Field now...

What I mean by repeating records is that all the output comlumns are repeated when the Owner Or Contractor are separate entities. I get two records for each project. The record for owners has Owner's field that has the the company's name but the Contractor's field is empty. The record for...

Jon K, I have a Borrower/Contractor table with Company name and several address fields. I have a Projects Table with project name and several fields about that project. Because a project can have many different contractors and a contractor can work on many different projects, I have ConPrjt...

Hi, I am re-asking this question because my post did not show up for some reason. I have a many to many table relating a contractor's table with a project's table. There is also a ownertype field with three choices: Owner, Contractor, Owner/Contractor. Is there some way to create a query...

Hi, I have a many to many table relating a Contractor's table to a project's table. There is a third field Ownertype with a list of three choices:Contractor, Owner, or Owner/Contractor. Is there someway to create a query if a project has a contractor and owner without duplicating the records...

mdemarte, I wanted to thank you for your help. I did not have the cntct # as the primary key as I had thought. By making it the primary key my problem was solved. Thanks. ;)

My projects table has a unique index that is the primary key. I have a field in the projects table that looks up values in the contacts table that is connected by Cntct#( the primary key in the contacts table). I hope this is not to confusing. Here is a copy of SQL View of the look-up query...

My contacts table does have a primary key that is set as auto-number type!!!:confused:

Please help!!! I have a projects table that has a look-up field from a contacts table. When I try to enforce referential integrity, I get an error message saying no unique index found. I don't understand whats wrong. Also, when I try to use this look-up field in a query, my query returns no...

OK!! I sort of got the query to work by using "Group by" and "First". The query gives me one record when there are two owners, but it does not always give me the owner of my choice. How do I get the query to pick the owner I want.:confused: