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 13 of 13
Search took 0.01 seconds.
Search: Posts Made By: malcolmdixon
Forum: BOOK: Access 2010 VBA Programmer's Reference May 7th, 2014, 04:41 PM
Replies: 3
Views: 1,443
Posted By malcolmdixon
Hi, Do you mean SQL to query your table and...

Hi,

Do you mean SQL to query your table and provide the results in the format you show? You need to create a crosstab query.


TRANSFORM First(StudentResults.Grade) AS FirstOfGrade
SELECT...
Forum: Access May 7th, 2014, 02:10 PM
Replies: 2
Views: 1,539
Posted By malcolmdixon
Hi, Is this the sort of layout you envisage:...

Hi,

Is this the sort of layout you envisage:

Oct-2013 Nov-2013 Dec-2013 Jan-2014 Feb-2014
01-BR/SR 08-PreTest 12-Implementation
02-URS 09-UAT
03-URS Signoff ...
Forum: BOOK: Access 2010 VBA Programmer's Reference April 7th, 2014, 03:57 PM
Replies: 1
Views: 1,120
Posted By malcolmdixon
Hi, You can create a form to use as a...

Hi,

You can create a form to use as a msgbox, give it a public property of the text it must display and then you can use this new form class like a msgbox that you can open and close...
Forum: BOOK: Access 2010 VBA Programmer's Reference April 8th, 2013, 02:01 AM
Replies: 5
Views: 4,639
Posted By malcolmdixon
Hi again, Your table must have a field...

Hi again,

Your table must have a field called PCName. If I understand correctly your table is not called tblPC but something else?

You'll also need another table called tblSpecification with 3...
Forum: BOOK: Access 2010 VBA Programmer's Reference April 7th, 2013, 09:46 AM
Replies: 5
Views: 4,639
Posted By malcolmdixon
Hi, The form needs to have a control named...

Hi,

The form needs to have a control named PCKey that is bound to the primary key field of the tblPC that you've created.

The purpose of this code is to copy a PC record and its Specification...
Forum: Access October 24th, 2012, 10:42 AM
Replies: 3
Views: 749
Posted By malcolmdixon
Hi JoeBB, This is what a LEFT OUTER JOIN is...

Hi JoeBB,

This is what a LEFT OUTER JOIN is used for.

Try

SELECT t2.ACC, t1.TERR
FROM Table2 t2 LEFT OUTER JOIN Table1 t1 ON t2.ACC = t1.ACC;

HTH.
Forum: Access August 8th, 2012, 01:01 PM
Replies: 2
Views: 1,265
Posted By malcolmdixon
Hi, This is because "subform" is no longer...

Hi,

This is because "subform" is no longer in the Forms collection, but the "mainform" is.

You can change the SQL to use
[Forms]![mainform_name]![subform_control]!maincategorycombobox].
...
Forum: BOOK: Access 2010 VBA Programmer's Reference July 8th, 2012, 04:30 AM
Replies: 2
Views: 1,654
Posted By malcolmdixon
Hi John, The report you are opening using...

Hi John,

The report you are opening using the OpenReport macro command must be bound to a query that requires a parameter. To create a parameter in a query, enter it in the criteria section as...
Forum: Access April 13th, 2011, 06:27 AM
Replies: 4
Views: 970
Posted By malcolmdixon
Hi Bob, I created a table with your sample...

Hi Bob,

I created a table with your sample "garbage" data, then built a query to extract the lot number as you require. The SQL is as follows:

SELECT GarbageData.Garbage,...
Forum: Access April 13th, 2011, 04:48 AM
Replies: 3
Views: 944
Posted By malcolmdixon
[] includes the range of characters inside the...

[] includes the range of characters inside the brackets, that is a to z AND A to Z. You can use a ! to exclude characters, that is Like "[!a-d]*" would filter OUT records with a to d as first...
Forum: Access April 12th, 2011, 06:01 PM
Replies: 3
Views: 944
Posted By malcolmdixon
First NEVER use NAME as a field name it's a...

First NEVER use NAME as a field name it's a reserved word!

To filter out the NAMEs with 4 characters use Like "[a-zA-Z][a-zA-Z][a-zA-Z][a-zA-z]*" in the criteria of a query. That will give you all...
Forum: Access October 19th, 2010, 02:49 PM
Replies: 13
Views: 1,803
Posted By malcolmdixon
Do you have memo fields and using DISTINCT? If so...

Do you have memo fields and using DISTINCT? If so check out http://support.microsoft.com/kb/896950.
Forum: Access October 16th, 2010, 07:55 AM
Replies: 13
Views: 1,803
Posted By malcolmdixon
You just need to bind the controls to the...

You just need to bind the controls to the underlying fields in the Project table using the ControlSource property. For example set up a [Section Director] field in the Projects table and set the...
Showing results 1 to 13 of 13

 


All times are GMT -4. The time now is 11:41 PM.


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