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 500
Search took 0.13 seconds.
Search: Posts Made By: mmcdonal
Forum: Access VBA July 2nd, 2014, 03:59 PM
Replies: 1
Views: 1,268
Posted By mmcdonal
Code?

What does the code look like on the button? It seems it is just a DotBang reference issue like [Forms]![MainForm].Subform.Control, etc.
Forum: Access VBA July 2nd, 2014, 03:57 PM
Replies: 1
Views: 801
Posted By mmcdonal
Hey

I am not sure what you are trying to do, but it sounds like something you would first do at the table level. You need to make the CraneNumber a look up value to the Crane table. Then when you create...
Forum: Access VBA July 2nd, 2014, 02:33 PM
Replies: 2
Views: 18,009
Posted By mmcdonal
See VBScript

You can use VBScript to accomplish this. Try:


Dim MyArray As Variant
Dim fso As Variant
Dim objStream As Variant
Dim objFile As Variant
Dim sSQL As String
Dim rs As ADODB.Recordset '(or some...
Forum: Access VBA July 2nd, 2014, 02:17 PM
Replies: 1
Views: 850
Posted By mmcdonal
Detail section?

Hi,

Create a module called Public Variables, then add this to the module:

Public pMyValue As String

Then on the button that opens the form, capture the values in this public variable (I...
Forum: Access VBA July 2nd, 2014, 02:11 PM
Replies: 2
Views: 806
Posted By mmcdonal
Easy

First, change the audit table to put a default value in the DateTime field so you don't have to capture that. Use Now() for the date and time. Then try this on the On Open event of the report:

...
Forum: Access March 3rd, 2010, 01:28 PM
Replies: 6
Views: 1,560
Posted By mmcdonal
I would create the query to select top 20, or 10...

I would create the query to select top 20, or 10 etc, ordered by date DESC, and then use that query to build a report ordered by date Asc. Does that help?
Forum: Access VBA March 3rd, 2010, 08:37 AM
Replies: 2
Views: 1,089
Posted By mmcdonal
These functions refer to 2 forms (WICT1 and...

These functions refer to 2 forms (WICT1 and WICT2). Are both forms open at the time these functions are run? If they are not both open, this will cause an error.
Forum: Access March 3rd, 2010, 08:34 AM
Replies: 6
Views: 1,560
Posted By mmcdonal
Hi again, I created a table like this: ...

Hi again,

I created a table like this:

Table1
DataID = PK
DayWeek = Text
DHigh = Single
DLow = Single
Forum: Access March 2nd, 2010, 03:08 PM
Replies: 6
Views: 1,560
Posted By mmcdonal
Do you mean like "SELECT * FROM MyData WHERE Date...

Do you mean like "SELECT * FROM MyData WHERE Date BETWEEN etc?" or select top 20? How are you displaying this data (form or report?) What events are triggering the view?

Do you have sample table...
Forum: Access VBA October 16th, 2009, 10:08 AM
Replies: 2
Views: 3,026
Posted By mmcdonal
Generally to use a SELECT stored procedure, you...

Generally to use a SELECT stored procedure, you would do this on the Access side:


'Open Connection
Set cn = New ADODB.Connection
cn.Open cString

'Create a new command object
Set cmdCommand = New...
Forum: Access VBA October 16th, 2009, 09:55 AM
Replies: 1
Views: 1,051
Posted By mmcdonal
You probably want to post in that book's forum...

You probably want to post in that book's forum here: http://p2p.wrox.com/book-beginning-access-2007-vba-isbn-978-0-470-04684-5-323/
Forum: Access VBA October 16th, 2009, 09:53 AM
Replies: 1
Views: 1,168
Posted By mmcdonal
Do you want to use the built-in Access security,...

Do you want to use the built-in Access security, or do you want to create your own?
Forum: Access VBA October 16th, 2009, 09:52 AM
Replies: 1
Views: 13,520
Posted By mmcdonal
That is pretty much how you want to do this. I...

That is pretty much how you want to do this. I would use this sort of loop though:


Do Until rsUnique.EOF
lgSum6MQ = customFunction6MQ(item) 'calculate quantity for 6 months
lgSum6MS =...
Forum: Access VBA August 10th, 2009, 02:52 PM
Replies: 1
Views: 1,949
Posted By mmcdonal
You need to have the Oracle client software...

You need to have the Oracle client software installed on your computer, and you need to do something like this:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim sCN...
Forum: Access VBA July 22nd, 2009, 11:19 AM
Replies: 3
Views: 1,162
Posted By mmcdonal
I don't understand what you are asking.

I don't understand what you are asking.
Forum: Access VBA July 16th, 2009, 09:03 AM
Replies: 13
Views: 28,906
Posted By mmcdonal
As to the book, there are a lot of Access VBA...

As to the book, there are a lot of Access VBA books at Wrox. I have Access 2000, and 2003 VBA, and Access Application Development by Wrox, for example. I would supplement that with a Microsoft Press...
Forum: Access VBA July 16th, 2009, 08:54 AM
Replies: 13
Views: 28,906
Posted By mmcdonal
I would not do any data corrections until I had...

I would not do any data corrections until I had the data in the local table. I would not concatenate the date fields, for example, until I got the table locally. So pull the data, then run your...
Forum: Access VBA July 15th, 2009, 09:28 AM
Replies: 13
Views: 28,906
Posted By mmcdonal
It's still a little vague: "how do I code the...

It's still a little vague: "how do I code the setup to start a VBA pass through query and how to get started with a recordset."

It sounds like you want to get data from the AS400, then process it...
Forum: Access VBA July 14th, 2009, 01:43 PM
Replies: 13
Views: 28,906
Posted By mmcdonal
What are you doing with the recordsets once you...

What are you doing with the recordsets once you get them?

To make the queries dynamic, you have to add the controls for your users to select parameter values.

For example, If I wanted a user to...
Forum: Access VBA July 14th, 2009, 09:37 AM
Replies: 13
Views: 28,906
Posted By mmcdonal
You need to post more information than this. An...

You need to post more information than this.

An example of a SELECT query would be something like:


Dim sSQL As String
Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection

sSQL = "SELECT * FROM...
Forum: Access July 6th, 2009, 09:21 AM
Replies: 6
Views: 4,174
Posted By mmcdonal
The very simplest way is to open the other report...

The very simplest way is to open the other report as acHidden, and then take the values from the report control. Make sure the On Close event of your visible report closes the other report. I would...
Forum: Access July 2nd, 2009, 08:22 AM
Replies: 6
Views: 4,174
Posted By mmcdonal
If this were on a report, which I am assuming,...

If this were on a report, which I am assuming, then I would do this:

Put a text box on the report header or footer, then put this code in the text box:


=Sum(IIf([Deviation]<0,[Deviation],0))

...
Forum: Access July 1st, 2009, 02:45 PM
Replies: 6
Views: 4,174
Posted By mmcdonal
Do you mean Sum the negative numbers? Or sum the...

Do you mean Sum the negative numbers? Or sum the negative numbers with the positive? Or sum the negative numbers AS positive numbers along with the positive, etc?

I am assuming this is on a...
Forum: Access VBA June 26th, 2009, 04:24 PM
Replies: 4
Views: 938
Posted By mmcdonal
That is why I suggested using a bound combo box...

That is why I suggested using a bound combo box to the column the user is selecting.

For example, if you run the combo box wizard on the first form, and have it look up values in IDA, and limit it...
Forum: Access VBA June 26th, 2009, 01:15 PM
Replies: 1
Views: 887
Posted By mmcdonal
First: Declare those integers as Long instead...

First: Declare those integers as Long instead since that will eventually cause problems if those are autonumber fields.

Second: When you reference "Set intID = Forms!frmgood!frmParts2!IDA ", that...
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 09:07 AM.


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