Search results

I am in a similar situation. The DB I created has been found to be very useful to my department. They were hostage to fortune as I was the only person who could adminster/maintain the DB. I flagged this a long time ago, but they only took me seriously when I handed in my notice :eek: Our...

Hi there Fenerfan, I am not sure about the actual question you ask but I think you cannot manipulate the reprot from the code that calls it. What you can do however, is manipulate the report itself directly in the "on Print" event. On my form I have code that populates various text boxes and...

If the spambots earn their keep on a pay per click basis, you would only be encouragng and rewarding them plus exposign the forum to the potential malwear that can lurk in these unsavoury places. Still, if you can devise a game that the moderators think safe, why not.

Only post once Boris, Only post your queries once and try to post them in the most appropriate part of the forum. You can go to threads you start and use the thread tools to delete the unwanted entries. I think your problem can be solved by creating a query in design view. Show the table that...

I eventually tracked down the problem. I have a table with 1 record to hold the date that the database was last updated. This field was added to the query and used on the title page of the report. When I revamped the update date form, the Data Entry option was set to Yes and so the update date...

Hi Bob, Thanks for the suggestion. The management comments and other stuff at that level and below are subreports in group footers. All the subreports in the footers seem to behave properly. They are all linked by the same field (ProjectID ). When I get back to the office I will check the...

asking the wrong question and getting the wrong answer mikebaldam, Your code works fine so thanks for that. It did not solve the problem I thought I had directly but it did put me on the right track. :) GHudson, your comments in your original post misled me with a 'trap for new players'...

Lists within lists Hi MStCyr This version orders a list within a list. The main form has a combo box used to select a sub grouping of the record set, in this case all the individuals in a particular department, and allows you to position them within that subset. This is used to make the...

Hi, My report has started printing the details twice:eek: I have been using the report for quite a while and never had this problem before, although I have been modifying things quite a lot recently. I can't see anything that might cause this or even think of how to do it. Any ideas...

Pretty straightforward Shades and works a treat. Regards,

A couple of points here. 1. It seems that the property was tied to your job. This may significantly change things as access to the property may be essential to the function of the job you left. Whether that makes a legal difference or not, I don't know but there was a complaint amongst...

Hi there, Chatting with someone who used Excel a lot, I mentiond the method I use in Access to concatenate things without spaces when an item is null. For example: Expr1: [FName] & " " & ([MName]+" ") & [LName] The bracketed middle part of the expression will not produce anything if there is...

Moniker, I hadn't come accross you at the time of writing the orignal response and would not have used your handle if I had. Coincidentally, you have been a great help responding to my postings on the same day I wrote it. Kind of a small world thing I guess. I can confirm to any that you do...

Thanks Moniker, That makes sense and I think I should be able to get it worked out - open, set caption, close, reopen & mail :) . I did read another post that claimed a closed report could have the caption reset but the link to the sample db was broken. :rolleyes:

Hi mctaguma, I don't think there is enough info to go on there. If you strip out all the data from the tables (in a copy db!) and delete the db items not relevant to your problem (tables, forms, queries etc) is it small enough to zip and post? This might be the best way forward. Cheers & welcome.

Hi Miniker, Thanks for the reply, although I'm not sure I understand it in relation to my problem. My report button outputs to preview, print or email depending on an if/then that looks at a frame select. Because of this, I want the report to be the same for the three options. The caption is...

No worries LeapardFist - glad to give back a little for all the help I have had from thsi forum From my sample can you see what you were doing wrong as it had to be something simple like a spelling mistake. Regards,

Hi there, I posted a question about this a while ago and got no response. The only thing I found on a search was a dead link to a solution, so I hope you will forgive me for posting again. I email reports from a button on my form. All works fine but the attachment to the email has the caption...

Hi, If every item in your tables only appears once, then they should be a single table. I don't know if there is a limit on the number of fields a table can have, but I assume it is a lot. The only normal reason people have one to one relationships is to protect sensitive data such as having...

Reserved word alert :eek: Access uses 'Name' itself. If you use this moniker, you will get all sorts of problems. Retitle your field to somethng else like "EmpName" for instance. Do this then Zip your db and post it if it has no sensitive data etc. Regards,