Struggling with calculated field on form
Thu, 11 Dec 2008 11:28:01 -0800
I have a table that has a field for # of days used (tb_Labor), and another
table (Employees) that has a field for Cost perday, for each employee....I've
built a form and show the one field for the days, but want another that
calculates the cost perday * the # of days, once i enter something in the
days field ...
|
Combo Box to open forms
Thu, 11 Dec 2008 10:54:14 -0800 (PST)
On my switchboard in access 2000 I want to have a combo box that when
i click a value it will open the a form. I imagine that it is easy but
everything is hard for me. Thanks in advance! ...
|
Tab with 'X' in it - Access 2007
Thu, 11 Dec 2008 10:38:23 -0800
Is it possible to get the tab controls with x's in it like in Windows
Explorer 7? Now it is just 1 'x' and it is in right of the screen ...
|
Filtering Queries from List Box
Thu, 11 Dec 2008 10:33:01 -0800
Hi all,
I have a query which shows staff members and their campaigns. The 'criteria'
part of the query looks up the staff member selected in a report's list box
and filters for that staff member.
So for example, if the user selects 'Joe Bloggs' on the report' list box,
the query will filter to only show ...
|
Coding combo boxes
Thu, 11 Dec 2008 10:08:10 -0800
I need to have someone confirm I am not going nuts. After working in Access
Form 2003 on my last project, use a little bit of VB code enabled me to build
in a little more function and some nice to have things, like clearing the
combo box once the user selected the record they wanted on the form.
Now workin ...
|
Text box "flashes" when clicked
Thu, 11 Dec 2008 06:53:01 -0800
I have a text box using a query as a recordsource. The Click event sets the
filter property of the parent form to the value selected in the text box.
Every time I click the text box, the items disappear for a brief second and
then re-appear. I do not explicitly requery the text box, but am guessgin
that s ...
|
Linking Subform Error
Thu, 11 Dec 2008 06:49:00 -0800
If this question had been answered I do apologize..I read through the
questions and I still cannot resolve my issue. I have 2 tables - dist id
field and customer field. I am trying to create a form with 2 subforms....
in the first form the use selects a district id and district information is
displayed. u ...
|
|
|
Primary Keys
Thu, 11 Dec 2008 05:40:00 -0800
All,
Here is my dilemma. I have a table listing item#'s and item descriptions.
The item# is the primary key. I have a form that captures item# description
and other information. I would like the description field to auto fill once
the item# is entered. I can not use a combo box as there will be nearly 1 ...
|
Toolbars come and go?
Thu, 11 Dec 2008 05:29:09 -0800
I'm designing a basic master form that contains several controls including
subformas displayed as datasheets. The problem is that as the user navigates
into or out of a datasheet subform, Access displays toggles the display of
form related toolbars as the context and focus dictate. The practical issues
is ...
|
Access Form automatic scrolling
Thu, 11 Dec 2008 05:23:01 -0800
Is there a way to have an Access form automatically scroll down as fields are
filled? Thanks in advance for any assistance provided
--
Byron Gomez ...
|