glad you figured it out
-Crystal
--- On Wed, 8/27/08, Lon Lasher wrote:
>
> It was something simple that I overlooked, as I expected.
> It had data entry set to "yes." So the form
> opened as a data entry form only. Duh.
>
It was something simple that I overlooked, as I expected. It had data entry set to "yes." So the form opened as a data entry form only. Duh.
--- On Wed, 8/27/08, strive4peace <strive4peace2008@
From: strive4peace <strive4peace2008@
Subject: Re: [MS_AccessPros] Odd occurence on data entry form
To: MS_Access_Professio
Date: Wednesday, August 27, 2008, 7:44 PM
since you say you have check the Filter...
Do you have code running on the form OPEN or LOAD events? If so, what is it doing?
- Crystal
--- On Wed, 8/27/08, lonlasher wrote:
>
> I have had this happen on one database (rating) for a long
> time and
> now it's just started on a second database (safety).
>
> When my main entry form opens, it is blank. It shows 1 of
> 1. I need
> to do a sort to get the data to show.
>
> These are Access 2003 databases using Access 2000 format
> because I
> have some A2000 users.
>
> The rating database is replicated so I figured it was
> something
> associated with replication. But the safety database is a
> stand-alone
> that is only on my machine.
>
> I've tried a number of things including filters,
> changing the source
> from table to query and back.
>
> It's probably something simple, but I can't seem to
> find the cause.
>
>
>
[Non-text portions of this message have been removed]
since you say you have check the Filter...
Do you have code running on the form OPEN or LOAD events? If so, what is it doing?
- Crystal
--- On Wed, 8/27/08, lonlasher wrote:
>
> I have had this happen on one database (rating) for a long
> time and
> now it's just started on a second database (safety).
>
> When my main entry form opens, it is blank. It shows 1 of
> 1. I need
> to do a sort to get the data to show.
>
> These are Access 2003 databases using Access 2000 format
> because I
> have some A2000 users.
>
> The rating database is replicated so I figured it was
> something
> associated with replication. But the safety database is a
> stand-alone
> that is only on my machine.
>
> I've tried a number of things including filters,
> changing the source
> from table to query and back.
>
> It's probably something simple, but I can't seem to
> find the cause.
>
>
>
Another way to do this is to make the ID field in the record source query
column 2 (with the name of the badge in the first column), & set the bound
column to 2. Leave the number of columns to display at 1, so the 2nd column
is not shown at all. This will also force the form to limit selections to
the items in your drop down list (populated from your Merit Badge's table).
One little thing I like to do is set the query to sort ascending on my
displayed text (merit badge names, in this case). Otherwise, the order
usually follows the order the items were entered into the table.
------------
Shay B. | ShayBee.com <http://www.shaybee.
Writer's Guide to Web Building <http://writerswebbu
------------
On Wed, Aug 27, 2008 at 2:58 PM, Peter Hoogenboom <phoogenb@hotmail.
> Hi adellinger,
>
> You can create the combo box you want by defining its row source to
> include the MeritbadgeID and MeritbadgeName. Then, set the
> BoundColumn to 1. That means the combo box's value property is bound
> to the MeritbadgeID column. THen, set the ColumnWidths property to
> 0". That will hide the first column, so users only see the second
> one.
>
> Tada!
>
> Hope that helps,
>
> Peter
>
> --- In MS_Access_Professio
> "adellinger01"
> <adellinger01@
> >
> > Hello - first off I have just joined this group! What a great
> > resource. Thank you!
> > I am new to Access and am running 2007.
> > I have created a database with 3 tables (contact, meritbadge, and a
> > join table)
> > ContactID - primary key
> > MeritbadgeID - primary key
> > The join table is linked to ContactID & MertibadgeID w/ one-to-many
> > relationship as to allow each person to be linked to more than one
> > meritbadge.
> > What I am trying to do is create a Form where I can select each
> > meritbadge from a combo box and have it entered into the joined
> table
> > fields linking the contactID to the meritbadgeID.
> > I hope this makes sense.
> > I can currently go into my join table in datasheet view and add
> > contactID and meritbadgeID numbers to test and successfully print a
> > report which lists for instances : First Aide w/ 7 people
> associated
> > with that.
> > I just want to create a better form for entering data using the
> names
> > of the merit badges rather than ID numbers.
> > Thank you!
>
[Non-text portions of this message have been removed]
Glad I could help, Royce.
Bob aka Bill <g>
From: MS_Access_Professio
[mailto:MS_Access_Professio
Sent: Wednesday, August 27, 2008 2:51 PM
To: MS_Access_Professio
Subject: [MS_AccessPros] Re: How to exclude records using form control
Thanks Bob! I'll give it a try. It will be tomorrow. A.D. is pretty
sharp. I used some of his code to send reports via email messages. I
really appreciate all the help you MVP's give us.!
Doyce
--- In MS_Access_Professio
<mailto:MS_Access_
<wrmosca@...
>
> Doyce
>
> This is kind of tricky because you can't just pass a comma
delimited
> string of primary keys as a parameter. But you can do it this way:
>
> SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate
> FROM Orders
> WHERE (((Orders.OrderID) Between [forms]![Form3]
[forms]!
> [Form3]![txtEND]
> AND NOT(((InStr(
> [OrderID] & ","))>0));
>
> txtStart is your starting number and txtEnd is your ending number.
I
> assume you already have something like that in your query.
>
> Open the query in SQL view and paste in the "AND" part of the
criteria.
> txtExclude is the text box on the form where the user enters the
> numbers to exclude separated by commas.
>
> If I remember right it was A.D. who came up with this beauty. I
sure
> know if wasn't me.
>
> Regards,
> Bill Mosca,
> http://www.thatlldo
> Founder - MS_Access_Professio
> http://tech.
> Microsoft Office Access MVP
> http://mvp.support.
>
>
>
>
>
> --- In MS_Access_Professio
<mailto:MS_Access_
> <winberry.doyce@
> >
> > Hello all,
> >
> > I want to design a form that will become criteria for a query.
The
> form
> > will select records based on a range of the primary key. I can do
> this.
> > The kicker is that I will want to exclude some records from the
range
> > that the user will input into the form. For example the range of
data
> > will be between 1 and 99. However, for whatever reason the user
needs
> > to exclude records 5, 62 and 83. What is the best way to do this?
> >
> > Doyce
> >
>
[Non-text portions of this message have been removed]
Peter -
Thank you for your response.
I am still having trouble with this and have attached the file - if you wouldnt mind looking at it.
You can probably see what i am trying to accomplish and just having gotten Access a week ago I am still trying to learn the ropes.
Any help or further direction would be much appreciated.
My frmMain_Contact shows what i am trying to accomplish.
Thanks
Allen
------------
From: "Peter Hoogenboom" <phoogenb@hotmail.
Hi adellinger,
You can create the combo box you want by defining its row source to
include the MeritbadgeID and MeritbadgeName. Then, set the
BoundColumn to 1. That means the combo box's value property is bound
to the MeritbadgeID column. THen, set the ColumnWidths property to
0". That will hide the first column, so users only see the second
one.
Tada!
Hope that helps,
Peter
--- In MS_Access_Professio
<adellinger01@
>
> Hello - first off I have just joined this group! What a great
> resource. Thank you!
> I am new to Access and am running 2007.
> I have created a database with 3 tables (contact, meritbadge, and a
> join table)
> ContactID - primary key
> MeritbadgeID - primary key
> The join table is linked to ContactID & MertibadgeID w/ one-to-many
> relationship as to allow each person to be linked to more than one
> meritbadge.
> What I am trying to do is create a Form where I can select each
> meritbadge from a combo box and have it entered into the joined
table
> fields linking the contactID to the meritbadgeID.
> I hope this makes sense.
> I can currently go into my join table in datasheet view and add
> contactID and meritbadgeID numbers to test and successfully print a
> report which lists for instances : First Aide w/ 7 people
associated
> with that.
> I just want to create a better form for entering data using the
names
> of the merit badges rather than ID numbers.
> Thank you!
>
[Non-text portions of this message have been removed]
Hi Clive,
I meant to say this in the original message, but forgot: I can't set
the subform data source to blank, since I am actually talking about
30-some forms that are saved in sourcesafe, and I can't make changes
to the application unless they are necessary to fix a bug or other
problem.
:-/
Peter
--- In MS_Access_Professio
<zctek@...> wrote:
>
> Hi Peter,
>
> Try setting the SubForm DataSource to a blank.
> All you have to do is remember what the name
> of the subform was when you are ready to
> include it again.
>
> Hope that helps.
>
> Regards, Clive.
>
> --- In MS_Access_Professio
> <phoogenb@> wrote:
> >
> > Pros:
> >
> > Is there any way to stop Access 2003 from loading subforms into
> subform
> > controls in design view? In other words, to make it behave like
it
> > used to in earlier versions, where the subform control is just a
> white
> > box?
> >
> > I am working in a project under source code control; the main
form
> is
> > checked out, and the subform is not. I would like to be able to
> open
> > the main form in design view without being asked whether to check
> out
> > the subform.
> >
> > I vaguely remember seeing an option for this, perhaps in Access
> 2000,
> > though I may be confused on this point.
> >
> > Thanks,
> >
> > Peter
> >
>
