|
Setting Up Users
I was looking for some help with setting up users for my DB. Because of
where I work the DB is on a shared drive so all user with access to that
drive can access the DB. I would like to assign user but the last time I
tried it only worked on my computer and not the others. Any help or guidance
would be welcomed!...
|
3 |
28.06.2009 02:49:54 |
|
|
Excessive database size
I keep information about my CD library on a fairly simple database on access.
There is a CD table and a Source info table with names, addresses,
hyperlinks for my most common suppliers. There are a couple of very simple
reports, two or three simple queries and a data entry form for the CD info.
I enter the supplier info directly into the table view.
There are 560 records on the CD tabl...
|
5 |
01.10.2006 03:28:01 |
|
|
test
tfgh
...
|
1 |
08.06.2007 00:57:03 |
|
|
good
good
...
|
2 |
02.12.2006 13:11:51 |
|
|
Creating a Report
Hi everyone
My Report retrieves data from a specific MS SQL Table. The report is
filtered by a SQL Statement.
The Data within that Table can be defined into 3 sub-categories; say
Material A, Material B, Material C
My Question is:
Is it possible to tell the Report to start a new Page as soon as data from
the next category appears. So, as soon as all the Data concerning Material A
has be...
|
5 |
01.11.2007 09:18:36 |
|
|
Dropdown list question for Access 2003?
Why is the dropdown list control greyed out on Form Design toolbar in
Access 2003? (Combo box control is not greyed out, though).
...
|
2 |
01.10.2006 03:23:01 |
|
|
Column values to single string
Hi
I have an email column in a table. How can I turn values in the column for
all records into a single string with each email separated by a ;?
Thanks
Regards
...
|
3 |
01.10.2006 02:35:01 |
|
|
Filesearch in Access 2007 Beta
Hi all,
Some code that I wrote in ACC2003 using the FileSearch object does not work
in the 2007 Beta. I have read that the new object model has "hidden" this
object (though I'm not sure what that means precisely). At any rate the
FileSearch object has ceased to function.
Is anyone aware of this issue and/or a work-around to using the FileSearch
object to getting a list of file names ...
|
4 |
01.10.2006 02:04:01 |
|
|
URGENT! REPLY NEEDED ASAP...
Hello,
I have a parameter query that ask for a First name and a last name. I would
like for an message to appear if no one by the names appear. I can't seem to
find anything in the discussions.
Example:
Enter First Name:
Frank
Enter Second Name
Smith
Message pops up if there is no Frank Smith in the database and Says oops
sorry try again.
Can anyone help me....I need to ...
|
3 |
01.10.2006 02:03:15 |
|
|
how do I speed Access handling of MS SQL data
I have an Access database where all of the data resides online in a MS SQL
database. Processing any of the data, whether through a query, report or form
takes way way too much time. How can I speed that up?...
|
2 |
01.10.2006 02:02:01 |
|
|
Alter Code for Batch Printing
This is my code to print a statement by selecting date range and OwnerName,
at the bottom of the code there is something about batch printing
statements but it is greened out. Can I use this for batch printing all
owners staements at todays date? Thanks for your Help......Bob
Private Sub cmdStatement_Click()
Select Case Me.OpenArgs
Case "OwnerStatement"
...
|
7 |
01.10.2006 01:48:01 |
|
|
Adding Times in Short Time Format
I am using Access 2003. One of the fields in my program is is the passage of
time. I take one time entry (Finish) and subtract another time entry (Start)
to get the amount of time spent on a task (Finish - Start = "Total_Time).
All of these times are formated in Short Time Format (hh:nn). This works
great until I try to get the Sum of "Total_Time". It works fine until the
total goes...
|
2 |
01.10.2006 01:34:01 |
|
|
Hyperlinks to bookmarks
Can I create a hyoerlink to a bookmark in a pdf file using Access 97? I have
succeeded in creating a link to a bookmark in a Word file, but it doesn't
work for a pdf....
|
2 |
01.10.2006 01:23:32 |
|
|
MAKING SIMPLE TO TALLY, AVERAGE, CALVULATE FROM DATASHEET VIEW
I WOULD SUGGEST MICROSOFT PEOPLE TO LOOK AT RBASE DATABSE FOR THIS FEATURE.
WHILE IN DATASHEET VIEW IN TABLE, QUERY MODE- CALCULATE IS OPTION ON THE
TOOL BAR WHICH LETS U DO SOME SIMPLE CALCULATIONS SO EASILY! IT WOULD BE NICE
TO HAVE THIS IN MSACCESS!
HAPPY TO DISCUSS
--
sb
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with ...
|
2 |
01.10.2006 00:03:02 |
|
|
my media player asks for a licence to play my music
when i want to play music downloaded of a cd my media player informs me i
have to have a licence to play and to wownload it , what licence is it...
|
2 |
30.09.2006 23:05:02 |
|
|
Access 2000 Runtime Service Pack 3 installation unsuccessful
I have been trying to install Access 2000 Runtime Service Pack 3 for months
now and am continually told "installation unsuccessful". Trawling the
internet has yielded no answers. Can anyone help me please?
Regards
Dr Ian Smith...
|
4 |
30.09.2006 23:03:01 |
|
|
subform info retrival
I have 2 tables with a one-to-many relationship with a common uniqueID
connecting them. From the main table there is a main form with a command
button to open a second form. In the second, there is info from the main
form table (name, address, etc...) to help with identificaiton. I want the
second from to retrieve the uniqueID from the first form so it will grab the
rest of the info. ...
|
2 |
30.09.2006 22:55:01 |
|
|
How can I increase the field lengths in Access 2007
I have an Access CD collection on the previous version of Access, converted
to Access 2007 Beta.
How do I increase the field lengths. I have altered the visual windows to the
size that I need, but, I cannot enter any more text than before.
The help facility has not been helpful at all.
...
|
5 |
30.09.2006 22:45:04 |
|
|
MS Access
I noticed there are many different types of MS Access, I am trying to read
discs that are mdb. Which version is best for me?...
|
3 |
30.09.2006 22:08:18 |
|
|
Grupos de noticia
Mensaje reeferente a los grupos de noticias
...
|
4 |
30.09.2006 21:05:16 |
|
|
Word to Access Automation
Hi,
An age old question and I have been extensively searching the past
posts and have seen some reasonable suggestions.
I am after some thoughts on the best way to achieve this. I am
building an application suit from scratch that needs to be able to
import Word documents into an Access Database.
The word documents/templates will effectively contain repetitive
information structures t...
|
6 |
30.09.2006 19:25:56 |
|
|
Suppressing blank lines on printout.
First, thanks for all the help with my first question. What a knowledgeable
bunch you are!
Back to printing out my names and addresses. I dont want blank lines printed
out in the middle of my address so I've set each text block to shrink =
Yes. This works fine. Trouble now is I want the address printed in a
rectangular window (pref with rounded corners but that may be asking too
much). I ...
|
3 |
30.09.2006 18:17:56 |
|
|
How do i syncronize the outlook calendar with another computer?
My father and I each have our own computer, and each need the outlook
calendar. But each one of us put in different dates/events. We would really
like it if we could syncronize our calendars. Were on the same network. Is
there a way/program to sync them? Thanks....
|
2 |
30.09.2006 16:44:24 |
|
|
Command
Hi,
For running in Window 2000, Command is working.
For running in Window XP, Command is not working. Why?
Because I want the program to check
/cmd "12345"
Autoexec:
Function start()
if len(command)>0 then
.............
end if
end function
Why it doesn't work in Window XP?
Thanks.
...
|
2 |
30.09.2006 16:42:46 |
|
|
Surveys
Okay, l have a survey that contain 28 quetions. Each question that is
answered yes, will have a number value to it. For example, if they answered
yes to "is the plan a 5500 plan?" that question is worth 1 point. I want the
total points added up on the form? So when I do a query and as for the plans
that scored between 50-60 ponts to pull up, it would be able to do so....
|
4 |
30.09.2006 16:27:39 |