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 25 of 98
Search took 0.01 seconds.
Search: Posts Made By: jurgenw
Forum: Access VBA May 19th, 2004, 09:02 PM
Replies: 3
Views: 3,127
Posted By jurgenw
http://www.mvps.org/access/api/api0004.htm ...

http://www.mvps.org/access/api/api0004.htm

Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com
Forum: Access May 5th, 2004, 11:07 AM
Replies: 7
Views: 16,186
Posted By jurgenw
Setting the selected property true/false does not...

Setting the selected property true/false does not work with anything but a multiselect listbox. It is read only with a single select list.

Your question pertains to a databound list (which is...
Forum: Access May 4th, 2004, 04:32 PM
Replies: 7
Views: 16,186
Posted By jurgenw
Just a couple of additional notes: Greg's...

Just a couple of additional notes:

Greg's solution makes a few assumptions. The first is that the column headers are not visible since they are row 0 of the list data when they are visible and...
Forum: Access VBA April 30th, 2004, 05:54 PM
Replies: 2
Views: 1,058
Posted By jurgenw
It is best to verify how the table validation...

It is best to verify how the table validation rules work in a table view of the data. Assuming an autonumber field exists, entering any value in any field will create a record notwithstanding that...
Forum: Access April 29th, 2004, 11:18 PM
Replies: 1
Views: 3,574
Posted By jurgenw
DAO is the fastest method for working with an...

DAO is the fastest method for working with an Access database. ADO adds a layer of abstraction that sacrifices speed and functionality in order to provide a generic interface to a broader variety of...
Forum: Access VBA April 16th, 2004, 06:34 PM
Replies: 8
Views: 23,607
Posted By jurgenw
My suggestion was predicated on a reference to...

My suggestion was predicated on a reference to the DAO library which you obviously do not have set. Using a variant results in late binding which is not efficient. Given that you are using ADO as...
Forum: Access VBA April 16th, 2004, 01:49 PM
Replies: 8
Views: 23,607
Posted By jurgenw
Judging from the error message it looks like you...

Judging from the error message it looks like you need to begin the sequence with:

If Not [dataFabric subform].Form.Recordset.EOF Then
[dataFabric subform].Form.Recordset.MoveFirst
For tmpint = 0...
Forum: Access April 15th, 2004, 12:02 PM
Replies: 5
Views: 3,713
Posted By jurgenw
Curiously the text delimited dates seem to work...

Curiously the text delimited dates seem to work in many queries. Date/Time fields are stored as doubles and using text delimiters imposes an implicit type conversion to string. This may result in...
Forum: Access April 14th, 2004, 10:48 PM
Replies: 10
Views: 2,392
Posted By jurgenw
With Access it is possible to set an autonumber...

With Access it is possible to set an autonumber programatically at the time of record creation, however, the purpose is to be both a means of uniquely identifying a record and of joining tables in an...
Forum: Access April 14th, 2004, 10:33 AM
Replies: 10
Views: 2,392
Posted By jurgenw
I have frequently heard about American SSN...

I have frequently heard about American SSN numbers being reissued or duplicated in error. Although such duplications are rare, they may be intolerable. In addition, many countries have privacy...
Forum: Access April 13th, 2004, 12:17 PM
Replies: 10
Views: 2,392
Posted By jurgenw
You can create a unique index on a combination of...

You can create a unique index on a combination of fields. The combination of FirstName plus LastName plus age is pretty close but a date of birth with names would be better. Adding Social Security...
Forum: Access April 12th, 2004, 11:33 PM
Replies: 15
Views: 3,216
Posted By jurgenw
Access in Terminal Services is a Client (thin...

Access in Terminal Services is a Client (thin client) Server (terminal server) deployment. All the processing takes place on the server... just like SQL Server. And you can run Terminal Services...
Forum: Access VBA April 12th, 2004, 04:09 PM
Replies: 10
Views: 6,971
Posted By jurgenw
Using SQL is viable but calling CurrentDB twice,...

Using SQL is viable but calling CurrentDB twice, after all it is a function, calls a refresh of all the local database collections. I would strongly suggest that an object variable be used so you...
Forum: Access April 12th, 2004, 12:00 PM
Replies: 15
Views: 3,216
Posted By jurgenw
When you have multiple users, splitting between...

When you have multiple users, splitting between application and data files is generally advantageous. Because of the way in which Access handles linked tables, there is no need to merge data files...
Forum: Access April 10th, 2004, 12:07 PM
Replies: 19
Views: 4,795
Posted By jurgenw
SELECT employees.empno, employees.name,...

SELECT employees.empno, employees.name, approvals.contractno, assignments.aposit, assignments.acontract, assignments.astrdate, assignments.aenddate
FROM (employees INNER JOIN approvals ON...
Forum: Access April 10th, 2004, 11:12 AM
Replies: 9
Views: 1,868
Posted By jurgenw
I settled on the Beginning Access 97 VBA (Smith &...

I settled on the Beginning Access 97 VBA (Smith & Sussman - Wrox) and The Microsoft Access 97 Access Developers Handbook (Getz etal - Sybex) and the VBA companion book to the Sybex book as my early...
Forum: Access April 9th, 2004, 04:50 PM
Replies: 1
Views: 1,107
Posted By jurgenw
=...

= ParentControlName.subFormCONTROLName.Form.NameOfControlOnSubForm

or

= Me.subFormCONTROLName.Form.NameOfControlOnSubForm


Ciao
Jürgen Welz
Edmonton AB Canada
Forum: Access VBA April 9th, 2004, 03:50 PM
Replies: 3
Views: 16,845
Posted By jurgenw
Does a file of the same name already exist? Does...

Does a file of the same name already exist? Does the logged in user have rights to the destination folder?

I've never used the FileSystemObject because it requires a reference to the Scripting...
Forum: Access April 8th, 2004, 09:10 AM
Replies: 1
Views: 826
Posted By jurgenw
Create a query of Counts and name it...

Create a query of Counts and name it qryEmployeeReasonCount

SELECT EmployeeName, Count(Reason) AS CountReason
FROM tblEmployeeReason
GROUP BY [EmployeeName & ' ' & Reason, EmployeeName
ORDER BY...
Forum: Access April 8th, 2004, 12:17 AM
Replies: 15
Views: 3,216
Posted By jurgenw
Just to rephrase a bit. If you need to run to...

Just to rephrase a bit. If you need to run to the local grocery store to pick up a few things for dinner, hop in your car, bike or jog over. If you need to move a few million cubic yards of ore,...
Forum: Access VBA April 7th, 2004, 02:22 PM
Replies: 10
Views: 6,971
Posted By jurgenw
I would suggest running a delete query to delete...

I would suggest running a delete query to delete the records and then run an append query to populate the table if it always has the same structure. Just run the queries in order by adding...
Forum: Access April 7th, 2004, 01:18 PM
Replies: 15
Views: 3,216
Posted By jurgenw
I disagree with Sal recommending the use of MSDE...

I disagree with Sal recommending the use of MSDE or SQL Server to people who specifically say 'I am new in Access'. Jet/DAO is more efficient than you imply and is well suited to many environments. ...
Forum: Access VBA April 7th, 2004, 10:13 AM
Replies: 7
Views: 65,540
Posted By jurgenw
Access does a great many datatype conversions...

Access does a great many datatype conversions implicitly. Whether it will produce the result you are seeking depends on the date arithmetic function and that is not tolerable.

Date/Tive fields...
Forum: Access VBA April 7th, 2004, 12:37 AM
Replies: 10
Views: 6,971
Posted By jurgenw
It's relatively simple with DAO: Dim db As...

It's relatively simple with DAO:

Dim db As DAO.database
Set db = opendatabase("C:\Path\to\File\file.mdb")
db.Execute "query1"
db.close
set db = nothing

You need a reference to the DAO...
Forum: Access April 7th, 2004, 12:25 AM
Replies: 3
Views: 2,212
Posted By jurgenw
The easy way is to link the tables (File Menu,...

The easy way is to link the tables (File Menu, Get External Data, Link Tables) from whatever locations and then write the query in the database in which they are linked (and/or reside). Watch out...
Showing results 1 to 25 of 98

 




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