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 23 of 23
Search took 0.01 seconds.
Search: Posts Made By: HiTechCoach
Forum: Access VBA November 27th, 2013, 10:03 PM
Replies: 2
Views: 1,518
Posted By HiTechCoach
Two methods I use: 1) (PUSH to Access)...

Two methods I use:

1) (PUSH to Access) Export the data from each table to a to CSV with the first row having the field names. Import the CVS files into Access.

2) (PULL from Access) Install...
Forum: Access VBA June 13th, 2013, 10:52 PM
Replies: 1
Views: 866
Posted By HiTechCoach
Sounds like you need to use a recordset. ...

Sounds like you need to use a recordset.

See:
http://msdn.microsoft.com/en-us/library/office/bb243789%28v=office.12%29.aspx
http://allenbrowne.com/ser-29.html...
Forum: Joomla! December 10th, 2011, 03:07 PM
Replies: 26
Views: 38,948
Posted By HiTechCoach
Do you have a separate domain or server to test...

Do you have a separate domain or server to test on?
Forum: Joomla! December 5th, 2011, 06:32 PM
Replies: 26
Views: 38,948
Posted By HiTechCoach
I would at install the security updates fro 1.5...

I would at install the security updates fro 1.5 ASAP. Even if you do consider upgrading to 1.7 you want to get your 1.5 version current.
Forum: Joomla! December 5th, 2011, 04:21 PM
Replies: 26
Views: 38,948
Posted By HiTechCoach
also check out: http://www.mobilejoomla.com/

also check out:

http://www.mobilejoomla.com/
Forum: Joomla! December 5th, 2011, 04:15 PM
Replies: 26
Views: 38,948
Posted By HiTechCoach
Both. Have Joomla switch templates for...

Both.

Have Joomla switch templates for mobiel devices

see:

http://extensions.joomla.org/extensions/mobile
...
Forum: Access VBA November 29th, 2011, 07:09 PM
Replies: 10
Views: 7,488
Posted By HiTechCoach
There are several methods you can use. For...

There are several methods you can use.

For example

1) if the field to be updates is part of the form's record source then place a text box on the form that is bound to the control. In the check...
Forum: Access August 30th, 2011, 10:59 AM
Replies: 9
Views: 4,394
Posted By HiTechCoach
Cindy, What exactly did you try? I have...

Cindy,

What exactly did you try?

I have many report where each group starts on a new page. I do not have any issues. When Printing or Previewing.

Ah ... just thought of something. Are you...
Forum: Access August 23rd, 2011, 04:07 PM
Replies: 3
Views: 868
Posted By HiTechCoach
If it is a data field then you should not be...

If it is a data field then you should not be storing it formatted as text). If stored as a date/time data type then tt is a number without any date formatting. This allows your to format the date as...
Forum: Access August 3rd, 2011, 03:58 PM
Replies: 5
Views: 3,718
Posted By HiTechCoach
Here are books by WROX Author Geoffrey L....

Here are books by WROX Author Geoffrey L. Griffith (http://p2p.wrox.com/members/gjgriffith.html)

Access 2010 24-Hour Trainer (http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470591676.html)...
Forum: Access August 3rd, 2011, 03:53 PM
Replies: 5
Views: 3,718
Posted By HiTechCoach
This is WROX's site who is a publisher of books...

This is WROX's site who is a publisher of books about Access.

Check the links in the navigation bar in the upper left corner below the logo.
Forum: Access July 24th, 2011, 01:57 PM
Replies: 1
Views: 1,900
Posted By HiTechCoach
No built in way in Access.

No built in way in Access.
Forum: Access July 23rd, 2011, 12:29 PM
Replies: 2
Views: 740
Posted By HiTechCoach
See it this helps: Referring to a Field in...

See it this helps:

Referring to a Field in the Previous Record or Next Record ...
Forum: Access July 19th, 2011, 11:55 AM
Replies: 2
Views: 835
Posted By HiTechCoach
Sure. I like to use a form to collect the...

Sure. I like to use a form to collect the criteria.

see: Report Dialog Examples (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=9&Itemid=28)
Forum: Access May 31st, 2011, 11:05 AM
Replies: 8
Views: 1,377
Posted By HiTechCoach
Have you tried using a Crosstab query? I...

Have you tried using a Crosstab query?

I have this example:
Dynamic Report based on a Crosstab query (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=6&Itemid=28)
Forum: Access VBA January 15th, 2011, 11:53 AM
Replies: 4
Views: 962
Posted By HiTechCoach
There is an extra ( before the INSERT. Try...

There is an extra ( before the INSERT. Try removing it.
Forum: Access October 17th, 2010, 03:12 PM
Replies: 13
Views: 1,972
Posted By HiTechCoach
If you are recreating the database then this is a...

If you are recreating the database then this is a perfect time to improve the design!

Do you have the legal rights to reverse engineer this database since you only have the MDE?

Have you...
Forum: Access October 17th, 2010, 01:11 PM
Replies: 13
Views: 1,972
Posted By HiTechCoach
Cindy, I do think part of your issues are...

Cindy,

I do think part of your issues are caused by the fact that the Projects table really is not properly normalized.

You have a lot of repeating fields for the project team members. These...
Forum: Access October 16th, 2010, 04:12 PM
Replies: 13
Views: 1,972
Posted By HiTechCoach
Cindy, To make sure we understand what you...

Cindy,

To make sure we understand what you are describing it would help if you use the terminology for Access.

Fields are in Tables and queries results.

Controls are object on forms and...
Forum: Access October 12th, 2010, 04:03 PM
Replies: 3
Views: 14,814
Posted By HiTechCoach
Cindy, There is no Marco, query or VBA code...

Cindy,

There is no Marco, query or VBA code required to handle this.

What version of Access are you using?

In the Northwind sample database the Orders form does exactly what you want.
...
Forum: Access October 6th, 2010, 08:52 PM
Replies: 4
Views: 1,078
Posted By HiTechCoach
Cindy, You're welcome. Glad to assist.

Cindy,

You're welcome.

Glad to assist.
Forum: Access October 5th, 2010, 12:38 AM
Replies: 4
Views: 1,078
Posted By HiTechCoach
Cindy, Try this: Private Sub...

Cindy,

Try this:



Private Sub ComOpenSelect_Click()
On Error GoTo Err_ComOpenSelect_Click

Dim stDocName As String
Forum: Access October 4th, 2010, 11:26 AM
Replies: 4
Views: 3,725
Posted By HiTechCoach
Try: Private Sub IndexCode0_AfterUpdate()...

Try:


Private Sub IndexCode0_AfterUpdate()

Me.ProJe.RowSource = "select ProjectName from Projects0 where IndexCode=" & Chr(34) & Me.IndexCode0 & Chr(34)

End Sub
Showing results 1 to 23 of 23

 




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