Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Forms | Forum profile

Forum profile page for Forms on http://www.access-programmers.co.uk. This report page is the aggregated overview from a single forum: Forms, located on the Message Board at http://www.access-programmers.co.uk. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Forms" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Access World Forums - Forms (site profile, domain info access-programmers.co.uk)
Title: Forms
Url: http://www.access-programmers.co.uk/forums/foru...
Users activity: 4 posts per thread
Forum activity: 186 active threads during last week
 

Posting activity on Forms:

  Week Month 3 Months
Threads: 186 598 1,669
Post: 696 2,545 6,759
 

Forms Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
boblarson
78
user's latest post:
Form Sinc
Published (2009-11-08 22:27:00)
Gareth: 1. Are you aware that the navigation buttons at the bottom of the form which shows the "record number" is misleading to many? The "record number" of which you speak is nothing more than a RELATIVE reference for records in the CURRENT recordset. They are not numbers which can identify a record always. 2. The Primary Key of your table should be the identifier of which you use to identify any row of...
missinglinq
56
user's latest post:
Open the form and find specific...
Published (2009-11-08 03:03:00)
After selecting " Open the form and find specific data to display " you have to hit " Next " and will be presented with a screen with the text " Which fields contain matching data the button can use to lookup information? " Below this are two boxes to select the field in each table you wish to use to "match" up the records. The only way I could replicate your problem was...
John Big Booty
45
user's latest post:
Don't print buttons on Form
Published (2009-11-08 21:51:00)
Quote: Originally Posted by ajetrumpet isn't there a "print" property for controls on forms? I thought there was always an option to print the control or not. is that not right? I know it is for some of them at least. You learn something every day There is a property Display When , which can be set to; Always , Print Only or Screen Only . How simple is that? No need to piss around with code
DCrake
27
user's latest post:
Merging multiple rows from a...
Published (2009-11-06 07:03:00)
I would swap you addresses subform for a list box and base the rowsource on the current subforms recordsource. Make the list box a multi select list box then let the user highlight the ones they want then have a command button that enumerates through all the selected items in the list box and concats them together with a semi colon, which is then passed to the Bcc textbox. David
gemma-the-husky
26
user's latest post:
Multi Subform in a tab
Published (2009-11-06 08:02:00)
ignore the blank subform instead of having a tab form with six tabs, just have one tab, and put on the tab any one of your six subforms now create an option group - and enter six options (values 1 to 6) with suitable text in the afterupdate event for the frame put this sort of code select case framewhatever (the name of the frame control) case 1: subdetails.sourceobject = "subform1" (whatever that is) case 2:...
sullyman
25
user's latest post:
update data in both form and...
Published (2009-11-03 15:37:00)
When you changed data again in the main form, did you again save that record to fully commit it
pbaldy
25
user's latest post:
Best solution for preventing...
Published (2009-11-06 17:32:00)
Actually it should be fairly simple. Try setting the Allow Edits property of the form to No (take a look at the other similar properties as well). That should allow the creation of new entries but prevent edits to existing records.
namliam
23
user's latest post:
Filtering the dropdown list in a...
Published (2009-11-06 05:27:00)
Unfortunatly what you want is not possible, your option 2 is the only viable workaround. The problem is that the combobox's visible are one and the same, only with different values. Change one, change all.
cheer
19
user's latest post:
SubForm Refresh Delay Problem
Published (2009-11-05 20:24:00)
Created one main form contains a SubForm inside. There is two buttons on the main form, indicated by a) Save button b) Refresh button This button will insert data through the insert SQL string into seperate MS Access but under the same server before the data is displayed on the SubForm. Question: Why I need to click the Refresh button 2 to 3 times in order to obtain the latest info ? Below is my code Quote: Private Sub RefreshSubForm()...
ions
19
user's latest post:
Input Masks Questions
Published (2009-11-06 16:33:00)
You would trap for non alpha characters that were typos.
 

Latest active threads on Forms::

