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 100
Search took 7.02 seconds.
Search: Posts made by: Gina Whipp
Forum: General Discussion June 6th, 2010, 04:41 AM Posted to microsoft.public.access
Replies: 1
Views: 2,038
Posted By Gina Whipp
Database for cataloguing magazine content

CharlesW,

This might help...

http://office.microsoft.com/en-us/templates/TC010186431033.aspx?pid=CT102144001033

--
Gina Whipp
2010 Microsoft MVP (Access)
Forum: Using Forms June 4th, 2010, 06:36 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 1,072
Posted By Gina Whipp
Lebans MouseWheelOff code

Tara,

I forget, does Access 2000 have Macro Security? If yes it will be located
under Tools and you will need to set that to Low.

--
Gina Whipp
2010 Microsoft MVP (Access)

READ ME: These...
Forum: Using Forms June 3rd, 2010, 07:08 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 1,072
Posted By Gina Whipp
Lebans MouseWheelOff code

Tara,

Sounds like you are opening it in Access 2007 with means the database must
be placed in a Trusted Location OR you’re my Documents folder. Is that the
case? ...
Forum: General Discussion May 24th, 2010, 11:45 PM Posted to microsoft.public.access
Replies: 7
Views: 189
Posted By Gina Whipp
Access97 runtime

Mark,

It was a separate package and if I remember correctly not that cheap. I am
not sure you can get a copy unless you got one when it came out. (I'm
pretty sure I got it on an old machine...
Forum: General Discussion May 24th, 2010, 08:33 PM Posted to microsoft.public.access
Replies: 3
Views: 150
Posted By Gina Whipp
Using multiple databases

Jessica,

Well, even though you were unsure you answered my inquiry... though I have
some pretty *query heavy* databases I can see why you might want them
separate. To answer your question, yes...
Forum: General Discussion May 22nd, 2010, 06:28 AM Posted to microsoft.public.access
Replies: 10
Views: 409
Posted By Gina Whipp
Duplicate Field Names

Oops, junction table...

***Modified
Guardian - ID
relationship
isprimary

***Junction table
GuardianID
PeopleID
Forum: General Discussion May 22nd, 2010, 05:56 AM Posted to microsoft.public.access
Replies: 10
Views: 409
Posted By Gina Whipp
Duplicate Field Names

That table is set up like an Excel spreadsheet, so in your case that would
not work... Your table should be set up like this...

Guardian - ID
Peopleid
relationship
isprimary

--
Gina Whipp
Forum: General Discussion May 22nd, 2010, 05:53 AM Posted to microsoft.public.access
Replies: 2
Views: 244
Posted By Gina Whipp
Convert a field from long integer to Autonumber

forest8,

Unfortunately, unless you have access to an SQL Server no way to turn that
field into an Autonumber. Fortunately you can use...

Dmax("YourIDField","YourTable") + 1

You can place that on...
Forum: General Discussion May 22nd, 2010, 12:30 AM Posted to microsoft.public.access
Replies: 3
Views: 150
Posted By Gina Whipp
Using multiple databases

Jessica,

Actually, why not have one front end? Why did you create separate front
ends to do different tasks?

I would create one front end (or dashboard) and let all the Users use it.

--
Gina...
Forum: General Discussion May 20th, 2010, 06:29 AM Posted to microsoft.public.access
Replies: 1
Views: 99
Posted By Gina Whipp
thumbnail in field?

espee2,

You really don't want to store pictures in the database (though Access 2007
does handle images better), it cause bloating which will push your database
to it's max size very quickly. Try...
Forum: General Discussion May 11th, 2010, 04:36 AM Posted to microsoft.public.access
Replies: 3
Views: 145
Posted By Gina Whipp
I have microsoft 2007 and I cannot download templetes

Jill,

I assume you mean Office 2007? Which templates are you having difficulty
with? What happens when you try? What version of Internet Explorer? Any
Anti-Virus running?

--
Gina Whipp
2010...
Forum: General Discussion May 11th, 2010, 04:34 AM Posted to microsoft.public.access
Replies: 2
Views: 140
Posted By Gina Whipp
2007 Data Export Limit

zyus,

