|
Disjoint and reflexive relationships in Access
Is it possible to implement a disjoint relationship w/total specialization in
Microsoft Access? When building the database in access do tables in disjoint
relationships need to be rolled up into the primary table? My final question
pertains to unary/reflexive relationships. If I do not have Micrsoft Access
Project, can I still map a reflexive relationship in regular access? Thanks
ever...
|
5 |
22.09.2006 13:13:39 |
|
|
Count Based on Multiple Columns
I am new to Access so this could probably be simple. I have an excel import
that contains three columns. The first is a customer name (this name could
repeat several times throughout the column, the second is the date (the date
or may not be the same for the customer entry), and a money amount (which
could be debits or credits.) I want to know if I can generate the count of
customers w...
|
2 |
22.09.2006 13:13:27 |
|
|
WANT TO SET UP OUTLOOK2003 AS MY MAIL MANAGER
I was using outlook express as my mail manager,but after formating I lost all
my previous letters in my in box,sent,and folders.My service provideris
IQARA.NET,now youtelecom.Now i want to set up out look again but failed in my
attempts. I want help....
|
3 |
22.09.2006 11:37:55 |
|
|
Filtering a form with Combobox
I have a form [frmProjects] with on field being [Project Manager]
I want users to have a drop down combo box, where they would select their
name and then have the form filtered to show only their set pf projects
I have searched this discussion group but I just can't get done.
I can start with an unbound combo box in the header of the form, I got that
part,
but what are my next steps...
|
7 |
22.09.2006 10:45:01 |
|
|
Linked Table Manager not updating tables simultaneously
I have a back end on a remote server and a front end on my desktop. To work
with a copy of the back end on my hard drive, I would like to change the
table links from the network server to the hard drive via the Linked Table
Manager. Per a suggestion posted to another newsgroup user, I checked that
all tables are pointed to the same back end and all file paths have the
\\server\...\back...
|
4 |
22.09.2006 10:39:45 |
|
|
List all data of field from a subform to single field in the mainf
How can i list all fields in a subform to a single field in the mainform. An
example is a patient record (main form). In the subform is the list of
medicine the patient has taken. I want in the mainform to list in a single
record all the medicine the patient has taken (e.g. penicillin, norfloxacin)....
|
4 |
22.09.2006 10:31:08 |
|
|
OrderBy Descending
Hi
I am trying to order a field in a form with a button
Me.OrderBy = "[EmpName]"
Me.OrderByOn = true
I Want to sort from last to first and i cannot find the syntax
Thanks
...
|
2 |
22.09.2006 10:16:12 |
|
|
what is reserved error (-3004)
i keep getting this error when i try to input data in my database, from one
table to another; anyone know what this error means.
3 tables running a music database
first table is: Artist.
next is: Album.
the last is: Tracks.
trying to input data into the tracks table from album table, and this is the
error message i receive.
is it possible that there's hyperlinks in the two tabl...
|
1 |
22.09.2006 09:23:01 |
|
|
MS Access : cannot join on Memo,OLE,od Hyperlink object
I have a MS Access Db,which I migrated to Oracle.I created linking with
oracle tables in my Access db.Both MS Access and Oracle db have unicode
characters.
I need to test whether the data is same in both databases.
I'm using Access db and linked tables of Oracle.I perform join on the
tables to get records. When I run the query on Access db to compare,I
get the following error
"cannot j...
|
1 |
22.09.2006 08:26:54 |
|
|
Default References
Hi everyone,
I want to know if there is a way that i can change the default references
that is loaded when a new project or database is created. I wan't to have
Access XP automatically include the DAO reference for every new project or
database. It is such a drag having to manually select the DAO reference every
time i start something new....
|
3 |
22.09.2006 06:58:02 |
|
|
convert roman numbers to text in MS Access
how can i change a roman number to a text character? example is changing 100
to one hundred...
|
3 |
22.09.2006 05:16:02 |
|
|
Access to Outlook Appointment
I am trying to add an Outlook calendar appointment from a form in access.
Once the form has been comleted I'd like specific fields from the form to
transfer over to outlook as an appointment. How do I do this? I don't know
much about VBA so I'll need help. Thanks for you help......
|
6 |
22.09.2006 04:32:01 |
|
|
Calling a sub of the subform
I'm try to call a sub in a subform from the mainform like this:
Forms![MainForm].Form![subform].Form![control in subform].name of sub
e.g. Forms![Property].Form![subfrmEase].Form![txtEase1].UpdateEnc
But it doesn't seem to work. Any ideas?
...
|
2 |
22.09.2006 04:25:56 |
|
|
Test if file found
Hi Folks,
I have images on a form that I load based on a field in a table. Works
well. However, sometimes I have a path/file name in the table when the file
does not exist. When this happens I continue to see the previous image. The
question is: can anyone suggest a way to test for the existence of the file
and if not found, indicate it so I can make the program do something else?
...
|
5 |
22.09.2006 04:24:01 |
|
|
antivirus question
I posted this before but I think someone accidentally responded to it
thinking they were responding to something else. So I am reposting.
should I be configuring my antivirus software to exclude access (mdb) files?
...
|
6 |
22.09.2006 03:54:29 |
|
|
ÊÔÑé
²âÊÔÕâ¸ö¶«¶«
...
|
1 |
22.09.2006 03:41:00 |
|
|
Purchase Order Database
I'm trying to create a basic database for generating Purchase Orders.
I found the following post (among others) that recommends using
Northwind and changing "Customers" to "Vendors" to reverse Sales Orders
to Purchase Orders:
http://groups.google.com/group/microsoft.public.access/browse_thread/thread/9bf294a11fa39c41/6c54c48eb4396ed4
I have a few questions:
If I do as is suggested in t...
|
6 |
22.09.2006 03:25:26 |
|
|
My Form is too large for the computers at work to run
Hello, I am creating a form which will when finished contain 36 columns each
column consisting of 2 sets of 15 combo boxes one side which displays a
budget figure for amounts delivered and the other side which will show
realtime amounts delivered. There will be a further 15 combo boxes at the
bottom to calculate the budget and actuall costs of the deliveries.
I have created the beta for...
|
5 |
22.09.2006 02:20:06 |
|
|
How do i Create a form header in access 2003
...
|
2 |
22.09.2006 01:49:36 |
|
|
Making a lable of a record
Is there an easy way to print a mailing label of a record from the form view
of that record. I would like to just have a button on the the form that would
say, "print label" and it would take selected feilds and make an avery label
of it.
I hope this isn't too much work for you guys. I appreciate your help.
...
|
2 |
22.09.2006 00:57:03 |
|
|
Outlook 2003 SP2 - Cannot right click on e-mail
Hi,
I have a very odd problem with a specific user who cannot 'right click' on
any emails in the inbox/sent/other folders.
The right click works on all other elements of Outlook i.e. calanders,
headers.
I've completely un-installed and re-installed Office 2003 and all the SP's
and updates but the problem wtill exists.
Anyone have any ideas?
Thanks,
Chris
...
|
3 |
22.09.2006 00:52:51 |
|
|
union query hanging
I have a program on a clients xp machine that has been running fine. All of
a sudden the union queries are hanging. It only seems to happen on this
machine so I know it is not in the data. Access has to be shutdown. Is
there a dll or something that may have been clobbered? I cannot get the
client to re-install Access.
Any help would be appreciated.
--
KSH...
|
1 |
22.09.2006 00:34:02 |
|
|
my msn blocks swear words how can i get it off
hi please can you help me my msn block a sentance if it has a swear word in
it how can i see the whole message...
|
1 |
22.09.2006 00:02:01 |
|
|
how to write a propose business plan
I need to know what are the initial steps, to get a sponsor, my idea was to
write a business proposal to start off....
|
2 |
21.09.2006 23:59:22 |
|
|
select multiple values in same row only display true values
I have a large Excel spreadsheet imported to access and would like to get
data from multiple rows but only show the colunm heading where the value that
meets the criteria appear in the queary or report...
|
2 |
21.09.2006 23:32:30 |