|
Help please
I have a "Deliverables" form. Each deliverable has a command button to open
a "Tasks" form (that shows all the tasks for the particular deliverable -
Each task record has the associated deliverable ID number ). The code for
this command is:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName =...
|
2 |
27.09.2006 16:55:02 |
|
|
Move-setting
On PC1 I have win2000 and Access 2000 and on PC2 XP and Access2003. When
I select a field in form design mode on PC1 I have to press Ctrl and one of
the arrow keys to move the field. On PC2 I can do the same action without
having to use the Ctrl-key. Is there a way to make the behavior identical on
both machines?
Thanks,
john
(crosspost from databases.msaccess with no reply's yet)
...
|
1 |
27.09.2006 16:41:04 |
|
|
ODBC call failed - only 1 of several tables
We have a Access 2003 front end with the data tables on a SQL server. One of
the users is getting an ODBC call failed (no error number) when trying to
open 1 of the tables. He is able to open all other tables with no problem.
We deleted his DSN and created a new one, removed the link and re-linked the
table, tried a different username and password (which worked on another
system) but ...
|
1 |
27.09.2006 16:23:01 |
|
|
DateAdd in forms
Hi, at the moment im using
=DateAdd("d",[Days],[Starthire]) to calculate a date using an ezxisting date
and a number of days, however in the field that this is entered in the
control source of, it doesnt seem to put that date into the table, can anyone
help rectify this? thanks, WK...
|
4 |
27.09.2006 16:15:17 |
|
|
Import SQL Server User-Defined Functions into Access 2002
I have an Access 2002 database consisting mostly of linked tables from a SQL
Server 2000 database. I was hoping to import a SQL Server user-defined
function from the SQL database into Access. It's not one of the commonly
requested functions (calculate working days between two dates, etc.). It's
proprietary to our business needs.
In general, can this be done and if so, how? I tried copyi...
|
5 |
27.09.2006 16:07:03 |
|
|
can't sort my query with the AZ and ZA button
Two of us are sharing a MS DB...if we create duplicate queries, she has
the sort option and I do not...my little "AZ-->" and "ZA -->" buttons
are grayed out. Why is this and how can I get the sort to work for me?
I have tried to right click the top of the query window, choose "Apply
Filter/Sort" but get a message that the records are locked...tried it
just becasue I don't see anything...
|
2 |
27.09.2006 16:03:16 |
|
|
simple pto database
I am trying to set up a simple pto datbase tracking which parent signed up
for which committee then sorting the parents with all the pertinent info by
committee. example - all those who signed up for fundrasing. not sure if i
know even how to begin!
thanks!...
|
3 |
27.09.2006 15:54:31 |
|
|
Comparing multiple lists
Hello All,
I have a situation where I have a master list of about 2000-2500 entries and
then there are few lists of varied number of entries. I want to compare this
master list with all these other list and at the end, get an excel sheet
where one column will have all entries from master sheet and then next few
columns will have checkboxes, if certain entry is present in either of the
...
|
2 |
27.09.2006 15:49:04 |
|
|
Overflow error when appending data to SQL from Access
I imported an excel spreadsheeting into a local table in Access 2003. There
are ~1400 records (dates, text, and integers). I verified that the date and
integer fields contain only that type of data. When attempting to run an
append query to a sql 2000 database table (with the same destination fields)
I receive an "Overflow" error. I have found reference to "Numeric Overflow"
and am n...
|
2 |
27.09.2006 15:41:04 |
|
|
VALIDATION AND CALCULATED FIELDS
Hi Guys,
Can anyone help please?
A) I have 2 tick boxes to capture “AUTHORISED ABSENCE†and “UNAUTHORISED
ABSENCEâ€. I also have an ABSENCE REASON text box.
If AUTHORISED ABSENCE or UNAUTHORISED ABSENCE is selected, then the ABSENCE
REASON box must not be empty. The message “Select A Reason†must be
displayed, else leave blank
I have tried,
=IIf([AUTHORISED ABSENCE]="...
|
4 |
27.09.2006 15:39:01 |
|
|
Access 2000 Form viewing in Access 2003
I recently upgraded to access 2003. I have a pretty extensive database in
Access 2003. When opening the database, the Start-up form does not always
poplulate the data. If I keep trying to open it, evantually, my data will
show up, but sometimes it takes half the day to get the data to show up. I
use this database all the time, so I really need it to work correctly all the
time. Than...
|
1 |
27.09.2006 15:29:03 |
|
|
*YIKES!* $#!+ ! Linked images!
Hi! I am a cartoonist and teacher too. One of the classes I teach,
since 1997, is called "History of Cartooning". It is a series of 30
lessons, I painstakingly created, with hundreds of slides in total. Now
I present it with Powerpoint and a video-projector. I have created the
notes with MS Access that include all the slides with a small text, and
info, each. I am quite pleased with the notes...
|
3 |
27.09.2006 15:19:14 |
|
|
calculating time differences between consecutive records
I have a large database that consists of transaction event histories
(i.e. records when a page was viewed, on which PC, each with a
time/date record). I'd like to calculate elapsed time for each page
view by calculating the difference between the time/date of each record
and the subsequent record for a given PC.
Is there a simple means to accomplish this?
A related question is, is there a s...
|
5 |
27.09.2006 15:14:02 |
|
|
Does anyone have an ACCESS survey that totals the answers?
I am looking for a survey created in ACCESS to send to employees that will
add the answers for each question for all participants automatically....
|
2 |
27.09.2006 15:12:19 |
|
|
Error 3033
Help please.
I am using Access 2003. I was working in the Northwind sample database
working with SQL statements.
I try to open the database now and get the following:
"You do not have the necessary permission to use the 'C:\Program
Files\Microsot Office\OFFICE11\SAMPLES\Northwind.mdb' object. Have your
system administrator or the person who created this object establish the
appropriate ...
|
1 |
27.09.2006 15:08:02 |
|
|
UN-Match Query
I have two tables with a like field in each table. Tables "A" and "B"
have a like field (Field#2). But Table "A" also has a field(Field#1)
which can contain a like value that is in Field#2.
I am trying to summarize Table "A" where Field#2 in Table "B" never
occurs in Field#1 in Table "A".
In the past I normally use the same method as the UnMatch Query Wizard
where I establish a left joi...
|
3 |
27.09.2006 15:03:42 |
|
|
Auto Number
When i have a auto number it come out like '8' how can i set it to come
out with zero first like '0008'
if not is there a way on a report i can make it put the '000' first
Thanks
...
|
3 |
27.09.2006 15:00:30 |
|
|
Can't open Access Database using shortcut on desktop
Recently we had Access 2003 installed at our workplace. We have a database,
located on a server, that is used by multiple employess. We have placed
shortcuts on the desktops of the employees, however I have found that the
shortcut will only work when there are no other people using the database.
When there are multiple people logged into the database you must open Access
and navigate ...
|
2 |
27.09.2006 14:59:51 |
|
|
TreeView: Debugging Load Procedure
I'm loading a TreeView from a work table.
Doing it over-and-over again: same data, same code.
The problem seems to be that I'm trying to create a duplicate node (i.e. one
with the same .NodeKey as an existing node.
I've got error trapping code in there that spells it all out: the record ID of
the input row that it's choking on, the offending .NodeKey and so-forth.
So far, so good.......
|
10 |
27.09.2006 14:56:22 |
|
|
Upload PDF's to a database
Through the user interface. I am new to Access and am learning on
Lynda.com the basics. I am trying to create a database that our sales
associates can upload information including pdf's of company specific
diagrams as well as company info. The company info I can handle, but
can Access allow you to upload PDF's to the database and make them
searchable?
Thanks!
...
|
1 |
27.09.2006 13:59:22 |
|
|
Access 97 and 2003 running together; Startup Menu
I am about to install Access 2003 on a computer with
Office 97. I read the stuff about the startup menu, and
am somewhat confused. Do I need to rename Access 97
stuff or not? The docs say that Access 2003 goes by
a different name on the startup menu, but also it suggests
renaming Access 97.
...
|
3 |
27.09.2006 13:41:02 |
|
|
TOOL - OFFICE LINK - ANALYZE IT WITH MS EXCEL
I have a REPORT in MS ACCESS and for distribution purposes, I intend to
send to the recipient in MS EXCEL format.
So I click TOOL - OFFICE LINK - ANALYZE IT WITH MS EXCEL
I did get the report in EXCEL format but the EXCEL report is with flaw.
I notice some of text that I have in ACCESS (under DATA TYPE of MEMO) get
truncated in EXCEL.
Your opinion please? How to ensure there is no tr...
|
1 |
27.09.2006 13:40:02 |
|
|
Error Message - object module
Where do I begin to trouble shoot this error message?
"The expression On Click you entered as the even property setting produced
the following error: Member already exists in an object module from which
this module derives."
It was working fine, but something happened and is not generating this
message. The event procedure appears to be intact.
Thank you for any help!
...
|
1 |
27.09.2006 13:38:01 |
|
|
Utility for managing files of access
Hello,
I would like to point out an utility (that I wrote to myself) for
managing microsoft access files.
DBChecker is a command line program that can:
1) compact and repair MS-access database files
2) clone the structure and data stored in a database file while it is
open
(for scheduled backup purpose)
3) check structure and data in a database "record by record" and
save
stati...
|
1 |
27.09.2006 13:19:57 |
|
|
Save and Close
The following event procedure works fine when running as a single user. As
soon as two workstations are running the database, it returns an error, "Save
command cancelled"
Any suggestions are appreciated.
Private Sub Command35_Click()
On Error GoTo Err_Command35_Click
DoCmd.Save
DoCmd.Close
Exit_Command35_Click:
Exit Sub
Err_Command35_Click:
MsgBox Err....
|
3 |
27.09.2006 13:00:01 |