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 | 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 61
Search took 0.01 seconds.
Search: Posts Made By: malcolmdixon
Forum: Access December 3rd, 2015, 04:12 PM
Replies: 2
Views: 1,154
Posted By malcolmdixon
Hi William, If you create a table that...

Hi William,

If you create a table that contains just numbers [Number] from 0 to maximum number then create an append query similar to the following:


INSERT INTO Deliveries ( SaleID,...
Forum: Access November 29th, 2015, 08:44 AM
Replies: 2
Views: 659
Posted By malcolmdixon
1 textbox and 1 combobox to a double number

Hi,

If you haven't managed to sort this yet, here's one solution.

I'd use a combobox for pre1unit with 2 columns, set a value list 1000000, "Mega", 1000000000, "Giga" etc. Hide the first column...
Forum: Access November 4th, 2014, 04:59 PM
Replies: 2
Views: 1,900
Posted By malcolmdixon
Form Timer

Hi pthegr8,

You could use the form Timer event to run code to requery the form displaying the filtered records every half second, that's 57600 requeries per 8 hours though!! If you have a...
Forum: BOOK: Access 2010 VBA Programmer's Reference May 8th, 2014, 05:45 AM
Replies: 3
Views: 1,507
Posted By malcolmdixon
Smile Glad it helped, don't forget to press the Thanks...

Glad it helped, don't forget to press the Thanks button [:D]

Malc.
Forum: Access May 7th, 2014, 09:58 PM
Replies: 2
Views: 893
Posted By malcolmdixon
Hi again, Here's an example using DCount, a...

Hi again,

Here's an example using DCount, a subquery may be better, but I expect the number of records to be queried is never going to be huge, so this should be quick enough.


SELECT...
Forum: Access May 7th, 2014, 09:18 PM
Replies: 2
Views: 893
Posted By malcolmdixon
Hi Rajesh, Do you still need help with this?...

Hi Rajesh,

Do you still need help with this?

You need a subquery to create the record counts with the key Designation/Grade. Use this to determine whether "Misc - " & Grade or Designation is...
Forum: BOOK: Access 2010 VBA Programmer's Reference May 7th, 2014, 08:37 PM
Replies: 1
Views: 1,085
Posted By malcolmdixon
Question Do you still need help with this Phillip? ...

Do you still need help with this Phillip?

Malc.
Forum: BOOK: Access 2010 VBA Programmer's Reference May 7th, 2014, 04:41 PM
Replies: 3
Views: 1,507
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,598
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,164
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 2nd, 2014, 11:16 AM
Replies: 2
Views: 1,400
Posted By malcolmdixon
Hi sjr1917, Using your code slightly...

Hi sjr1917,

Using your code slightly modified please try this:

Form code:

Option Compare Database

Option Explicit
Forum: BOOK: Access 2010 VBA Programmer's Reference April 8th, 2013, 10:49 AM
Replies: 5
Views: 4,746
Posted By malcolmdixon
Hi, Glad you got your form working as...

Hi,

Glad you got your form working as required, but macros make me shudder! Give me VBA any day.

Malc.
Forum: BOOK: Access 2010 VBA Programmer's Reference April 8th, 2013, 02:01 AM
Replies: 5
Views: 4,746
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,746
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 March 20th, 2013, 09:15 PM
Replies: 4
Views: 1,501
Posted By malcolmdixon
Hi, I understand what you are trying to do...

Hi,

I understand what you are trying to do now, but I still think that the patient's answers should be a record per answer rather than in fields in one table, i.e. a 1 to n relationship patient ->...
Forum: Access March 20th, 2013, 03:39 PM
Replies: 4
Views: 1,501
Posted By malcolmdixon
A table with 100 fields does not sound normalised...

A table with 100 fields does not sound normalised to me, check out http://en.wikipedia.org/wiki/Database_normalization. If each field mentioned is a question entity then you should have a separate...
Forum: BOOK: Access 2010 VBA Programmer's Reference December 20th, 2012, 09:42 AM
Replies: 1
Views: 1,268
Posted By malcolmdixon
Hi TerryLynn, The code listed on p206 is a...

Hi TerryLynn,

The code listed on p206 is a snippet of code only. It's from the Chamber Application database sample available for download from Wrox to accompany the book. Please see...
Forum: BOOK: Access 2010 VBA Programmer's Reference October 27th, 2012, 03:03 PM
Replies: 7
Views: 1,582
Posted By malcolmdixon
Hi liamfitz, I haven't tried it, but yes...

Hi liamfitz,

I haven't tried it, but yes that is your problem the image needs to be an ico file type. You can convert your png to an ico file using http://www.convertico.com/.

Make sure the...
Forum: Access October 24th, 2012, 10:42 AM
Replies: 3
Views: 799
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 22nd, 2012, 05:37 PM
Replies: 3
Views: 871
Posted By malcolmdixon
Hi Vince, I suspect you want the whole...

Hi Vince,

I suspect you want the whole process to be initiated by a user? A form with a Command button to run some VBA code via the OnClick event would be ideal.
Use the DoCmd.SendObject command...
Forum: Access August 20th, 2012, 04:40 PM
Replies: 3
Views: 871
Posted By malcolmdixon
Hi Vince, Welcome to the forum. When...

Hi Vince,

Welcome to the forum.

When you change the visibility of a control on a report, it will affect every detail record within that report. In order to achieve your goal you need to place...
Forum: Access August 14th, 2012, 05:11 AM
Replies: 7
Views: 4,635
Posted By malcolmdixon
Hi, Here's the code I promised. ...

Hi,

Here's the code I promised.



Public Function Process(sourceFolder As String, destinationFolder As String) As Boolean

'pre-conditions: folders have \ character as last...
Forum: Access August 14th, 2012, 03:46 AM
Replies: 7
Views: 4,635
Posted By malcolmdixon
Hi, You could always use the CInt() function...

Hi,

You could always use the CInt() function to convert the value to an Integer within the append query!
Forum: Access August 13th, 2012, 05:34 PM
Replies: 3
Views: 7,721
Posted By malcolmdixon
Hi Robert, Personally, I would use linking....

Hi Robert,

Personally, I would use linking. You can write VBA code to do the re-linking. It could iterate through Excel files in a folder, refresh links, run the append queries, etc. Although I've...
Forum: Access August 8th, 2012, 01:01 PM
Replies: 2
Views: 1,333
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].
...
Showing results 1 to 25 of 61

 


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


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