Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 245
Search took 0.01 seconds.
Search: Posts Made By: HiTechCoach
Forum: Access VBA May 15th, 2017, 04:39 PM
Replies: 1
Views: 752
Posted By HiTechCoach
You should be able to do what you stated within...

You should be able to do what you stated within Access.
Forum: Access VBA February 23rd, 2017, 02:10 AM
Replies: 2
Views: 1,011
Posted By HiTechCoach
The only idea I have without seeing the SQL for...

The only idea I have without seeing the SQL for the query qrySSRenewalDErnie is that the query is a SELECT query not an action query.

Sorry, my crystal ball in out of order. [:D] Please post the...
Forum: Access January 30th, 2017, 09:31 PM
Replies: 1
Views: 1,106
Posted By HiTechCoach
After some experiments with them, I have always...

After some experiments with them, I have always avoided the attachment data type for desktop databases. There are many posts from people having issues with it. I have also had lots of issues with...
Forum: Access VBA January 30th, 2017, 09:22 PM
Replies: 1
Views: 1,146
Posted By HiTechCoach
You should be able to redirect the output to file...

You should be able to redirect the output to file and the read it with VBA. I do this with several command line tools.

See: Using command redirection operators ...
Forum: Access VBA October 12th, 2015, 04:26 PM
Replies: 3
Views: 2,053
Posted By HiTechCoach
Laide Onabanjo, This is a very old post....

Laide Onabanjo,

This is a very old post. You should only reply to a thread if you are trying to answer the original post.

Please start a new post to as your question. Look for the New Thread...
Forum: Access VBA October 9th, 2015, 04:52 PM
Replies: 4
Views: 1,198
Posted By HiTechCoach
Does the book not show you how to create the...

Does the book not show you how to create the example yourself?

If it does, creating it all yourself will really be the best way to really learn.
Forum: Access VBA September 24th, 2015, 01:39 PM
Replies: 1
Views: 800
Posted By HiTechCoach
Here is site that has a great tool for updating...

Here is site that has a great tool for updating your back end.

http://btabdevelopment.com/free-access-tools/
Forum: Visual Basic 2010 General Discussion September 11th, 2015, 06:43 PM
Replies: 1
Views: 1,549
Posted By HiTechCoach
Sounds like what you wan to do is often called...

Sounds like what you wan to do is often called cascading combo boxes.

Note: This does not work well for a form in datasheet or continuous view modes.

I would expect that you have a manufacture...
Forum: Access September 11th, 2015, 06:36 PM
Replies: 1
Views: 567
Posted By HiTechCoach
I am not sure is yo want ro add (insert/append ...

I am not sure is yo want ro add (insert/append query) the skill or update an existing record.

If ass the skill to the staff when why add the records?

If the record not not exist would mean...
Forum: Access VBA September 2nd, 2015, 04:46 PM
Replies: 1
Views: 671
Posted By HiTechCoach
What is the erro mesage? The...

What is the erro mesage?






The first issue that I spotted was that you need an extra space at the beginning the continuation lines after the quotes.

"FROM LINE_ID,...
Forum: Access August 24th, 2015, 04:12 PM
Replies: 4
Views: 699
Posted By HiTechCoach
Thanks for the update. Great job figuring it...

Thanks for the update.

Great job figuring it out!

Good luck with your project.
Forum: Access August 24th, 2015, 12:30 PM
Replies: 4
Views: 699
Posted By HiTechCoach
I would use an Update query. You can build it...

I would use an Update query. You can build it with VBA code and run it.

How will you know which records to update?
Forum: Access July 19th, 2015, 09:27 PM
Replies: 1
Views: 749
Posted By HiTechCoach
Splitting is really the Best Practices method to...

Splitting is really the Best Practices method to continue any development.

I actually start EVERY Access application split. It makes development much easier.

Here are my thoughts and TIPS on...
Forum: Access March 20th, 2015, 03:28 PM
Replies: 2
Views: 637
Posted By HiTechCoach
Need more details about the database. Can...

Need more details about the database.

Can you post the code you have tried so far.

Also see these previous posts:

http://p2p.wrox.com/access-vba/86460-using-variable-recordset.html
...
Forum: Access March 4th, 2015, 06:04 PM
Replies: 3
Views: 788
Posted By HiTechCoach
Yes. Only very simple forms can be be...

Yes.

Only very simple forms can be be switch to datasheet view.

In over 15 users using Access I have rarely switch a form to datasheet view.

I find that a properly normalized (well...
Forum: C# 4.0 aka C# 2010 General Discussion March 3rd, 2015, 06:19 PM
Replies: 5
Views: 9,824
Posted By HiTechCoach
see: ...

see:

http://www.wrox.com/WileyCDA/Section/C-and-C-.id-105059.html?sort=DATE&sortDirection=DESC
Forum: Access March 3rd, 2015, 06:15 PM
Replies: 1
Views: 582
Posted By HiTechCoach
Are you building desktop or web databases? ...

Are you building desktop or web databases?

Access 2010 24-Hour Trainer
by Geoffrey L. Griffith, Truitt L. Bradly
...
Forum: Access March 3rd, 2015, 05:18 PM
Replies: 3
Views: 788
Posted By HiTechCoach
The short answer is that you will not be able to...

The short answer is that you will not be able to use datasheet view with your current form design.
Forum: Access VBA March 3rd, 2014, 12:59 PM
Replies: 4
Views: 1,623
Posted By HiTechCoach
Cross posted here:...

Cross posted here: http://www.vbaexpress.com/forum/showthread.php?49070-Grid-Control-Rows-Not-Displaying-Selected-State-Correctly&p=305855#post305855
Forum: Access February 19th, 2014, 12:43 PM
Replies: 1
Views: 610
Posted By HiTechCoach
Yes it is possible to do what yu want. It will...

Yes it is possible to do what yu want. It will require a high programming skill level.

Since you are new to Access you may want to check out: Dashboard BuilderTM for Microsoft® Access®...
Forum: Access VBA February 17th, 2014, 03:22 PM
Replies: 1
Views: 1,676
Posted By HiTechCoach
Sending is normally done through some SMS gateway...

Sending is normally done through some SMS gateway . What service re you using for your SMS gateway?

It is also possible to send Text messages via email if you now the recipient's provider.

I...
Forum: Access VBA January 19th, 2014, 06:11 PM
Replies: 6
Views: 5,674
Posted By HiTechCoach
Great job figuring it out. [:)] Thanks for...

Great job figuring it out. [:)]

Thanks for posting your solution.
Forum: Access VBA January 18th, 2014, 05:53 PM
Replies: 6
Views: 5,674
Posted By HiTechCoach
Looks like the closing ) for the sub query is out...

Looks like the closing ) for the sub query is out of place. Needs to be after the "as toe"

Try:


Set rsABCDd3min = db.OpenRecordset("Select t.* from ABCDdown3Minutes as t INNER Join (SELECT...
Forum: Access VBA January 11th, 2014, 01:47 AM
Replies: 1
Views: 4,500
Posted By HiTechCoach
I save my mail merge source documents as a...

I save my mail merge source documents as a template to prevent them from being over written.
Forum: Access VBA December 31st, 2013, 12:35 AM
Replies: 1
Views: 1,399
Posted By HiTechCoach
Here are the two ways I pass data: 1) Push ...

Here are the two ways I pass data:

1) Push

a) You can use the OpenArgs parameter of the DoCmd.OpenForm to pass pus the data to the form it opens. When the other form opens use the Form's On...
Showing results 1 to 25 of 245

 


All times are GMT -4. The time now is 08:47 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.