|
More site info...
microsoft.public.access.forms | Forum profile
|
|
Forum profile page for microsoft.public.access.forms on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.access.forms, 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.forms" 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.forms:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
98
|
390
|
1,120
|
|
Post:
|
258
|
941
|
2,743
|
|
|
microsoft.public.access.forms Posting activity graph:
|
Top authors during last week:
Crystal (strive4peace)
14
user's latest post:
sum lookup in...
Published (2009-12-01 11:50:00)
Hi Ashley, "you also cannot sum a column of a combobox. You can only sum fields from the RecordSource." Warm Regards, Crystal remote programming and training http://MSAccessGurus.com free video tutorials http://www.YouTube.com/user/LearnAccessByCrystal Access Basics http://www.AccessMVP.com/strive4peace free 100-page book that covers essentials in Access * (: have an awesome day :) * Ashley wrote: > Hi...
user's latest post:
Access 2003 front end with sql...
Published (2009-12-06 05:25:00)
Foe record locking to work properly, you need to allow all permissions except Full Control to the folder housing the database.
user's latest post:
Insert fields dynamically into...
Published (2009-12-04 13:30:00)
On Fri, 04 Dec 2009 20:14:46 GMT, "mls via AccessMonster.com" <u55943@uwe> wrote: >Never mind I am going to create dummy columns for all the test not performed >and dump all the field values into database. > >I don't think my table structure is wrong. It is indeed wrong. >Each specimen can be tested 2 - 3 >times for same group/set of test ( test1 or...
user's latest post:
Problem with Multi-tabbed forms...
Published (2009-12-02 15:55:00)
I inherited a application that is using 2007 Multi-tabbed forms with 4 nested subforms on several of the tabs to navigate through the 4 related tables. The tables have a growing number of records causing the subforms to crowd the screen. It is becoming more and more difficult to navigate down through the 4 tables on some of the tabs, having to use the scroll bars to try to get portions of the subforms on the screen. I am hoping to...
user's latest post:
Multiselect List Box in...
Published (2009-12-05 05:30:00)
Once you make a list box Multiselect, any reference to it will always return Null, whether or not anything's selected. Replace 'Text field example. Use quotes around the value in the string. If Not IsNull(Me.txtFilterCity) Then strWhere = strWhere & "([County] = """ & Me.txtFilterCity & """) and " End If with 'Text field...
Scott_Brasted via AccessMonster.com
7
user's latest post:
Criteria for opening form from a...
Published (2009-11-29 12:50:00)
Dear Crystal and John, I don't want anyone to get mad or annoyed because I really appreciate all the help I get here and I do not want anyone to think otherwise, but PLEASE read my answers. I read yours. The query returns results. No blank records. All I want is for the subform, where there are no blank records, to allow me to double click on a field and open aonther form, period. If there is a reason why a query result would...
user's latest post:
How to display a form and hide...
Published (2009-12-03 21:40:00)
"cr113" <cr113@hotmail.com> wrote in message news:3c3a8562-142f-42b0-8074-5cca73fc7fbd@a32g2000yqm.googlegroups.com... > > First off I'm using Access 2003, maybe that makes a difference? Anyway > if I open a typical Access .mdb file I can see a "main" window with an > Access menu across the top that says, "File Edit View Tools"....
Linq Adams via AccessMonster.com
7
user's latest post:
Hide linked table in...
Published (2009-12-03 16:35:00)
As Stefan said there's little sense in your post as it currently reads. You say: "I want to link a column of my form to a column\table in another database xx.mdb. This column should update and refresh with all the new data." And then you say: "I have read-only with xx.mdb" How are you going to update the data in this column if you have Read-Only rights to xx.,db?
user's latest post:
How to display a form and hide...
Published (2009-12-03 10:10:00)
We're not there. We can't see what you're seeing. You "don't want to show the main Access window" ... what do YOU mean by that? When I use a startup form, that form opens, not the "main Access window" (per my definition)... Regards Jeff Boyce Microsoft Access MVP
user's latest post:
IIF function in...
Published (2009-12-03 08:10:00)
Thanks everybody! Instead of Null, I used zero. It works. "Ashley" wrote: > Hi, > I have below function in the control source. It returned #name? > Basically, I would like "if totalminutes is zero, then this field is > zero,else 60/totalminutes > IIf([TR_PRICING].[Form]![TOTALMINUTES] Is > Null,0,(60/[TR_PRICING].[Form]![TOTALMINUTES])) > > Where...
|
|
|
|
Latest active threads on microsoft.public.access.forms::
Started 4 days ago (2009-12-04 10:45:00)
by Arvin Meyer [MVP]
Try using a datasheet form, or an Access query on the front end to copy &
paste records.
Started 2 days, 15 hours ago (2009-12-05 19:50:00)
by Tom van Stiphout
On Sat, 5 Dec 2009 16:12:01 -0800, zyzzyva
<zyzzyva@discussions.microsoft.com> wrote:
Select the controls, then click Remove on the Arrange ribbon.
-Tom.
Microsoft Access MVP
>Qt based on Access 2007
>
>I cannot seem to find a way to UN-GROUP text boxes on Forms created with the
>Form Wizard...
Started 2 days, 15 hours ago (2009-12-05 19:50:00)
by Tom van Stiphout
On Sat, 5 Dec 2009 15:58:01 -0800, Dadders
<Dadders@discussions.microsoft.com> wrote:
What are the values of fld1 and fld2 in both scenarios?
-Tom.
Microsoft Access MVP
>I have a working Access 2007 Application which is now failing miserably in
>2010. It hinges on location the first available working ...
Started 2 days, 20 hours ago (2009-12-05 15:03:00)
by Daniel Pineault
To select a file, take a look at:
http://www.mvps.org/access/api/api0001.htm
To select a folder/directory, take a look at:
http://www.mvps.org/access/api/api0002.htm
Started 2 days, 21 hours ago (2009-12-05 13:40:00)
by ruralguy via AccessMonster.com
It is on the right side of the Arrange ribbon.
accdev wrote:
>I've just started in Access 2007 and am in the most complex game of MS new
>release HideAndSeek that I've ever been in...... after many years of Access
>development.
>I'm designing a form. Up to now it has no header or footer and I want to
>add them. In ...
Started 3 days, 1 hour ago (2009-12-05 09:15:00)
by Tom van Stiphout
On Fri, 4 Dec 2009 12:47:02 -0800, Eric
<Eric@discussions.microsoft.com> wrote:
Perhaps MSFT wants to gently steer you towards creating a Ribbon.
Of course you can still go old-style, and simply create a form with
buttons on it and open it at startup time.
-Tom.
Microsoft Access MVP
>I am trying ...
Started 3 days, 5 hours ago (2009-12-05 05:30:00)
by Douglas J. Steele
Once you make a list box Multiselect, any reference to it will always return
Null, whether or not anything's selected.
Replace
'Text field example. Use quotes around the value in the string.
If Not IsNull(Me.txtFilterCity) Then
strWhere = strWhere & "([County] = """ & Me.txtFilterCity & """) and "
End If...
Started 3 days, 5 hours ago (2009-12-05 05:30:00)
by Douglas J. Steele
I'm not sure you can: web browsers get their colour cues from the HTML (or
CSS) they're rendering.
Started 3 days, 19 hours ago (2009-12-04 16:05:00)
by fredg
On Fri, 4 Dec 2009 12:44:01 -0800, linda wrote:
> Hi,
>
> I am trying to export certain records that have been filtered.
> When I export it to excel, save the file and then reopen the file all
> records are displayed in excel. I woul dlike only the records that I have
> filtered to export from Access to Excel. Any ...
Started 4 days, 2 hours ago (2009-12-04 08:35:00)
by Golfinray
I would use an update query. You simply need to add an ID to the database
table, like your labid. On the query grid pick the table and the table you
want to update. Join them on the labid and then add the fields to update. Or
use update in a sql query.
|
|
Hot threads for last week on microsoft.public.access.forms::
Started 5 days, 23 hours ago (2009-12-02 11:46:00)
by Golfinray
IIF statements are laid out like this:
IIF([yourtable!yourfield]is null,[what to do if true],[what to do if false])
Started 1 week ago (2009-11-30 14:25:00)
by John W. Vinson
On Mon, 30 Nov 2009 13:39:18 -0800 (PST), Susan <susanhull@ou.edu> wrote:
>On my form, I'm using Case coding on the GroupHomeID field's After
>Update event to change the values in the address fields, so the
>address will automagically update depending on the GroupHomeID. The
>address, city, state, and zip work great, and change as ...
Started 1 week, 1 day ago (2009-11-30 09:20:00)
by Arvin Meyer [MVP]
Perhaps a simplistic answer, but do you have NetBIOS enabled on all the
machines? The UNC ( Universal Naming Convention) that you want to use depends
upon it.
Started 1 week, 1 day ago (2009-11-30 05:05:00)
by bhicks11 via AccessMonster.com
Yes you can. Here's a link to a good explanation of working with Tab
controls:
http://bytes.com/topic/ access/insights/615446-acce ssing-tabs-tab-control
Bonnie
http://www.dataplus-svc.com
gorsoft@hotmail.com wrote:
>I am reporting this as my earlier post may not have been too clear.
>
>I have a ...
Started 5 days, 2 hours ago (2009-12-03 08:55:00)
by cr113
On Dec 3, 10:15 am, cr113 <cr...@hotmail.com> wrote:
> I'm developing an Access application and I want to make it look like a
> real app by only displaying the form and none of the menu windows. I
> tried unchecking everything under Tools/Startup but it still displays
> the main window with File Edit View etc. I also tried executing the...
Started 4 days ago (2009-12-04 10:45:00)
by Arvin Meyer [MVP]
Try using a datasheet form, or an Access query on the front end to copy &
paste records.
Started 1 week ago (2009-12-01 04:45:00)
by Arvin Meyer [MVP]
In the Data Entry Form make some changes in the code behind the Close
button. Add the following before the form closes:
If Me.Dirty = True Then Me.Dirty = False 'saves the record
Forms!MainFormName!SubformControlName.Form.Reque ry
of course you will need to substitute your main form name and your subform
control name...
Started 4 days, 2 hours ago (2009-12-04 08:35:00)
by Golfinray
I would use an update query. You simply need to add an ID to the database
table, like your labid. On the query grid pick the table and the table you
want to update. Join them on the labid and then add the fields to update. Or
use update in a sql query.
Started 1 week, 1 day ago (2009-11-29 17:00:00)
by Crystal (strive4peace)
Hi Len,
if you are using a version of Access below 2007, you can
show the number of records directly in a textbox control :
ControlSource --> =[Form].Recordset.Recordcount & " records"
if you are using 2007, you need to calculate this in code to
display in a textbox on the current event of the main form
and ...
Started 1 week, 2 days ago (2009-11-28 16:05:00)
by Crystal (strive4peace)
Hi Scott,
*** Difference between Subform Control and Subform ***
The first click on a subform control puts handles* around
the subform object.
*black squares in the corners and the middle of each size --
resizing handles
The subform object has properties such as
Name
SourceObject
...
|
|