|
pictures in Access report records
Can anyone suggest how I could get picture links in Reports to work.
I think I accurately followed the steps in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820
the How To page.
I'm using Access 2002 with Windows XP Pro. The above on last page says it
applies to to Access 2003 and Access 2002 Std Edition.
I also tried the How To for Access 2000 and could not make it work eit...
|
6 |
20.09.2006 21:49:46 |
|
|
Automation - Long String to Excel
The string M in the code snippet below is a
long path to a File on a Server.
When the code tries to open the Workbook...
Set objXLWb = objXLApp.Workbooks.Open(M)
......''it says it can't find the File.
It there a "limitation" to automating to a Server File?
I have done plenty of automation to Local (C:) Files,
and can modify my design to populate a Local File &
then send it to a User.
...
|
6 |
20.09.2006 21:11:59 |
|
|
Is there any reason to buy full version as opposed to upgrade?
Should I buy the full version of Office 2003 or the
upgrade? Please advise your thoughts.
...
|
5 |
20.09.2006 20:19:55 |
|
|
SQL Query help
Hi,
I have a Make table query that was designed through the SQL builder of MS
Access queries, however now i need to make alterations to the query but
everytime i try and open it in design view it crashes on me, causing the
database to not respond. Therefore, is ther any back way i can open the query
in SQL design view without having to open it via the normal design view.
Hope you can...
|
2 |
20.09.2006 19:59:02 |
|
|
equivalent of datediff in ms access
If I have a t-sql query
select datediff(day, getdate(), column_date)
how can i write this in MS ACCESS
...
|
2 |
20.09.2006 19:56:01 |
|
|
default form when db opens
I got a db from a friend and I saved the original and modified the copy.
When I open the db, it still presents the original form when the db is
opened. I have created an autoexec macro but that first form always opens
up.
What so I have to do to change it?
TIA
...
|
3 |
20.09.2006 19:46:42 |
|
|
seperating columns from a table
I have been working with an Excel spreadsheet that contains over 150 columns
of data. I tried to create one table in Access to mirror this spreadsheet,
but there are too many columns for a single table. How can I break these
columns into two tables and maintain integrity?
Thanks...
|
3 |
20.09.2006 19:43:01 |
|
|
DCount .......
Dear all,
I have a form that's used to disply the search citeria,the form looks like
this :
Name Job description phone Mobile
John employee 00 00
Tony Account manager 00 00
Peter Supervisor 00 00
I'd like to creat an unbound text box to count the how many "account manger"
will appear as a re...
|
4 |
20.09.2006 19:27:51 |
|
|
Unable to see new records unless the application is closed and reopened
Greetings,
I hope there is someone out there who could help me with this problem
that is how to avoid closing and reopening of MS Access application if
the database was updated through the website in order to view the
latest records.
Thanks in advance
Best regards
-Rino
...
|
2 |
20.09.2006 18:46:02 |
|
|
Queries
Hi, Every one
I have a quick question. I created a database a while ago for our
collections team. They have reports that they print out but they all print
out together. Is there a way for me to set it up to pull up certain id
numbers at a time. I use the Like "*1234" but that pulls them all up
together.
If anyone could help, please
Thank you
Sheria...
|
4 |
20.09.2006 18:42:18 |
|
|
Selecting first row of a table
How can I query a table to select the first record of a group. For instance
if I have duplicate values for a client name, but the other fields for that
record contain differnt values, how can I select just the first record with
the corresponding values. Here's an example:
Client Name Date Value
ABC Co. 1/1/2006 1
ABC Co. 1/7/2006 7
...
|
3 |
20.09.2006 18:20:07 |
|
|
Copy/Paste does not copy a table from Access to SQL Server
I'm trying to make a copy of a table, in the same database, as a different
table name. I copy the table to the clipboard and then paste it. Access
prompts to enter the new table name, but then says it cannot find that name
(of course I'm just creating it) and won't do the copy.
Should this work?
...
|
2 |
20.09.2006 18:18:23 |
|
|
Create message box
Is there a way to create a warning message box if someone attempts to
edit/delete the data in a field/control?...
|
4 |
20.09.2006 18:10:44 |
|
|
Button Click doesn't change textbox visible?
I have a button and it's suposed to change the text for a call "type" is.
When I click the button teh code below fires. Unfortunatly I don't see the
change from Emergency to Reservation in real time. I have to move a record,
and then come back to see the change.
What do I have to add to the code below? That same code will update the
time to Now in another similar button click.
Pri...
|
3 |
20.09.2006 17:54:06 |
|
|
SendObject Vaildation
Is there a way to validate an email address prior to executing the SendObject
command?
I have a form that prompts the user to enter his/her email address. When
the user clicks the "Send" button, a message is sent to 2 email addresses.
One email address is hard coded and the other is what the user entered. I
would use an "On Error" statement but the users email address is passed to
...
|
1 |
20.09.2006 17:46:03 |
|
|
Problem with calculating formulas in Excel 2003
I am creating a spreadsheet that intends to calculate, on a monthly basis,
the tax due for each company on the group I work for. As this projection has
a 10-year horizon and many variables are included in it, each company has a
similar spreadsheet ranging till cell DT721.
My problem is that I noticed that this workbook I'm working on, whenever it
is open, shows "Calculate" on the nether...
|
3 |
20.09.2006 17:41:02 |
|
|
Where to place Add-Ins????
C:\Program Files\Microsoft Office\OFFICE11\ADDINS
C:\WINDOWS\addins
I have been trying to get a *.mda "Add-In" installed. I have
placed it in the above directories but it still does not show in the
"Add-In Manager" . Can someone please tell me how to accomplish
this?
Thank you
...
|
4 |
20.09.2006 17:22:52 |
|
|
Can not hide the Database Windows on specific databases, please help!
I inharited about 12 databases that I want to hide the Database Windows on.
I've done this many times before in the Startup Windows.
For what ever reason no matter if the box is checked or not, it will not
hide the Window.
Access security is setup on this database and I'm loggin in as Admin.
I converted the database to 2002-2003 format, that didn't make any
differenece.
I've ran compact and...
|
2 |
20.09.2006 17:21:14 |
|
|
Auto populate, again
I looked around a bit but all questions I found dealt with updating just one
field. What I want to do is load an entire record ie. auto-populate several
fields at once.
I have a table that is linked to a location table via a location id. In a
form based on the main table, I would like to just enter the name of the
location, and then have the form pull in and show all related information.
...
|
2 |
20.09.2006 17:21:02 |
|
|
EOF Issue
Greetings,
I have a form that displaysthe project managers for the various projects in
the database. The form is set to show only one record at a time, vice a list
of managers, as it also displays a subform with all the projects assigned to
that manager.
The problem I am having is that if a user deletes the last record or moves
past it either by the navigation buttons at the botto...
|
6 |
20.09.2006 17:09:01 |
|
|
Trying to retrieve unique records
Can someone please tell me how to force access to extract unique
records, based on the last record in a particular field.
Basically I have a customer table linked to a customer_order table. I
want to query through access fields within the customer and
customer_order table, but only extract their most recent order to the
results, therefore ending up with a unique list of customers with last...
|
2 |
20.09.2006 16:58:03 |
|
|
line chart
I am trying to create a line chart with 2 lines on it, the x axis should have
weeks on it 1 to 20 and the y axis should have dates on of when a form was
completed.
One line should represent the ideal interval inbetween the forms being
filled in and the other should represent the actual interval between the
forms being filled in.
I have written a query that extrapolates the ideal and actu...
|
1 |
20.09.2006 16:57:01 |
|
|
I want to migrate access database to sqlserver2000
While I am migrating database from msaccess to sqlserver2000,
s_guid,s_collineage,s_genration and s_lineage fields are inserted, as these
are not related to my database. If I remove these fields from swlserver2000
database, am i going to losing anything?...
|
2 |
20.09.2006 16:54:35 |
|
|
linking tables
i am wondering what linking tables accomplishes - i have never done it
before.
how do i setup a database to work with two tables that i cannot get a
unique index (primary key) for - besides the default "ID"? i can shed
more light if need be, but i wanted to get this question out there
thanks
...
|
2 |
20.09.2006 16:39:02 |
|
|
HOW DO I ENTER 3.51.3 AS NUMBER IN ACCESS (TRAVELLING TIME)
i am wanting to enter hours minutes seconds as number in a data column this
being the time taken to cover a specifc distance. Putting the second decimal
point in throughs it out. Any Help appreciated...
|
18 |
20.09.2006 16:24:59 |