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 21 of 21
Search took 0.01 seconds.
Search: Posts Made By: richard_peers
Forum: Access VBA July 25th, 2007, 04:37 AM
Replies: 7
Views: 1,191
Posted By richard_peers
Well, mmcdonal has already answered most of your...

Well, mmcdonal has already answered most of your questions, and pretty much exactly as I would have done. However, there is still the question of the date format in SQL, and the Americo-centric...
Forum: Access VBA July 23rd, 2007, 01:14 AM
Replies: 7
Views: 1,191
Posted By richard_peers
Hi ManFriday These are not VBA variables,...

Hi ManFriday

These are not VBA variables, they are part of the SQL (i.e. inside the strings). They are table name aliases - look at the sFROM string, where tblSales has an "s" after it, and...
Forum: Access VBA July 17th, 2007, 01:49 AM
Replies: 7
Views: 3,770
Posted By richard_peers
Looks to me like you're pretty much there. All...

Looks to me like you're pretty much there. All you need is an equivalent function to ConvertToSqlFragment called something like ConvertToDisplayableCriterion, and build up...
Forum: Access VBA July 16th, 2007, 02:58 PM
Replies: 7
Views: 3,770
Posted By richard_peers
Well, I'm assuming you want the filter criteria...

Well, I'm assuming you want the filter criteria displayed on the report, most likely in a label, rather than a text box. In that case, you can assemble the string above, and then assign that to the...
Forum: Access VBA July 14th, 2007, 06:08 AM
Replies: 12
Views: 1,654
Posted By richard_peers
Okay, so you want to do a "query by example"...

Okay, so you want to do a "query by example" screen - all of the combo box entries are possible search criteria, but the user is not expected to choose values for all of them, just the ones he wants...
Forum: Access VBA July 14th, 2007, 02:15 AM
Replies: 7
Views: 3,770
Posted By richard_peers
This looks like a classic application for the...

This looks like a classic application for the DLookup function. This allows you to access any table and return data, as long as your criteria will specify a single row in the table. So in your case,...
Forum: Access VBA June 16th, 2007, 02:12 PM
Replies: 2
Views: 1,968
Posted By richard_peers
It's not possible to tell from the snippet of...

It's not possible to tell from the snippet of code you have supplied, but it is likely that one or more of the items you are including in your VALUES clause are strings - no idea about MPAN,...
Forum: Access VBA June 15th, 2007, 01:58 PM
Replies: 3
Views: 4,280
Posted By richard_peers
Okay - well, I did say I was working a little in...

Okay - well, I did say I was working a little in the dark here! I'm assuming that you have a reference to the appropriate libraries - otherwise, you'd get an error much earlier on. One thing that...
Forum: Access VBA June 13th, 2007, 12:42 PM
Replies: 3
Views: 4,280
Posted By richard_peers
Well, I don't normally use ADO, but it looks like...

Well, I don't normally use ADO, but it looks like it is objecting to one of the datatypes you have used in the tbl.Columns.Append list. Are there any types you have used here that were not in the...
Forum: Access VBA June 12th, 2007, 12:22 PM
Replies: 5
Views: 1,446
Posted By richard_peers
One minor addition - sorry, mmcdonal, especially...

One minor addition - sorry, mmcdonal, especially as you are so helpful all the time, but I was surprised to see an "advanced member" using code like this:

Public pMS, pDR, pDK As Boolean

and...
Forum: Access VBA June 12th, 2007, 12:11 PM
Replies: 2
Views: 24,376
Posted By richard_peers
I think your problem may be that the date is not...

I think your problem may be that the date is not storing correctly - it needs to be formatted as mm/dd/yyyy to store in a Jet (Access) database table. If you supply it the other way round, then some...
Forum: Access VBA June 12th, 2007, 11:59 AM
Replies: 3
Views: 4,868
Posted By richard_peers
The way I have always tested for a selection...

The way I have always tested for a selection having been made in a combo box is like this:

If cmbMyCombo.ListIndex = -1 Then
MsgBox "Please select a value in MyCombo", vbExclamation + vbOkOnly,...
Forum: Access VBA May 31st, 2007, 11:07 AM
Replies: 4
Views: 1,250
Posted By richard_peers
Apologies - I was typing code from memory, always...

Apologies - I was typing code from memory, always a bad idea!

Here's the function I actually use (it has a couple of other bells and whistles):-

Public Function FormatDate(datInput As Date,...
Forum: Access VBA May 30th, 2007, 01:02 AM
Replies: 4
Views: 1,250
Posted By richard_peers
Hi Andrew This is one of those classic...

Hi Andrew

This is one of those classic Access "gotchas" that Microsoft have left littering the application, but don't cover (in my view) in anything like enough detail in the documentation.
...
Forum: Access VBA May 17th, 2007, 11:08 AM
Replies: 2
Views: 2,103
Posted By richard_peers
Hi Darren A simple syntax problem. Try...

Hi Darren

A simple syntax problem. Try this:-

Private Sub Form_Current()

If Me.Fee.Value <> Me.SuggFee.Value Then
Me.Fee.BackColor = 255
Me.Fee.ForeColor = 16777215
Else
Forum: Access VBA May 13th, 2007, 03:32 AM
Replies: 3
Views: 13,656
Posted By richard_peers
Hi Vlad (again!) I had exactly this problem...

Hi Vlad (again!)

I had exactly this problem recently. What I wanted to do was to have full control of the background colour of the cells, so a datasheet display was ruled out. I tried all sorts of...
Forum: Access VBA May 13th, 2007, 03:28 AM
Replies: 8
Views: 15,839
Posted By richard_peers
Hi Vlad The answer is simple - just treat...

Hi Vlad

The answer is simple - just treat the continuous form as if it were a normal form. For example, if the user clicks a command button on a particular record in the continous form, then...
Forum: Access VBA April 16th, 2007, 05:16 PM
Replies: 2
Views: 4,153
Posted By richard_peers
Hi PT As you have found, although the...

Hi PT

As you have found, although the continuous form allows fields to vary from record to record, the definition of other screen objects is singular, and gets replicated across every record.
...
Forum: Access VBA March 24th, 2007, 11:53 AM
Replies: 3
Views: 1,363
Posted By richard_peers
Hi medic That's the way client-server...

Hi medic

That's the way client-server systems work - data is only pulled to the client when it requests it, there is no way to originate data transfers from the server. By moving your Access...
Forum: Access VBA March 6th, 2007, 01:54 PM
Replies: 3
Views: 1,410
Posted By richard_peers
Hi Vince You are doing a lot of work for...

Hi Vince

You are doing a lot of work for something quite easy. Try using a query like this, and handling all 5 in a single recordset:

SELECT tblBubbles.BubbleNr, MIN(tblBubbles.Datum) AS Datum...
Forum: Access VBA March 4th, 2007, 07:10 AM
Replies: 0
Views: 852
Posted By richard_peers
Help! Supposedly simple grid requirement

Hi

This has been driving me nuts [xx(] for weeks. What I'm trying to achieve is a simple input sub-form, where the user is entering a single column of figures, one value per record, but the screen...
Showing results 1 to 21 of 21

 


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


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