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
   ► MB Lobby   Print This     

Don G Message Board Activity

  


8 Message Board Posts:


Thread 8 of 8
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 7 of 8
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 6 of 8
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 5 of 8
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 4 of 8
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 3 of 8
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
2791
Hits

Microsoft Access

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

Don G
RE: Adding data from VB into Access
Use a query to calculate the takings and either combine the query with your member table to provide a summary of info or feed the query to a report.  Reports are prettier and can provide details as well as totals, but queries are quicker if you just need totals.
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 8
Thread Starter or a Reply (but not last)  Group

lerry1989
Adding data from VB into Access
I am writing a program with VB. It is connected to Microsoft Access so the user can add member details to the form and when they press save, the details are stored in the Database but I also need to create reports so the user can calculate their monthly takings. Does anyone have a basic way of doing this that I can easily adapt?, , Thanks
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago

Don G
Use a query to calculate the takings and either combine the query with your member table to provide a summary of info or feed the query to a report.  Reports are prettier and can provide details as well as totals, but queries are quicker if you just need totals.
13 years ago
Nothing New Since Your Last Visit
2767
Hits

Microsoft Access

Follow PrestwoodBoards on: 


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