|
Creating table of contents when headings are in a table
I have a large table (spanning 20+ pages) in which I have headings within the
table. I would like to show tHese heading in my table of contents. Is this
possible?...
|
2 |
24.07.2006 12:27:41 |
|
|
How canI send message to a group each one see himself only in to:
Thanksfor your help...
|
2 |
24.07.2006 12:26:39 |
|
|
Form, parameter query problem
I have a form that runs a parameter query which brings up the
parameter value box in which I must enter -1 or 0 then shows the
records matching exactly what I requested.
BUT
What I would like is to have a form come up with two text boxes (first
and last names) and 5 checkmark boxes (maybe more later) So that I
could enter a name and/or mark the checkboxes. If I mark two boxes I
would like...
|
2 |
24.07.2006 07:33:02 |
|
|
Assigning a Value from a from --- with query?
How would you insert the result from a query and assign it to a value in a
form (and table). The two inputs from the form are pricing and product which
are established in the form. The query then assigns a unitprice based on the
2 form inputs and stores it as a value in table: order.unitprice.
I previously tried using an IIF statement in the form text block with
=IIF.... as the contro...
|
2 |
24.07.2006 07:30:01 |
|
|
date/time 24 hour
I figured it out, but I cannot get it to do 24 hour time.
I have 99/99/0000\ 00:00;0;_;;
example of what I need: 7/23/2006 20:32
not: 7/23/2006 8:32 PM
Thx
...
|
2 |
24.07.2006 07:26:01 |
|
|
database for my movies- question about filtering
I am curious how I would do this. If I make a number of fields where I can
put in actors/actresses. I could have up to 10 for just this type, or do I
make one field for this and put in all ten names? If I have 10 different how
do I then filter since I want to search for say all movies with tom cruise
but he may be listed in any one of those 10 fields?
I hope this makes sense......
thanks...
|
5 |
24.07.2006 05:55:25 |
|
|
What is the best way to start a new database in Access?
I am a Paralegal and I need to start a database of my Attorney's Clients. How
do I get started?...
|
2 |
24.07.2006 03:48:15 |
|
|
i simply want to put an X in a box and change it if needed
word 2000 is ther version i am using. I believe it is a check in (in a
square box)
I used it before it allow a person to swith between check and not checked
options....
|
2 |
24.07.2006 00:29:26 |
|
|
Including 2 or more fields in X axis of a chart
Hi,
I have 2 fields, derived from a query, called Suburb and StreetName
respectively, and a 3rd called Count, also from the same query.
I want to include the 1st two in the X axis category and the 3rd (Count) as
the Y axis. I know I will have to reduce font etc to make them fit, but its
sort of essential that the suburb be included with each entry of the
StreetName. I don't want the ei...
|
1 |
24.07.2006 00:00:02 |
|
|
Help with multiple Dcount condition
Hi everybody,
as a change I am stuck with some code and I cannot make a Dcount
function work.
I have my Table with Customers (Tbl_Customers)
CustomerID. (text)
Name
Company
etc.
Then I have another Table with Orders by these Customers (Tbl_Orders)
CustomerID (Text)
OrderID (Text)
Cdxdix (text) which is some other data I have to insert about each
order. Many customers can have the...
|
3 |
23.07.2006 18:59:07 |
|
|
Dir function in Access 2003
I am converting a database from Access 97 to 2003, and cannot get the
DIR function to work.
Even creating a new database, with a single form, and one text box
=dir("C:\autoexec.bat")
doesn't work.
In all cases I get #Name? error.
What am I doing wrong?
Is this function disabled some where?
(Have checked security on help page - nothing disabled)
Help please....
|
7 |
23.07.2006 06:16:38 |
|
|
how to hide database behind
Is there any way to open a main menu form without showing the access window
behind it and make it appear as a standalone application? l only want the
main menu form to opened not display what is sitting inside and if there is
code which part l must write. l tried this at my properties form event onload
DoCmd.ShowToolbar"FormView"acToolbarNoStartup.
For details, l try to finish my assigme...
|
3 |
23.07.2006 05:57:01 |
|
|
how do I print a form without the command button showing on the pr
how do I print a form without the command button showing on the print...
|
3 |
23.07.2006 05:08:33 |
|
|
Linking files
NEWBIE!!!!
Is there anyway to link a file to one record in Access
also I would like to be able to browse for this file and then save it some
how in the database file, or a folder on my system
Any example would be GREAT
Thanks in advance
...
|
2 |
22.07.2006 23:08:11 |
|
|
Subform Display of Data Sheet View
I have a mainform which identifies a project. On a subform, I would like to
display a list of team members for that project displayed in data view. I
cannot keep the entire list accessible in the data view. If I enter a name,
it will be displayed. If i close the main form, and open it later, only a
blank new cell will be visible, and there is no way to scroll to view the
other names. Is ...
|
3 |
22.07.2006 19:16:01 |
|
|
Displaying Week Ending
Hi, This one has been bugging me
This is my query
SELECT DISTINCTROW Format$(TimeSheet.Date,'ww yyyy',4) AS [Week Ending],
TimeSheet.Employee, Sum(TimeSheet.Units) AS [Sum Of Units], Count(*) AS
[Count Of TimeSheet]
FROM Employees INNER JOIN TimeSheet ON Employees.EmployeeID = TimeSheet.
Employee
WHERE (((TimeSheet.Date)>=[forms]![Startup]![1sttsent] And (TimeSheet.Date)<=
[Forms]!...
|
3 |
22.07.2006 06:50:18 |
|
|
database website
Is there an easy way to use frontpage to convert MS access database. I
have mid size database that I would like to convert to a webbased. Is
there an easy way of doing it? (a third party software, using
frontpage or dreamweaver etc.) I would appriciate any comments.
Best regards.
...
|
4 |
22.07.2006 00:25:15 |
|
|
Adding a field to the field list
I created a table and the a report from that table and then was asked to add
another column/field to the table. Now I don't know how to get that field to
show up on the field list so that I can add it to the report. Can anyone
help.
...
|
2 |
21.07.2006 22:23:01 |
|
|
How do I split field
I have a field that contains a Qty and unit:
311 ea
12 ea
5 ea
....etc.
How can I return only the number and exclude the "ea". This field is
currently a text field and I have more than 3 milion records.
Can I split this field into 2 or at least just return the number in a query?
...
|
3 |
21.07.2006 22:00:01 |
|
|
linking or merging to Excel
I have a worksheet in Excel that has customer information including phone
number etc... I've imported it in to Access 2000. It imports the phone
number as a number field. I need it to be a text field to perform other
functions such as find unmatched. Iv'e tried changing the format in Excel
prior to importing but it still imports as a number. Is there a way to
change the field type with...
|
6 |
21.07.2006 20:54:27 |
|
|
TimeStamp not being captured consistently
I have a split dB rolled out within my POB. Areas of the business have their
own forms to input data which is then captured in a main table on the backend.
One of the data fields I am capturing is a time stamp by using Date(). Out of
about 100 users, about 10-15% do not populate the backend table with the
timestamp. Their PC clocks are enabled and functioning correctly. Would
anyone know why ...
|
3 |
21.07.2006 19:04:02 |
|
|
Clear Database and Reset the AutoNumber
Good Morning Everyone,
I'm making a database and I'm playing with it using test data. When
I want to put the actual data in, how do I reset the autonumber back to
1? How do I tell the database to completely delete the fake records so
the autonumber doesn't start at, o, 50?
Thanks!
Jillian
...
|
6 |
21.07.2006 19:03:03 |
|
|
Query matching Different Dates??
I have 2 tables with date fields, table1 is titled Date and table2 is titled
DocDate.
I need to extract data where:
[table1].[Date] is one day prior than [table2].[DocDate]
In other words, let's say table 2 date of 07/10/2006 must look at table
one's records with a date of 07/09/2006
There are many other fields in my query, but the results need to be built
around this criteria. ...
|
3 |
21.07.2006 15:32:02 |
|
|
Microsoft Jet Engine Error Message
Hello,
I built a purchase order form from a query in order to autofill information
such as Employee for who completed the purchase order, Ship to and Vendor
information from combo boxes. It works, but until you select select from the
combo boxes first on the form I keep getting the same error message:
Microsoft Jet Database engine cannot find a record in the table "Vendors"
with k...
|
3 |
21.07.2006 14:56:01 |
|
|
Duplicate Data from one table into another
Hi there
I'm creating a database to help a friend with his courier business and
running into a few problems.
I have 3 tables: Customers, Services, Customer Rates
Most Customers use all the services offered and each customer has a unique
pricing structure.
Here's what i want to do:
When I enter a new customer in the Customers table(using a form), I want the
customer Rates to be updat...
|
4 |
21.07.2006 13:30:19 |