I.T. Discussion Community!
National-Louis University, Don Grady -Collapse +Expand
-Collapse +Expand
Don G
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (5)

Search Don G:

Advanced
Personal Account . . .
Don G
Elgin, IL USA



Real Name:  Don Grady
Primary Role:  Management
Title:  Executive Director
Company:  National-Louis University
Joined: Jul 2007 (13 years ago)
Visits: 8

Message Boards Activity

5 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

Don G
Replacing quotes with VBA in Access
I am downloading data from a web survey into a txt file that I then import into Access.  Users are inserting "quotes" in their comment fields.  I am cleaning up the comments in the txt file by reading them into variables and using the REPLACE function to remove jargon (e.g. &LF; is replaced withBig Grin!. That works fine, but I have tried to REPLACE the quotes with ^ or single quote but I can't get VBA to read the quotes. I have even used Chr(34) and it is not recognized.  How do I REPLACE quotes in substrings?
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago

mprestwood
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
7184
Hits

Microsoft Access

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

Don G
New guy on the block
I just joined the group and am interested in seeing if I can learn more about VBA to augment my MS Access skills.  I build user friendly applications for streamlining processing tasks within our University including downloading web based surveys to Access and analyzing feedback trends. , I have been using Access for about 10 years, Paradox before that.  I love creating integrated applications with MS Word, Outlook, etc. to generate personalized email blasts and reminders.  Fun, fun, fun. See you on the boards!
13 years ago

Wes
Hi Don.  Although I'm not a real VBA guy, I've always had a high regard for the database behind Access (Jet), and I've written many applications (in Delphi) that use the Jet database engine. Welcome! There are a lot of Access, VBA, and Paradox mavens around here. Wes  
13 years ago
Nothing New Since Your Last Visit
1987
Hits

PrestwoodBoards

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

DSW05
Simple Copying Macro
I have created a macro in Ms Access that selects certain rows and columns. Next I need the macro to copy the selected so I can use a simple past function. Simple right? NO! Banging Head On Wall I can't find a command in Access to copy! In every other Office program this command is "selection.copy", but not in Access. Please help; it is something I desperately need for my job. Worried
Posted to MB Topic: Access VBA Programming « Access Board
16 years ago

Don G
Consider using a query to select the data you want.  Then make it an Append or  Make-Table query to create a temporary table or copy (append) your data into another table. 
13 years ago
Nothing New Since Your Last Visit
2748
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

Don G
RE: Simple Copying Macro
Consider using a query to select the data you want.  Then make it an Append or  Make-Table query to create a temporary table or copy (append) your data into another table. 
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

Don G
RE: Passing Value From One Query to Another
Your first query becomes input for your second query.  Just drag and drop the field from the first query to your new query design.  It works like a charm.  When you execute the 2nd query, it automatically updates results from the 1st query for its input.  Hope this helps.
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

jdoody
Passing Value From One Query to Another
Hi all! I'm new to this site, which I just happened to stumble upon. I have a question that is probably easy for a seasoned Access user. I have created a series of queries and have linked them in order to create a report consisting of current and prior year budget to actual totals. I am wondering how to pass values between queries - for example, user enters "6" - for month 6 - in query 1, how do I access this "6" as input for query 2?
Posted to MB Topic: Access VBA Programming « Access Board
18 years ago

Don G
Your first query becomes input for your second query.  Just drag and drop the field from the first query to your new query design.  It works like a charm.  When you execute the 2nd query, it automatically updates results from the 1st query for its input.  Hope this helps.
13 years ago
Nothing New Since Your Last Visit
2793
Hits

Microsoft Access
More...

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech