Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 15 of 15
Search took 0.01 seconds.
Search: Posts Made By: psychadelic
Forum: VB Databases Basics July 8th, 2003, 04:46 AM
Replies: 1
Views: 1,131
Posted By psychadelic
Hello try these queries to get the result...

Hello

try these queries to get the result you want. They work with SQL Server and Ms Access though, so modify them is you are using another RDBM.

SQL Server:
SELECT Date, Particulars,...
Forum: VB Databases Basics July 3rd, 2003, 03:49 AM
Replies: 7
Views: 2,712
Posted By psychadelic
I think there is a little problem with the second...

I think there is a little problem with the second WHERE...

Try this:
SELECT * FROM TABLE WHERE DATE > 01/01/01 AND DATE < 01/02/01

or this:
SELECT * FROM TABLE WHERE DATE > #01/01/01# AND...
Forum: Beginning VB 6 July 3rd, 2003, 03:26 AM
Replies: 1
Views: 2,049
Posted By psychadelic
Hmm I don't think you can use command button and...

Hmm I don't think you can use command button and combo boxes in Visual Basic built in datagrids. But you can fake by popping up these objects on the grid whenever you click in a cell. You will have...
Forum: Access VBA July 3rd, 2003, 02:47 AM
Replies: 2
Views: 1,736
Posted By psychadelic
Hello, this is what I do in my Ms Access 97...

Hello,

this is what I do in my Ms Access 97 projects

1. In Tools\Startup and Tools\Startup\Advanced
uncheck menus, built-in toolbars, shortcut keys and special keys

2. Use the runtime...
Forum: Access VBA June 18th, 2003, 04:42 AM
Replies: 3
Views: 4,674
Posted By psychadelic
The datediff function will always return a number...

The datediff function will always return a number of time intervals between two specified dates. You can change the type of intervals if you want.

DateDiff(interval, date1, date2) where interval...
Forum: Access VBA June 18th, 2003, 03:09 AM
Replies: 3
Views: 4,674
Posted By psychadelic
Tada! : DateDiff("d", Date1, Date2) ...

Tada! : DateDiff("d", Date1, Date2)


[:o)] cheers
Forum: Beginning VB 6 June 18th, 2003, 02:49 AM
Replies: 3
Views: 1,594
Posted By psychadelic
You can try to get your hands on the Microsoft...

You can try to get your hands on the Microsoft Windows CE Toolkit for Visual Basic 6.0. I have never used it but you can give a try.
...
Forum: Access VBA June 18th, 2003, 02:16 AM
Replies: 1
Views: 2,717
Posted By psychadelic
Hello the world, I think you cannot hide a...

Hello the world,

I think you cannot hide a column in a datagrid. I can't find any properties to do this. But you can find a way to work around this particular problem. Just build a query/stored...
Forum: Pro VB 6 June 12th, 2003, 09:02 AM
Replies: 2
Views: 3,209
Posted By psychadelic
Hello Alan, Hi everybody, I am using this...

Hello Alan, Hi everybody,

I am using this piece of code to send mail in my VB app and I've no problem with Ms Outlook. I have cut some of it but I think you could make good use of the following....
Forum: Beginning VB 6 June 11th, 2003, 06:00 AM
Replies: 1
Views: 9,222
Posted By psychadelic
Hello you can use dynamic arrays instead....

Hello

you can use dynamic arrays instead. Try this as an example:


Private Sub Command1_Click()

Dim iCol As Integer
Dim iRow As Integer
Forum: Access VBA June 9th, 2003, 03:17 AM
Replies: 6
Views: 4,301
Posted By psychadelic
Hello, Sorry for the delay I was off this...

Hello,

Sorry for the delay I was off this week-end. I tried part of your code in a form bound to a table. On the double click event just add the following:

Private Sub list23_DblClick(Cancel...
Forum: Access VBA June 6th, 2003, 06:19 AM
Replies: 6
Views: 4,301
Posted By psychadelic
Hi again timmaher, and I'm sure glad to...

Hi again timmaher,

and I'm sure glad to help. When there are multiple selections in a list box, the value of the list box control will always be Null and you can't set the MultiSelect in run time...
Forum: Access VBA June 6th, 2003, 02:39 AM
Replies: 1
Views: 2,207
Posted By psychadelic
Hello, I am using a barcode ocx in one of my...

Hello,

I am using a barcode ocx in one of my Ms Access project and when I want to update it all I have to do is :

Forms![FrmPrintBarCode]![barCode1].Caption =...
Forum: Access VBA June 4th, 2003, 03:41 AM
Replies: 6
Views: 4,301
Posted By psychadelic
Hi, set the property MultiSelect to simple...

Hi,

set the property MultiSelect to simple for your listbox [in access 97] and try something like this. The name of the listbox is List1

Dim iCount As Integer

For iCount = 0 To...
Forum: Beginning VB 6 June 4th, 2003, 02:12 AM
Replies: 5
Views: 1,956
Posted By psychadelic
Beginner, intermediate or Pro?

Hello,

I didn't find any VB general discussion forums so I will post this question here. I was just wondering how do know your current level of competency in VB? I am using VB for 4 yrs now doing...
Showing results 1 to 15 of 15

 




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