Search results for query: *

Hi All, I have a problem with Outlook VBA, as follows: I have my own domain name and consequently get everything@mydomain.com downloaded to outlook (mostly junk). There are several users on the same PC with their own profile. What I want to do is copy specific mail items to the relevant user...

I have a chart with its data table displayed (approx 40 values) because the values are up to 15,000 you cannot read them when displayed normally, so I want to display the text vertically. Is this possible? there is no option in the Format Data Table dialog. TIA Rich Bespoke and off-the-shelf...

I am trying to use the IN clause to update a table in another mdb. VBA produces the SQL string, but I get Error 3144 Syntax Error in Update statement. The table names and field names are the same in both mdbs. Here is the string: UPDATE [projectcodes]INNER JOIN [projectcodes]IN...

I am trying to create a Windows XP compressed (zipped) folder from Access 2000 using VBA. I then want to copy files to the zipped folder and email it. The copying and emailing aren't a problem, but I am having trouble in creating the zipped folder. Any ideas? TIA Rich Bespoke and...

It would appear that VB.Net Standard Edition 2003 does not have any built in report writing capability. I was sold on VB.Net on the basis that it had greater functionality than VB6. At least VB6 had the DataReporter. All the help files re reporting in VB.Net refer to Crystal Reports. It fails to...

Apologies if this is a stupid question. I have vb.net standard 2003, which I understand comes with Crystal Reports. The help system says go to Projects - Add New Item and select Crystal Reports. The problem is its not there. Help only seems to refer to Visual Studio.net in relation to Crystal...

I have a report which includes a subreport. The subreport also has a subreport (ie a sub-subreport). The problem is that if the sub-subreport needs to print on a subsequent page it will not. The next record is displayed and the rest of the sub-subreport data is lost. Any help greatly...

I am trying to place a tab control on a single page of another tab control. the problem is the sub tab control appears on all the parent tabs, not just the one I am trying to place it on. Before I drop the new tab control I select the parent tab page that I want it to appear on, but the new tab...

Hi, I am using the OutputTo command in a loop and I would like to stop the 'Printing report to ....etc' dialog box from displaying. Does anyone know how to do this? Setwarnings false does not do it. TIA Rich Lead Developer www.blsoftware.co.uk

I am trying to delete the links to attached tables, while keeping the system tables and a couple of others. Here is my code, run off a command button: Private Sub Command71_Click() Dim db As Database Dim tblD As TableDef Set db = CurrentDb() For Each tblD In db.TableDefs If Not...

HI, I am trying to change permissions so that users can export tables to a backup file, and then once the backup is created, change their permissions back so that they cannot open the backup. (so that the backup cannot be changed. This is my code : '******************************** Dim W As...

I have an Access 2000 project and when I try to close a form I get the error message: " You've copied a large ammount of data to the clipboard, do you want to save this data for other applications". There is a lot of VBA code attached to the form but nothing which actually writes...

I have seen this question before, but didn't need the answer till now. I have searched FAQ and Keyword Search, without success, so here's the question; I have an application in Access2000 in which several forms take a long time (about 30sec) to load, after that they load quickly (presumably...

I have seen this question before, but didn't need the answer till now. I have searched FAQ and Keyword Search, without success, so here's the question; I have an application in Access2000 in which several forms take a long time (about 30sec) to load, after that they load quickly (presumably...

I am try to use an array in a recordset, but I keep getting the "Item not found in this collection" error, which I assune to mean it cannot interpret the variable name. here is part of my code: dim arAccSalary as variant, arSalary as Variant, ArAccSalaryC as control '*********store...

I have two combo boxes on a form, cboFund and cboCostCentre. Both combos are bound to fields on the form; Fund and CCentre The selection in cboCostCentre is dependant on the fund selected in cboFund. cboCostCentre is requeried on the cboFund After Update event. The ID's of each selection are...

I am trying to use docmd.findrecord to move to a particular record in a sub form, but cannot get it to work. I have a form 'Employees' and a datasheet subform containing salary levels. When the user moves to a different employee I want the subform focus to move to the first record where the...

I have an Access97 document management database, which uses the Acrobat Active X component, enabling me to display Acrobat in an Access form. How can I create a record in Access every time the document displayed in the Acrobat window is printed? Its a tough one but any help greatly appreciated...