Search results

DoCmd.SendObject acSendReport, "ReportNameHere", acFormatRTF, "EmailAddressHere", "ccHere", "BccHere", "EmailSubjectHere", "EmailMessageBodyHere", False, " "

worked perfectly, many thanks.

Using Access 2000, I have a form with a simple multi select list box. The user selects items from the box and clicks a command button, which runs code based on the selection in the list box. These entries may change as a result of the command, so the list box refreshes and updates, but the...

I am using Access 2000 SP3.

I have a report that previews and prints perfectly, with several levels of grouping. However, when I export the report in .rtf format, the top most level of grouping is excluded totally. This top level was added to the report at a later date, not at initial creation, if that makes a difference...

Ok I downloaded the Admin tools and OutlookSecurity.oft file to edit the settings. Following the instructions, it would seem you can only edit the settings if you use group policies with Exchange. I need to edit the settings on a machine using Outlook with an Internet Only mail account. Any ideas?

Our database can send a variety of emails containing Excel attachments by clicking on the relevant form buttons. This was working fine under Access 2000. However, since installing Service Release 1, Service Pack 3 and the Outlook SP3 fix, whenever the button is clicked a pop up box with a timer...

The procedures that require these queries to run are quite detailed. Time and resources are not available to redesign major parts of the database unfortunately. Thanks for all your help though.

So seeing as there were no corruptions or errors at all when the database was unsplit, its well worth reverting back for a speed increase of 300%. In this case, splitting a DB has been very bad.

Of course, but the slowdown is very apparant, even when the FE is being used on the same PC as the BE. Also, before when running these queries, the data was being processed on one PC but was located on another, but it was still 3 times quicker than now. I thought splitting sped up a large...

Our office database runs via a main form and table with about 100,000 records. It was unsecured and not split, so each user was opening the actual database file from their PC across the network. The computer it is hosted on has been in place for a year. All was fine and pretty smooth, access...

Dont really like the idea of a hidden command button, my forms are already full as it is! I still need Admins to be able to close the form though via right click, going into design view and then closing. Also, with your code and a non maximized form they could simply drag it down their screen...

Have set up database security fully and properly. What I need to do now is stop users from closing forms and editing data directly from the underlying tables. They must only be able to edit data via forms. I have set permissions for the users so that they cannot view forms in design view. I...

I could really do with that file too, if someone could PM or email it to me please...

I fixed the problem by changing the Lookup of each offending field in the table from Text Box to Check Box. Now all queries based off that table will default to check box rather than text box.

Worked perfectly, thank you. I think the table in question was originally created from an Excel sheet that was exported from a different database. The Yes/No data was therefor stored as 0/-1 in the Excel sheet and Access adopted this method of viewing Yes/No field in the new table in datasheet...

Oh yes, I know that the data is stored as 0/-1 regardless of how it is displayed in datasheet view. However, I print a lot of one off reports for various departments that are just print outs of query results. Designing an Access report would be a waste of time as its a one off. The query's...

Taken over a database from a colleague who has since left. The main table has several Yes/No fields, and the data contained within them is in the raw form 0 or -1, not the default check box appearance. Perhaps this was because the table was created originally from a source such as Excel...

But how did these zero length strings get there in the first place? The data in the source table was inputted from another database.

I used a combination of manual and update queries to change the odd and problematic data to true Null. Exactly what would the Trim function do (permanent?) and would it explain why it happened?