A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 35
Search took 1.53 seconds.
Search: Posts made by: AndrewDB
Forum: Database Design May 27th, 2010, 10:02 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 582
Posted By AndrewDB
SAVING REPORTS "SAVE AS"

Hi All. I have created a standard report as a type of template. Users can
access this report in layout view and change label captions, positions of
fields etc. But when they save the report I do...
Forum: Database Design March 15th, 2010, 05:23 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 646
Posted By AndrewDB
UNLOCK A SECURED CODE MODULE

Hi Tom. Thanks for your reply. Your guess is incorrect - the db is split but
the front end is 160Mb and cannot be sent by mail. The user is in a different
country quite far from me. The change...
Forum: Database Design March 11th, 2010, 03:45 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 646
Posted By AndrewDB
UNLOCK A SECURED CODE MODULE

Hi All. I need to send a "patch" to a remote user to replace a form in an
Access 2007 application. The code behind the forms of that database has been
locked with a password. In order to copy the...
Forum: Mailmerge February 25th, 2010, 06:18 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 4
Views: 275
Posted By AndrewDB
WHO MOVED THE GRAPHICS?

Hi Graham. I have solved this by saving the word document as a jpeg image and
inserting the image into the mail merge document. Tested this and it worked
great. Great pity that Word is used as the...
Forum: Mailmerge February 24th, 2010, 08:38 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 4
Views: 275
Posted By AndrewDB
WHO MOVED THE GRAPHICS?

Hi Graham. Thanks for your response. Anybody know of any way around this? I
specifically do not want to send attachments.
--
Kepior Senso Fumor


"Graham Mayor" wrote:

If you are trying to merge...
Forum: Mailmerge February 23rd, 2010, 07:33 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 4
Views: 275
Posted By AndrewDB
WHO MOVED THE GRAPHICS?

Hi All. I am trying to merge a document that contains graphic images. The
merge itself with the Access data is no problem. When I open the messages in
Outlook the graphics have moved to different...
Forum: Database Design February 22nd, 2010, 07:14 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 300
Posted By AndrewDB
ORGANIZATIONAL CHART

I am amazed at the presumptious and totally self-righteous attitude with
which my last reply was responded to. Facebook has a facility to block a user
who is not wanted, maybe MS should look into...
Forum: Database Design February 22nd, 2010, 04:21 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 300
Posted By AndrewDB
ORGANIZATIONAL CHART

Hi John

Thanks for you response and suggestion. I will look into the commercially
available ones. Was just hoping somebody would have used this before and
could point me in the right direction...
Forum: Database Design February 21st, 2010, 08:58 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 300
Posted By AndrewDB
ORGANIZATIONAL CHART

Hi All

Anybody know of software that will use Access Database as data source that
will show an organizational hierachy similar to that shown in Word 2007
SmartArt?
--
Kepior Senso Fumor
Forum: Database Design February 17th, 2010, 03:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 165
Posted By AndrewDB
A REAL CHALLANGE

Hi Tom
Thanks for your response. I Knew it would not be a simple solution. Just
wondered if there was a way to capture the name of the last file saved in
Windows considering "My Recent Documents"...
Forum: Database Design February 15th, 2010, 08:55 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 165
Posted By AndrewDB
A REAL CHALLANGE

I need to (from within Access) 1. Open a document scanning software so that a
document can be scanned; and then, after scanning, record the file name of
the scanned document in a database without...
Forum: Database Design January 20th, 2010, 09:22 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 180
Posted By AndrewDB
ANIMATED CLIPART IN MS ACCESS

Hi All. Any suggestions how I can insert animated clipart into a form. When I
insert the clipart as an image it loses its animation.

Thanx in advance
--
Kepior Senso Fumor
Forum: Database Design September 25th, 2009, 09:41 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 102
Posted By AndrewDB
List View Control

Thanks Gina. You're a star. Seems I had the bracketing wrong.
--
Kepior Senso Fumor


"Gina Whipp" wrote:

AndrewDB,

Try... =[YourListBoxName].[Column](2)
Forum: Database Design September 21st, 2009, 03:17 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 102
Posted By AndrewDB
List View Control

Hi All. I'm trying to use a List View control to show a set of icons together
with a recordset. How do I pass the value of the third column in the List
View of the selected record to a field on the...
Forum: Database Design September 16th, 2009, 11:31 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 100
Posted By AndrewDB
FILE LOCKING IN SQL DATABASE - ERROR 3197

Hi All, I really will appreciate help in this one. I have an Access 2007
client linked to a MySQL database which I connect to using ODBC. At times
when updating a recordset I get a Error 3197 "You...
Forum: Database Design September 8th, 2009, 08:06 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 6
Views: 124
Posted By AndrewDB
Replace form in external mdb

Thanks Ken. If the form already exists in that database I need a message
informing me so that I can respond -Replace? Yes/No. If yes I need to first
delete the original form before copying the new...
Forum: Database Design September 3rd, 2009, 01:35 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 70
Posted By AndrewDB
Linking to ODBC tables thru VPN

Hi All. Anybody have experience to link mdb to MySQL database situated on
remote server (Remote as in 1500km away). VPN maybe??
--
Kepior Senso Fumor
Forum: Database Design September 3rd, 2009, 09:56 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 6
Views: 124
Posted By AndrewDB
Replace form in external mdb

Hi All. I need to replace a form and attached vb procedures situated in an
external mdb using vba. I can use copyobject but as a form with that name
already exists I get an error.

--
Kepior...
Forum: Database Design August 25th, 2009, 04:43 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 142
Posted By AndrewDB
Refreshing a treeview control

I use a treeview control to show a list of related sets and subsets of
records and action this from the a forms OnCurrent property.

I just can't get the treeview to refresh when I move to another...
Forum: Database Design July 2nd, 2009, 04:07 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 510
Posted By AndrewDB
Posting Access data to Outlook

Hi All. I need to present data from a scheduling database in a type of
year/monthly/weekly layout similar to that used by Outlook. Instead of trying
to re-invent the wheel, is there a way that I...
Forum: Database Design January 29th, 2009, 06:19 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 141
Posted By AndrewDB
Creating a PDF file from multiple reports

Hi Tom. That's a possibility I haven't considered. I will definately try it.
Just one question: Considering that the report is then loading 5 linked jpg
images at once will it still be within the...
Forum: Database Design January 28th, 2009, 05:40 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 139
Posted By AndrewDB
How to Design PDF Repository to Link with DB Form

Hi MEB. I have a similar type of system that I use and I have found that by
creating a field as a hyperlink which is used to save the file information
works best. The user just clicks the hyperlink...
Forum: Database Design January 28th, 2009, 05:34 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 141
Posted By AndrewDB
Creating a PDF file from multiple reports

I have a small Access DB where I capture accident claim information and then
run 5 reports which contain the data layered over a background image of the
actual claim form (1 report per page). This...
Forum: Database Design January 10th, 2009, 10:57 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 6
Views: 126
Posted By AndrewDB
Opening a report in a different access database

Thanx Bonnie and Clifford. I really appreciate the support.

Andrew
--
Kepior Senso Fumor


"Clifford Bass" wrote:

Hi Andrew,
Forum: Database Design January 9th, 2009, 11:20 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 6
Views: 126
Posted By AndrewDB
Opening a report in a different access database

Hi Bonnie
Thanx for your response. I did try that initially but had problems with the
registration between the form image and database fields. Each time the report
was opened the fields did not...
Showing results 1 to 25 of 35

 
Forum Jump

All times are GMT +1. The time now is 12:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 OfficeFrustration.
The comments are property of their posters.