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 52
Search took 0.01 seconds.
Search: Posts Made By: Bob Hansen
Forum: Access July 15th, 2009, 01:53 PM
Replies: 2
Views: 847
Posted By Bob Hansen
I was able to get a solution from a Microsoft...

I was able to get a solution from a Microsoft page:http://support.microsoft.com/kb/208923

The solution for me was the following code, using RunCommand vs. DoCmd:
SendKeys "%hs%n"
RunCommand...
Forum: Access July 15th, 2009, 12:11 PM
Replies: 2
Views: 847
Posted By Bob Hansen
Changing Match option on Find/Replace form

The line
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
brings up the Find and Replace dialog.

The default value for the Macth field is 'Whole field'

How can I automatically set...
Forum: Access VBA May 6th, 2006, 01:19 AM
Replies: 1
Views: 1,912
Posted By Bob Hansen
Line Item Numbers needed

Using a sub form to add line items to an order, want a line item number as a reference. The table for the subform has a field to store the value. Right now the line item is being entered manually...
Forum: Word VBA April 10th, 2006, 10:34 AM
Replies: 0
Views: 1,549
Posted By Bob Hansen
Protect Document Limitations

I need to retain the ability to lock documents, but need to limit the password to the current users network password.

History:
Employees have need to lock documents, but when they leave...
Forum: BOOK: Expert One-on-One Access Application Development July 30th, 2004, 05:07 PM
Replies: 7
Views: 2,713
Posted By Bob Hansen
In addition to different format, they are now in...

In addition to different format, they are now in about 17 different files. I was frustrated initially when I had do the download process three times for the original ZIP files that were there.
...
Forum: Access VBA July 25th, 2004, 05:34 PM
Replies: 6
Views: 4,751
Posted By Bob Hansen
One more comment on Macro Scheduler...

One more comment on Macro Scheduler (www.mjtnet.com). "Pricey" is always relative. But, it also allows you to make compiled run time versions of the scripts and distribute for free, no licensing,...
Forum: Access VBA July 20th, 2004, 11:11 PM
Replies: 6
Views: 4,751
Posted By Bob Hansen
Take a look at using Macro Scheduler. I use it...

Take a look at using Macro Scheduler. I use it with windows and DOS programs daily.

Available for free download at www.mjtnet.com.

Latest version is 7.2.050 I think. Too many features to...
Forum: Access July 14th, 2004, 09:12 AM
Replies: 6
Views: 1,861
Posted By Bob Hansen
Rather than discussing form components for a...

Rather than discussing form components for a moment, I think that blackman has this type of problem:

He has an PO listing several part numbers of items purchased. He wants to click on the third...
Forum: BOOK: Expert One-on-One Access Application Development July 12th, 2004, 10:43 PM
Replies: 8
Views: 2,166
Posted By Bob Hansen
Thanks for the explanation Helen. I think I can...

Thanks for the explanation Helen. I think I can follow that OK.
Forum: Access VBA July 12th, 2004, 12:32 PM
Replies: 3
Views: 1,464
Posted By Bob Hansen
Thanks for cleaning and clearing that up Greg.

Thanks for cleaning and clearing that up Greg.
Forum: Access VBA July 12th, 2004, 10:37 AM
Replies: 3
Views: 1,464
Posted By Bob Hansen
Try using "date()" vs. "now()", and "less than"...

Try using "date()" vs. "now()", and "less than" vs. "is not"

Select * from user where user.date < date() and user.activation is null;
Forum: BOOK: Expert One-on-One Access Application Development July 9th, 2004, 09:56 PM
Replies: 8
Views: 2,166
Posted By Bob Hansen
Reference Libraries

Hello Helen.....glad to see you reviewing the forum, looks like you hit every item posted. Thanks for a great reference book.

Question: It seems like many of the problems are related to missing...
Forum: Access VBA July 6th, 2004, 11:46 PM
Replies: 4
Views: 3,334
Posted By Bob Hansen
You may also want to look at the system value...

You may also want to look at the system value formats for dates in Control Panel, Regional Settings to see if you can make an easier change there. But rmemeber that any chaage there will also affect...
Forum: BOOK: Expert One-on-One Access Application Development July 4th, 2004, 11:36 AM
Replies: 8
Views: 1,139
Posted By Bob Hansen
You said: "B U T the author fails to to do that,"...

