|
Cannot Lock Table Access 2003
In the AfterUpdate event on a Combo Box (data from tblName) I have:
DoCmd.OpenQuery "qryName"
The error I get is something like:
"Can not lock on tblName. Someone/another process is using it..."
The query (only table is tblName) is Make Table .
How do I prevent error message from appearing?
Thanks....
|
2 |
24.09.2006 01:15:45 |
|
|
Can I have multiple records (same table) open simultaneously in 1
...
|
3 |
23.09.2006 23:16:16 |
|
|
access 2003
how do i design an access database table for compiling all the laws to help
prepare me for taking a bar examination?...
|
1 |
23.09.2006 23:01:02 |
|
|
First value in listbox as default
How to set first value in listbox as default value?
Thanks!...
|
2 |
23.09.2006 20:19:13 |
|
|
Normalizing tables
I have read countless threads and reviewed material on MS website regarding
normilization,but it seems the more I read the farther I am away from
understanding how it works. I have 5 tables (Consultants, Clients, Family,
Friends, Professional) containing basic contact information (name, address,
city, st, zip, etc) plus information specific to the contact (birthdate,
relationship type, spous...
|
2 |
23.09.2006 19:02:35 |
|
|
I can't add a new record in a form. How Do I?
I have set up a form in access 2003 to manage my sheep, but once i have added
the information to the 1st record I am unable to add a new record. I have
tried adding a new record with any information in it but it still does not
work. I am aware you can create a table and use that to create your form, but
i dont want to do that because 1 record contains simmiliar information about
the shee...
|
2 |
23.09.2006 18:18:20 |
|
|
Database shutdown
I just click on any of the field in subform.It gives that error and the
database is shutdown
Microsoft Access and windows has encountered a problem and needs to
close.We are sorry for the invonvenience. I did
following things but its a same problem.
1.I run Tools-Repair database but same problem.
2. Copy all files to a new databse but it wont work.
3. Copy whole form as a text file an...
|
5 |
23.09.2006 14:40:00 |
|
|
Hide a data input line in a form until check box selected
I am new to MS Access and databases in general, so please forgive my
ignorance on what is probably a very simple question. I would like to create
a yes/no checkbox on a form that will once validated, show a field to allow
data to be input. If the field is unchecked, the user will not see the field
to enter data, Please advice.
John
...
|
9 |
23.09.2006 14:36:39 |
|
|
Repost for cell not visible
I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In th...
|
4 |
23.09.2006 13:35:43 |
|
|
Legal Secretary resume
I will be migrating to Canada soon. Presently I am working as a Legal
secretary in an International Bank. I need a make an professional resume to
apply for jobs in Canada. I have total 10 years of experience working in a
Bank as a secretary....
|
2 |
23.09.2006 12:12:32 |
|
|
Button images
Hi.
Is possible to add a image and text in the same button?
Thank you.
Acores...
|
3 |
23.09.2006 07:58:01 |
|
|
Dropdown Select Problem
On my Main Menu I have a dropdown list from a Combo Box (cbFinishHorse),
that shows me Horses that are in Finished Status. I am trying to write the
code for AfterUpdate. So as when I click the name of the horse his form
Record appears.
This is the Row Sourse:
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS
Name, [StableReturnDate] FROM tblHorseInfo WHERE Sta...
|
3 |
23.09.2006 02:11:11 |
|
|
passwords to restrict access to records
I am fairly new to access (4 weeks) and am building a customer database. I
have one main form with several tabs and subforms on it. Currently when the
database is opened they enter their name, press a button which takes them to
a switchboard from which they search for customers based on criteria (i.e.
Name, phone number, contact, etc.)
The main table, tblCustomers, has a field, Employe...
|
2 |
23.09.2006 01:57:24 |
|
|
Date Calculation from two forms
I have the date of birth on one form and the referral date on another. On
the form with the referral date, I want to calculate age at time of referral.
Here's the expression I've tried in various places (in a SetValue macro,
unbound control).
DateDiff("yyyy",Forms![frmReferrals_Main]![DateofBirth],Forms![frmReferrals_Source]![ReferralDate])+Int(Format(Forms![frmlReferrals_Source]![...
|
2 |
22.09.2006 21:54:45 |
|
|
Word merge pulls from wrong table column
Albert Kallal's WordMerge is working very nicely now but I have a problem
with one mergefield:
I have an Employees table and a field on the form with a dropdown and that
enables the relevant name to be displayed.
I have set the template mergefield to be the EmployeeName, which is stored
in full in one of the table columns. However, when I do the merge, I get the
ID number from the Employ...
|
3 |
22.09.2006 21:32:01 |
|
|
make a Field returnsu foriegn key value, not foriegn key id
Good day,
What I want to do is a little bit more complicated than the title.
I have a form that has an embedded sub form. I use a drop down in the
form to affect the values in the sub form. This works fine, however my
problem is that some fields which are foriegn keys, return the exact
field value (which i dont want). How can I change this so that when I
change the drop down in the form,...
|
3 |
22.09.2006 21:23:49 |
|
|
Can I prevent free text entry in combo boxes (in forms)
Hello all
Is there a way I can prevent free text entry in a combo box without
having to change it to a list box? I don't know VB and have searched
the help files and the Access Bible with no luck, so I'm thinking this
is not possible.
I have a form with a combo box for selecting a location, run off a
simple query. I don't want anyone being able to type in anything other
than what's in...
|
3 |
22.09.2006 21:21:35 |
|
|
Setting default value
I am trying to set the default value of an unbound text box using a macro.
In the AfterUpdate property in the combo box I've added this macro using
SetValue:
Item: [Forms]![frmReferrals_Main]![RefNote]
Expression: IIf([Forms]![frmReferrals_Main]![Status]="Admitted","See active
residents files for more information","See Referrals tab for more
information")
The problem is that a select...
|
3 |
22.09.2006 20:41:02 |
|
|
Designating one record as the primary one
I'm not sure in which group I should post this, and I had a hard time coming
up with a descriptive subject line. I have asked about this topic before,
and thought I had come up with a solution, but it seems not.
Here is the situation. I have a Contacts table and a related PhoneNumber
table (Contact ID is the PK/FK). The phone numbers are displayed on a form
in a list box (lstPhone), ...
|
12 |
22.09.2006 20:03:09 |
|
|
PLEASE HELP.....List Box Search Form
I have used a sample listbox search form from another database that will
allow you to type and it automatically start listing records that correspond
to that particular letter or letters.
My problem is this...Once I click my record search button the search form
open as it should, but when I type in the text field nothing happens. WHAT AM
I DOING WRONG??? My code for the text field(search f...
|
2 |
22.09.2006 19:48:02 |
|
|
application color
what sequence of numbers will give me the back ground color of Access 2003
Application Background.
I have a form with no borders and i want it to belnd in with the background.
I already found "Set a color property to a system color" in the help file,
but none of those colors give me what i need.
...
|
2 |
22.09.2006 19:42:02 |
|
|
Items showing on additional tabs
I have created a form with multiple tabs. A few of the items from my first
tab are also showing on any additional tabs. Most of the items are correctly
only showing on the first tab. I cannot find the control to "assign" the
text box etc. to tab 1.
Any help would be apprecaited...
|
4 |
22.09.2006 19:33:54 |
|
|
Child and Parent field links
Hello!
I have three forms....One main form with information and a choice of
Yes/No. When Yes is selected a form pops up for data entry. When No
is selected a different form pops up for data entry. The problem is
that there is no link to the parent form so the data entered is not
going to the tables. I would like to link the child and parent fields
of the forms for data input but am not ...
|
2 |
22.09.2006 19:25:05 |
|
|
Record Locking
I'm using an Access database fe which is linked to a Sql Server be containing
all the tables.
In the Advanced Options, I set the Default Record Locking to Edited Record.
On the Form I set the Record Locks property to Edited Record. However,
multiple users can still open up the form with the same record on it and edit
it simultaneously. How can I stop multiple users from opening up th...
|
1 |
22.09.2006 19:11:01 |
|
|
Want notification when duplicate value for field is entered
Greetings, thanks for assisting a newbie trying to stay afloat.
I'm designing a form that would notify the data enterer when a duplicate
value is entered into a particualr field. This field identifies a specific
production run of our product and we want to be notified witha pop-up box
when duplicate comments are made about the same production run for our QA
team.
Most duplication fe...
|
2 |
22.09.2006 17:46:01 |