|
More site info...
Discussions in microsoft.public.access.formscoding - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.access.formscoding:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
107
|
381
|
1,135
|
|
Post:
|
261
|
946
|
3,049
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.formscoding (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.access.formscoding posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.formscoding Alexa graph:
|
Top authors on Discussions in microsoft.public.access.formscoding during last week:
user's latest post:
Resizing the Details Section...
Published (2009-11-25 21:00:00)
Stewart Berman wrote: >Access 2007 > >I have a form with a header width a few controls and a details section with >five sub form controls. The resize event of the form with resize and >position the controls so they are fully visible as the user changes the size >of the form window. There appears to be a problem with the detail section. > >If the user enlarges the form all is...
user's latest post:
sorts query while including...
Published (2009-11-23 13:30:00)
Hmm. That doesn't make sense to me. Perhaps you'll have to add some calculated fields to the SQL and sort on them: SELECT FixtureTypesNoProject.Type, IIf(InStr([Type],"-")=0,Len([type]),InStr([type],"-")-1) AS Sort1, IIf(InStr(type,"EM")=0,[Type],Replace([Type],"EM","0")) AS Sort2 FROM FixtureTypesNoProject UNION Select...
user's latest post:
Temporary Form with 2 Sub form...
Published (2009-11-24 19:05:00)
To make the new data show in the main form, do a requery on the main form. If the DoCmd.RunSQL code is on the subform, then you can go Me.Parent.Requery Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Alam via AccessMonster.com" <u56406@uwe> wrote in message news:9f9ea960c6b92@uwe... >I have 2 table both are exactly same > PatientRecordTransTb And PatientRecordTb...
user's latest post:
How to select a description in a...
Published (2009-11-23 10:50:00)
"Goldar" <Goldar@discussions.microsoft.com> wrote in message news:7AE0EF50-E734-4578-B993-5807ED99C6AF@microsoft.com... >I want to give the user to look up (in a combo box) a product by either > product number -or- description. If I display direction, how can I force > the > combo box to return the product ID for the selected description? I have an > option box that...
gmazza via AccessMonster.com
9
user's latest post:
DLookup Path problem in...
Published (2009-11-23 13:50:00)
Its weird because when I take out the specs and just leave a comma like this: DoCmd.TransferText acExportDelim, , "SCMHeader", strFile then the Export works fine, but every field in the .txt file has quotes around it. Only way to get rid of the quotes is to use specs no? So when I remove the specs the Export doesn't complain about a file not exisitng, but now I have no specs and need to get rid of the quotes....
user's latest post:
Sub requery + other question in...
Published (2009-11-23 00:00:00)
Hi I have a form containing two subforms (sub1 & sub2) on sub 1 I have a combobox and a textbox and a unbound botton that saves the information from the combobox and the text box. On sub2 I have a form showing the informations that where input in sub1. My question is: 1. How do you requery sub2 after the sub1 button has been pressed? 2. How do I "blank out" the fields on sub1 so that the user has an...
user's latest post:
retrive the values if the...
Published (2009-11-25 07:05:00)
mls - If you select a record on the form and then change the values, it will change the record you are on. This is what is happening when you select the labid and the record comes up, then you change the test_no on the form. You should not allow changes to any fields in the primary key (e.g. test_no). When you add a new record to a database, the fields by default are all blank. You say all the fields are blank, but that is the...
user's latest post:
File Attachment Help ! in...
Published (2009-11-20 13:05:00)
I have created table to keep a track of attached file info. Fields are : CustID, FileName,FileLocation In my main form I have created “Attached File” button – (to attach file – should attach more than one) and “View Attachment” - (to view all attached file) button. I have created two list box – one to view the list of attached file (Current attachment). And other to view the list which is already there (previously...
user's latest post:
Notes table and...
Published (2009-11-19 23:23:00)
Thank you very much Jeanette, i will deep dive into the world of foreign keys and append queries..there is much to learn here. My foreign key is based on a autonumber formatted field..that this have any effect on this...? Once again, Thanks! "Jeanette Cunningham" wrote: > You will need a foreign key in the Notes table that tells you, for every row > in the notes table, which is the row in the main...
al416 via AccessMonster.com
6
user's latest post:
Type Mismatch error in...
Published (2009-11-25 07:05:00)
Any idea why I am getting a "Data Type mismatch on criteria expression" error on the second line? MaxCAR = DMax("[CARNumber]", "tblCARs") LastAuditNumber = DLookup("[AuditNumber]", "tblCARs", "[CARNumber] = '" & MaxCAR & "'") Both Fields are dimensioned as Integers CARNumber is and...
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.formscoding during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.formscoding:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.formscoding:
Started 19 hours, 32 minutes ago (2009-11-26 21:50:00)
by John W. Vinson
On Thu, 26 Nov 2009 19:03:01 -0800, Teddy <Teddy@discussions.microsoft.com>
wrote:
>I want to create a form with a combo box that has 3 choices only. I would
>like the choices to be Exceptional, Very Good, and Good. In the table design
>I thought I was supposed to do the following.
>
>General tab / default value / "“...
Started 1 day, 6 hours ago (2009-11-26 10:30:00)
by ruralguy via AccessMonster.com
Have you tried converting your macro to code? What version of Access are you
using?
Pasadena-D wrote:
>Hello,
>
>I have a user form that when the user clicks the ok button I want it to open
>another form based on the same record number. I can make this happen using
>the Access Macro as follows:
> Form Name: frmTask...
Started 22 hours, 5 minutes ago (2009-11-26 19:17:00)
by Wind54Surfer
Never mind, I answered my own question.
Thanks anyway
"Wind54Surfer" wrote:
> Hi all,
>
> I am wondering if there is a way to list all the tables so I can pick them
> to view them.
> I am not very good with code.
>
> Any help really appreciated....
Started 22 hours, 2 minutes ago (2009-11-26 19:20:00)
by Allen Browne
"efandango" <efandango@discussions.microsoft.com> wrote in message
news:62B48567-5241-4707-83EE-EB01656BA1A3@micros oft.com...
> I am using Allen Browne's great utility 'Find as you type' on a form, but
> now want to print the results of the forms output. Can it be done?
You may be able to apply the form's filter as the WhereCondition...
Started 1 day, 7 hours ago (2009-11-26 10:20:00)
by Rick Brandt
Teddy wrote:
> I am creating a form using Access 2003. One field on my form is Start. I
> would like to add a button next to this field so that when I click the
> button on the Form the current time will display in the field.
>
> Can you tell me what I need to do to the Start field in the table and the
> form where it ...
Started 1 day, 19 hours ago (2009-11-25 21:28:00)
by 8l2255
Just to clarify,
I have the code
Dim db As DAO. Recordset
Set rs = CurrentDb.OpenRecordset("itemtbl")
With rs
For a = 1 To TxtN
.AddNew
!ProductID = ProductID
!CategoryID = CategoryID
!StatusID = 1
!Date_Acquired = Date_Aquired
.Update
Next a
End With
rs.close
to ...
Started 1 day, 10 hours ago (2009-11-26 07:00:00)
by Ken Snell
For Each myObject in myCollection
If isNull(myObject.Value) And myObject.Visible = True Then
Msgbox("Field can not be null, bla bla bla")
myObject.setFocus
end if
Next
Started 1 day, 5 hours ago (2009-11-26 11:40:00)
by fredg
On Thu, 26 Nov 2009 10:19:43 -0800 (PST), TeeSee wrote:
> My form is populated by a query. In the query there are two calculated
> fields -- NetCost and NeNetCost. The following IIF's are in text
> boxes. The first one with the string responses works as expected so
> the logic seems to be okay but I keep getting #Name? error in the ...
Started 1 day, 6 hours ago (2009-11-26 10:45:00)
by ruralguy via AccessMonster.com
It sounds like the RecordSource of the MainForm is a Query with an Inner Join.
A MainForm/SubForm arrangement would only require a query of the Customer
table as the RecordSource of the MainForm and a query of the Contacts table
as the RecordSource of the SubForm with the CUSTID# as the SubFormControl's
LinkChild/MasterFields properties....
|
|
Hot threads for last week on Discussions in microsoft.public.access.formscoding:
Started 4 days, 7 hours ago (2009-11-23 09:30:00)
by Linq Adams via AccessMonster.com
My guess would be because your file name is
450*.csv
and files names cannot have special characters, such as the asterisk, in them.
Started 1 week, 1 day ago (2009-11-19 07:20:00)
by Marshall Barton
Hannah wrote:
>I've got a frmCountry and a sfrmHarbours, each has a combo box on.
>cboCountry (main form) lets you choose a country and cboHarbour (sub form)
>lets you choose a harbour from that country. frmCountry also has all the
>fields for country (e.g. contact person, address) and sfrm Harbour also has
>all the fields about ...
Started 1 week ago (2009-11-20 16:25:00)
by Tom van Stiphout
On Fri, 20 Nov 2009 13:04:52 -0500, "Winters" <info@info.com> wrote:
IT is more right than Training.
You can't publish Access forms to the web. Access is a workgroup
solution that runs as a Windows application.
The closest you can get to Access forms on the web is if you publish
them to SharePoint. This is a new capability for ...
Started 1 week, 2 days ago (2009-11-18 16:40:00)
by Stuart McCall
"WTC AS3 NCO" <WTCAS3NCO@discussions.microsoft.com> wrote in message
news:556E39C6-D44B-474E-A394-6019ECC7C76A@micros oft.com...
> Reference to Access 2007
> I have a Dialog Form that users will use to select two Table names from
> two
> combo boxes. How can I clear the values when the form loads to force the
> user
> to ...
Started 4 days, 4 hours ago (2009-11-23 12:25:00)
by Douglas J. Steele
The ORDER BY clause must always be at the end of Union queries. However, the
ORDER BY clause will have to be modified slightly, since it now applies to
the UNION query, not to table FigureTypesNoProject:
SELECT FixtureTypesNoProject.Type
FROM FixtureTypesNoProject
UNION
Select "< ALL >" FROM [FixtureTypesNoProject]
...
Started 4 days, 9 hours ago (2009-11-23 08:05:00)
by Keith Wilby
"Nick" <6afraidbecause789@gmail.com> wrote in message
news:55765372-249c-4d47-9a2a-7f26af3035ba@p33g20 00vbn.googlegroups.com...
>
> Users are sometimes clicking a save button in a subform more than
> once, attaching the same record(s) from a subform combobox > 1 time in
> the underlying join table.
>
>
Why do you ...
Started 3 days, 1 hour ago (2009-11-24 15:25:00)
by Ken Snell
What you've posted should be ok.
If you wanted, you could concatenate the fields' values into a single
string, with a delimiter between each value, in a DLookup, then parse out
the values, though I'm not sure if it'll be better for you.
These lines of code
InstallTSN = Nz(DLookup("[installTSN]", "T_installhistory", ...
Started 1 day, 6 hours ago (2009-11-26 10:30:00)
by ruralguy via AccessMonster.com
Have you tried converting your macro to code? What version of Access are you
using?
Pasadena-D wrote:
>Hello,
>
>I have a user form that when the user clicks the ok button I want it to open
>another form based on the same record number. I can make this happen using
>the Access Macro as follows:
> Form Name: frmTask...
Started 1 week ago (2009-11-20 07:50:00)
by Mark Andrews
Everything is possible, however not always easy to do.
One approach might be something like:
- emails go out with a hyperlink in the body of the email
- when the user clicks the hyperlink it goes to a web page that lets them
approve/reject, the link is customized for each user so the web page already
knows who they are.
- ...
Started 4 days, 14 hours ago (2009-11-23 02:35:00)
by Jeanette Cunningham
If I understand what you are trying to do, here is a suggestion.
Create a routine which will show and hide the controls as needed.
Call this sub when ever needed.
Private Sub ShowHideControl()
Me.ChequeNo.Visible = Me.TransTypeIDCombo = 1
Me.CardTranscationNo.Visible = Me.TransTypeIDCombo = 2
Me....
|
|
Size: 1,931 bytes
