|
How can I get a field to auto-fill based on another field?
I have a form in which I enter consumer information. My co-workers would
like it if when they enter a zip code it automatically fills in a region
letter (i.e. zip code =19111, region=A, zip code=19149, region=B, and so
forth). Each region has about 10 zip codes assigned to it. Do I need to
create another table and/or subform, or can I just take care of this with an
event, code, or mac...
|
2 |
10.08.2006 16:10:23 |
|
|
Compact and Repair
I'm trying to compact and repair my database. I keep receiving the message
"TempMSysAccessObjects" already exists. How can I compact and repair if I
keep getting this message?
Thanks....
|
3 |
10.08.2006 16:05:02 |
|
|
Looking for an access template for teachers.
For an all encompasing data base where teachers can record and access all
class info. From attendance to grades to phone numbers...
|
2 |
10.08.2006 15:10:03 |
|
|
Can you have a field that holds "notes" on the account?
We are about to purchase Access for our office, but I first need to make
sure that along with all of the basic data, that it will also give us the
opportunity to make notes on client accounts. Is there a way to do this? ...
|
4 |
10.08.2006 14:49:32 |
|
|
multiple users
We recently moved an Access database file from a Win98 machine to our main
File Server (Windows 2000 Domain controller). When on the Win98 machine more
then one user could access the db at the same time. Now only one or two can
at the same time. Not always the same users can access it at the same time. I
tried it when I first moved the file to the DC and three or four could get on
but no...
|
4 |
10.08.2006 14:41:02 |
|
|
partial security
Is there any way i can make half the fields of a table read only but the
other half editable depending on the userl? if its the admin then the talbe
should be regularly editable.
thanks...
|
3 |
10.08.2006 13:50:01 |
|
|
order history database
we've been keeping track of up to 7 years of order history for about
6000 items in an excel spreadsheet, which as you can imagine is a
little clunky. the company finally sprang for microsoft access (don't
know why they didn't have it before) and now i need to figure out how
to import the excel spreadsheet into an access database in a way that
will be more useable.
currently the columns are...
|
4 |
10.08.2006 12:09:02 |
|
|
find by form button
I would like to make a button on a form just like the "find by form" button
on the toolbar at the top of the screen. Using the command button wizard,
you can choose the picture but it doesn't give you an option to create just a
simple "find by form" button. Is there a way to do this? ...
|
3 |
10.08.2006 12:08:02 |
|
|
template download
I seem to be blocked from downloading even with the pop up blocker off...
|
2 |
10.08.2006 03:23:26 |
|
|
Set start up folder in Access application?
I have two application, each in it's location.
As clients will run both, is there a way to set the default start-up thru
code as they open each application?
TIA.
...
|
3 |
09.08.2006 21:08:31 |
|
|
can't send and receive email problem satelit?
I have tryed to configure the email and set it up several times the pop is
incoming mail.hughes.net and outgoing is smtp.hughes.net it comes back with
an error message server is an error...
|
2 |
09.08.2006 20:59:20 |
|
|
Front End Corruption
I have a split DB that recently started corruping on the front end (it
happened twice). Will running an MDE resolve that issue? Thx, Dj...
|
2 |
09.08.2006 20:55:39 |
|
|
Record Find, First & Last
Help please
I am looking to find all the occurences in a table where one of the Fields
holds a "Serial Number" and another field holds the "Contract Number". The
Serial Numbers are unique and the Contract Numbers are the same. So, I want
to search through my Table, searching every record for a field that matches
my Contract Number Criterion and pick out the corresponding unique serial
n...
|
5 |
09.08.2006 18:56:42 |
|
|
setfocus doesnt work
I have this code on a text box control (tfind) How come the focus does not
go back to it? It goes to the next control
There is something wrong with my code, but i cannt see it.
Thnks
Private Sub tfind_LostFocus()
Dim sqlstring As String, mymsg As String
If IsNull(Me.tfind) = True Then
Exit Sub
End If
Me.Mainsub.SourceObject = "Blank"
sqlstring = "SELECT count(*) as CC FROM BKA...
|
3 |
09.08.2006 18:01:36 |
|
|
Guided creation
Goodmorning,
when use the guided creation of tables, query, and other appears an error
message that says the characteristic is not installed or something is not
activated.
Someone knows to give some council?
Thanks to all
Marco
...
|
2 |
09.08.2006 17:26:20 |
|
|
New record option is not enabled on form. What's wrong?
I just created my first form in Access. I entered test data and saved the
record. It will not allow me to add a new record. The properties and the
settings are enabled to add and edit data. I am sure it is something very
simple to fix. Are there any experienced users that can help?...
|
2 |
09.08.2006 16:43:33 |
|
|
calulation with acess
I'm making a reservation list with access. I need to be able to calulate the
price of there stay. Taxes etc. Will access let me do this? If it won't
what should I use and if it will can someone help me with this? Thanks for
all the help....
|
6 |
09.08.2006 15:51:03 |
|
|
Lookup Table Field Retrieval / Separating Databases
Hi, I'm new to the boards and also a fairly new Access user. I am building a
database that will be used to store process equipment information for clients
that we work with. I have come across two issues that I need advice on.
The first issue has to do with a Lookup table. I have read that lookup
tables are generally not the best practice to use, but I believe it would be
the best thing ...
|
2 |
09.08.2006 15:29:58 |
|
|
Totals problem with Report
Hi – I’m sure this is really simple but being a total newbie….
Have produced my first report, which breaks down different document types
within ‘batches’ of documents (each batch has a unique number). What I need
is to total up the number of individual batches & this is where the wheels
fall off…..
For example:-
Batch no 1 Doc type A
Batch no 1 Doc type B
Batch no 2 ...
|
2 |
09.08.2006 15:26:52 |
|
|
creating and relating tables
I'm fairly new to Access and would like some help with creating and relating
tables in my database. I'm creating a database with the following in mind:
I have a table with a bunch of securities in it and each security can have
an Issuer, Servicer, or SyntheticAssetCP or any combination thereof. Each
Issuer, Servicer, or SyntheticAssetCP can be rated by SP, Moodys or Fitch or
any combina...
|
4 |
09.08.2006 14:59:07 |
|
|
Querying the day of the week
nI want to query the day of the week (Monday, Tuesday..) for today's date and
then retireve the classes I teach from my table on that day of the week.
I have stored the day as Monday = 1, so Monday, period 1 is stored as 11,
Tuesday period 3 is stored as 23. Can anyone advise?
--
Bruce Rae...
|
3 |
09.08.2006 14:11:02 |
|
|
Specifing a single record for a report
I have a reprt that I will need run after every order that is entered and
will need to see just the information from that order. Is there a way that I
can either set up a button in the orders form I have created or to have a
data entery box when the report is opened asking for what order? Any and all
help is appreciated....
|
7 |
09.08.2006 11:39:36 |
|
|
New Database
Hi. I'm running into a bit of a problem here. This is going to be pretty
long to explain, so please bear with me.
I have a database that contains accounts, account owners, taxes owing, and
payments. I need a lot of help creating a report that is required by our
office. The report needs to show:
Date, Payment, FeesPaid, FeesOwing, DelinquentPenalty, and Balance.
The problem I'm r...
|
2 |
09.08.2006 06:54:47 |
|
|
Can't use second parameter in MsgBox
When I use MsgBox in my script, if I add the parameter for the type of box
in the second parameter, I get a syntax error. I choose the parameter from
the list of available ones that appears as soon as I enter the comma. So
I'm not mis-typing. I've tried this with several different button types -
vbOKCancel, vbCritical and others. The minute I choose the second
parameter, the statemen...
|
12 |
09.08.2006 01:51:36 |
|
|
How can I deal with footnotes in a report?
I am moving from Excel to Access and trying to figure out how I can deal with
footnotes. One idea I had was to make the footnotes a field in the table, and
display the footnote field in report's footer. I've tried doing this but do
not see my footnotes when I print. Any ideas what the problem is? Any other
suggestions to deal with footnotes?
...
|
4 |
08.08.2006 22:36:18 |