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 74
Search took 0.29 seconds.
Search: Posts made by: sweeneysmsm
Forum: Database Design May 31st, 2010, 12:52 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,993
Posted By sweeneysmsm
2003 to 2007

Thanks so much. Have to treat myself to a 2007 Access book:)

Mary

"John W. Vinson" wrote:

On Fri, 28 May 2010 13:47:01 -0700, sweeneysmsm
wrote:

I...
Forum: Database Design May 28th, 2010, 09:47 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,993
Posted By sweeneysmsm
2003 to 2007

Hi, Noella,

Thanks for your so prompt reply. I guess it seems that Access 2007 security
is "across the board" but does not allow for the wonderful fine-tuning that
previous versions permitted -...
Forum: Database Design May 28th, 2010, 02:01 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 433
Posted By sweeneysmsm
Upgrading an .mdw to 2003 format?

Thanks so much!

Mary

"John W. Vinson" wrote:

On Thu, 27 May 2010 16:38:01 -0700, sweeneysmsm
wrote:

I have upgraded my frontend & backend .mdb...
Forum: Database Design May 28th, 2010, 12:42 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,993
Posted By sweeneysmsm
2003 to 2007

My understanding is that if I upgrade a 2003 format .mdb to 2007 all security
settings will be gone. Can someone elaborate on just what that means? I
presume no login, no workgroup. How about...
Forum: Database Design May 28th, 2010, 12:38 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 433
Posted By sweeneysmsm
Upgrading an .mdw to 2003 format?

I have upgraded my frontend & backend .mdb from 2000 to 2003. Do I also
upgrade the .mdw in the same way?

Thanks so much.

Mary
Forum: Database Design May 4th, 2010, 09:40 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 622
Posted By sweeneysmsm
Skydrive

The responses above have been helpful, but I am still interested in focusing
on the skydrive. Windows live has a skydrive. Is it possible to connect to a
backend in skydrive from a desktop target -...
Forum: Database Design April 28th, 2010, 11:13 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 622
Posted By sweeneysmsm
Skydrive

This is probably a crazy question, but will ask it anyway.

Is there a way to share an Access database via the web?

Off the top of my head I am thinking of a situation where there might be a
split...
Forum: Database Design April 10th, 2010, 11:12 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 341
Posted By sweeneysmsm
Add table to split database

Thank you to all who helped me to clarify my task. I really appreciate it.

Mary
Forum: Database Design April 10th, 2010, 11:10 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 341
Posted By sweeneysmsm
Add table to split database

Thank you for this good advice. I am actually not making a change to an
existing table, but rather adding an additional table. I will keep what you
said in mind for the future.

Mary

"John W....
Forum: Database Design April 10th, 2010, 06:55 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 341
Posted By sweeneysmsm
Add table to split database

Hi, Daniel,

Thank you for your so-speedy reply.

One question: When you say "Open your front-end and Import - Link the new
table", are you saying that I first Import the table, and then link it,...
Forum: Database Design April 10th, 2010, 06:33 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 341
Posted By sweeneysmsm
Add table to split database

I have a split Access Database on a network. I need to add a new table to the
database. Do I export it to both the front end and the back-end or do I run a
relinking module or do they just find...
Forum: Database Design August 6th, 2009, 04:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 135
Posted By sweeneysmsm
Access Developer Extensions and Office 12

I have an Access database that was designed in Access 2003. I also have the
Access Developer Extensions (2003 – 11.0.5622).

I just recently installed Office 12 on my laptop but I have Office 11...
Forum: Database Design July 1st, 2009, 10:35 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 101
Posted By sweeneysmsm
Access/Comcast/Digital Conversion

Update:

Thank you all for all suggestions.

I did use the Shift-Key trick and that did open the database object window.
Once there I opened a new module and went to Tools/References with the intent...
Forum: Database Design June 28th, 2009, 07:30 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 101
Posted By sweeneysmsm
Access/Comcast/Digital Conversion

