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 4.87 seconds.
Search: Posts made by: Rick Brandt
Forum: New Users June 5th, 2010, 07:19 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,046
Posted By Rick Brandt
Does SQL Run Behind Queries?

trip_to_tokyo wrote:

Access 2007

When I run a query does Access, "go away" and run the SQL for what I see
in the GUI?

If the answer is, "yes" is there anything that I can switch on to...
Forum: General Discussion June 4th, 2010, 07:31 AM Posted to microsoft.public.access
Replies: 9
Views: 709
Posted By Rick Brandt
Only change font fomat in select words within a memo field

garvic82 wrote:

I have tried it that way, but it just changes all of the text in the memo
box
and not just what was selected. And I don't see an option to change this
to
Rich Text in the...
Forum: New Users June 3rd, 2010, 10:44 AM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 3,935
Posted By Rick Brandt
Let's pick a replacement for this (Access) newsgroup

John W. Vinson wrote:

On Tue, 01 Jun 2010 20:03:55 +0200, Steve Hayes
wrote:

Will the replacement one connect to Microsoft?

THIS one won't, that's for...
Forum: General Discussion June 2nd, 2010, 07:20 PM Posted to microsoft.public.access
Replies: 3
Views: 414
Posted By Rick Brandt
Barcode Labels

gonzo wrote:

Now I know im not the only one who has had problems trying to print their
own barcode labels. I started trying to print my own about 6 months ago
but kept encountering lots of...
Forum: Using Forms June 2nd, 2010, 07:27 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 924
Posted By Rick Brandt
How do I repeat my header on each page of an access form

Evon wrote:

[email protected]#$%^&*?! I am frustrated. I want to repeat a header on each form. Help
states that there is a repeat property that needs to be set to yes. I
can't
find it anywhere! I've...
Forum: Using Forms June 2nd, 2010, 06:58 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 334
Posted By Rick Brandt
BoundColumn property

gator wrote:

Can someone please explain in layman terms, the purpose of BoundColumn in
ComboBox in terms of viewing two columns when dropped down and storing one
value in the table and...
Forum: General Discussion May 30th, 2010, 10:48 PM Posted to microsoft.public.access
Replies: 8
Views: 444
Posted By Rick Brandt
open form with no data

Pierkes wrote:

Hi Rick,

I tried to reply to the group earlier but didn't see it appearing so
here's another go...

Thanks for your code, it works !

However, i do not use the...
Forum: General Discussion May 30th, 2010, 07:56 PM Posted to microsoft.public.access
Replies: 8
Views: 444
Posted By Rick Brandt
open form with no data

Pierkes wrote:

Hi,

I have a form on which i present al lot of data from a database.
On the form is a comobox which i use to select the right record en present
the data of this record on...
Forum: General Discussion May 25th, 2010, 07:22 AM Posted to microsoft.public.access
Replies: 26
Views: 422
Posted By Rick Brandt
MS Rant - TabIndexes

Dirk Goldgar wrote:

"Tony Toews [MVP]" wrote in message
...
"Dirk Goldgar" ...
Forum: General Discussion May 19th, 2010, 07:27 AM Posted to microsoft.public.access
Replies: 6
Views: 198
Posted By Rick Brandt
Getting 'Smart Quotes' out of Access

Arvin Meyer [MVP] wrote:

"Excuse me, but my Notepad is using Courier New, and it doesn't have curly
quotes" I think I set that up to match the font I use in the IDE code
window.

Smart quotes...
Forum: General Discussion May 18th, 2010, 07:27 AM Posted to microsoft.public.access
Replies: 15
Views: 680
Posted By Rick Brandt
Quit macro not working in runtime

Owl wrote:

Thank you for your reply, Dirk.

