Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
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 38
Search took 0.01 seconds.
Search: Posts Made By: boblarson
Forum: BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 December 27th, 2010, 01:32 PM
Replies: 8
Views: 3,648
Posted By boblarson
Turns out I don't have this particular book (I...

Turns out I don't have this particular book (I could have sworn that I did). So I apologize for posting. I was hoping to help out and can't it would appear. Sorry about that.
Forum: BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 December 24th, 2010, 05:29 PM
Replies: 8
Views: 3,648
Posted By boblarson
This is old, but I'm curious - where in the book...

This is old, but I'm curious - where in the book does it talk about this? And what is your purpose of modifying the manifest? As far as I know, you aren't modifying the existing manifest in YOUR...
Forum: Access VBA December 24th, 2010, 03:02 PM
Replies: 11
Views: 4,350
Posted By boblarson
Also, to go with Boyd's reply, you also are...

Also, to go with Boyd's reply, you also are including too many tables in the FROM and then also should use a join on tbl_OrderInfo : (I also included the extra spaces so it is obvious)

SQL =...
Forum: Access December 24th, 2010, 01:57 PM
Replies: 1
Views: 1,954
Posted By boblarson
I would use Me.Controls("heb" &...

I would use

Me.Controls("heb" & G_Grid).SetFocus

And sometimes you might need to concatenate first:

Dim strCtl As String

strCtl = "heb" & G_Grid
Forum: Access VBA May 8th, 2009, 06:31 PM
Replies: 2
Views: 3,418
Posted By boblarson
Go to the startup options and remove the USE...

Go to the startup options and remove the USE ACCESS SPECIAL KEYS checkmark from the checkbox. That should do it for you.
Forum: Access May 7th, 2009, 05:52 PM
Replies: 2
Views: 1,637
Posted By boblarson
If it is a single select list box then you can...

If it is a single select list box then you can just reference it in the query as criteria. If it is multi-select then you would need to build the criteria by iterating through using VBA. Which do...
Forum: Access VBA April 23rd, 2009, 03:33 PM
Replies: 5
Views: 4,791
Posted By boblarson
If you put the sub report in and then make the...

If you put the sub report in and then make the section and the subreport as Can Grow, you can basically make the sub report itself in Design View just a minimal object just big enough to be able to...
Forum: BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 April 23rd, 2009, 01:40 PM
Replies: 4
Views: 42,260
Posted By boblarson
Glad you got things to work for you. :) Thanks...

Glad you got things to work for you. :) Thanks for letting me know that you had gotten it taken care of.
Forum: Access April 22nd, 2009, 07:41 PM
Replies: 2
Views: 760
Posted By boblarson
I also just want to say - I'm not trying to be...

I also just want to say - I'm not trying to be difficult just for the sake of being difficult. Letting users create objects within a database is risky, not only from a standpoint of them screwing...
Forum: Access VBA April 22nd, 2009, 06:18 PM
Replies: 1
Views: 1,799
Posted By boblarson
While the database is open, go to TOOLS >...

While the database is open, go to TOOLS > DATABASE UTILITIES > CONVERT DATABASE and select the 2002-2003 version.
Forum: BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 April 22nd, 2009, 02:41 PM
Replies: 1
Views: 2,619
Posted By boblarson
I know that this is over a month old, but I...

I know that this is over a month old, but I thought I would try answering for future use.

It would appear that gobjRibbon has not been instantiated and therefore you get the Error 91.
Forum: Access April 22nd, 2009, 02:39 PM
Replies: 2
Views: 760
Posted By boblarson
I'm sorry, but I have to ask WHY do you need to...

I'm sorry, but I have to ask WHY do you need to let a user create a new query in your program? If they need to do their own queries then it should be done from a separate linked database and they...
Forum: BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 April 22nd, 2009, 12:41 PM
Replies: 4
Views: 42,260
Posted By boblarson
And I forgot to say how you run it... Either...

And I forgot to say how you run it...
Either like:

CurrentDb.Execute strSQL, dbFailOnError


or

On Error GoTo err_handler
Forum: BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 April 22nd, 2009, 12:36 PM
Replies: 4
Views: 42,260
Posted By boblarson
This is almost a month old, but here goes: ...

This is almost a month old, but here goes:

1. Create your make table query in the QBE grid and then

2. take the SQL of that to the VBA Window

3. You can then modify the SQL code

for...
Forum: Access VBA April 22nd, 2009, 12:28 PM
Replies: 2
Views: 957
Posted By boblarson
You will need to do a search (Google for...

You will need to do a search (Google for Microsoft Access Resize) for a form resizer. I know there is something out there for free but there is also some pay ones (Peter's Software I think is one of...
Forum: BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 April 21st, 2009, 12:47 PM
Replies: 1
Views: 1,574
Posted By boblarson
Have you gotten this fixed yet? If not, post...

Have you gotten this fixed yet? If not, post back and we can try to help. It would seem that the form can't find something so I was wondering if your table name wasn't assigned properly. Anyway,...
Forum: Access VBA April 21st, 2009, 12:43 PM
Replies: 3
Views: 3,940
Posted By boblarson
Glad to hear! :)

Glad to hear! :)
Forum: BOOK: Access 2003 VBA Programmer's Reference April 20th, 2009, 07:21 PM
Replies: 1
Views: 2,761
Posted By boblarson
This is a bit old but just as an FYI for anyone...

This is a bit old but just as an FYI for anyone following on. You can get the count of records from a table by using this:

DCount("*", "YourTableNameHere")

That is a very simple way.
Forum: Access VBA April 20th, 2009, 01:21 PM
Replies: 3
Views: 3,940
Posted By boblarson
If your PDF Reader is the default then you should...

If your PDF Reader is the default then you should be able to use this (as long as the entire path is in txtSubject). If not you would need to create the path first.

FollowHyperLink Me.txtSubject
Forum: Access April 17th, 2009, 03:24 PM
Replies: 3
Views: 899
Posted By boblarson
It should not IF (and this is a big IF) you have...

It should not IF (and this is a big IF) you have split the database (backend with tables on the server) and a COPY of the frontend on EACH user's machine. This is the way it SHOULD be set up for...
Forum: Access VBA April 8th, 2009, 07:31 PM
Replies: 7
Views: 1,010
Posted By boblarson
If I read this correctly, I am seeing it...

If I read this correctly, I am seeing it differently than anyone else. I thought you wanted to let them cancel out if they choose cancel. The simplest way is just to change this part:

...
Forum: Access April 8th, 2009, 06:34 PM
Replies: 2
Views: 1,229
Posted By boblarson
I've put rows on two lines before (continuous or...

I've put rows on two lines before (continuous or single form) in order to make them fit. I make sure to add a demarcation line so that you can tell where the records change. Getting the headers to...
Forum: Access March 6th, 2009, 07:19 PM
Replies: 6
Views: 889
Posted By boblarson
Lookup fields at table level - not a good idea. ...

Lookup fields at table level - not a good idea. Here's why:
http://www.mvps.org/access/lookupfields.htm
Forum: Access March 1st, 2009, 12:24 AM
Replies: 6
Views: 889
Posted By boblarson
Can you elaborate further? What is this other...

Can you elaborate further? What is this other column and why does it need updating when a user puts in the data?
Forum: Access March 1st, 2009, 12:23 AM
Replies: 6
Views: 889
Posted By boblarson
3,000 posts - congrats!

Good job mmcdonal!
Showing results 1 to 25 of 38

 


All times are GMT -4. The time now is 12:01 PM.


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