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 10 of 10
Search took 0.06 seconds.
Search: Posts Made By: mmcdonal
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: 885
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...
Forum: Access VBA June 26th, 2009, 01:11 PM
Replies: 4
Views: 938
Posted By mmcdonal
Here is what I usually do for input validation: ...

Here is what I usually do for input validation:


Dim sIDA As String 'I am assuming it is a string
Dim sLink As String

If IsNull(Me.IDA) Or Me.IDA = "" Then
MsgBox "Please enter an IDA.",...
Forum: Access VBA May 6th, 2009, 09:00 AM
Replies: 9
Views: 1,220
Posted By mmcdonal
I would do just what I did in the example, except...

I would do just what I did in the example, except you could put it in a public function, and then just pass a query string to it, and return a boolean. Like:

Public Function fCheck(sSQL As...
Forum: Access VBA April 8th, 2009, 09:06 AM
Replies: 7
Views: 977
Posted By mmcdonal
Also, I would do this: Dim sMessage As...

Also, I would do this:


Dim sMessage As String
Dim sTitle As String

sMessage = "Please enter the number cooresponding to the paper size " _
& "you wish to print on." & _
vbCrLf & "1 - Letter" &...
Forum: Access VBA April 8th, 2009, 09:00 AM
Replies: 7
Views: 977
Posted By mmcdonal
I am not sure why you want to force the user to...

I am not sure why you want to force the user to input a string when they click cancel by keeping them in a loop. But you could do this:


If ReportSize <> "" Then
Do While ReportSize <> "1" And...
Forum: Access VBA February 12th, 2009, 08:19 AM
Replies: 7
Views: 4,222
Posted By mmcdonal
Since the back end is SQL, you have a lot of...

Since the back end is SQL, you have a lot of options. Do a search in Access Help for "Publish web pages" and it will show you how to make data access pages out of Access forms and reports.

HTH
Forum: Access January 29th, 2009, 04:31 PM
Replies: 4
Views: 1,145
Posted By mmcdonal
So this is not a bound control? If it is bound,...

So this is not a bound control? If it is bound, do this on the Before Insert and the Before Update events:



If IsNull(Me.MTOW) Or Me.MTOW = "" Then

...
Forum: Access January 13th, 2009, 09:27 AM
Replies: 6
Views: 8,112
Posted By mmcdonal
Here is what I did. I created a table with a...

Here is what I did.

I created a table with a Yes/No field, and populated it with sample data.

I then created a query that looks like this:

Query1:
SELECT Count(Table1.SampleID) AS...
Forum: Access December 12th, 2008, 02:55 PM
Replies: 2
Views: 840
Posted By mmcdonal
Okay, the Title text box is very...

Okay, the Title text box is very distracting.

You can't limit tables in Access like this, nor I think in most other databases. You have to give the users some access to the data, and in so doing,...
Showing results 1 to 10 of 10

 


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


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