A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 10 of 10
Search took 0.04 seconds.
Search: Posts made by: Boggle
Forum: Using Forms May 17th, 2010, 10:16 AM Posted to microsoft.public.access.forms
Replies: 6
Views: 346
Posted By Boggle
Order By/Filter clause corrupted with aliases

Hi Karl,

I just realised that after writing the query, I put SELECT * FROM query in
the Record Source, instead of what I guess you meant - setting the Record
Source directly equal to the query...
Forum: Using Forms May 14th, 2010, 04:26 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 346
Posted By Boggle
Order By/Filter clause corrupted with aliases

Thanks for the suggestion - but it didn't help. After saving, Order By
becomes:
Lookup_control.[query.table1.field]

and again, table1 is always the first table joined in the query, and...
Forum: Using Forms May 14th, 2010, 03:51 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 346
Posted By Boggle
Order By/Filter clause corrupted with aliases

It gets worse. I removed the aliases just to see what happened. I am still
referencing two fields with the same name in different tables. The Order By
clause is still fine until you...
Forum: Using Forms May 14th, 2010, 03:05 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 346
Posted By Boggle
Order By/Filter clause corrupted with aliases

By the way this is Access 2007.

I just wrote a simple cleanup routine (within any pair of square brackets,
split by periods, and replace the contents with the last token), but the
syntax check...
Forum: Using Forms May 14th, 2010, 12:57 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 346
Posted By Boggle
Order By/Filter clause corrupted with aliases

I have a datasheet form (actually it's a subform, but this happens if you
look at the subform on its own). It has a SQL query for a record source
which joins three tables, and uses aliases (AS)...
Forum: Using Forms April 12th, 2010, 09:49 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 68
Posted By Boggle
Flickering/flashing when updating image or moving mouse ACC2007 Wi

I have an image control supported by a lot of code to allow dynamic and
interactive graphics - for example drag and drop of activity boxes in a Gantt
chart. I trap mouse up, mouse down and mouse...
Forum: Using Forms January 26th, 2010, 06:52 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 129
Posted By Boggle
Pivot table/chart in subform - can't open Field List

And finally - I found a download of a compiled help file for Access 2003
Office Web Components (OWC11), owcvba11.exe which is a self-extracting
archive of owcvba11.chm. So far the properties seem...
Forum: Using Forms January 26th, 2010, 05:26 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 129
Posted By Boggle
Pivot table/chart in subform - can't open Field List

Just in case anyone else is looking for an answer ...

I was wrong about the pivot chart being accessed via the PivotTable property
of the form. I guess the form has the stub of a pivot table even...
Forum: Using Forms January 21st, 2010, 04:28 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 129
Posted By Boggle
Pivot table/chart in subform - can't open Field List

OK, looks like I've got a workaround for pivot tables. If you do:

frm!PivotTableSubForm.Form.PivotTable.DisplayFieldList = True

then the field list pops up. So I shall probably put that on a...
Forum: Using Forms January 20th, 2010, 07:46 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 129
Posted By Boggle
Pivot table/chart in subform - can't open Field List

I have an MDB (developed in Access 2003) with forms which include subforms on
a tab control. Some of the subforms are in PivotTable or PivotChart view
(with a SQL recordsource). I want the users...
Showing results 1 to 10 of 10

 
Forum Jump

All times are GMT +1. The time now is 11:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.