|
relationships
How do I set up these relationships? I think I have most of them but...
I need several different reports using some of the same information, but
only one record at a time. I have six tables
In order to get a query to limit the records I need to see essentially all
the tables, which means I need the relationships to work with the tables.
The needed tables as I see it are as follows:
...
|
2 |
12/31/2008 3:18:00 PM |
|
|
ts_Open_Very_Slowly
At work, about 1 month ago, I received a new Dell Precision (2.66GHz with 2GB
RAM).
Included in this purchase was Microsoft Access 2007.
Here is the information on the “About†page…
Microsoft Office Access 2007 (12.0.6211.1000) SP1 MSO (12.0.6320.5000)
The installation of Access went fine. The product works great with one
exception.
Opening up a small test report that is obtain...
|
1 |
12/31/2008 2:55:01 PM |
|
|
Print preview last page..
I would like to preview the last page im my report:
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
Dim stDocName As String
stDocName = "rptScanlog"
DoCmd.OpenReport stDocName, acPreview
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click
End Sub
Thanks and happy new year to ...
|
2 |
12/31/2008 10:10:01 AM |
|
|
Total Monthly Average box
I am using the following formula in a query to give a percentage of column B
as a whole of column A:
ItoT:
Format(Round(Sum([Weekly_Data_Query]![Tours])/Sum([Weekly_Data_Query]![Inquiries]),2),"Percent")
It seems to look okay in a report give 20 different customer rows, but I
want to have an average of all customers at the end of each month on the
report.
What kind of box and form...
|
2 |
12/31/2008 4:33:00 AM |
|
|
Splitted DB Front-End issue (error 3048)
Conceited and fully happy with myself I've just finished my first Access
project. Since I'm a rookie, I suspect my work is not over-loaded with
bombastic VBA modules and elaborate functions (comparing to what I've seen in
some DB I've downloaded for learning purposes). Some couple of dozens of
tables (mostly with a very few fields), about the same amount of queries most
of wich serve as ...
|
1 |
12/31/2008 3:16:00 AM |
|
|
How to transfer Contact from Yahoo to Hot mail
I'm trying to move my contacts from Yahoo to Hot mail can anyone tell me if
this can be done and how?
Thanks...
|
2 |
12/31/2008 12:26:07 AM |
|
|
Lookup with loop
I am a novice in programing with MS Access and all db's consist of only of
simple queries, make tables, and procedures. Below is my objective. Is this
possible without using VB? If not, would someone direct me to a useful
site/post that would get me started. Many thanks!
Table:
Employee Mgr Initials
---------- -------------
AAA XYZ
BBB XYZ
CCC ...
|
4 |
12/30/2008 7:08:00 PM |
|
|
mail merge database
Hi
I want to make a database for a group of volunteers to use for mailings.
Store names and addresses and a few other details
add and delete members using a form
click a button to run a label mail merge from a table
ditto from a query
I can do these things independently but find the mail label report can't
generate the labels from the label wizard Avery A4 size -is there a
workaround fo...
|
2 |
12/30/2008 5:52:52 PM |
|
|
office assistant
I have been looking to activate the office assistant on word. could someone
please help with this request.
...
|
3 |
12/30/2008 5:18:08 PM |
|
|
Modifying Delete Button code
In my form I have Delete Button coded by the wizard with some modification as
follows:
Private Sub btnDeleteAsset_Click()
On Error GoTo Err_btnDeleteAsset_Click
If MsgBox("Are You sure You want to delete this asset?", _
vbYesNo + vbExclamation, "Attention!") = vbNo Then
Me.Undo
Cancel = True
Else
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd...
|
13 |
12/30/2008 12:11:01 PM |
|
|
Round percentages in queries
How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get
99% instead of 98.64%?
--
Tyler at Creme
New Access User...
|
2 |
12/30/2008 12:23:46 AM |
|
|
navigation pane as menu in accde
hi,
i try to build a small application using access 2007 as client and for now i
use navigation pane as menu system; i create some items and groups and a set
of macros who hide all unnecessary items and groups for each user (user role
exactly); work fine for now but i don't know what is happened in accde? still
work or is just a bad idea?
thanks in advance
...
|
1 |
12/29/2008 10:45:28 PM |
|
|
Trap error in Combo Box
Can anyone help please?
I use a Combo Box as a "Find Box" to list all available (non duplicated)
entries in a table. Great, but I also want the user to input the name that
they want to find and if the name is not in the Table, I want to trap out the
error (The Item does not exist in the List) and tell the user that the name
does not exist in the Table giving them the option "Do you want ...
|
4 |
12/29/2008 10:18:04 PM |
|
|
Changing an unput mask
I want to change the way a date is entered in my database from MM/DD/YYYY to
MM/YY, how am I supposed to do that?...
|
3 |
12/29/2008 8:53:33 PM |
|
|
Access 2007 query
Hello if there is help at hand , I am quite new to this.. I have forms, and
tables created with 70 employees that have up to 21 different training
certifications held that all differ in dates of expiry, trying to produce one
report for all that shows each persons certification held and when due for
expiry. what is the best way for me to do this. thanks...
|
8 |
12/29/2008 4:29:39 AM |
|
|
Search question
Every day when I start Access, the first time I search a table (or
query) with ctrl-f it wants to search for the exact text and 'as formatted'.
I have to un-select both options.
Is there a way to have it save the settings?
TIA
Rich W....
|
7 |
12/28/2008 4:50:06 PM |
|
|
New acces user
Help please newbie to this ..I have set up a table & form within access
Trying to produce a report that shows up to 70 employees that are assigned
up to 21 different training certificates with expiry date.
How do i produce a query that shows all employees and training certs that
may be due for re-training within 3 months ? I would like this to show on 1
report. Thanks...
|
8 |
12/28/2008 4:22:53 AM |
|
|
changing value of cells
how do i replace the text in multiple cells to read the same as the text in
other cells of the same value?
if the text in cell d reads XXX and the text in cell f reads yyy, how do I
change the text in only those f cells that read yyy to read the same as the
text in only those d cells that read xxx? there are thousands of these f
cells that need to be updated....
|
2 |
12/27/2008 1:05:06 PM |
|
|
REQUEST
DEAR SIR
I am a student of III year And Iam Intrested in Communaction&Computer But I
Dont Have Money did you help me learn about computer programimg and other
computer software in hindi language it is because my english is week
I hope you are thinks about me
Thanks & Regards Nitin Chandravanshi...
|
2 |
12/27/2008 4:04:04 AM |
|
|
Performing subtraction on 2 fields to fill another
I am so frustrate with Access. This is so simple in Lotus Approach. Any one
help me? I have 2 date fields and I want to calculate the number of days and
have the result appear in a 3rd field. The expression builder is not showing
the tables in my DB, and so I cannot use that method! Why doesn't Mocrosoft
just add a calculated field like Approach has!...
|
6 |
12/26/2008 6:17:20 PM |
|
|
Sequential Numbers in Reports
Sequential Numbers in Reports.
I have a report that runs showing visitors to our building.
I would like to add a sequential number to each record of the report
starting at 1001
I have added an unbound text box to the report and set the properties as
follows:
Data Tab,
Control Source =1
Running Sum - Over all
This numbers the first record as 1 the second as 2 and so on.
Is there...
|
2 |
12/26/2008 5:02:01 PM |
|
|
Conditional formatting
On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)
Thank you all
Bre-x
...
|
6 |
12/26/2008 1:36:07 PM |
|
|
Hyperlinks
I'm not sure if I've understood this right or if I'm just doing something
wrong - maybe someone can help me?
I think it should be possible to have a field of the data type hyperlink and
to link to a document (PDF for example) on my hard drive and by clicking
that hyperlink to have the document open?
Well if that is the case it's not working for me and yet it seems like it
should be s...
|
13 |
12/25/2008 9:02:36 PM |
|
|
not wanting this program
T0 Whom Who Runs This Program, please note I DO NOT WANT THIS PROGRAM how
please do I get it off my computer.
...
|
4 |
12/25/2008 8:01:59 PM |
|
|
ırsız_karakter_gırısı
sql ile access veri tabanına sınırsız karakter gırısı...
|
1 |
12/25/2008 5:30:03 PM |