Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BillPowers Referencing 1

Status
Not open for further replies.
solo7

solo7

Technical User
Mar 14, 2001
243
NO
I've been using BillPowers Referencing code to automate deployed referencing thread181-437632 but whilst the code works fine on my machine - even when I remove some references. When I deploy my Database onto a foreign machine I'm getting errors in calling basic functions such as MID RIGHT LEFT. All part of VBA.STRINGS

Can anyone shed any light please ??

Steady ... [thumbsup2]
 
Sort by date Sort by votes
Hi solo7,

Have you downloaded the example from
Because this routine was rolled out in dribs and drabs, the full "working" code is available in the file calledAutomatedReferencing.zip

If you have already tried the download can you send me a zipped copy of your db, removing any sensitive data first.

The posted version initially doesn't make any calls other than to the standard libraries VBA and Access, so hopefully your problem will be pretty obvious once I've viewed your db.

billpower@cwcom.net

Bill
 
Upvote 0 Downvote
Hi Bill,
That's extremely generous of you billpower. I will be in touch.

Steady... [thumbsup2]
 
Upvote 0 Downvote

That's extremely generous of you billpower. I will be in touch.

Steady... [thumbsup2]
 
Upvote 0 Downvote
Hi Solo,

Thanks for the DB.

I thought it would be something simple.
=====================================

Function SearchForReferencesFileLocation()
On Error GoTo Err_SearchForReferencesFileLocation
Dim strDirectory As String 'add this line to your code

=====================================
Dim strDirectory As String is missing from the above function. Other than that, you really got the hang of this routine, well done.

All the best

Bill
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dpk136
  • Locked
  • Question
Referencing form fields problem
Replies
8
Views
75
dpk136
dpk136
ps32208
  • Locked
  • Question
referencing a table record in query expression 2
Replies
3
Views
50
jsteph
jsteph
sleonard1432
  • Locked
  • Question
Cross referencing a RS for multiple forms...........
Replies
0
Views
34
sleonard1432
sleonard1432
Crowley16
  • Locked
  • Question
Query referencing practices question
Replies
2
Views
29
Crowley16
Crowley16
Sydney1
  • Locked
  • Question
Referencing Access 2000 Runtime Question
Replies
3
Views
49
Remou
Remou

Part and Inventory Search

Sponsor

Back
Top