|
Text box
In Access 2003, how do i get a text box to appear blanked out upon opening
the form.
I can get it to change upon editing a tick box but cannot get it to open
like this
Thanks,
Matt...
|
5 |
29.09.2006 12:37:02 |
|
|
Interesting form design problem: help!
I have two tables, "Employee" and "department", which has a 1-to-many
relationship.
From "employee" I have the fields "employeeID", "Fname" and "Sname" and,
from "department", I have the fields "WeekID" and "rate".
When I go through the wizard I choose these fields. Unlike what I would
expect, I am not getting the step in the wizard which shows the fields from
"employee" in the main ...
|
11 |
29.09.2006 11:36:29 |
|
|
Button Click to clear entered text in a combo box
Hi
I have a combo box on a form that is used to do a surname search. One
of the things the people using the database do is before adding a
person's details onto the database they persform a surname search. If
there is no match at all for the surname entered Access says so. If
clicking to enter a new record it still comes up with the same message
that there is no match for the name. Thi...
|
2 |
29.09.2006 10:34:19 |
|
|
copy and paste
Hi,
I copy words from a word document, Eng 97, which include
double-quotation mark and paste it to a Access 97 form which field type is
memo in Eng Win Xp. After this, when I press the backspace key, chinese
character will appear in the place of double quotation mark and when I
print, Chinese appears as well. Can you please help? Thanks.
...
|
4 |
29.09.2006 06:38:03 |
|
|
Aide Merci
Bonsoir les amis
Je vous expose mon problème. Je suis en train de réaliser un formulaire de
saisie de commande. mon est le suivant :
une commande est sous forme de pack. un pack est constitué d'une dizaine
de produits. Je voudrais que sur le formulaire une fois que l'on
sélectionne le nom du pack le panaché de produit correspondant apparaissent
dans un sous formulaire avec les quantité pr...
|
3 |
29.09.2006 03:10:48 |
|
|
Updating tables
We maintain a table (table A) of names and addresses in Access 2003. We
periodically recieve a table (Table B) of names and addresses from an outside
source. We would like to compare the two tables in a form and indicate if A
should be updated with B information, then update, or if B should be
appended to A, then append. ...
|
2 |
29.09.2006 03:07:01 |
|
|
Can't remove controls from Tab Order
I have several controls (of various types) that I do not want to include in
the tab order on the form.
So I set the Tab Stop property vaue to No for each of those.
But they still appear in the list in View/Tab Order despite saving, exiting
the mdb, everything short of a reboot so far!
I DO NOT want users to be taken to these fields.
Is there something I am missing, to exclude them from the...
|
6 |
29.09.2006 00:58:52 |
|
|
Forms -- "Tax Table"
Hello,
Let's say I've got a table that lists all fifty states and a tax rate
associated with each.
As would be expected, I would like a user to be able to change / update the
tax rate, but not change the state name, nor add / delete records.
I'd like a form that displays all fifty records (state name & tax rate
fields) at once, and the user scrolls up/down to find the entry they wan...
|
3 |
29.09.2006 00:34:21 |
|
|
Q: two forms, one table
I'm using Access 2003 in a multi-user environment. I am planning on creating
two forms, both bound to one table. The reason for this is the first form is
already filled up and I need to add a new subset of data.
Is this recommended and what are the things I need to watch out for if I do
this? The secondary form will be a child to the primary form (ie. whatever
record the primary form i...
|
4 |
29.09.2006 00:30:06 |
|
|
Can't build a link between unbound forms
This is the error message I get when I try to link the LogID (primary) from
the master form and the LogID from the Item Entry subform in the properties
box.
Both LogID's are Long Integers, with only the master table having the LogID
listed as primary.
I am using Access 97. I can build the exact same tables and forms in Access
2000 and it works, no problem. Unfortunately, everyone...
|
5 |
28.09.2006 23:31:04 |
|
|
Converting a MS Word doc to an Access Form
We have a word document being used in the office for client contact
information. 13 different individuals fill out these forms and submit them
to my group.
1. Can I make this Word doc an Access form so that the 13 employees are
populating a single database of contact information?
2. Even if I have to build an original Access form, how do I share the form
with each employee, each com...
|
2 |
28.09.2006 23:19:53 |
|
|
space bar function within an access form
Within an access form and within a text or memo field, the spacebar
and enter keys are acting as the tab key. How do we get the default
spacebar and enter functions back?
...
|
1 |
28.09.2006 22:55:34 |
|
|
Trouble repositioning a StatusBar-control
Hello,
Access 2000 here.
I have the intention to build a 'Personal Addressbook', but first I want to
have the GUI so right now I'm busy with a smooth UserForm.
At least, that's what I want.
A ToolBar and a StatusBar were added, but when resizing the form to
maximized, the StatusBar won't move.
Me.InnerHeight or Me.WindowHeight won't work - if I say +10000 or -10000, +1
or -1...
|
1 |
28.09.2006 22:29:29 |
|
|
If.. Else help
I am trying to use this code in the On Close Event of my main form, but
I get can "variable not defined" Compile error. I am new to and VB so
any help would be appreciated.
Thank in advance
If MsgBox("Are you sure you want to exit?", 65, " Database") = vbOK Then
DoCmd.RunCommand acCmdExit
ElseIf vbCancel Then
Cancel = True
End If...
|
8 |
28.09.2006 21:32:20 |
|
|
"Smart Tag" Inheritance...
Hello!
In using the "Developing Smart Tag Solutions with Microsoft Office Access
2003", I have come across an 'Error' problem. I'm using Windows XP SP2, IE
7.0.
The instructions are:
1) With the Employees1 form [which has the Smart Tags - one added to the
Employees table (Northwind.mdb) and a new Employees form (Employees1 form
created) and one added directly to the Employees1 fo...
|
1 |
28.09.2006 20:25:01 |
|
|
Refreshing sort order after record added - subform
I have a subform which I will call SubformA, I then have two items
Comment_Date and Comment. I just have it so a new line is inserted
after previous comments that you can type into, and then it adds the
new comment record. What is annoying me is that I want the newest
comments first, and it sorts properly on load, but when I add a new
record, it doesent add it to the top of the comments. Is t...
|
1 |
28.09.2006 20:16:03 |
|
|
Combo Box Problems
I have a combo box in a subform. When the user selects an account and then
goes to enter the contract for the account, they need to select the
associated contact. When they select the contact, the name appears just fine
and the information is stored in the underlying table, but the next time they
open the database and scroll through the account records, the selected
contacts do not sho...
|
4 |
28.09.2006 20:12:02 |
|
|
Record of actions within a page
Within a page (i.e. in a framed panel) I want to have an "Actions" record
that would look and behave rather like a table in Word.
It needs 4 columns: Date (will default to current date) By (will default to
user) Action (free text) Follow-up (date field).
Each entry area (row, I suppose) should be expandable to suit whatever is
entered.
The panel needs to have an indefinite number of rows...
|
2 |
28.09.2006 19:51:03 |
|
|
Date format
I have syntax error???
if (((Date()) Between '6/30/2006' And '9/29/2006')) then
txtDt = 6/30/2006
end if
txtDt is unbound text box.
Help,
Please...
|
8 |
28.09.2006 19:49:01 |
|
|
Filter with like value from combo box
Hi,
Can someone tell me if there is a way to filter a subform with a combo box
to return all records that are "like" the selection chosen? When I click on
the record source of the subform, it brings me to the SQL Query grid, the
combo box is referenced in the related field. It will only show me records
for those that match exactly. I need a Like*.
Example: Select "Water" from co...
|
5 |
28.09.2006 19:49:01 |
|
|
setting values
Hi, currently havea form called job's with customer details on the front that
run off a customer number, so on the front page when i click on adda new job
it gets a new record on that job form as well as pop up a form to enter new
customer details. The problem is that when i enter these new customer details
and click add ( which runs a macro that sets the value in the job form to the
rel...
|
2 |
28.09.2006 19:45:43 |
|
|
toggle button
I created toggle buttons (from A to Z) at the bottom of a form (Form footer)
and would like them to return the results (in the same form).
Meaning that when I click on the button "A", the result would return all
records with Last Name starting with letter A.
HOW??
Thanks
--
Marg...
|
4 |
28.09.2006 19:33:39 |
|
|
dlookup with multiple criteria
On a form Tankentryform I am trying to grab the rate field back on the table
tbltanksrate2 where the following fields on the form are equal to the given
values back on the table. The rate field is just an input not a calculated
field but it should automitically be put in on the form based on the
clientid, pickupyd,etc. see below.
getting a syntax error not sure where???????
=dlook...
|
8 |
28.09.2006 19:32:53 |
|
|
Prevent "Enter" moving cursor into next field?
I have several text boxes on a form, in which users will type a fair amount
of text (notes). They will want to use Enter every now and then to provide a
new line.
However, this moves the cursor out and into the next field/control/text box.
Normally this would be OK as an alternative to tabbing into the next input
area, but for these text boxes I need to constrain it so that it stays within...
|
5 |
28.09.2006 19:12:09 |
|
|
Access Forms
Hi, all I am fairly new to manipulating forms in access. First I need
to get
the database to have unique records. So I followed the instructions
for
creating a query and trying to append records to a new database. Here
I am stuck I can't append records to the new database. Can anybody
help help ????
Cause then I need to do a form off this database and have a subform
display required...
|
2 |
28.09.2006 18:40:39 |