Started 12 hours, 36 minutes ago (2009-11-10 09:49:00)  by missinglinq
Quote: Originally Posted by elmister ...the result the value of the formula doesnt get put in the table under that field Of course it doesn't! The Control Source for the TaxPaid textbox is not a field in the table, it's =[Price of phone]*0.0825 Change the Control Source for the TaxPaid textbox to the ...
Thread:  Show this thread (6 posts)   Thread info: data bye bye Size: 1,135 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: data bye bye :: Forms :: Access World Forums"
Started 1 day, 5 hours ago (2009-11-09 16:26:00)  by John Big Booty
You could have a button that opens a pop up form that uses your query as a data source. Your query would use the following as Criteria for date; Code: Forms!FRM_Name!DateFieldName Where FRM_Name! is the name of the referring Form
Thread:  Show this thread (5 posts)   Thread info: user input Size: 530 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: user input :: Forms :: Access World Forums"
Started 13 hours, 43 minutes ago (2009-11-10 08:42:00)  by boblarson
Yep, just set the BORDER property of the subform control (control on the main form which houses the subform) to TRANSPARENT, and the SPECIAL EFFECT to FLAT.
Thread:  Show this thread (3 posts)   Thread info: Removing border/frame on subform Size: 156 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Removing border/frame on subform :: Forms :: Access World Forums"
Started 13 hours, 57 minutes ago (2009-11-10 08:28:00)  by NC24
I'll try that, thanks!
Thread:  Show this thread (2 posts)   Thread info: Adding fields from different tables to the same form without error Size: 22 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Adding fields from different tables to the same form without error :: Forms :: Access World Forums"
Started 1 day, 1 hour ago (2009-11-09 21:04:00)  by georgedwilkinson
Check the sql source for the combo boxes and try running that same sql in a query window. If it doesn't work, you'll be a little closer to the answer. My guess is that there is no connection to the table(s) where that data resides. But nobody can really tell without more information.
Thread:  Show this thread (9 posts)   Thread info: Combo Box Not populating Size: 301 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Combo Box Not populating :: Forms :: Access World Forums"
Started 17 hours, 30 minutes ago (2009-11-10 04:55:00)  by Mr. B
I hate to be the bearer of bad news, but you need to redesign you database structure. You need a table for the client locations, not three columns in the client table. This will make life simpler for you. Change this and then you will be able to have your combo box that will very easily show the available locations for a selected client.
Thread:  Show this thread (8 posts)   Thread info: Dependent Dropdown and Multi Columns Size: 358 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Dependent Dropdown and Multi Columns :: Forms :: Access World Forums"
Started 1 day, 11 hours ago (2009-11-09 11:20:00)  by boblarson
First of all, you need a couple of things. 1. You don't have a checkbox on the form called Active (not sure I would call it that but since you do, my code reflects that. That is why you are getting the initial error. 2. Once you put a check box on the form and name it Active then you can use this code in your checkbox's After Update and the form's On Current event: Me.PaymentIN_...
Thread:  Show this thread (9 posts)   Thread info: Show/Hide active form Size: 516 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Show/Hide active form :: Forms :: Access World Forums"
Started 17 hours, 17 minutes ago (2009-11-10 05:08:00)  by DCrake
From a users point of view I would find this more of a hinderance. You are telling them something that they already know. How do they know, beauce they have just changed it. I don't know how busy your screen is but lets say it has 20 controls, there is a possiblity for at least 20+lines in your message box, a more simple aproach would be to tell them that the changes they have made are about to ...
Thread:  Show this thread (4 posts)   Thread info: moved: Update record dialog with exact confirmation on which fields to be
updated? Size: 584 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: moved: Update record dialog with exact confirmation on which fields to
be updated :: Forms :: Access World Forums"
 

Hot threads for last week on Forms::

