|
More site info...
|
|
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.
|
|
|
|
|
Posting activity on Forms:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
186
|
598
|
1,669
|
|
Post:
|
696
|
2,545
|
6,759
|
|
|
Forms Posting activity graph:
|
Top authors during last week:
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...
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...
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
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
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:...
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
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.
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.
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()...
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 ...
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
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.
Started 13 hours, 57 minutes ago (2009-11-10 08:28:00)
by NC24
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.
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.
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_...
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 ...
|
|
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
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.
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?
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"
...
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.
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.
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?
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....
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
...
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 ...
|
|
Size: 1,135 bytes
