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 | 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 16 of 16
Search took 0.01 seconds.
Search: Posts Made By: jpaul
Forum: Pro VB Databases February 27th, 2008, 06:48 PM
Replies: 1
Views: 1,152
Posted By jpaul
Well I found a fix, here is the code: If...

Well I found a fix, here is the code:

If IsNull(cboDTAbove.Value) = False Then
DTAboveVal = "[DgnTemp] >= " & cboDTAbove.Value
cboDTemp.Value = ""
End If

When I filter it, it worked. Not...
Forum: Pro VB Databases February 27th, 2008, 04:51 PM
Replies: 1
Views: 1,152
Posted By jpaul
CODE FOR NUMBER AND ABOVE

Hello and Thanks
I want to search in a number field for all records with the
combo box value number and above.
Ex. If the value is 200 then all records with the value 200 and above.
Can anyone...
Forum: Pro VB Databases January 29th, 2008, 01:48 PM
Replies: 4
Views: 1,550
Posted By jpaul
Nevermind, solved problem. Thanks

Nevermind, solved problem. Thanks
Forum: Pro VB Databases January 29th, 2008, 01:46 PM
Replies: 1
Views: 1,498
Posted By jpaul
Nevermind, Solved problem on my own.

Nevermind, Solved problem on my own.
Forum: Pro VB Databases January 28th, 2008, 06:12 PM
Replies: 4
Views: 1,550
Posted By jpaul
I'm a little confused on this. Can you give me a...

I'm a little confused on this. Can you give me a little more info.
Also Look at my other entry on the record.count problem.
Thanks:)
Forum: Pro VB Databases January 28th, 2008, 05:21 PM
Replies: 1
Views: 1,498
Posted By jpaul
Help RecordCount

I'm trying to get a count of an array that is filtered. (Search Record qry)
TO count the records I used this code:
If TogFilter.Value = -1 Then
If cboUnit.Value <> "" Then strFilt(0) = "[Unit] =...
Forum: Pro VB Databases January 22nd, 2008, 04:08 PM
Replies: 4
Views: 1,550
Posted By jpaul
ubound and array

I've used and array to perform a search for records (SQL).
Once filtered how do I use "Ubound" to count them?
I'm already using ubound in the array.
heres my code:
Private Sub TogFilter_Click()...
Forum: VB Databases Basics January 22nd, 2008, 03:02 PM
Replies: 1
Views: 472
Posted By jpaul
ADOvsDAO

Question, Can I use both ADO and DAO in the same database or form?
Thanks
Forum: VB Databases Basics January 22nd, 2008, 02:49 PM
Replies: 2
Views: 1,041
Posted By jpaul
Nevermind on the idea, Because the count would...

Nevermind on the idea, Because the count would only work when the select buttons is clicked. I need it to work when filtered.
Forum: VB Databases Basics January 22nd, 2008, 12:46 PM
Replies: 2
Views: 1,041
Posted By jpaul
I have an Idea, I have 2 buttons for select and...

I have an Idea, I have 2 buttons for select and deselect all after I've filtered for the records. They use ADO or DAO recordset. I could use the recordcount method inside those options to return the...
Forum: VB Databases Basics January 22nd, 2008, 11:49 AM
Replies: 2
Views: 1,041
Posted By jpaul
record count help

Greetings,
I've got to do a count of all the records in a search.
Right now I've used an array to get the results but how can I also get a count of the records found. Example: if I search for the...
Forum: VB Databases Basics November 14th, 2007, 12:10 PM
Replies: 5
Views: 1,723
Posted By jpaul
Thanks again, I posted a topic "If BOF and EOF...

Thanks again,
I posted a topic "If BOF and EOF then" Question.
I actually meant to post it as a reply here.
Forum: VB Databases Basics November 14th, 2007, 10:37 AM
Replies: 2
Views: 4,426
Posted By jpaul
Rst.BOF And Rst. EOF question

I understand. The book was informative. More than most of the books at the local book store. I have a cub question:
I'm a little confused on a concept.
The statement: "If Rst.BOF And Rst. EOF...
Forum: VB Databases Basics November 13th, 2007, 08:58 AM
Replies: 5
Views: 1,723
Posted By jpaul
Sorry to say, it didn't work. Ambiguous Name...

Sorry to say, it didn't work. Ambiguous Name error. Adding Rst to the name of the sub when called is most likely the error. but I most likely don't understand this yet and didn't place it correctly....
Forum: VB Databases Basics November 12th, 2007, 05:26 PM
Replies: 5
Views: 1,723
Posted By jpaul
Not to offend, The code you wrote on is...

Not to offend,
The code you wrote on is actually from one of the books purchased
from this web site. In taking your advice, that would mean the writer didn't know what she was talking about. If...
Forum: VB Databases Basics November 8th, 2007, 04:41 PM
Replies: 5
Views: 1,723
Posted By jpaul
Object required

I'm using the example from the book "Beginning Access 2003 VBA
the "PopulateControlsOnForm" sub.
Code:
=================================

Private Sub Form_Load()
On Error GoTo...
Showing results 1 to 16 of 16

 


All times are GMT -4. The time now is 03:59 AM.


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