|
automatically fill in complete name
I want to have Access auto fill in the complete city name when I begin to
type in the first few letters of the name...
|
10 |
06.09.2006 17:25:22 |
|
|
Cursor/page movement
Working in a database section, my cursor automatically highlights the first
item. That is fine until I scroll thru all my records and my page keeps
jumping back to wherever the cursor is positioned. I can scroll halfway
down, left click to move the cursor to that field, then scroll down further
and the page jumps back to where my mouse was placed with the left click. I
can't leave th...
|
1 |
06.09.2006 16:18:01 |
|
|
Controlling data entry based on Option selected
I am working on a database for tracking customer issues. I have had one (1)
very basic Access 2003 class... And I am a blonde (handy excuse...) so I
need lots of help. Here is a basic breakdown:
I have a form based on a table that has several option groups. Each of the
groups follows this format:
OptionGroup1: Customer Notified of Immediate CA? (yes/no)
OptionGroup2: Customer N...
|
16 |
06.09.2006 11:11:07 |
|
|
Calculations
I am trying to learn how to do some calulations with my data.
Say I have 2 tables:
Total Orders
Total Hours
Each table's Primary key is a date.
The 2 tables are linked by the date.
Orders Table has these Feilds
Date
Today's Orders
Orders left from Yeasterday
Orders from Previous days
Hours Table has these fields
Date
Total Hours
Calculations i need to build example:
1st Cal...
|
9 |
06.09.2006 08:01:02 |
|
|
Help with Relationships
Please someone help.
I have looked all through these discussions to find a version of my
scenario, but have not been able too. I am using Access 2003.
I am creating a database for a finance company who deal with Mortgages.
I have created the following tables: Contacts, Property, Mortgage, Mortgage
Company, Buildings & Contents, Life Ins, ASU, Investments and Others.
I want to create one fo...
|
6 |
06.09.2006 03:13:21 |
|
|
Cannot save record.
I have an autolook up query that automatically fills data in on a form. The
primary key is the phone number. It works fine when I it finds a matching
key. If it doesn't find a matching key and I try to save the record I get the
following message. The Microsoft Jet database engine cannot find a record in
the table <name> with key matching field(s) <name>. (Error 3101). I
under...
|
1 |
06.09.2006 02:08:01 |
|
|
Forms
Hello, I have been working with an existing Access Table and Queries that
were completely set up by someone else.... I have learned to run queries with
out any problems. Now I have been asked to design Forms with a new data base
and new data. My question is? What is the easiest way to build Forms so that
others may enter data into the same data base? The Tables to the new data
base have...
|
2 |
05.09.2006 19:16:48 |
|
|
Writing Expressions in Access
This is a simple expression, I just am having issues today. I am trying to
write an expression that show the difference between 2 fields and if the
second field is 0 then no total would display....
|
8 |
05.09.2006 16:13:11 |
|
|
save record in continuous subform before opening child form
I have a Household form that has a continuous subform for all the People that
reside in that household. The continuous subform has a command button that
opens a "child"form where the user can add additional details for that person
(add to their history, etc.)
This works well except when a new person is added to continuous subform,
when the command button is selected, the data added to ...
|
3 |
05.09.2006 15:46:15 |
|
|
thank you for your help
l would like to give a hand and a great thank to Mr.Duanne Hookam,
Mr.Fredg,Mr Wayne - I-M ,John Vinson, Mr Ork and Mr Jeff Boyce( and also all
the for your help to finish my final project . l already submitted my
project and now waiting the result. l hope god will bless you .TQ ....
|
1 |
05.09.2006 13:43:01 |
|
|
Nested Subform???
Hi Again
I am using s tab page and i am having problems trying to display 2
different recrords on the same page.
I have a table which shows what type of services each of our two vehicles
has. One of them has one type and the other has three.
Is there anyway i can show the different types of services for the second
one on the same page?
I did try a query but it duplicated all the info fo...
|
3 |
05.09.2006 13:14:02 |
|
|
Dialog box for "search"
Is it possible to create a dialog box that allows the user to search one of
two parameters (name or document #)? If I am using a Menu created from
design view with control buttons, do I need to call the data screen prior to
opening the dialog box?...
|
7 |
05.09.2006 12:22:47 |
|
|
عب
ايه المهمه الى انتوا عاوزنى اعملها او بتأهلونى الايه والمخابرات اشمعنى
اختارتنى انا
...
|
1 |
05.09.2006 11:41:02 |
|
|
Printer problem
Hello, just recently i took over managemenet of a access 2002 database that
our company uses for printing different reports. My problem is that one of
the IT admins removed a printer from the network and this is causing some
problems for some users.
When they try to run a report they get a message saying something like.
Translated from norwegian :)
" This document was previously for...
|
2 |
05.09.2006 11:34:32 |
|
|
lost password
I am using access 2000. I can get into access, but i cannot access my files
as they are password protected and i have lost the password. The user comes
up as "admin " by default. if someone could help me i would be very grateful.
thanks...
|
4 |
05.09.2006 10:01:02 |
|
|
I Cannot Delete a Record with a Subrecord
Can anyone please help me? I am a greeny Database developer. I created a
delete button using the button wizard but when I click on it I get the
following message "The Record cannot be deleted because table ‘tblCLines’
includes related records.cannot delete a record." I have eight other sub
forms and they all delete the reodrds fine. But this fsubCLines does not
delete the record. Any...
|
2 |
05.09.2006 04:46:51 |
|
|
form wizard not show available fileds
In access 2003 form wizard not show available fields. What can I do. This
problem appear for all databases....
|
2 |
04.09.2006 22:31:02 |
|
|
database too big!
I've been creating a new database to transfer our approx 12000 record db
into. The old db has a record for each person, and we get a lot of families,
so the new database has a record per address, and a separate table that
tracks the people and associates them to an address in the main table.
I started transferring everything today, and went to finish up, and noticed
my new database is ...
|
6 |
04.09.2006 19:49:16 |
|
|
Browse puts records in wrong order
Hello,
I am using the following to go from my menu form to the form where you
can browse and update students' records.
Private Sub Browse_Students_Click()
On Error GoTo Browse_Students_Click_Err
DoCmd.OpenForm "Students", acNormal, "", "", , acNormal
DoCmd.Maximize
DoCmd.GoToRecord acForm, "Students", acFirst
Browse_Students_Click_Exit:
Exit Sub
I hate ...
|
5 |
04.09.2006 19:46:36 |
|
|
Add Record command button & cursor
Hi,
I used the built-in "Add Record" command button on my form. It works
fine except that when I click it and the empty form comes up for typing in
the new information, my cursor is not positioned at the first field. My tab
order is set correctly, and the cursor always goes to the right field for
other actions. It just does not work for the "Add Record" button. How can
I get t...
|
3 |
04.09.2006 18:10:37 |
|
|
Setting the Record Focus...
When I open my forms the wrong record is highlighted. How do I set the focus
on to another particular record, so the form opens focused on that new
record?
Thanks!...
|
2 |
04.09.2006 17:59:02 |
|
|
Bookmarks
Help please. Maybe I just dont undererstand Bookkmarks but I want to find a
record in my table and have the Form's bound textboxes display the
appropriate information. Easy, you might say just use the following
rs1.move 246
me.bookmark = rs1.bookmark
and the appropriate listboxes in the form will show the data that is held in
record no 256 in the Table. I have done this and it works f...
|
15 |
04.09.2006 14:57:02 |
|
|
Single Front End with split back ends
My application contains a lot of rules defined logic, the logic being held
in tables.
It makes sense for me to keep the rules tables in a seperate mdb from the
actual data. I am hoping that during the life of the system any upgrades
will result in changes to the rules tables rather than changes to the data.
This means that - hopefully - the majority of changes will just suppling
new ...
|
4 |
04.09.2006 11:51:49 |
|
|
Resizing form?
Hi! When I open my database, the menu form comes up, and it is just the
right size. However, the menu takes you to the data entry form which should
cover the entire screen. I want it to come up maximized, however I have not
been able to make it happen. Resizing it and then saving the database does
nothing. Any ideas? THANKS!
Mommio2
...
|
2 |
03.09.2006 22:40:02 |
|
|
SendObject w/ field from form
My form has an Email button which runs a macro which SendObject's a report.
I want my Subject line to be a table field from my report. Is that possible
using my Macro? If not, is it possible using code? I have minimal
experience (at best) writing code. If it's possible using code, could
someone give me a hint on where to start? Thx, DJ
...
|
2 |
03.09.2006 20:56:01 |