Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 22 of 22
Search took 0.02 seconds.
Search: Posts Made By: shepston
Forum: Access August 11th, 2003, 10:54 AM
Replies: 6
Views: 1,829
Posted By shepston
Great Morris. I have found working with Notepad...

Great Morris. I have found working with Notepad much more predictable then Wordpad...just for future reference!



-Shay Shepston
Forum: Access August 5th, 2003, 02:53 PM
Replies: 6
Views: 1,829
Posted By shepston
It also might be possible to first import into...

It also might be possible to first import into Excel then imported as an Excel file into Access. But without seeing the file, I'm not sure this will be of any benefit.

-Shay Shepston
Forum: Access August 4th, 2003, 12:39 PM
Replies: 2
Views: 3,073
Posted By shepston
That is a strange glitch indeed. I have all my...

That is a strange glitch indeed. I have all my buttons turned off and by enabling the max button it stays that way.

I never would have thought of that one Greg. Thanks!

-Shay Shepston
Forum: Access August 4th, 2003, 11:18 AM
Replies: 2
Views: 3,073
Posted By shepston
Keeping a Form Maximized

I am having a hard time keeping all my forms Maximized. Whenever open one form A top of Form B then close Form B, Form A is in the restore state. I find myself having to issue many DoCmd.Maximize ...
Forum: Access ASP July 28th, 2003, 05:14 PM
Replies: 2
Views: 1,175
Posted By shepston
Have a look at this book: ...

Have a look at this book:

http://www.wrox.com/books/076454375X.shtml



-Shay Shepston
Forum: Access July 25th, 2003, 12:17 PM
Replies: 17
Views: 12,567
Posted By shepston
Did you try uninstalling office first then...

Did you try uninstalling office first then reinstalling? If you have the room on your hard drive, you also might want to set the entire Access installation to "Run all on my computer".

-Shay...
Forum: Access July 17th, 2003, 11:51 AM
Replies: 2
Views: 2,539
Posted By shepston
I am inclinded to think the form is not updated...

I am inclinded to think the form is not updated or refreshed before you try to change it again. I would start by adding:

Me.Refresh

in the AfterChange event for the field you are changing. ...
Forum: Access July 14th, 2003, 11:14 AM
Replies: 2
Views: 1,147
Posted By shepston
One quick note if you do that Kenny: make sure...

One quick note if you do that Kenny: make sure you make a backup incase the privileges are not set correctly and you cannot get back in.

That probably goes without saying but I wanted to make sure...
Forum: Access July 7th, 2003, 05:19 PM
Replies: 4
Views: 1,520
Posted By shepston
In ElseIf section, you have: ...

In ElseIf section, you have:


Me.MonthCounter=intYearCounter


Was this by design or was it intended to be:


Me.MonthCounter=intMonthCounter
Forum: Access ASP July 5th, 2003, 08:39 AM
Replies: 1
Views: 1,341
Posted By shepston
You could add another field that would have the...

You could add another field that would have the hyperlink information or you could construct the hyperlink to use the moduleID:


http://www.somesite.com/somedirectory/moduleID.html


That...
Forum: Access VBA July 4th, 2003, 11:10 AM
Replies: 8
Views: 1,829
Posted By shepston
Steven's approach would be the easiest assuming...

Steven's approach would be the easiest assuming there is only one event that is executed when you close the Form. If there are multiple options for closing the form, i.e. [close], [cancel], [move to...
Forum: Access July 4th, 2003, 10:35 AM
Replies: 4
Views: 1,520
Posted By shepston
Wow...that is pretty cumbersome. For starters,...

Wow...that is pretty cumbersome. For starters, all of your cstrOldSQL statements are the same with only one variation based on intNumber so this would be much easier to read and troubleshoot:

...
Forum: Access VBA July 1st, 2003, 08:37 AM
Replies: 3
Views: 1,230
Posted By shepston
This was posted in the Access Forum. Check there...

This was posted in the Access Forum. Check there for more information.

-Shay Shepston
Forum: Access July 1st, 2003, 08:30 AM
Replies: 8
Views: 1,715
Posted By shepston
Marc, I would be more able to help you if...

Marc,

I would be more able to help you if you could supply the code where you are generating the SQL. But for some pointers, a lot of the problems with generating SQL strings has to do with the...
Forum: Access June 12th, 2003, 01:27 PM
Replies: 2
Views: 1,207
Posted By shepston
1. The best way to handle this problem would be...

1. The best way to handle this problem would be to write a sub that would trigger the ordering form to open and set the value of your given combo box to the product from the first form:

Private...
Forum: Access VBA June 11th, 2003, 10:48 AM
Replies: 1
Views: 1,443
Posted By shepston
You could set a new Sub that is called by both...

You could set a new Sub that is called by both the Form_Open and the Go_Click events:

Private Sub newSub()
DoCmd.Close acForm, "frmBlank1_EPD", acSaveYes
DoCmd.OpenForm...
Forum: Access June 10th, 2003, 01:26 PM
Replies: 5
Views: 13,985
Posted By shepston
Solution 2 from Greg and John's solution work...

Solution 2 from Greg and John's solution work just as I need. Thanks for giving me 2 to chose from!

Thanks for you help guys.


-Shay Shepston
Forum: Access June 10th, 2003, 11:26 AM
Replies: 1
Views: 1,833
Posted By shepston
I'm not sure what your are attempting to do here....

I'm not sure what your are attempting to do here. You say the user has to click the picture in order to see the picture? If they are clicking the picture, are they not seeing the picture?

-Shay...
Forum: Access June 10th, 2003, 11:24 AM
Replies: 1
Views: 1,867
Posted By shepston
After the REQUERY, you could use: ...

After the REQUERY, you could use:

Screen.PreviousControl.SetFocus

Hope that helps.

-Shay Shepston
Forum: Access June 10th, 2003, 11:02 AM
Replies: 5
Views: 13,985
Posted By shepston
That is a good idea but because of layout issues,...

That is a good idea but because of layout issues, it cannot be maximized.



***EDIT***
I was able to stretch and resize this form to cover the other form but it does not look clean since the...
Forum: Access June 9th, 2003, 05:44 PM
Replies: 5
Views: 13,985
Posted By shepston
How do I Unhide a Form?

I am using two different forms to open a third form. For simplicity, lets say FormA and FormB have buttons to open FormC.

Here is the problem. When I open FormC from either FormA or FormB, the...
Forum: Access June 3rd, 2003, 07:33 PM
Replies: 5
Views: 1,638
Posted By shepston
It is great to see it back up!

It is great to see it back up!
Showing results 1 to 22 of 22

 




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