Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Continuous Form & 2 queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NetworkTrade - 04 Mar 2008 23:56 GMT
User would like a spread sheet type look (former excel junkie)…but for a
good reason.  Will describe in nontechnical terms:
The data on left half is related to data on right half by a unique common
field.  But a query that would bring them into a single record source results
in the query not being update-able. (The left half data is from a query that
has a sum subquery….so I understand why the query is not updateable)

So while the left half data is static – the right half data is update-able.

Going with a subForm loses the continuous form look they want to scroll thru
lots of lines of data

Is there any method to establish a continuous form style where the
left/right sides scroll in sync?  Am in 07.  Or maybe I need to back and
forth between access & excel……presuming someone else out there has wrestled
with the same situation would welcome ideas…..

Signature

NTC

NetworkTrade - 05 Mar 2008 00:36 GMT
answering my own question;

write the left side data to a temp table - then make query on this and right
side data......results in an updateable query...allowing a continuous form....

Signature

NTC

> User would like a spread sheet type look (former excel junkie)…but for a
> good reason.  Will describe in nontechnical terms:
[quoted text clipped - 12 lines]
> forth between access & excel……presuming someone else out there has wrestled
> with the same situation would welcome ideas…..
Peter Hibbs - 05 Mar 2008 09:38 GMT
Using a Flex Grid control would be more elegant and also looks more
like a spreadsheet. Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20D
emo.mdb
'
for some examples.

HTH

Peter Hibbs.

>answering my own question;
>
>write the left side data to a temp table - then make query on this and right
>side data......results in an updateable query...allowing a continuous form....
NetworkTrade - 05 Mar 2008 16:46 GMT
thanks will check it out
Signature

NTC

> Using a Flex Grid control would be more elegant and also looks more
> like a spreadsheet. Have a look at :-
[quoted text clipped - 9 lines]
> >write the left side data to a temp table - then make query on this and right
> >side data......results in an updateable query...allowing a continuous form....
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.