Search results

How is the query being called? Are you clicking on a button?

Is it not possible for you to have a query to extract the text data you want? Like this: SELECT [tblMain].[MainID], [tblBreed].[breedType], [tblAnimal].[animalType] FROM tblAnimal INNER JOIN (tblBreed INNER JOIN tblMain ON [tblBreed].[BreedID]=[tblMain].[BreedID]) ON...

Probably too late for you but : Private Sub Check12_AfterUpdate() DoCmd.SetWarnings False If Check12.Value = True Then DoCmd.OpenQuery ("UpdatePoints") DoCmd.SetWarnings True Me.Refresh Me.Check12.Value = False end sub Query called "UpdatePoints" UPDATE tbl_points SET tbl_points.active =...

I have used this and it 'works for me'. Format([Date], "dddd") & " Week " & DatePart("ww", [Date]) & " of " & DatePart("ww", "12/31/" & [Year]) When I ran with it [Date] and [Year] are fields on a form. Are you getting an error when you run yours? I can only think that it doesn't know what...

gotcha. Makes sense. cheers

Heres my attempt at Dgar007's suggestion. It seems to work.

On second thoughts that's not what you want. sorry.

In the form replace DVDTitle with EpsiodeTitle as the Recordsource of the field.

Have you followed the other instructions of the web page, ie. copying of the files to correct location etc?

[URL http://support.microsoft.com/default.aspx?scid=kb;en-us;249065&Product=acc2000 [/URL] Maybe this will help.

Hi Milo Can you explain why you have used this. .MoveLast .MoveFirst .FindFirst "[Account Number] = """ & strAccNumber & """" I understand what they do individually but not when used one after the other like this. Thanks

Remove the two dots from the end of the link.

I have created a PivotTable (which works) but I now need to change the source of the data from a linked table (textfile) to an an actual table. The data structure of the two is identical. The textfile has been imported. To save recreating PivotTable stuff is there a way to just point it to the...

Did it just like the Doc_Man said. Glad to help.

Is this what you mean? I'm not sure but I suspect that the (cr) code is in the wrong place in your sample.txt file. What data is supposed to be in what field?

Here's a slightly modified version to make it easier to follow what I've done.

Open the form and run from there.

Here you go.

Here's a couple of examples that might be useful.

Why not have just one report whose footer is modified/manipulated by the calling sub. How different are the footers?