Thank you so much for replying, Damon.

As for the "Red herring", perhaps you are right, but it does seem
strange/inexplicable to me that 3 groups who had not had reason to contact me
for 5+ years...
Forum: Database Design June 27th, 2009, 11:54 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 101
Posted By sweeneysmsm
Access/Comcast/Digital Conversion

Thank you so much for replying. I will try to clarify.

It is an Access database, not an Access Project. When I said that the
Database would open but not the database window I meant that the...
Forum: Database Design June 27th, 2009, 01:48 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 101
Posted By sweeneysmsm
Access/Comcast/Digital Conversion

I have 3 separate clients for whom I have installed an Access database. The
databases have been in use for 5 years in one instance and 3 years for the
other two. They have had no problems until the...
Forum: General Discussion June 24th, 2009, 10:21 PM Posted to microsoft.public.access
Replies: 0
Views: 48
Posted By sweeneysmsm
Wizard which pops up after initial sign-in

I received a call from a client who has had a database I designed in
operation for about 6 years – no problems. The routine is that the user signs
in giving her login name and password, and then...
Forum: Database Design May 12th, 2009, 10:40 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 122
Posted By sweeneysmsm
Make a change in Access DB backend

My database has been split. I used JStreet Access Relinker to set up the
linkage.

I now want to add a URl (hyperlink) field to the Back End Contacts table so
that I can draw that field into the...
Forum: General Discussion May 9th, 2009, 08:23 PM Posted to microsoft.public.access
Replies: 4
Views: 70
Posted By sweeneysmsm
Select All in a listbox

Thank you, Ken. I think I will just go with the extended multi-select but I
am grateful to have the code you sent.

Mary

" wrote:

Mary:

If you want to do it...
Forum: General Discussion May 9th, 2009, 08:22 PM Posted to microsoft.public.access
Replies: 4
Views: 70
Posted By sweeneysmsm
Select All in a listbox

Thank you so much. That was perfect.

Mary

"Ken Snell MVP" wrote:

Change the Multiselect property to Extended.

You then can select the first item, scroll down to the end of the list, hold
...
Forum: General Discussion May 9th, 2009, 01:58 AM Posted to microsoft.public.access
Replies: 4
Views: 70
Posted By sweeneysmsm
Select All in a listbox

Is there a way to select all of the records in a listbox instead of having to
select each one individually?

I am using the listbox to send stored e-mail addresses so that a report can
be sent out....
Forum: General Discussion April 30th, 2009, 05:15 PM Posted to microsoft.public.access
Replies: 7
Views: 58
Posted By sweeneysmsm
Send e-mail with Access

Mr. Meyer's sample worked just fine with the necessary adaptation. Thank you
so much. I guess I had hoped for one that I could just use to send e-mail but
perhaps in Access one always has to...
Forum: General Discussion April 9th, 2009, 08:44 PM Posted to microsoft.public.access
Replies: 7
Views: 58
Posted By sweeneysmsm
Send e-mail with Access

Thank you for your help. I will try to give EMail Senate a go. Will post
again after Easter when I will have time to try it.

Mary

"Douglas J. Steele" wrote:

See whether Arvin Meyer's...
Forum: General Discussion April 9th, 2009, 08:42 PM Posted to microsoft.public.access
Replies: 7
Views: 58
Posted By sweeneysmsm
Send e-mail with Access

I was looking for something that I could get or buy as a developer and
utilize in the applications that I develop. As I read rptsoftware.com it
would seem that my users would have to purchase this...
Forum: General Discussion April 9th, 2009, 01:29 PM Posted to microsoft.public.access
Replies: 7
Views: 58
Posted By sweeneysmsm
Send e-mail with Access

I have created a membership database for an organization. There is a field
for Member's e-mail address.

Is there a way to send an e-mail to ALL memberS or certain memberS based on
a query (e.g. a...
Showing results 1 to 25 of 74

 
Forum Jump

All times are GMT +1. The time now is 06:47 PM.


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