|
More site info...
microsoft.public.access.formscoding | Forum profile
|
|
Forum profile page for microsoft.public.access.formscoding on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.access.formscoding, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
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 "microsoft.public.access.formscoding" on the Message Board at http://www.microsoft.com/communities/newsgroups... 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 microsoft.public.access.formscoding:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
95
|
302
|
1,136
|
|
Post:
|
215
|
705
|
3,112
|
|
|
microsoft.public.access.formscoding Posting activity graph:
|
Top authors during last week:
user's latest post:
Clicking maniacs… in...
Published (2009-11-08 03:50:00)
Hi all.. I have an issue were clicking more then once on a command button creates problems in a network environment. It takes some time for the command to reach the back end etc etc. Is it possible to restrict the number of clicks that execute the command? Lets say that only one “click” is valid..after the initial click..the command is not valid? Thanks a lot!
user's latest post:
Which Form Event in...
Published (2009-11-05 12:58:00)
"RayToddJr" <RayToddJr@discussions.microsoft.com> wrote in message news:F06E92C4-2403-4B37-BDC3-C78EB19CA741@microsoft.com... > Which event do I need to use to be able to compare an .oldvalue vs .value? > > I am currently using AfterUpdate event however, the .oldvalue is always > equal to the .value? A bound control's .OldValue property holds the value of the control...
user's latest post:
dsum error message in...
Published (2009-11-05 11:44:00)
Hello. I am using the following dsum but keep running into an error 2471 about the expression entered as a query parameter produced 'BusinessType'. I can not figure out what the issue is. material_qty = "" & DSum("Quantity", "SalesOrderItems", "Quantity > 0 And SONumber = Forms!SalesOrders.SONumber And BusinessType Like...
user's latest post:
What is best way to re-use an...
Published (2009-11-03 07:40:00)
Access Vandal, We are not reusing the "account number". Each member is assign a account number that NEVER changes. And I should have been more clear. We do not "delete" a member. We flag the the member as "deleted". The number we are re-using is a "door prize" number. This number is used to reward prizes to members at different fund raising events. They are...
user's latest post:
Call a Public Sub-routine on a...
Published (2009-11-03 08:43:00)
I am using the custom navigation buttons from www.lebans.com, and he includes a call to a public sub in a subform, using this syntax: Call Me.frmNavButtons.Form.EnableDisableButtons I would like to make the same call from that form's parent form, so I am trying to do something akin to this: Call Me![Primary Tasks Subform].Form!frmNavButtons.Form.EnableDisableButtons but in the different versions of this I have tried, I've...
user's latest post:
Bypass code in...
Published (2009-10-30 12:56:00)
I need to find an easy way for the user to create a new record (or choose not to)after they complete the record they are in, so coding it for a custom message box seemed the easiest way to do that. I understand that it fires each time, which is a drawback, I agree. That's why I wanted to know if there was any work around to avoid having it fire under other circumstances. "Linq Adams via AccessMonster.com"...
user's latest post:
Concentate combo box selection...
Published (2009-11-06 11:09:00)
I experimented. When I took the "(0) off of the end of the statemetn it works fine. But I'd still like to knwo what's going on etc. so that I can learn from this.
user's latest post:
Pulling ALL records in subform...
Published (2009-11-02 09:07:00)
Hi MN You could loop through the recordset of the subform. Regards, anlu "MacNut2004" <MacNut2004@discussions.microsoft.com> wrote in message news:54446243-BB2E-4132-9506-0AD226D8EA8D@microsoft.com... > Hello, > > I have a form that has a subform which can have multiple records entered. > What I am trying to do is to pull in data from the form AND subform into > an...
user's latest post:
Combo Box Hell or Why can't...
Published (2009-11-02 15:14:00)
Does it work if you set it to Null? Me.cboChangeRep = Null If not, try Me.cboChangeRep.Undo -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "DawnTreader" <DawnTreader@discussions.microsoft.com> wrote in message news:BDAD338B-4FB4-485A-9EB0-C9AE1A5DE13D@microsoft.com... > Hello All > > I thought i posted this once already, but it seems to...
user's latest post:
Appending Codes from a list. in...
Published (2009-11-05 13:04:00)
>>what goes in the left "action" column? SetValue -- Build a little, test a little. "Fred" wrote: > > Dear Karl, > > Thanks for the reply. But you might have forgot to treat me like a Dummy > regarding cod and combo boxes. > > When you said: > > On the combo box AfterUpdate event call macro to SetValue. > >...
|
|
|
|
Latest active threads on microsoft.public.access.formscoding::
Started 1 day, 22 hours ago (2009-11-08 14:35:00)
by Mr. B
AFAK, there is not a way to hide the line between columne, however, you could
concatenate values together and display in one column.
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
"Steve Haack" wrote:
> I ...
Started 3 days, 5 hours ago (2009-11-07 08:15:00)
by Beetle
A form has a RecordSource property, not a RecordSet
property. The RecordSource property is a string, so you
just use your SQL statement directly, rather than creating
a record set and trying to use that, which would result
in a Type Mismatch error.
Dim SQLstmt As String
SQLstmt = "Select * From TableA"
Me.RecordSource =...
Started 3 days, 17 hours ago (2009-11-06 20:07:00)
by Jack Leach
I use a recordsetclone of the subform to perform a FindFirst method on.
Actually, I recently built a global function to handle "standard" record
movements in a subform ( first, last, previous, next, offset). Your question
prompted me to write the below function, which will move to a given ID.
You will still need to capture the ID ...
Started 4 days, 1 hour ago (2009-11-06 12:19:00)
by kismert
You are working too hard. You want a "bound form" to do the work for you.
You do this by binding the form to the table via a query:
1. Make a query, qryResources, which returns all the fields in table
Resources, (Why? call it good practice)
2. In your form, set the Recordsource property to qryResources.
3. For each control in ...
Started 3 days, 20 hours ago (2009-11-06 16:51:00)
by Jack Leach
In the afterupdate event of the form set the Enabled property of the button
to false...
Private Sub Form_AfterUpdate()
Me.ButtonName.Enabled = False
End Sub
this is one way, but then you need to reset it for each record you go to
(use the Current event of the form) or when the form is Dirty... etc.
...
Started 3 days, 20 hours ago (2009-11-06 16:46:00)
by Jack Leach
Me.Comboboxname.Requery should work. Disregard the fact that they are on
tabbed controls, it doesn't matter as far as this situation is concerned.
Have you been able to verify that the queries are pulling the correct
information? I use the Me.Comboboxname.Requery method all the time for these
types of operations. It seems as ...
|
|
Hot threads for last week on microsoft.public.access.formscoding::
Started 1 week, 1 day ago (2009-11-02 12:15:00)
by Daryl S
Dennis -
I assume you have a valid reason for re-using the numbers, and cannot just
create new ones.
Do you need a different set of numbers for each fund? In your Background
section, it sounds like one number per person. I am not sure of the 'group'
that a member leaves, causing them to be deleted. If you just need ...
Started 1 week, 1 day ago (2009-11-02 09:51:00)
by Keith Wilby
"Renraf" <Renraf@discussions.microsoft.com> wrote in message
news:A69BF9DB-A32F-4A50-852F-86A922027C03@micros oft.com...
>I was wondering how I can use BeforeUpdate and AfterUpdate events, or
> something similar, in a split database.
>
> I had validation code in the BeforeUpdate event for the record, and it was
> working fine ...
Started 5 days, 23 hours ago (2009-11-04 13:38:00)
by KARL DEWEY
>>it would append my selection onto the end of whatever is already in the
"Codes" field
The term 'append' in Access mean to add records but your further comment
sound like you want something else.
Can you elaborate some more on what you are trying to do?
--
Build a little, test a little.
"Fred" ...
Started 1 week, 2 days ago (2009-11-01 05:24:00)
by anlu
Hi Peter,
You should leave out the ' in the first argument - that is probably what
generates the error. Also, if you want to use wild cards in your criteria,
you should use "like" in stead of "=", otherwise you won't get many hits.
I.e. your code should look like this:
If DCount("*","FruitQuery","[Fruits] like '*" & Me...
Started 6 days, 2 hours ago (2009-11-04 10:24:00)
by Daryl S
John -
It sounds like you just need to know how to get the code into the right place.
Since you are using the Me convention, this code should be in the form, not
a stand-alone module. There are a couple ways to open the code window for
the form. It is probably easiest to go into design mode on the form, then in
the ...
Started 1 week, 1 day ago (2009-11-01 19:06:00)
by BB
Hi Jani
Just to clarify, since you say, "today is November 1, I would want to pull
200910", does this mean that you ALWAYS want to run the report for the six
month up to the end of last month?
That aside, you need to use the FORMAT and DATEADD functions.
FORMAT function example: FORMAT(Date(),"YYYYMM") - formats ...
Started 1 week, 1 day ago (2009-11-02 05:40:00)
by Mike Painter
Jeff wrote:
> I have a form that used to be a standalone where the user selected the
> event to be modified and based on that, I changed the color of the
> screen. That works fine.
>
> Now the users have requested to make the form only available through
> another screen (users click a button, which calls a macro to open the
>...
Started 1 week, 1 day ago (2009-11-01 19:10:00)
by BB
Goldar
A quick question, in your code, you are attempting to open a recordset base
a variable called: qryBudgetAsTotals
Is this supposed to be a variable, or is that the actual name of a query you
want to open, in whic case you need to enclose it in quotation marks, ie:
"qryBudgetAsTotals"
The same goes with "...
Started 1 week, 2 days ago (2009-11-01 05:09:00)
by anlu
Hi Peter,
My guess is that since your [Basket ID] seems to be a numeric field, this line
> Forms![Basket View].Filter = "[Basket ID] ='" & Me.Search & "'"
should be changed to
Forms![Basket View].Filter = "[Basket ID] =" & Me.Search
since the '- delimiter is only used on text expressions.
Regards,
...
Started 1 week ago (2009-11-02 13:35:00)
by Renraf
Sorry, should have done a more thorough search before asking. I believe this
is the correct syntax?
Forms!InputStudyData![Primary Tasks Form].Form!Category
"Renraf" wrote:
> If I have this layout in a form:
>
> InputStudyData ( primary form)
> -[Primary Tasks Form] (subform)
> --Category (control...
|
|