Yes it can handle 1mil rows... or there about. Are you using the
TransferSpreadsheet method? Like...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "QueryName",...
Forum: General Discussion May 11th, 2010, 04:29 AM Posted to microsoft.public.access
Replies: 1
Views: 71
Posted By Gina Whipp
Did I screw up

Terry,

Not sure what you mean by the relationship order... a wee bit more
information please. It might also help to show us the RecordSource of your
report. If a query then copy/paste the SQL...
Forum: General Discussion May 9th, 2010, 03:47 AM Posted to microsoft.public.access
Replies: 1
Views: 84
Posted By Gina Whipp
WordMerge

Will never take *candy* from strangers... This is an Access newsgroup and a
free Word Merge for Access is already available, no reason to look at yours.
Please move along...

--
Gina Whipp
2010...
Forum: General Discussion May 8th, 2010, 06:44 PM Posted to microsoft.public.access
Replies: 1
Views: 109
Posted By Gina Whipp
unbound text box

jwebster1979,

Several options available but which one(s) depends on what version of
Access...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,...
Forum: Running & Setting Up Queries May 6th, 2010, 03:39 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 299
Posted By Gina Whipp
Function is not availalbe in expressions in query expression error message (0/1)

Not sure what happened with SendObject... and that is not a Reference
issue. Unfortunately, tracking down errors is sometimes tedious (and
annoying). Did you change anything in the macro that...
Forum: New Users May 6th, 2010, 03:33 AM Posted to microsoft.public.access.gettingstarted
Replies: 5
Views: 338
Posted By Gina Whipp
Group Control Missing

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Forum: Running & Setting Up Queries May 5th, 2010, 12:56 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 299
Posted By Gina Whipp
Function is not availalbe in expressions in query expression error message (0/1)

Oh dear... missed that last line, no you can't but it surely sounds like a
Reference issue. Okay, when you open the database on your machine what
References are set?

As a side note, stop using...
Forum: New Users May 5th, 2010, 12:53 AM Posted to microsoft.public.access.gettingstarted
Replies: 5
Views: 338
Posted By Gina Whipp
Group Control Missing

he buttons you seek are to the left of those buttons, they have no
description or wording next to them. Just hover your mouse over the
controls.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I...
Forum: New Users May 4th, 2010, 03:06 AM Posted to microsoft.public.access.gettingstarted
Replies: 5
Views: 338
Posted By Gina Whipp
Group Control Missing

zyzzyva,

To Group and/or Ungroup go to the Arrange tab and then the Control Layout
section and the buttons to the left of *Snap to Grid* and *Tab Order*

--
Gina Whipp
2010 Microsoft MVP...
Forum: Running & Setting Up Queries May 4th, 2010, 12:36 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 299
Posted By Gina Whipp
Function is not availalbe in expressions in query expression error message (0/1)

Check the References on your Client's machine. Sounds like ther might be
one missing.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -...
Forum: General Discussion May 3rd, 2010, 03:26 AM Posted to microsoft.public.access
Replies: 1
Views: 83
Posted By Gina Whipp
Outline (function notation) :)

We don't do homework here... We answer questions related to Microsoft
Access the database software.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,...
Forum: General Discussion April 30th, 2010, 04:10 PM Posted to microsoft.public.access
Replies: 7
Views: 144
Posted By Gina Whipp
shut off Auto Correct for Word, Outlook, Excel but not Access

Unfortunately, not that I am aware of as it for *Office*.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors...
Forum: General Discussion April 29th, 2010, 09:30 PM Posted to microsoft.public.access
Replies: 7
Views: 144
Posted By Gina Whipp
shut off Auto Correct for Word, Outlook, Excel but not Access

Glad to help and glad we got sorted out!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors...
Forum: General Discussion April 29th, 2010, 05:41 PM Posted to microsoft.public.access
Replies: 7
Views: 144
Posted By Gina Whipp
shut off Auto Correct for Word, Outlook, Excel but not Access

Maybe I misunderstood, question...

Can I shut off the AutoCorrect function "replace text as you type" in all
but Access? Yes you can as it is set per program. If you are trying to do
it globally...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:26 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.