You said: "B U T the author fails to to do that," Curious to know how you determined that. In the downloaded code? I have not personally gotten that far in the book yet.

I can't speak for the...
Forum: BOOK: Expert One-on-One Access Application Development July 3rd, 2004, 11:07 PM
Replies: 8
Views: 1,139
Posted By Bob Hansen
I will repeat a portion of my earliet posting...

I will repeat a portion of my earliet posting that I guess you may have overlooked:
=================================================

I believe that you must have CheckData() triggered in the...
Forum: BOOK: Expert One-on-One Access Application Development July 3rd, 2004, 05:26 PM
Replies: 8
Views: 1,139
Posted By Bob Hansen
See page 271, 4 lines from bottom for Sub...

See page 271, 4 lines from bottom for Sub CheckData(). The routine continues through all of page 272.

I believe that you must have CheckData() triggered in the After Update Events for cboToyID,...
Forum: BOOK: Expert One-on-One Access Application Development June 29th, 2004, 07:17 PM
Replies: 14
Views: 1,825
Posted By Bob Hansen
Re the comment: "As I type this note there is...

Re the comment:
"As I type this note there is nothing listed for this book's errata. So it's likely that whatever you have discovered is news to us, and we'd like to share that information with...
Forum: Access VBA June 29th, 2004, 07:12 PM
Replies: 2
Views: 1,514
Posted By Bob Hansen
You could have one printer already configured as...

You could have one printer already configured as Landscape as the default. Then you could send the Report, always selecting that specific printer.
Forum: Access VBA June 25th, 2004, 01:13 AM
Replies: 1
Views: 2,205
Posted By Bob Hansen
Function to run an executable

I hate to ask with such a basic issue.....[:I]...too many hours, gotta take a break.....

I would appreciate a sample function to run an executable program using VB code. I think it may look...
Forum: BOOK: Expert One-on-One Access Application Development June 23rd, 2004, 09:59 PM
Replies: 6
Views: 1,270
Posted By Bob Hansen
Thanks for pointing that out, tlwaltz. I...

Thanks for pointing that out, tlwaltz.

I should have looked further down the Figure 2.20. I stopped looking at the first two fields.[:I]

I now see the field (4th) being referenced. And...
Forum: BOOK: Beginning Access VBA June 20th, 2004, 10:22 PM
Replies: 5
Views: 4,155
Posted By Bob Hansen
Check out this page, where you may possibly find...

Check out this page, where you may possibly find the code: http://www.wrox.com/dynamic/books/download.aspx
Forum: Access June 18th, 2004, 08:59 AM
Replies: 6
Views: 932
Posted By Bob Hansen
Cannot do that directly only using a table. If...

Cannot do that directly only using a table. If you don't want to use a form then you could run an update query to fill in the combined data.

Does this combined value really need to be saved in a...
Forum: Access VBA June 16th, 2004, 05:06 PM
Replies: 3
Views: 1,301
Posted By Bob Hansen
For JohnKruse: I think that this is the...

For JohnKruse:

I think that this is the forum for that book.
http://p2p.wrox.com/forum.asp?FORUM_ID=13

It is one forum for all of the issues since my 97 version.
Forum: Access June 16th, 2004, 04:55 PM
Replies: 3
Views: 3,165
Posted By Bob Hansen
The Yes/No type field is a boolean type. And the...

The Yes/No type field is a boolean type. And the True value of booleans in Access is "-1", not "1" as in many other languages.

Need something like:
If StillActive=-1 then append to table1
Else ...
Forum: BOOK: Expert One-on-One Access Application Development June 16th, 2004, 01:09 PM
Replies: 7
Views: 5,234
Posted By Bob Hansen
My thoughts were already submitted on 6/5/04 in...

My thoughts were already submitted on 6/5/04 in response to a similar question. Can be found at: http://p2p.wrox.com/topic.asp?TOPIC_ID=14277
Showing results 1 to 25 of 52

 


All times are GMT -4. The time now is 03:09 PM.


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