|
Yet another "no current record" problem
I have a form with 4 unbound text boxes and a button. The RecordSource for
the form uses values in the text boxes. When I open the form, all is fine.
No rows show because the criteria are all null and there are no rows in the
database that match that situation (at least I assume that's why no rows
show up.) I set "No Additions" to True in my code, so no empty row shows up
either. Once...
|
1 |
21.08.2006 16:55:06 |
|
|
default value
Is there a way to make the default value of something 1 greater than
the last value of that column in the table. For example, that last
"OrderNo" is 208, is there a way to make the next time I enter an order
it automatically defaults the "OrderNo" column as 209?
Thanks!
...
|
3 |
21.08.2006 16:37:01 |
|
|
Adding a column to a database
I'm having trouble adding a column to my database. I have tried the help
option in Access, but it doesn't give me the option to insert column. Can
someone please help?...
|
3 |
21.08.2006 14:51:31 |
|
|
find not finding records
Hello,
I was asked to look into a problem with the access find box not finding
some records, when searching thru records via a form. The "missing"
record could be found if the partial name and wildcard * was used. I
checked the actual record and could find no leading or trailing
characters. It's only "sometimes" this happens, and the records which
are not found appears to be totally ...
|
6 |
21.08.2006 11:22:34 |
|
|
Access 2003 ActiveX component can't create object
When trying to construct a lookup table in access, I get the following
message "ActiveX component can't create object"
After doing some investigating, I learned that by default the
"Microsoft ActiveX Date Objects 2.1 or 2.5 Library" should be
referenced when opening a data base. I checked to see if it was
referenced by clicking references in Tools Visual Basic Editor and
found that not onl...
|
2 |
21.08.2006 06:19:48 |
|
|
newbie question about E-mail
I'm trying to convert an old booking system to Access for Children's Theatre
of Charlotte's school performances (professional productions for youth).
Tables will (should?) include Schools (i.e. customers), ShowTitles (i.e.
catagories), PerformanceDateTimes (i.e. products), Contacts (multiple people
book from the same school), Bookings (i.e. orders) ... if we have e-mail
addresses as a fi...
|
4 |
21.08.2006 06:17:46 |
|
|
Baseball Database
Hello All,
I am having a terrible time with trying to make a baseball database which
tracks Teams, Games, Rosters and Stats.
My biggest problem is designing the schedule/games and stats part.
I have a tables like the following:
Teams
Rosters
rosterid
teamid
playerid
Last....
Schedules
scheduleid
teamid
Homegame (Y/N)
Opponet
Date, time, etc
GameStats
statsi...
|
1 |
21.08.2006 05:41:01 |
|
|
Query not updateable in Access 2000
G'day,
I have a task which has been giving me grief; specifically, Access
would hang when I was trying to add or remove records from a subform
when using an SQL update query. Subsequent research and investigation
has revealed that the query forming the RecordSource for the subform is
not updateable - I'm hoping some kind soul can tell me why.
What I am trying to achieve is to have a form...
|
2 |
21.08.2006 01:30:10 |
|
|
Strange Update Query Problem in Access 2000
G'day,
I am experiencing a problem where the Access application hangs after an
update query that I am performing via code.
I have a form with two subforms; one subform lists the courses that
form part of the package students will take, the other subform lists
the courses available for that package based on the department offering
the package.
What I want to do is have buttons on each ...
|
4 |
21.08.2006 00:45:49 |
|
|
Adding only new records from another database
I have created a customers table that feeds from another Acesss database's
customer list table.
The other database is constantly being updated -new records (customers) are
added daily.
I need to periodically scan this "foreign" database and add only new
records to my own database (to keep the two tables synchronized in some
fields only).
How can it be done?
Thanks!...
|
5 |
20.08.2006 15:50:02 |
|
|
Report Views...
When you open a form, how do you set it to automatically bring up a report
centered in a full page, with 150% Zoom? I use Access 2000.
Thanks!...
|
9 |
20.08.2006 14:01:01 |
|
|
x and y axis graph on graph paper in excel
I need help figuring out how to draw an x and y axis graph, on graph paper in
Excell. Please.
...
|
2 |
19.08.2006 22:20:33 |
|
|
Find problem found - why happening?
Hello,
Thanks to those who offered advice in previous "find not finding records"
post, as you set me on the right track to start resolving the problem.
I did find the culprit - about 200 records out of the 8000 in the db have a
"chr(10)" attached to the end of the data, in the field that the find is
being executed on.
These records are both old and new, were not imported, entered by vario...
|
5 |
19.08.2006 04:48:21 |
|
|
I need help!
I've posted my cry of help before with my old database, and it doesn't seem
like nothing I did was working, so I've decided to scrap it and start from
scratch. But, I need help with creating my tables so I can do what I need it
to do. Any ideas will help. This is what the database is supposed to
contain:
Taxpayer Info
Delinquent Accounts (one Taxpayer can have multiple accounts)
Pa...
|
3 |
18.08.2006 22:26:01 |
|
|
Grouping & Counting on a Field
Hello,
I've created a query that list all Access Reports that were written for
various departments. The query works fine but is displaying duplicate
department names (one display for each Access Report written for that
department).
I'd like to display the results (w/o duplicate department names) in an
Access Report as follows:
DEPARTMENT NUMBER OF REPORTS WRITTEN
HR ...
|
9 |
18.08.2006 20:38:01 |
|
|
Re: how do I search for a specific name in Excel spreadsheet?
Use CNRL F
...
|
1 |
18.08.2006 19:48:08 |
|
|
help with syntax
I have this expression:
DateDiff("d",[InvoiceDate],Now())
I want to modify it to pull InvoiceDate from a specific
table ECNCMaster. I can't seem to figure out the bracketing.
Could someone give me a hand with syntax?
gls858...
|
5 |
18.08.2006 18:35:49 |
|
|
create booklet printed on both sides 8.5 X14
I need to prepare a numbered 10 page booklet on a 8.5X14 sheet printed on
both sides...
|
3 |
18.08.2006 17:37:56 |
|
|
how do I search for a specific name in Excel spreadsheet?
I want to search for a name in a simple spreadsheet. I don't understand the
Lookup function and don't think the "Go to" function works either. Any
suggestions?...
|
2 |
18.08.2006 17:19:52 |
|
|
need help with opening excel automatically
i have a command button that transfer an access form to a specific excel
file, and i'd like to have it so that once that button's clicked, the data is
transferred, and that excel file where it was saved, would pop up....
I've done a search here, and i've seen answers relating to hyperlinks, shell
codes....and most of these answers are like Greek to me (can you tell i'm a
beginner??!!)
...
|
4 |
18.08.2006 16:58:01 |
|
|
How many Tables
I am building a database for employee performance reviews.
The review on paper has 10 catagories with questions under each catagory
that are rated with a 1- 4 rating system.
My question is do I make a tables as follows?
Employees Table
Name
Hire Date
..and so on.
Catagory 1 Table
Catagory1 question 1
Catagory1 question 2
...and so on
Ca...
|
13 |
18.08.2006 16:47:07 |
|
|
Reminders
Hi I need to set up part of my db to be able to give the user the facility
to enter notes and then be reminded that action is required on a certain
date related to the notes (The notes would have to be linked to the
CustomerID). Each user would get there own reminders but I would like it
set up so that the notes can be seen by anyone who wanted to check them as
and when needed. Has any...
|
1 |
18.08.2006 15:16:51 |
|
|
Disappearing Act
Hi,
When I start Access the Assistant paper clip is present, but after a while
it just disappears and I get a pop-up that I need to install a character....
|
1 |
18.08.2006 12:35:02 |
|
|
Love Hotline
Lady only 24-Hrs +91 9810577227
...
|
1 |
18.08.2006 02:05:08 |
|
|
group by date to create daily invoice totals
I have created a query that includes dates and daily invoice amounts. Each
date has more than one invoice entry. I need to create in my query a column
that will combine invoice totals for each day....
|
2 |
17.08.2006 18:03:29 |