The actions in my Quit macro (which works - to exit the database - on
every single other database I use OUT of Runtime) are simply Quit (and of
...
Forum: General Discussion May 12th, 2010, 07:33 AM Posted to microsoft.public.access
Replies: 5
Views: 108
Posted By Rick Brandt
convert dd and mm and yy fields to one dd/mm/yy field

Vic33 wrote:

Phew, you assume that I know what I'm doing! Can't I just use the
dateserial
function? I've tried this: set [datefield] =
dateserial([day],[mo],[yr]);
to no avail. My...
Forum: General Discussion May 10th, 2010, 07:33 AM Posted to microsoft.public.access
Replies: 9
Views: 262
Posted By Rick Brandt
Wise to set up user level security for a multi FE MDB ??

Sunny Ho wrote:

I am currently using MS 2003 and work on a multi-user database.

I have reviewed previous posts in the forum and followed their advise
achieved in spliting the database to FE...
Forum: Database Design April 28th, 2010, 10:37 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 11
Views: 571
Posted By Rick Brandt
What are AutoNumber Dangers

Barry A&P wrote:

I recently viewed a post that said "autonumber is fine as long as you dont
display it to the user..." Everything in my database references
autonumbers!! did i make a big...
Forum: Running & Setting Up Queries April 18th, 2010, 04:35 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 109
Posted By Rick Brandt
Acccess 2007 Runtime and Queries

MChrist wrote:

While I've created MDE files before, I've never used the Runtime for
Access. I was wondering if the runtime limits you to only running existing
queries, or can you modify them...
Forum: Setting Up & Running Reports April 13th, 2010, 10:36 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 142
Posted By Rick Brandt
Memo Field Cut Off

jschping wrote:

Hi,

I have a report that works off a query, including some memo fields. In the
report, they are getting cut off.

I already have the controls set to Can Grow, and I know...
Forum: Running & Setting Up Queries April 13th, 2010, 10:35 AM Posted to microsoft.public.access.queries
Replies: 8
Views: 108
Posted By Rick Brandt
Opinion about aggregates

AccessKay wrote:

I’m fairly new to Access so this may be an inane question to all those
experienced people out there. My question is about the use of aggregates
in
a query. I’m...
Forum: General Discussion April 12th, 2010, 06:56 PM Posted to microsoft.public.access
Replies: 2
Views: 120
Posted By Rick Brandt
Where to add a Toolbar to start it up with Access, not the databas

DawnTreader wrote:

Hello All

I have been developing for a while now and i have started to gather a
bunch of tools that are making my life easier. however some are hidden
away on the add...
Forum: Setting Up & Running Reports March 25th, 2010, 07:32 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 164
Posted By Rick Brandt
Run report without running access?

GWB wrote:

Hi - Dumb question:
To keep it simple, can I create a link or shortcut for a report so that
with a click of the mouse the report will show?

You can have it open Access, then your...
Forum: Database Design March 25th, 2010, 07:40 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 665
Posted By Rick Brandt
Database Runtime Question

MFulton via AccessMonster.com wrote:

So basically once the runtime is installed, runtime users will have access
to
any changes made to the actual database as they are made. For example,
...
Forum: Database Design March 24th, 2010, 07:26 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 665
Posted By Rick Brandt
Database Runtime Question

MFulton via AccessMonster.com wrote:

I am designing a database in Access 2003. It is almost complete other
then the fact I need to create a runtime for it to enable PCs without
Access to
...
Forum: Using Forms March 21st, 2010, 02:58 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 72
Posted By Rick Brandt
How to automatically move to next field after Bar/EAN code entry?

Stephen8667 wrote:

Table Columns: EAN Code; Product Name; Order Qty
Form Fields: EAN Code as a combo box; Product Name (No Tab stop); Order
Qty. Question: The cursor is in the Cbo Box. I am...
Forum: General Discussion March 21st, 2010, 09:01 AM Posted to microsoft.public.access
Replies: 1
Views: 101
Posted By Rick Brandt
Unable to send email in HTML format

Greg wrote:

I have the following code and for some reason I am unable to send email in
HTLM format. Email in formated in Rich Text format and I want to add bold
fonts and differnt color to ...
Forum: Database Design March 20th, 2010, 08:12 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 543
Posted By Rick Brandt
Navigation Pane unhides when creating liked table

HarkitsMark wrote:

I have a runtime/accde app to be distributed to users that can't have
access to the nav pane or objects, and even though I've disabled special
keys, including shift keys,...
Forum: General Discussion March 18th, 2010, 12:23 PM Posted to microsoft.public.access
Replies: 1
Views: 243
Posted By Rick Brandt
SendObject doesn't find fields in querry

J.Bennett wrote:
I have a form that has a button to run an "event Procedure" to preview a
report, and to email the report as a pdf attachment. The codes I use are
as follows:

Private Sub...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 02:15 AM.


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