Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 19th, 2010, 09:35 AM
Authorized User
Points: 346, Level: 6
Points: 346, Level: 6 Points: 346, Level: 6 Points: 346, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2010
Posts: 61
Thanks: 0
Thanked 13 Times in 13 Posts
Default Continous Form (like Property Sheet entry)

Hi,

Daft question time!

The application I am developing needs to have a form where entry is a bit like a Property Sheet, continuous, left column read only, right column different type of entry could be freeform text, numbers, a date, a drop down box with different list values, etc depending on the current record.

Now I know you can't manipulate the current record by making controls visible etc without affecting the non-current records, so I can't do that. Neither can I create controls dynamically.

The number of records will vary, I suppose I could create a single form with lots of controls and only activate dynamically what I need, but this would put a restriction on the number of records that could be held.

I have tested (not completely) a floating input form that covers the entry on the form to be updated. It moves with the current record and looks good, however when the Access window or form moves sync is lost as there is no Move event. Also scrolling the current record out of view causes issues (Now sorted using a function in Timer). It's not really a good solution and I don't want to put more effort in until I can get some clarification I am going down the right path and may be missing a trick or two.

Any ideas would be appreciated or should I develop in Visual Basic instead?

TIA

Malc.

Last edited by malcolmdixon; October 19th, 2010 at 10:10 AM.. Reason: Solved part of issue myself
Reply With Quote
  #2 (permalink)  
Old October 23rd, 2010, 11:28 AM
Authorized User
Points: 346, Level: 6
Points: 346, Level: 6 Points: 346, Level: 6 Points: 346, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2010
Posts: 61
Thanks: 0
Thanked 13 Times in 13 Posts
Default

Well I managed to sort this out in a continuous form using the OnPaint event combined with a textbox and a combobox with certain properties set and a bit of other 'manipulation', it seems to work really well.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set form.field default value based on entry in another form rmccafferty SQL Language 1 February 11th, 2010 07:20 PM
Continous Form, resize based on content (Tricky) hkmulligan Access 2 August 13th, 2007 12:02 PM
How to run Macro on entry to new sheet? Wazar Excel VBA 4 May 16th, 2007 08:35 AM
Is it possible to select record in continous form chiefouko Access VBA 0 July 18th, 2006 04:20 AM
Continous form problem Vince_421 Access VBA 10 June 1st, 2006 05:06 AM



All times are GMT -4. The time now is 02:38 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.