Path:
Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 07 Sep 2008 15:12:27 -0500
Newsgroups: comp.database.ms-access
Subject: Subroutine call sith same name for string and field - Can do?
From: CLEAVE6@comcast.net
Date: Sun, 7 Sep 2008 20:12:27 GMT
X-Newsreader: News Rover 13.1.2 (http://www.NewsRover.com)
Message-ID: comcast.com>
Lines: 19
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 71.200.177.222
X-Trace:
sv3-HMrnvrNRMhRESRddWhjqOjGYSzc574eOGgkOtDN7ZslXO2PugyK88pUDT3TacQwpG1yZjaxfQpT2LUo!PouYBo1hMsSosNLhmCbqkR/WdTk4GWAHKqcc8GXQ2hkzvTP7BlSLhX/civlBxpcitO7VeCxcMac/!pJxeW89CX8ppMdhSkWQ04rItCICq7lA=
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint
properly
I want to create a text file with a name which is the same as a field name ...

I want to create a text file with a name which is the same as a field name
and print to that file based on the contents of that field. I would like to
do this with a subroutine call.

there are fields in a table A, B, C etc. (all are boolean).

I want to write a text file

call subx("A")

Private subx(S as string)
Open "c:\XXX" & S & ".TXT" For Output As #1 ' no problem with this
.
.
If S = true then.....

Obviously this doesn't work; can I do something like this somehow?

Dick

I need to copy an entire database from my desktop to my laptop, both
machines have Access 2003
Any advice will be appreciated

=======================================
Get A GPS Today At A Low Price!!
http://www.GPSTakesYou.com
=======================================

GPS Devices www.gpstakesyou.com

=======================================

2X[k \p\)Q\]wCIm @4n&

I am an old FoxPro programmer having trouble transitioning to Access,
and I have a hot project to work on.

I have a record for a company. That record has a field of account
numbers. The account number field can have from 1 to 16 account
numbers in it, separatd by a ; or semicolon. (Shades of PICK).

How do I convert this type of record

ABC Co, Main Street, Anywhere, PA, 1234;1237;1239;1290

to this

ABC Co, Main Street, Anywhere, PA, 1234
ABC Co, Main Street, Anywhere, PA, 1237
ABC Co, Main Street, Anywhere, PA, 1239
ABC Co, Main Street, Anywhere, PA, 1290

How do I do it in Access?

Mainly I can't find references to do what I thought were common
database functions, such as

1. stepping through a table's recrods and

2. adding a record to a second table based on some sort of processing
logic.

Hi
How can I disable the close button in access 2007. Reason I want to force a
backup on exit and now I cant. The code for Access 2003 to disable close
button does not work in Access 2007
Thanks
Alfred

Dell 530 desktop

After several blue screens and other hassle, I got Office XP to
install. Everything seems fine except for Access Xp

I using the 1012 as default printer. If I try and use the Print or
Print Preview Icons, It may or may not work. It doesn't matter if it
is in the Tool bar on top or drop down menu.

However If I change the default to a Hp Photosmart 7350 using a HP5550
Driver, if things work fine.

I am using this as a work around right now pending a better solution.
Created and work on database. When things look right. Save DB and go
out and make 1012 default and Print it.

Any ideas why?

Ed

Posted Via Usenet.com Premium Usenet Newsgroup Services

I'm hoping for some guidance here! The problem is this: I am running Access
97 under Vista, everything works great except I have a macro that does a
mail merge with data from the database into a word document. When I invoke
the mail merge, the open file dialog opens, I select the word document that
i want to merge to and then i get "Error: Type 13 Mismatch". I am thinking
that it has to do with visual basic versions. Any Suggestions??