Started 4 days, 15 hours ago (2009-11-06 07:03:00)  by DCrake
I would swap you addresses subform for a list box and base the rowsource on the current subforms recordsource. Make the list box a multi select list box then let the user highlight the ones they want then have a command button that enumerates through all the selected items in the list box and concats them together with a semi colon, which is then passed to the Bcc textbox. David
Thread:  Show this thread (26 posts)   Thread info: Merging multiple rows from a single field into a textbox Size: 398 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Merging multiple rows from a single field into a textbox :: Forms :: Access World Forums"
Started 6 days, 10 hours ago (2009-11-04 11:51:00)  by boblarson
Are you using the FORM's before update event or the control's? It should be the FORM's event that you are using. That way if any other control has something either entered in it by someone or an edit is made, it dirties the form (provided it is a BOUND form). Then the Before Update event WILL fire whenever you either try to navigate to another record OR even closing the form.
Thread:  Show this thread (24 posts)   Thread info: Check for required field in Before Update event Size: 381 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Check for required field in Before Update event :: Forms :: Access World Forums"
Started 4 days, 14 hours ago (2009-11-06 07:27:00)  by someboddy
What do you mean by "can not seem to create the combobox"? Is access not letting you draw it on the form? Or is the problem in populating it?
Thread:  Show this thread (23 posts)   Thread info: combobox from table Size: 151 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: combobox from table :: Forms :: Access World Forums"
Started 4 days, 20 hours ago (2009-11-06 01:59:00)  by namliam
I cannot see the images, but this is what I understand you want to do.... You want to see all the animals that can be carried in cages, as long as the cage can carry a dog... You would have to change your query a bit.... instead of searching for "dog" you need to be searching for cages that can cary a dog. So instead of a query like so select * from yourcagetable where type = "dog" ...
Thread:  Show this thread (20 posts)   Thread info: Filtering the dropdown list in a combobox Size: 597 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Filtering the dropdown list in a combobox :: Forms :: Access World Forums"
Started 1 day, 14 hours ago (2009-11-09 07:47:00)  by boblarson
Rick: I'm still kind of trying to figure out exactly what you are saying for your DLookup part, but I'm wondering if your tables/relationships are proper. I usually find if the relationships seem to form a circle then something is not right.
Thread:  Show this thread (17 posts)   Thread info: DLookup: One to many table relationships Size: 372 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: DLookup: One to many table relationships :: Forms :: Access World Forums"
Started 1 week ago (2009-11-03 13:37:00)  by boblarson
It would not be available because that feature is only available with the new ACCDB format and not with older adp, mdb formats.
Thread:  Show this thread (16 posts)   Thread info: ADP Collect Data Feature Size: 127 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: ADP Collect Data Feature :: Forms :: Access World Forums"
Re: Very odd problem - 14 new posts
Started 1 week, 4 days ago (2009-10-30 06:27:00)  by Fifty2One
Did you put a requery for the next combobox after your rowsource statement to reset the subsequent combo boxes?
Thread:  Show this thread (18 posts)   Thread info: Very odd problem Size: 111 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Very odd problem :: Forms :: Access World Forums"
Started 1 week ago (2009-11-03 16:04:00)  by John Big Booty
You will need to set the focus to any other control before you can return it to the original control, try something like; Code: Private Sub cboGeneratorNumber_LostFocus() If Me.cboGeneratorNumber = 0 Or IsNull(Me.cboGeneratorNumber) Then MsgBox "You must select a Generator.", , appTitle Me.AnyotherConrolOnYourForm.SetFocus Me.cboGeneratorNumber....
Thread:  Show this thread (14 posts)   Thread info: Control Validation Rules Doesn't Work Size: 756 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Control Validation Rules Doesn't Work :: Forms :: Access World Forums"
Started 5 days, 11 hours ago (2009-11-05 11:08:00)  by boblarson
Go into design view of the form and place a tag of "lock" (without the quotes) into the TAG property of the controls you want to lock. Then you can set the AllowEdits to YES so your text box works and then you put this in the On Current event of the form: Code: Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "lock" Then ctl.Locked = True End If ...
Thread:  Show this thread (14 posts)   Thread info: How best to allow edits to some fields but not others? Size: 727 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How best to allow edits to some fields but not others? :: Forms :: Access World Forums"
Started 1 day, 14 hours ago (2009-11-09 07:51:00)  by resolva Registered User
Hey all, got a problem with a database which should be simple but it doesn't seem to be working. If you see in my relationships I have a weak entity table between Speakers and Presentations. I am basically trying to make a form so that it has Speakers on and a subform underneath it with the Presentations which that speaker does. I have tried every way possible of linking them but it ...
Thread:  Show this thread (14 posts)   Thread info: Linking form with subform problem Size: 493 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Linking form with subform problem :: Forms :: Access World Forums"