Search:

It was after I copied their data file and ran it as a test file against a copy of my main file. I opened 2 instances of Access on my machine and ran one in each. I decided to look at the...

Thanks for your suggestions.
I finally worked out what the problem was.
Because it happened on all their machines I realised it had to be a problem with the data file.
Somehow when one machine had...

I did a compact & repair - there was a corrupted record and the repair helped fix that.
Where do I check for locks?

Thanks
Lorraine

I have a database which has worked fine for years. I developed it for a business and maintain it. The business uses it in a networked environment, with the main file on each machine and data file on...

Thanks Hans

I knew I could do it that way but was hoping to do it automatically. Yes, I do use pdf995 and find it handy.



The built-in output to PDF doesn't have an option to convert only a...

I have a report which is produced as a pdf file and automatically attached to an email.
My problem arises when the report is more than one page, as we only want to attach the first page.
I know I...

Charlotte, Thanks for recommending the book 'Access 97 Expert Solutions'.
I went to Google and entered the book name, and found a site where I was able to download the entire text of the book! I...

Thank you Francois and Charlotte. That has solved it.

After I sent my question I checked out the Northwind sample database and found I had the same problem with it, so I knew then it wasn't a...

I have a strange problem. I have created and been using a database in A2000. It has a main form with a number of subforms on tab control pages. On the front page is a series of text boxes in which...

Thank you Hans. I knew it had to be something simple, just couldn't see what.

Here is a copy of the form and the table behind it. I was running it from a query, but realised that all the fields come from one table so changed the record source. I thought that might solve the...

No, it doesn't make any difference whether it is opened by itself or within the main form. And there is no VBA code which would affect it.
There must be something causing the problem, but I can't...

I have a very dumb question that I hope someone can help with.

I have a database which has a lot of forms & subforms, most of which are working fine.

Today I had to do another one, which is...

From the example you posted it appears you have spaces in the query name. If that is so, I think you would need either [ ] or " " around the name.

Instead of the OnOpen event, put it in the OnFormat event of the Detail section.

Remember to also set the Visible property for the label (if there is one).

Graham, do you have the Northwind sample database on your machine? If so, have a look at the Orders form and the Order Details subform. There you will see an example of what you are trying to do.
...

Try this:

Forget DSum - I just use Sum

In the subreport footer, set the control source for Text24 to read =sum(cost of parts) - I am assuming 'cost of parts' is the field you are trying to...

In the footer of the subreport create a text box to sum the totals you need. When the subreport is linked to the parent report by a job number, only the sum of the items in that job number will be...

Have you tried sending it in RTF format?

I haven't worked out the actual code needed, but my suggestion would be to create a new function in a module.

Either use Select Case or If..Then..Else construction to customise the result...

If you are using separate fields for each box you will run into problems - do you have a maximum number of boxes allowed?

Have you tried putting the information for the boxes into a separate...