Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes.
I would like a combobox Manufacturer that would filter a Products combobox
that would in turn filter a Brands combobox. After selecting a Brand from
the Brand combobox, I need to enter several Varieties for each Brand and
several Sizes (Size, Unit, Pkg) for each Variety.
Please help. I am new to this. I have the relations set in the order that
the tables appear on the 1st line of this post.
|
3/11/2010 6:38:14 AM
|
1
|
"rnjalston" <u58...@uwe>
|
|
form within a form
I have Office Professional 2007 (Vista) . I have a simple data base with
about 500+ names, addresses, etc. Many of the names have unusual spelling.
I would like to make some type of form on my basic form that would allow me
to enter the first letter of a last name and have all names starting with
that letter to show up. I have a parameter query and made a parameter sub
form, and it works fine by itself but if I try to put it in the design when I
then try to save it the subform wants to work right then and does but when I
close the design view the parameter subform is just bl
|
3/11/2010 3:30:01 AM
|
1
|
=?Utf-8?B?Rm9zdGVyMQ==?= <Fost...@discussions.microsoft.com>
|
Form Combo Box Causes Query Error Message
Using Access 2007, I created two similar combo boxes, using the control
wizard for each form, in design view, one for each of two separate databases.
For one database it presents no problem at all. But for the other, when I
create a query, initially the query displays during the creation process.
However, every time I try to re-open the query, it re-opens and displays the
correct data, BUT only after I close an error message box that always pops up.
The error message says:
"An invalid condition was encountered by Access due to a value that you
entered for a field or table property.
|
3/11/2010 3:20:02 AM
|
0
|
"dlhappy via AccessMonster.com" <u56...@uwe>
|
Form Combo Box Causes Query Error Message
Using Access 2007, I created two similar combo boxes, using the control
wizard for each form, in design view, one for each of two separate databases.
For one database it presents no problem at all. But for the other, when I
create a query, initially the query displays during the creation process.
However, every time I try to re-open the query, it re-opens and displays the
correct data, BUT only after I close an error message box that always pops up.
The error message says:
"An invalid condition was encountered by Access due to a value that you
entered for a field or table property.
|
3/11/2010 3:17:01 AM
|
0
|
"dlhappy via AccessMonster.com" <u56...@uwe>
|
Selecting multiple criteria in a report in Acc 2007 using a form
How can I select multiple criteria using a form to generate a report in
Access 2007.
--
Lady_Dee
|
3/11/2010 1:38:04 AM
|
1
|
=?Utf-8?B?TGFkeV9EZWU=?= <Lady...@discussions.microsoft.com>
|
Access 2007
I am trying to get the combo box to match the subform on the form when it is
open.
-
Lady_Dee
|
3/11/2010 12:39:02 AM
|
1
|
=?Utf-8?B?TGFkeV9EZWU=?= <Lady...@discussions.microsoft.com>
|
Back End on NAS Device
Repost -
Access 2007 split FE/BE, each user has their own FE.
Combination of TS and local LAN users.
System worked fine when the BE was on the server.
A few hours after client moved it to a NAS device, the BE corrupted.
In searching, I can find very little relating to Access back end and NAS.
Does anyone know of any issues with locating an Access BE on a NAS device?
--
AG
Email: npATadhdataDOTcom
|
3/10/2010 10:16:43 PM
|
4
|
=?Utf-8?B?QUc=?= <NOSPAMagi...@newsgroup.nospam>
|
Subform New Record
Is this possible? Form A opens to job number from switchboard selection
with all related data from job table.
Form B, which is a subform on Form A, opens for tech to enter name and time
started on job. If Tech1 has already started time on job and Tech2 wants to
help on same job, it opens with Tech1's time. I need Form B to open to a
new record for Tech2 to enter time, but Form A still relate to job number
selected from switchboard.
Thanks in advance for any help,
Pam
|
3/10/2010 10:16:35 PM
|
2
|
"Pam" <pamnos...@deltaprocess.com>
|
Checkbox will not check
I have a continuous form based on a multi-table query.
Tables (joined fields) (other fields used by the query)
TrackingNumbers (OrderID) (TrackingNumber, FreightAmt, Paid)
Orders (OrderID, CustomerID, FreightID) (OrderDate)
Customer (CustomerID) (CustomerName, City)
Freight (FreightID) (FreightName)
Sorted by FreightName, OrderDate
Paid = 0
The form is to be used when I receive bills from various freight companies...
allowing me to verify charges and check them off when I pay them. The form
lists all orders with unpaid freight bills with this information:
FreightName-OrderID-
|
3/10/2010 9:29:04 PM
|
3
|
"milwhcky via AccessMonster.com" <u54...@uwe>
|
Based on a lookup of Primary Key display data in the first table
I have 4 tables (amongst about 20) that are related in a DB for surplus
material
1st Table is SurplusReport_TBL primary key is SurplusNbr. The table holds
the information on items surplus to needs. To donated, salvaged, sold, or
dumped etc. One surplus report per shipment.
2nd Table is SurplusListing_TBL and the primary key is SurlusNBR. This
tables hold individual items, many for each individual surplus. contains
ItemNBR this is a counter of all items being surplused, autonumber.
in Surplus Listing is SurplusItemCount and also SurplusDescription,
AssetNBR, and ConditionC
|
3/10/2010 9:04:01 PM
|
0
|
=?Utf-8?B?RHdhZGU=?= <Dw...@discussions.microsoft.com>
|
PLEASE PLEASE PLEASE HELP
Please can someone help me immediatly. I have a form with a field on it that
is attached to a table. when a agent creats a audit they click on this drop
list to show all the groups in this table and they select one. The problem
is if the group is not in the table they put a new group # in the field and
it takes. This cause the report to not populate because it is not finding
the group #. My questio is how can I set the field so if an input is made
that does not match the table that field is pointing to it rejects the data
and prompt the user that this id is not found. Pleas
|
3/10/2010 8:53:01 PM
|
1
|
=?Utf-8?B?SXNzYWNoYXI1?= <Issach...@discussions.microsoft.com>
|
Will this work and how in Access
Currently using Access 2003 - We need to be able to pull various components
from several tables in a couple of linked databases into one form/report.
We are making “Parts Lists” – so there is the main component and then the
other smaller parts that make up that main component listed below it. One
table holds the main configuration numbers, and another table in a separate
database holds the component parts numbers.
We need to pull the main component number along with its description as a
portion of the heading from the main component table from a linked Access
database into a for
|
3/10/2010 5:06:30 PM
|
3
|
"delephant" <u58...@uwe>
|
numerical summation to passed from sub to main form
I have a subform that tracks payments. I have a text box in the form footer
that calculates total payments. I need that total amount of payment passed
to the main form, so that I can then calculate a "balance due" from Total
Owed - Total Paid [which I do know how to do].
Thanks
|
3/10/2010 4:27:02 PM
|
2
|
=?Utf-8?B?S2VyaSBpbiBWZXJtb250?= <KeriinVerm...@discussions.microsoft.com>
|
DoCmd.HourGlass not working
I've got a form with a treeview object. When I double click on a
particular node in the treeview I open a second form. The second form
takes awhile to populate so I want to display an hourglass cursor. I
can't get the hourglass to display. What's odd is that it works from a
button click event but not the treeview double click event.
This code doesn't work:
Private Sub TreeView1_DblClick()
Call DoCmd.Hourglass(True)
DoCmd.OpenForm "SecondForm"
End Sub
This code works:
Private Sub Button_Click()
Call DoCmd.Hourglass(True)
DoCmd.OpenForm "SecondForm"
End
|
3/10/2010 3:45:22 PM
|
2
|
cr113 <cr...@hotmail.com>
|
Filter Form doesn't close
Hi all. I have an Access 2007 form with a command button that does
this on the OnClick event:
DoCmd.RunCommand acCmdAdvFilterSort
The filtering form opens correctly and I'm able to specify my
criteria. If I right click and choose Apply Filter/Sort, the
filtering works BUT the filter form doesn't close. Instead, my Access
2007 form appears in front of it and gets the focus but the filtering
form stays open.
I'm using a customized ribbon and have tried two other ways to
accomplish this. The first is:
idMso = "ApplyFilter"
The second is a m
|
3/10/2010 2:25:00 PM
|
1
|
CP <cput...@tnc.org>
|
Pop-up Box with a reminder
I currently have a form for entry of clients information (OOH Data Entry). In
that form i have two fields one call last physical date and the other last
dental exam. I would like a box to pop-up reminding then to enter the most
current date for the clients last physical and dental exam to the database.
Since they are forgetting to enter the most recent date, we have dates from
07" and a physical and dental should be done every year. How can i do this in
a form? I would really like to use that same reminder for two other fields.
Maybe is possible to have just one pop-up remindi
|
3/10/2010 2:08:01 PM
|
1
|
=?Utf-8?B?amVzc2ljYQ==?= <jess...@discussions.microsoft.com>
|
duplicate check before report runs
Hi,
I have a form that has been added to over time. The latest addition is a
check box that generates a letter to the GP if a patient is on a particular
drug (user activated). A 2nd table (tblPPIreview) has been set up to hold
the information returned via that letter. (It is faxed out and faxed back).
What I want to do is this. When the user checks the box for the letter, it
'sends' the patient's personal unique identifier (NHS number) to the 2nd
table so that it is recorded in that table that a letter was sent. However,
if the NHS number already exists a message pops up
|
3/10/2010 11:58:01 AM
|
4
|
=?Utf-8?B?S2F0ZUI=?= <Ka...@discussions.microsoft.com>
|
How to Navigate Through Records in Alphabetical Order
I have a membership DB with a Family_tbl and a Person_tbl. A form/subform
shows the family info and all the persons belonging to that family. As I add
members, the Family table is getting increasingly out of alphabetical order,
which makes it difficult to find a particular family.
How can I get the navigation buttons to scroll through the records in
alphabetical order, instead of primary key order? I've tried sorting the
table, but that has no effect on the form.
As the DB grows, I can see navigating getting more difficult, even with
alphabetical order; so an extension of
|
3/10/2010 4:14:01 AM
|
2
|
=?Utf-8?B?RW5uZWFk?= <Enn...@discussions.microsoft.com>
|
primary key duplicate record is not incremental
Hi,
When I duplicate a record in a form using a command button, the primary key
of the newly created record does not continue from the last one. For example,
if the last one is 1410, and I want to duplicate record 1157, the new one is
a random number (i.e., 545687). Any idea how to fix this?
cheers,
Gonzalo
|
3/10/2010 12:56:02 AM
|
2
|
=?Utf-8?B?R29uemFsbw==?= <Gonz...@discussions.microsoft.com>
|
count on form list
Hello
Hiw can I make count number to calculate how many post raw it is be on the
form list?
So the resoult sould looks:
No
1
2
3
4
5
6
7
8
Thanks
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us
|
3/9/2010 11:51:02 PM
|
1
|
=?Utf-8?B?SGlnaGxpZ2h0IGJldHdlZW4gMyBmaWVsZHM=?= <Highlightbetween3fie...@discussions.microsoft.com>
|
Delay in an action for certain time and then let it execute
How do i delay an action for certain time and then let it execute
automatically.
For an example i want some action to execute and then need to close the form
after 2 Minute time.
How do this 2 min delay can be imposed?
|
3/9/2010 10:58:03 PM
|
1
|
=?Utf-8?B?YWxpeg==?= <a...@discussions.microsoft.com>
|
Forms-Appropriate Control to Use
I would like to place a control on a form so end user can select a name from
the Clients table that has the fields: client, address, city. In a
subsequent field choose the client address and city.
Field: Client
Field: Client_Address_and_PhoneNumber
The goal is a report showing appointments for drivers for the day.
|
3/9/2010 8:55:01 PM
|
1
|
=?Utf-8?B?U3VlVw==?= <S...@discussions.microsoft.com>
|
Restricting SubForm to One Record Entry Per Parent: Access 2007
Hello All,
I have a one-to-one relationship between two table. I have successfully
added the subform, but I get the option to add additional child records in
the Datasheet View. This means that when a user tabs to the next row and
enters data they get an error--and they should.
Question: How do I restrict the subform to show only one row in Datasheet
View?
I hope I was clear. Feel free to ask for clarification.
Thank you in advance for your assistance.
|
3/9/2010 8:30:04 PM
|
1
|
=?Utf-8?B?QWxjaWRl?= <Alc...@discussions.microsoft.com>
|
Main Form with Subforms
I am creating a form with the main form at the top - data comes from a
specific query within the database so that I am able to sort and place
filters within the query to get the data I want, the main record source is
Project ID..
The first subform is side by side with the second subform. The 1st has data
that comes from a table within the database, and the child link key is the
project number that links to the master project ID.
The second subform again comes from a different table within the database,
the child is project Number, to Master of Project ID.
The idea is the
|
3/9/2010 8:20:06 PM
|
5
|
=?Utf-8?B?U2FN?= <...@discussions.microsoft.com>
|
Access 2007 Fonts
In AC 2007 when I open the drop down for the fonts I see a few fonts that
aren't in the system fonts in
my Control Panel.
There are 8 of them and are named:
Z@R32AF with a variation after the R.
I didn't name all of them but the extension and the Z@R are in all the
names.
Again these font names do not show up in control panel|fonts.
Any idea how these fonts got into access?
Thanks,
James
|
3/9/2010 7:12:50 PM
|
1
|
"JamesJ" <...@darwin_roadrunner.com>
|
How can I show multiple Pivotchart forms on the same screen at onc
I have a series of pivot charts created in Access and I'd prefer to be able
to show them all at once on one screen. Normally I'd do this in Excell since
it would be cake to sqeeze them all together but in this situation I need the
conditional formatting of pivot charts that access provides. So is there a
way to put all the charts on one "thing"?
I've tried putting them as subforms on a new form but they just come up
blank, same for trying to put them on a report.
-Thanks
|
3/9/2010 7:10:06 PM
|
1
|
=?Utf-8?B?ZGFuZGMwNzEx?= <dandc0...@discussions.microsoft.com>
|
Embedded Acrobat Viewer
I am trying to embed Acrobat Viewer ActiveX control into Access Form. I have
done it before on different forms and it works OK. But now, in the new form
that I am working on now, the PDF file is not showing up. No errors, but no
image either.
Any thoughts?
|
3/9/2010 6:53:02 PM
|
0
|
=?Utf-8?B?eTc3MA==?= <y...@discussions.microsoft.com>
|
Auto sum / total 2 fields in a record
Auto sum 2 fields in a record
Hi. This is incredibly easy to do in Excel but I’m afraid it’s eluding and
frustrating me in Access!!! I have a very simple table with 5 columns
formatted to collect money amounts. So, the User would enter the 5 money
amounts into each record. So far so good….
The first 2 fields in each record collect “Income from farm”, the second
field collects “Income from shop”. I’d like a 3rd field to automatically add
up the content of what’s been entered in the first 2 fields (the 3rd field
should never accept user input directly) and display that resul
|
3/9/2010 6:24:07 PM
|
3
|
=?Utf-8?B?UGV0ZXI=?= <pe...@discussions.microsoft.com>
|
Error 3075
I’ve looked at nearly every post and can’t find an answer so many thanks for
any help.
I have a value for FloorProgCriteriaID that’s populated via this code on a
form open event:
Me.FloorProgCriteriaID = _
[Forms]![frmSelectFloorProgCriteria] _
![lstFloorProgCriteria]
Can someone please help me figure out why I’m getting a run-time 3075 syntax
error (missing operator) in query expression '[AuditID] = 12 And
[FloorProgCriteriaID] = And [AuditorID] = 'T5925MS''
(I didn’t leave out the value after [FloorProgCriteriaID]. The value returned
is Null based on the Debugger).
Private
|
3/9/2010 5:12:42 PM
|
3
|
"T5925MS via AccessMonster.com" <u58...@uwe>
|
set default focus to nothing?
In a pop-up form with several fields, some users are typing in data to the
field with the default focus, before they look to see what field they should
actually be typing in. The result is incorrectly changed data.
I would like to force the users to choose a field before they start typing.
But it seems the default focus is always going somewhere (1st item on tab
control). Apparently I can't set it to a label. The best I've been able to do
is create a dummy text box & set the default focus there. But there must be a
more graceful solution?
Thanks in advance.
|
3/9/2010 4:45:01 PM
|
2
|
=?Utf-8?B?YmljeWNsb3Bz?= <bicycl...@discussions.microsoft.com>
|
Currency Field
I am using Access 2003.
I have a form with a currency field that has 5 decimal points. This field
rounds up when I do not want it to. Ex: I put in $0.15768 and get $0.15770.
I trield to expand the field to 6 decimal points but it still rounded up.
How do I get this field to accept just the currency I put it and not round
up? I would appreciate any help you can give me.
Aurora
|
3/9/2010 3:01:01 PM
|
5
|
=?Utf-8?B?QXVyb3Jh?= <Aur...@discussions.microsoft.com>
|
Access2000: BeforeUpdate for TextBox
Hi
On a form I have 2 controls, txtHours & txtMinutes. Whenever there is
entered 60 or more minutes into txtMinutes, I want full hours added to
txtHours (or txtHours value replaced, I haven't decided yet), and set
reminder as new value for txtMinutes. Something like:
Private Sub txtMinutes_BeforeUpdate(Cancel As Integer)
If Me.txtMinutes < 60 Then
Else
Me.txtHoues = Me.txtHoues + Int(Me.txtMinutes / 60)
Me.txtMinutes = Me.txtMinutes Mod 60
End If
End Sub
Current code returns an error "The macro or function set to the BeforeUpdate
or Valida
|
3/9/2010 2:48:13 PM
|
2
|
"Arvi Laanemets" <garb...@hot.ee>
|
List Box Click Event Anomaly.
Access 2003.
I have a form with a List Box control, the Row Source is linked to a
query to show a list of client addreses. The List Box control is third
in the Tab order so the user will press the TAB key and move the
cursor to the List Box, use the Up and Down arrow keys on the keyboard
to select a record in the list and then click the selected record to
display some information about the client.
The problem is that as soon as they press an arrow key, the List Box
Click event is triggered and they get the first client in the list
instead of the one they want. This seems to be a f
|
3/9/2010 12:35:57 PM
|
13
|
Peter Hibbs <peter.hi...@btinternet.com.NO_SPAM>
|
Adjust the width of a tab control on a form?
Hi
In my database, there is a main form and a subform.
The subform consists of a tab control. In this tab control, I have placed
my forms (which have working Master and Child links).
I can't seem to make the tab control narrower than its current size. I want
to make 8 inches wide instead of its current 10 inches.
None of the forms in the tab control are 10 inches wide.
How can I make this change?
Thank you in advance for your help.
|
3/9/2010 4:04:01 AM
|
1
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Name saving as ID
I'm currently utilizing a combo box in my main form to select employee names
from a linked table. When the record is saved into the database table, it
shows the ID number from the table instead of the name from the field. How
would I correct this? Thanks!
|
3/8/2010 8:55:01 PM
|
6
|
=?Utf-8?B?VGhlRHJlc2NoZXI=?= <TheDresc...@discussions.microsoft.com>
|
New (Blank) record not active
The form I use to enter new data has an icon for "New (Blank) record". This
icon is faded and not active, so I can't use it to enter new data. Did I
somehow inadvertently lock something?
--
Ted in Chicago
|
3/8/2010 8:33:01 PM
|
1
|
=?Utf-8?B?VGVkQ2hpY2Fnbw==?= <twie...@hotmail.com.(donotspam)>
|
Hyperlinks in Access 2007 Rich Text
I love the HTML-based rich text in Access 2007, especially now there's a
hotfix so you can edit rich text in subforms. It's so much less hassle than
ActiveX rich text controls, or embedded Word documents.
However, I have a problem which has been bugging me for days. If I want a
clickable hyperlink in a rich text field, all is well if I simply type the
URL into the field e.g. "www.microsoft.com". But, there doesn't seem to be
any way of displaying the hyperlink as a word or phrase rather than the URL
e.g. if I wanted it to show as something like this:
"For more information
|
3/8/2010 6:14:01 PM
|
0
|
=?Utf-8?B?QmF6?= <...@discussions.microsoft.com>
|
Lookup Field 2nd Column
When using a lookup field within a form to choose information within another
table, how do you have the ID be the bound field but show a second field in
the form for the user. For example. There is a table for Cities. The first
field is CityID (AutoNumber) and the second is the name of the City.
Currently if the user uses the lookup field in the clients form, they can see
City in the dropdown list but the CityID is what shows when you choose a
record. Any Ideas how to show City Name instead?
--
Rose
|
3/8/2010 1:57:01 PM
|
2
|
=?Utf-8?B?Um9zZQ==?= <R...@discussions.microsoft.com>
|
how to put in a look up
I would like a look up or whatever in my data base. I have many unusual
names in the data base and it is hard to come up with the correct spelling of
a name. I would like to just be able to enter the first letter of the last
name and have all names starting with that letter come up along with the ID
number I have assigned. I do not have much programing knowledge so it should
be easy to do.
I am using Office Professional 2007.
Thank you
Foster1
|
3/8/2010 4:38:01 AM
|
1
|
=?Utf-8?B?Rm9zdGVyMQ==?= <Fost...@discussions.microsoft.com>
|
Relationships, duplicate values
Hi, I'm getting the common message "The changes you requested to the table
were not successful because they would create duplicate values...." I think
my table relationships are causing this and don't know how to get around. I
have 4 tables: tblCustomer, tblWorkOrder, tblClientBuildings and
tblClientBuildContacts, the last three are related to tblCustomer by
CustomerName(Primary key in tblCustomer). I have a form frmCustomer that has
a subform that is a continuous form that is bound to tblClientBuilding. On
this subform there's a command button that opens a popup form that is bound
|
3/8/2010 1:37:26 AM
|
1
|
"J_Murphy via AccessMonster.com" <u58...@uwe>
|
Does any one know of a template for purchases, business card siz
I would like to be able to have a business card size card that I can punch
the amount of purchase for my customers. After they make a certain amount of
purchases I would collect them and they would receive a discount on their
next purchase or a free item.
|
3/7/2010 11:54:01 PM
|
1
|
=?Utf-8?B?Y2FwdHVyZWQgbWVtb3JpZXM=?= <captured memor...@discussions.microsoft.com>
|
Subreport in Form
Howdy!
Virtually, what I would like to do is put a subreport in a form. Reading
around, I have discovered this to be impossible ;).
Basically, what I have is a report building form that I would like to have a
preview of the report off to the side. Is there a practical way of
accomplishing this? I am using Access 2007.
Thanks for any input!
|
3/7/2010 5:28:01 AM
|
0
|
=?Utf-8?B?VW5jbGUgSmF5?= <Uncle ...@discussions.microsoft.com>
|
Error 13 Type Mismatch
Need help solving a type mismatch error on the following code:
Many thanks!
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Limits the number of records allowed
'based on the field FloorProgMaxObservations
If DCount("*", "tblFloorProgAudit", "[AuditID] = _
" & Me.AuditID.Value & "" And _
"[FloorProgCriteriaID] = " & _
Me.FloorProgCriteriaID.Value & "" And _
"[AuditorID] = '" & Me.AuditorID.Value & "'") = _
Me.FloorProgMaxObservations.Value Then
MsgBox "You're attempting to exeed the maximum _
number o
|
3/7/2010 12:35:34 AM
|
2
|
"T5925MS via AccessMonster.com" <u58...@uwe>
|
How to right justify text in a listbox column.
How do I right justify text in a listbox column? I tried padding with
spaces but it just seems to strip them off.
|
3/6/2010 6:55:10 PM
|
3
|
cr113 <cr...@hotmail.com>
|
pivot table calculations
I have not done much in pivot tables. But I have designed a pivot table form
that does all I need except for the last step - creating a column to show a
net amount.
That is, I need to subtract…….
I have the sum of expiring Leases, that’s all I need. I do not care about
the type of lease.
For beginning leases, I have sums for three types – new, renewal or
extension – and a total for all beginning leases.
I need to know a net number for each month – number of all beginning leases
minus the total of all expiring leases. I can’t figure out how to get that
figure in the pivot t
|
3/6/2010 5:58:06 PM
|
0
|
=?Utf-8?B?QmliaQ==?= <B...@discussions.microsoft.com>
|
table or form creation
I have tried for hours to get this work and I cannot. I need to do this. I
have a list of items I sell for our charity group. I have various items and
various sizes. e.g. Short sleeve t-shirts, long sleeve t shirts, hoody's
etc., size small, medium, large, xlarge, xxlarge for $10 each. I want to put
a name with the order, then add a cost per item, then total all the items
purchsed. I want the final form to look like this.
name item cost per item total # of items total cost
In the end i want the report to say John Smith 1 XLarge and 1 medium SSleeve
tee shirt $20.00 and say
|
3/6/2010 3:12:01 PM
|
3
|
=?Utf-8?B?bW9sc29uMg==?= <mols...@discussions.microsoft.com>
|
Application Very Slow
I am using Access 2003 FE & BE application. My BE is in the server and about
15 Nos of simultanious users accessing the database with FE (MDE format)
application which is on there own Pc's. For almost all recordset operations I
have used "db.OpenRecordset("", dbOpenDynaset)" type in my FE application. If
only one user is using the application, then it is very fast and just after
any of other user logged on to the system then the whole application
performance dropping down considerably. And also two users are not using the
same form as well as not using the same tables (Directly) . I wan
|
3/6/2010 7:40:49 AM
|
1
|
"DineshLiyanage via AccessMonster.com" <u50...@uwe>
|
Application Very Slow
I am using Access 2003 FE & BE application. My BE is in the server and about
15 Nos of simultanious users accessing the database with FE (MDE format)
application which is on there own Pc's. For almost all recordset operations I
have used "db.OpenRecordset("", dbOpenDynaset)" type in my FE application. If
only one user is using the application, then it is very fast and just after
any of other user logged on to the system then the whole application
performance dropping down considerably. And also two users are not using the
same form as well as not using the same tables (Directly) . I wan
|
3/6/2010 7:40:39 AM
|
4
|
"DineshLiyanage via AccessMonster.com" <u50...@uwe>
|
Combining forms with separate tab controls
Hi there
I have created two forms. Each form contains a tab control.
I would like to combine these two forms and incorporate information from
both tab controls.
What is the easiest way to complete this task?
I really don't want to recreate the forms.
Thank you in advance for your help.
|
3/6/2010 3:56:47 AM
|
1
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Show a count of a field in a text box on a form - JCW
I would like to show the count of total current records in a specific field
and have the count show in a text box on my main form that opens when the
program is launched so I can see count without having to run a query, etc.
My main table is ECG and the field that I want to count is lupactive which
will have yes in the field to indicate that the record is current.
Any ideas would be appreciated. Thanks
--
JCW
|
3/6/2010 2:18:08 AM
|
1
|
=?Utf-8?B?Sm9oblc=?= <Jo...@discussions.microsoft.com>
|
On Cursor Hover Quastion
Access 2007 sp2
I have command button's Cursor On Hover property set to Hyperlink Hand.
On the same form I have a date field.
After choosing a date from the date picker and then move the mouse pointer
over the command button the hyperlink hand doesn't appear. In other words
the
mouse pointer remains as a pointer (default), it doesn't change to the
hyperlink hand.
Any idea why this occurs?
Thanks,
James
|
3/5/2010 11:45:30 PM
|
0
|
"JamesJ" <...@darwin_roadrunner.com>
|
change currency amount to words
I have a total field $565.30 and I want to display it in words in a form in
access.
|
3/5/2010 10:20:01 PM
|
1
|
=?Utf-8?B?RGViYmllIEdvbnphbGV6?= <Debbie Gonza...@discussions.microsoft.com>
|
Access 2007 scrolling with Left mouse button
Hi, all. I have an Access application written in Access 2003 that we
are now testing with Access 2007. When using Access 2003, the users
used to be able to scroll through records displayed on a form by
positioning the cursor on top of a VCR button and holding down the
left mouse button. People with external mice could also cause the
same scrolling by using their mouse wheel. Neither of these behaviors
happen when the application is run using Access 2007.
After reading a number of posts about changing the behavior of the
mouse WHEEL when using Access 2007 so it mimics the scrollin
|
3/5/2010 9:42:01 PM
|
9
|
CP <cput...@tnc.org>
|
Using Form to Lookup/Search a Table
I'm looking to see if someone can point me to either the Access Help pages or
another location which will describe how to use a Form and Subform to look up
a type in a specific value into a field and have it look up that information
(such as running a query would) but display it into a subform.
Thanks
Jeffrey Wilson
|
3/5/2010 7:09:01 PM
|
7
|
=?Utf-8?B?SmVmZnJleSBXaWxzb24=?= <JeffreyWil...@discussions.microsoft.com>
|
Look up field
I am using Access 2003
I have a form created in which I have to type descriptions of our ball
products.
Ex: 0.75mm Tungsten Carbide, or 0.33mm Ceramic, or 1.25mm Plastic etc.
I am trying to create a field where I would only have to type the number -
0.75, or 0.33 or 1.25 - and be able to select the material to go with the
size. I made a Look up data base for the description field. But after I
type the number and select the description - the material over writes the
number. Leaving me with only the material and no size. Can anyone help me
figure out how to do this? I have a
|
3/5/2010 5:53:01 PM
|
4
|
=?Utf-8?B?QXVyb3Jh?= <Aur...@discussions.microsoft.com>
|
Query/subquery in form
I have a form with a query listed in a "list" box. The query has a sub-query
with a linked field. When I run the query by itself, the "+" shows up and I
can "drill down".
When I run the form, the "+" will not show up on the form. Can you not have
this option on a form?
Thanks
|
3/5/2010 5:39:01 PM
|
1
|
=?Utf-8?B?V2FybWFu?= <War...@discussions.microsoft.com>
|
Force Record in Subform
I have a main form (F_Ticket) and a subform (F_Ticket_Sub). A user enters
general ticket info in the F_Ticket form then line item detail in the
F_Ticket_Sub form. My problem is that I want to enforce that at least one
line item is entered in the F_Ticket_Sub form. If not I dont want a new
record created in the main form - because ther should never be a new record
in the main form without at least one record in the subform that relates.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1
|
3/5/2010 5:03:39 PM
|
11
|
"szag via AccessMonster.com" <u2...@uwe>
|
Convert Julian to Date
Hi and TIA! I've researched and tried many many conversion functions but
none give me the results. One Example
Public Function JDatetoDate(MyDate As Integer) As Date
JDatetoDate = DateAdd("d", Right(MyDate, 3) - 1, "01/01/" &
Left(year(Now()), 3) & Left(MyDate, 1))
End Function
?JDatetoDate(8044) returned 2/13/2018 expected 2/13/2008
?JDatetoDate(0044) returned 2/13/2014 expected 2/13/2010
Any ideas. Basically want to convert a 4 digit julian to a date/time and
then I will add 1 minute to it. Thanks!
--
Reggie
|
3/5/2010 4:37:52 AM
|
1
|
"Reggie" <No_Spam_chief123...@yahoo.com>
|
Sorting in Pivot Charts
I'm using Access 2003 & am trying to sort in a Pivot Chart. I have a single
series & I'm trying to sort by the qty of that series. Thanks much in
advance, M.C.
|
3/4/2010 11:38:01 PM
|
0
|
=?Utf-8?B?TWljaGFlbGNpcA==?= <Michael...@discussions.microsoft.com>
|
Check Control if Visible or hidden
Hello All,
How can I check thru code, if a control on the form is visible or it's
hidden?
Thanks in advance
Abe
|
3/4/2010 9:37:21 PM
|
2
|
"Abe Katz" <abek...@mindspring.com>
|
Re-Link backend with ini file
OK I've been playing around with this for a couple of days now and
have found a few suggestions as to how to do it. But I still can't
get it to work.
Basically, I have a Frontend called FEApp.mde and a file called
DataPath.ini in one folder and a Backend called BEdata.mdb on another
shared computer. The DataPath.ini file and has only one line in it.
\\PC1234\SharedDocs\BEdata.mdb
On another forum, someone posted a suggestion to have this code in the
Front End
Dim strFile As String
Dim intFile As Integer
strFile = App.Path & "\DataPath.ini"
|
3/4/2010 9:24:07 PM
|
11
|
Nick Del Vecchio <las.sier...@gmail.com>
|
tabbed forms - tab 3 link to tab 2
I am using a tabbed form.
Tab A is based on ProjectTable with PK=ProjID
Tab B is based on ProjectDescTable with PK= ProjDescID and links to
ProjectTable with a field for ProjID. Tab B's child field is ProjID and
mother field is from Tab A's PK field.
Tab C is based on ProjTasksTable with PK=ProjTaskID and links to
ProjDescTable with a field for ProDescjID.
I want tab C to link to Tab B. Mother field would be ProjDescForm's
ProjDescID and child field would be ProjTaskForm's ProjDescID. The wizard
only shows me fields from Tab A.
Is there a way to link Tab C to Tab B?
Than
|
3/4/2010 7:17:01 PM
|
1
|
=?Utf-8?B?cGF0dGk=?= <pa...@discussions.microsoft.com>
|
Cross Tab Query
I have a access database with SQL backend. The table labproofs has charges
listed by report date, with the below query, I can run a cross tabquery with
the end date selected from a form (monthly report), and it gives me the 12
month data from the end date selected. However, the problem I face is for
example if the end date selected is feb 28th, I get the data for previous
months as Jan 28, Dec 28, Nov 28 ......, I want data for the month end
numbers like feb 28, Jan 31, Dec 31....., I am not sure what I am doing wrong
here.
Please help.
Gmen
PARAMETERS [Forms]![Monthly Reports]
|
3/4/2010 5:19:52 PM
|
4
|
"Gmen via AccessMonster.com" <u44...@uwe>
|
Excel Type Rounding
Hello,
Am using A2k. Want to round numbers to thousands. With Excel I use
Round(number, -3) for this. However, dont know how to do it with Access
standard Round() function. The same syntax produces an error with Access. Pls
Help
For example, I want 125,232 to be displayed as 125,000 and 125,832 to be
displayed as 126,000
TIA
Anand
|
3/4/2010 5:16:02 PM
|
1
|
=?Utf-8?B?QW5hbmQ=?= <An...@discussions.microsoft.com>
|
Show complete record in continuous forms
I have had the same issue for a while but don't know if there can be anything
done about it. Continous forms have a sloppy look when when you have too many
records to show on one page. Is there any kind of coding that can be done to
give functionality like a report has where records stay together. I know
reports and forms are apples and oranges but just wondering if there is a way
to give a form a better look and not show half of a record at the bottom when
it is opened up. I'm guessing not but if there are any ideas...
Thanks.
--
Message posted via http://www.accessmonster.com
|
3/4/2010 5:01:40 PM
|
4
|
"szag via AccessMonster.com" <u2...@uwe>
|
Hyperlinks not working
My computer and office program recently were upgraded to Access 2007. Now I
notice that all of the hyperlinks that i have to word and pdf documents are
not working. Please advise as to how i can reactivate them.
--
Archivist
|
3/4/2010 4:43:01 PM
|
0
|
=?Utf-8?B?QXJjaGl2aXN0?= <Archiv...@discussions.microsoft.com>
|
Confusion with forms and related subforms
Hello,
I'm trying to figure out the concept of embedding subforms into main forms.
I have main tables, 4 junction tables, and a few look-up tables (not all
look-ups are listed below). If I'm reading it correctly, the junction tables
which relate to the main tables should be in the form of a subform placed
within the main form they relate to? I'm lost on the fact that I believe I
have a subform which appears should be on another subform which should then
be on a form. If this is correct, the form looks extremely busy and not user
friendly, and just plain incorrect. Is it t
|
3/4/2010 1:39:02 PM
|
3
|
=?Utf-8?B?TGVlIEFubg==?= <Lee...@discussions.microsoft.com>
|
dividing lines
I have made a continueous form in Access and when I switch to the print
preview, I can see the dividing lines on the screen. However when I print the
form, the dividing lines do not appear on the paper. I use Office 2007 with
SP2.
When I perform the same actions on a machine with Office 2007 SP1, the
dividing lines are shown on the print preview as well as on the printout. Can
anyone help me with this issue.
--
bosje
|
3/4/2010 12:21:01 PM
|
1
|
=?Utf-8?B?Ym9zamU=?= <em...@voorbeeld.com>
|
Disallow field sorting by users
I'm using Access 2007. My subform is shown in datasheet view. The field
captions on the datasheet contains the standrd Access 2007 dropdown option to
sort on the field but I want to disable this and kind cannot find a way to do
so. I got rid of the filter option on that dropdown by seting the Allow
Filters property to false but I can't find a similar property to disallow
sorting.
Any ideas?
|
3/4/2010 9:07:02 AM
|
1
|
=?Utf-8?B?TWl0Y2ggUG93ZWxs?= <MitchPow...@discussions.microsoft.com>
|
How to minimize a form - Access 2007
Hello,
I have a pop up request form executed from a button on another form. The
pop up form accepts parameters which are passed to a query which is the
source for a report.
When the report's preview runs it appears behind the request form. The only
way I can find to have the report in the fore front is to not have it as a
"pop up".
I have been trying to find info on the Do cmd to use it to minimize the
request form before running the report with no luck.
Any help as usual would be most appreciated.
Abay
|
3/4/2010 3:48:01 AM
|
1
|
"Abay" <a...@aol.com>
|
How do I add a record counter to my form
I would like to add my own record counter, like "Record # of #", to my form.
How can I do this?
|
3/4/2010 2:04:01 AM
|
21
|
=?Utf-8?B?Z2FnZWNyZXM=?= <gagec...@discussions.microsoft.com>
|
What does this macro error mean?
I just made a change to my database and now I am getting an error message
when I open it. The message says: "The expression OnCurrent you entered as
the event property setting produced the following error: Return without
GoSub."
What does this message mean?
|
3/3/2010 8:06:01 PM
|
4
|
=?Utf-8?B?Z2FnZWNyZXM=?= <gagec...@discussions.microsoft.com>
|
Stop advancing in form with the "next" arrow at end of "list"
I have an editable form for users where they can query by date, etc.
However, the next entry arrow allows them to advance beyond the result. For
example, if their query resulted in 1 of 4, they can still click to 5, 6, and
so on which only adds blank lines to the database table. How do I set this
to stop at the last entry of their original query?
|
3/3/2010 7:24:01 PM
|
3
|
=?Utf-8?B?RHVjaGVzcw==?= <Duch...@discussions.microsoft.com>
|
re-linking backend on shared folder
I have several front ends on different computers connected to a single
backend on a shared folder on one of the computers. All is fine
untill I update the front ends and then have to manually re-link each
one with the backend. Since I am modifying the front end on my own
machine and then copying it to the other machines, the path to the
back end will not be the same.
Is there a way I could have a small text file or excel file in the
same folder as the front end that has the location of the backend and
use it to somehow to relink the tables?
|
3/3/2010 6:49:00 PM
|
6
|
Nick Del Vecchio <las.sier...@gmail.com>
|
Sorting Buttons (VBA)
I am struggling with creating commdand buttons for sorting on a field. Here
are the codes in the two buttons:
ascending sort button...
Me.OrderBy = "[Vendor_JE]"
Me.OrderByOn = True
descending sort button...
Me.OrderBy = "[Vendor_JE]Desc"
Me.OrderByOn = True
The ascending button seems to work. My question is why isn't the descending
button working and how to do clear out the OrderBy in the forms property.
Thanks!
--
Message posted via http://www.accessmonster.com
|
3/3/2010 5:45:46 PM
|
3
|
"szag via AccessMonster.com" <u2...@uwe>
|
Calendar-control in Access 2010
Is it correct that at last the calendar-controll is yet avalable again in
Access 2010? (a few days ago it was desappeared)?
Luciano
--
Luc Ringoir
Belgium
|
3/3/2010 4:41:01 PM
|
0
|
=?Utf-8?B?THVjaWFubw==?= <Luci...@discussions.microsoft.com>
|
how to put photos in Microsoft Access Form
I've noticed that the questions asked in the "Community" are from 2005 -
2007. Yet none is any help to me and I've tried almost all of them.
I have Access 2003. is there any updates putting photos in Access 2003 form.
Also, I posted my question yesterday and it's not in the community list.
What happened to it. How am I to know when my question will be answered.
Will I get an e-mail that someone has looked at what I've posted and give me
some help.
Please let me know
Helen
|
3/3/2010 4:34:02 PM
|
2
|
=?Utf-8?B?SGVsZW4=?= <He...@discussions.microsoft.com>
|
tabbing thru subform doesn't work
I have a form of contact information that has a subform with some yearly
dollar figures. I'm trying to set up the form so my user can view and edit
the contact information and enter the dollar information for the current
year. I found some code that allows me to tab from the last field on the
subform to the first field of the main form. The tabs work the way I want
them to the first time thru. However the next time thru when I tab from the
main form to the subform it goes to the last field on the subform and then
tabs back to the main form. How do I force it to go to the 1st fi
|
3/3/2010 3:31:02 PM
|
1
|
=?Utf-8?B?SyBFc3NtaWxsZXI=?= <KEssmil...@discussions.microsoft.com>
|
Help with requery/update
I have a form called frmAuthorization with a combo box drop down menu called
RNAsssor. I want to send an email to the Assessor chosen in the combo box
with a report attached containing the data just entered on the form. I have
a macro set up to send the report in an email.
In the On Exit event of the combo box I have:
DoCmd.Requery
DoCmd.RunMacro "mcrInitialAssessment.Initial"
The problem is when I exit the combo box, it does the requery and all of the
data disappears from the form, and the email is not sent. When I take the
DoCmd.Requery out of the code, the email an
|
3/3/2010 3:07:01 PM
|
4
|
=?Utf-8?B?TWFyeSBCZXRo?= <MaryB...@discussions.microsoft.com>
|
Disable cmd button - focus problem
I have a cmd button (filter button) that enables another button (print
preview button).
I then disable this print preview button after it is clicked by first
setting the focus to another control and then disabling the button.
That works fine.
Private Sub cmdSpecialPreview_Click()
DoCmd.OpenReport "rptPrintPreview", acViewPreview, , strWhere
cmdFilterOff.SetFocus
cmdSpecialPreview.Enabled = False
End Sub
The problem is that if the user clicks the first button (which enables
the 2nd button) and then clicks somewhere else. This keeps the second
button enabled.
I tried to disab
|
3/3/2010 2:42:01 PM
|
2
|
Nick Del Vecchio <las.sier...@gmail.com>
|
list attachments in a form or record
I have figured out how to add attachments to a record, but the default way of
handling them on forms isn't the greatest. I would like to be able to have a
list of the attachments directly on a form (I have a form that lists details
for contacts and I would like one of the fields to be the list of
attachments). I would also like the ability to select and open the
attachments from the form. Is this possible? I did a quick search and
haven't found any discussion that covers this. I'm using Access 2007.
|
3/3/2010 1:31:01 PM
|
3
|
=?Utf-8?B?R250bGhuZHM=?= <Gntlh...@discussions.microsoft.com>
|
ACC2007: SubForm slows down form
Hello,
i have a form which is connected to a query with about 6000 records on sql
server. If i open that form, it is really fast. But If i add an empty subform
on this form, the form opens in 12 sec. What i've seen is, that without the
subform the record counter on the bottom only shows the current record but
with a subform on it, it seems that it loops through all records and the
shows "1 of 6000".
Any ideas why there is a difference? I also tried to make the subform
invisible or disable it, but the behaviour is the same.
Regards
Andi
|
3/3/2010 12:52:01 PM
|
0
|
=?Utf-8?B?QW5kaQ==?= <A...@discussions.microsoft.com>
|
Combo box help please
I have a combo box with 4 fields which is using a query made from 2 related
tables. Column 0 populates the primary table and I need column 1 to populate
the secondary table once selected in the form. The details from each field
are located on the form (hidden with a visible field which joins columns 2&3
into one field)
Is there a way to do this? Really do not want to split this down if I can
help it. If I do need to split it, is there a way to select column 0 and it
make the 2nd combo box only show related entries e.g
Current Combo - 0=Company Name, 1=ContactID, 2=First
|
3/2/2010 11:51:07 PM
|
8
|
=?Utf-8?B?Q2hhcmxpZQ==?= <Char...@discussions.microsoft.com>
|
Limit rows in subform based on field in main form
I have a main form that has a number field (this field inidcates the number
of seats available). I want the subform to only allow the user to enter data
in rows that are equal or less than than the number field in the main form.
please help with code and best place to enter.
many thanks!!!
|
3/2/2010 11:50:01 PM
|
4
|
=?Utf-8?B?Y3ludGVldWg=?= <cynte...@discussions.microsoft.com>
|
same subform used in two different forms
Hi Folks,
Is it possible to use the same subform in two different main forms
simultaneously? If it's possible, is it good practice? I can foresee
that there may be problems with code, but the subform I'm thinking of is
very basic.
Three tables:
tblFamily
FamID (primary key)
FamLastName
tblIndividual
IndID (primary key)
InFamID
FirstName
MiddleName
....other personal data
tblAddress
AddressID
AdFamID
street
city
state
zip
Two main forms for different types of data entry
frmFamily with family information on the main form and address
information in the
|
3/2/2010 11:26:33 PM
|
2
|
"Kathy R." <geneseo...@frontiernet.net>
|
remembering strWhere
I have a form that has 3 quick filter command buttons. After the user
hits the filter buttons, I'd like the user to be able to print preview
with the filters they selected. Right now, it is working by making 3
additional print preview buttons with a code like this,
DoCmd.OpenReport "rptPrintPreview", acViewPreview, , strWhere
Rather than having 3 extra buttons, I'd like for Access to remember
the strWhere condition so that I can have just one button for print
preview.
Is there a way to temporarily store the strWhere filter so that it is
available again?
|
3/2/2010 10:40:43 PM
|
3
|
Nick Del Vecchio <las.sier...@gmail.com>
|
Dificult with subform
Hello, wonderful forum, as I do not speak English, this is a machine
translation of Google, I hope you understand my question.
I have to make a form with a subform included.
This subform would include data on the main form.
The difficulty is given by the relations between the two tables
Main form
Table 1: Suppliers
id_prov
Subform
Table 2: Articles
id_art
prov_1
prov_2
prov_3
Where the two tables are related as follows
id_prov -> prov_1
-> prov_2
-> prov_3
Where any item can belong to three different suppliers.
The idea is that in all the articl
|
3/2/2010 9:04:43 PM
|
7
|
"jtguardado" <u58...@uwe>
|
how do you get a form to link to a datasheet that you created
ok here is my problem. I created a form from scratch. I gave off labels and
text boxes with list boxes, and so forth. Basically I used all of these
different things. So now I am trying to link my form to the database I
created but it will not link, and because I created the form from scratch it
says that it is unrelated. I am new to all of this and was wondering if
anyone can tell me what code I am missing, or what I am forgetting. Thank you
for taking the time to read this.
|
3/2/2010 8:16:01 PM
|
1
|
=?Utf-8?B?YW5ld2Jvcm5tYW4=?= <anewborn...@discussions.microsoft.com>
|
How can I put photos in Microsoft Access Form
I used the information BobLarson said in putting photos in Microsoft Access
Form but it's not working. My computer keeps asking for Form1, which I
deleted because nothing was happening the way I wanted it to. What I would
like to know is there a online video that can show how you can do this
procedure. And how can I get my computer stop asking for Form1.
|
3/2/2010 6:26:01 PM
|
2
|
=?Utf-8?B?SGVsZW4=?= <He...@discussions.microsoft.com>
|
Format of SSN Field on Form
I have a table with an pkEmpID (auto number) and txtSSN, txtLName, etc. fields.
I have a form with a combo box used to query this table. The combo box
retrieves the pkEmpID and txtSSN when the user types in the SSN. (The pkEmpID
is bound to a field in another table.)
When I type in the SSN, I want the combo box to display it as @@@-@@-@@@@.
If I set the field format to @@@-@@-@@@@ in the table, the SSN displays the
data okay on the form. But you have to type in the dashes as part of the
entry. I prefer not to have to do that.
I took the formatting off the table field and tried to s
|
3/2/2010 4:27:01 PM
|
2
|
=?Utf-8?B?S2VuIEh1ZHNvbg==?= <KenHud...@discussions.microsoft.com>
|
Tab Control
Hello, I'm using Access 2003. I have a form with a tab control. I want to
have another tab control within one of the page of the main tab control. So
when you go to a certain tab, I'll see 3 sub pages. Is this possible? I
can't seem to drag a new tab control onto a existing page of the main tab
control.
Thanks
|
3/2/2010 3:29:02 PM
|
2
|
=?Utf-8?B?RG9u?= <...@discussions.microsoft.com>
|
Filter Datasheet based on Combo Box selection
I have a SubForm that displays in Datasheet view. I want to add a Combo Box
just above the SubForm that the user can select the Pay_Period_Ending_Date,
and once selected I would like the Datasheet to filter based on this date.
Can someone please direct me as to how I can do this?
--
Message posted via http://www.accessmonster.com
|
3/2/2010 12:39:15 AM
|
3
|
"Pasadena-D via AccessMonster.com" <u56...@uwe>
|
Auto Populate a Combo Box based on the user selection of another Combo Box
I have a form that has 3 Combo Boxes; 1) Personnel Number, 2) First Name, 3)
Last Name. The Row Source for each Combo Box is "tblPersonnel_Number", and
each Combo Box is assigned to their respective Control Source by name. When
the user selects their Personnel Number I'd like the First Name, and Last
Name to populate automatically. I found out how to do this by using
"=Personnel_Number.column(2)" for First Name, and "=Personnel_Number.column(3)
" for Last Name, but when I close the form it saves the Personnel Number into
"tblPersonnel_Number" but not the First Name and Last Name. Is the
|
3/2/2010 12:34:44 AM
|
4
|
"Pasadena-D via AccessMonster.com" <u56...@uwe>
|
Displaying Records In A Continuous Form
I know this is easy, but how can I make a continuous form display only active
records without a new record at the bottom? I would like the new record to
be available only after the "Add Record" button has been selected. I've
looked at all of the form properties, and there isn't an obvious choice to
make this happen.
--
Thank You,
Walt
|
3/1/2010 9:18:01 PM
|
3
|
=?Utf-8?B?V2FsdA==?= <W...@discussions.microsoft.com>
|
form design issues - Access2007
Hello Access 2007 here, 2 quick questions:
1) how can I manage comboboxes do NOT change background on exit? It seems
that by default, once you exit the control it kind of make its background
transparent, even if either backcolor or backstyle values didn't change, I
ckecked.
2) I'm noticing that after starting typing in an unbound form, the labels
text seems kind of bolder, not looking "regular" as when the form opened. I
read some years ago something about issues regarding memory licking that can
cause weird *things*. Does anyone know something more accurate?
thanks,
rocco
|
3/1/2010 6:24:01 PM
|
5
|
=?Utf-8?B?cm9jY28=?= <ro...@discussions.microsoft.com>
|
Do not run subform criteria when form opens
I have a subform query with criteria selection, for client name. In the main
form I have a button which then requeries, for the user to enter their
selection criteria, and list the results. How can I stop the subform query
selection criteria box from appearing when I open the main form?
Any help would be greatly appreciated.
|
3/1/2010 5:53:01 PM
|
2
|
=?Utf-8?B?TWF0dFc=?= <Ma...@discussions.microsoft.com>
|
recall of infor on a form
I have created two tables: table one has basic info lname, fname, grade,
student id number. Table two is an incident report form with fields: student
id number, date ,grade , etc. I have a relationship from table one to to
table two in a one to many relationship respectively. My user wishes to enter
incidents on a form. So I created a form from table two and all works as
planned. However my user would like to enter either a)student number or b)
last name with out using a drop down list( long list of choices.) and then
have it display both student number and last name then save
|
3/1/2010 3:44:01 PM
|
2
|
=?Utf-8?B?dG9ua2FwbGF5ZXI=?= <tonkapla...@discussions.microsoft.com>
|
A2K-TOOLS - Convert Database to current ACCESS-Version
Hi,
i want to create a form to convert several hundreds of A97 dbs to A2K.
does anybody know what which routines are behind the Convert to
current Database-Version
in the A2K-Tools Database Utilities option.
How could this be integrated in my form for the convert-loop over the
a97-dbs.
many thanks f=FCr helping
|
3/1/2010 2:07:21 PM
|
2
|
harmi <rharmga...@yahoo.de>
|
How to keep the top of the form anchored at the top
Hi there
I have created a form and subform where the subform is a tab control.
When I open my form, I'm at the top of the page but when I start to select
any of the tabs, I'm no longer at the top of the form but am located near the
bottom.
How do I set it so that my form always stay at the top instead of moving
around?
Thank you in advance for your help
|
3/1/2010 5:13:01 AM
|
1
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
select correct record
Hi,
I have an unbound box to search and select an athlete in a sales form. It
works only partially. Each athlete can have several sales records for each
contract year and there are some athletes with the same last name. I want to
be able to select the record based on the contract year. But when I try to
select the year that I want it just selects the first record. Here is my code
and the information from the recordsource box.
SELECT qrysales.Lname, qrysales.Fname, qrysales.SalesID, qrysales.
contractyear FROM qrysales ORDER BY qrysales.Lname;
Private Sub cbosearch_AfterUpdat
|
3/1/2010 1:59:35 AM
|
1
|
"timbits35 via AccessMonster.com" <u34...@uwe>
|