Search results

Thanks very much for that. I will give it a try

I wonder if there is a way of determining whether the print icon has been clicked during a print preview. I have looked a thread where the "activate" and "deactivate" were used but these are entered whenever "preview" is selected and don't distinguish the actual print. Any idea?

Thanks Bat17 I did that and sorted most things out. Locked in battle with other gremlins now

I tried the LibraryLoader and it gave an error message "could not find VB:vbe6ext.exe" and exited Access. Now, because I altered the startup to be the libraryloader it just does the same thing whenever I load the mdb. I want to remove the loader from the startup but cannot do so. Help!

I have an invoice report which is grouped by client. I wish to preview the invoices with the invoice numbers AutoNumbers generated at Group Header level in the Invoice table. The problem is that the code in the format part of the group header is executed a number of times, i.e. the first client...

I was updating the tables in the subreport to say that they had been processed and the report went through the code again and saw that the details had been processed and didn't do them a 2nd time. I had to put a flag in to check whether it was the preview or the print part of the report, to...

report footer problem I also seem to be having a report footer problem. I want to put invoice totals on the bottom of my report. I initially had the information on the page footer, but moved it to the report footer. Now in the preview of the report of the report everything looks ok but when I...

I guess it is may be possible, but why don't I get an error when I close the form with the X at the top right hand corner?

PS. this is in Access 2000.

I get the same error as you in a form which I am trying to close with an "Exit" command button. There is no other instance of this click event anywhere in the project. I wonder if anyone knows the answer to these problems, which cannot be that proposed by Bob above. Here is my code: Private...

It is ok, I seem to have got around it by not defining the RecordsetClone as a recordset object and only using the verbs available for this as follows: Private Sub ID1_GotFocus() ' Find the next ID1 to be used if a new one is being input Dim rst As ADODB.Recordset Dim strSearchID1...

I wonder if this is something to do with the version of VBA that I am using. I have version 9108, which is VB 6.3 1987-2001.

when I try to define "rst" as a recordsetclone as follows, I get the message "Run time error '13', Type mismatch" dim rst as RecordSet If IsNull(Me.ID1) Then strFirstChr = Mid(Me.Name1, 1, 1) strSearchID1 = strFirstChr & "*" Set rst = Me.RecordsetClone...

When I use the following code I get the message "Object doesn't support this property or method". What can I do about this? Private Sub ID1_GotFocus() ' Find the next ID1 to be used if a new one is being input Dim rst As Recordset Dim strSearchID1 As String Dim GroupUpperLim...

I got it to work fine! Thanks for the abundance of info.

PS. I know the form is different, but I was just using a test form until I got it right

I did have Option Compare Database, but not Option Explicit. It eventually decided to work after I tried to put in OpenArg variable as a last resort. I never used the OpenArg, the where condition just seemed to work when I added the extra parameter. Here is my current code: I added an extra...

I open a form with a criteria set but when the form opens it has every record, rather than restricting the records to those matching the criteria. I wonder if anyone has had this problem before? I use a query in the called to get the underlying recordset. This is my code: Dim CritText As...

I can't see adSearch anywhere on my version of VBA. I have Access 2002.

a put in the MoveFirst and still got the same error. There must be something fundamental wrong with my logic somewhere. Thanks