I.T. Discussion Community!
Highlights Updated Posts Unanswered Posts Online Today Who's Reading What Member Birthdays!

HighLights (Access Group)

Switch to New Group Posts By Type view.

New: Access Group Members

1. trsleigh  (19 visits. London UK) 2. Nathan.C  (16 visits. Banner Elk, NC USA) 3. morke  (3 visits. IRELAND ) 4. Kenneth.G  (2 visits., -- --) 5. Andrew.T2  (12 visits. bury st edmunds, UNK UK) 6. DurbanDriver   (3 visits., -- USA) 7. ronando  (57 visits. Italy ) 8. chicarnam  (4 visits., -- USA) 9. Lewy  (7 visits. Northampton, -- USA) 10. MPWhite   (14 visits. Portland, -- USA)

New Access Posts: All Types

View:
New?   Title Created By For...
None. No highlights in last 90 days.
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New: Access Message Board Posts

Go To: Access Message Board

Thread 5 of 5
Thread Starter  

jseidel
Reading Paradox tables from Access 2007
I have an Access application that imports data from Paradox tables in an existing, external application (Timeslips by Sage). App was originally written in Access 2003 and I was able to link to several Paradox tables and read them successfully (no update is required). We upgraded to Access 2007 and the existing Paradox links work just fine but I have been unable to create new read-only links to more of the Timeslips' Paradox tables. The new Import wizard assumes a read-write link and then fails with the error:      "Unexpected error from external database driver (11010)." Development is on a Windows7 64-bit machine and deployed to a WindowsXP machine (soon to be upgraded to Windows7). I've tried linking on both machines and NoGo. I've also tried searching the web for code that could handle this but to no avail. Any suggestions as to how I can accomplish this?  Thanks very much.,
Posted to MB Topic: Access VBA Programming
9 years ago
69 replies. Last post:

Anonymous
Thanks for taking the time to share with us such a great article. I really appreciate your work. It�s difficult to find excellent writing like yours nowadays. Usually I visit your blogs and get updated through the information you include. best business statistics assignment help
33 hours ago
New Stuff Since Your Last Visit
6258
Hits

Thread 4 of 5
Thread Starter  

PS_2515
Best Blinds Online
Get stylish and modern Newcastle Blinds to cover up your window and other desired location. Lakeview Blinds Awnings & Shutters carefully manufacture the best quality products that are long-lasting. Get affordable shutters, blinds, awnings, security screen door, window screens & coverings. Browse now. 
Posted to MB Topic: MS Access Interactive
8 days ago
Nothing New Since Your Last Visit
9
Hits

Thread 3 of 5
Thread Starter  

PS_2629
Plan A Family Weekend Trip To Nepal Using The Foll
{Too Long!}
Posted to MB Topic: Access VBA Programming
29 days ago
Nothing New Since Your Last Visit
12
Hits

Thread 2 of 5
Thread Starter  

PS_2531
roku.com/link
{Too Long!}
Posted to MB Topic: Access VBA Programming
58 days ago
Nothing New Since Your Last Visit
19
Hits

Thread 1 of 5
Thread Starter  

PS_2516
Graduation Invitations
{Too Long!}
Posted to MB Topic: MS Access Interactive
65 days ago
Nothing New Since Your Last Visit
35
Hits
More...

New: Access Knowledge Base Posts

Go To: Access Knowledge Base
  KB Article    

Douglas.M
1. How I Make a Multiple Page PDF File Scroll to a Specific Page in a Browser

This article discusses a programming technique I used in a Microsoft Access database application to display a multiple page PDF document and make it position itself at a specific page.

Posted to KB Topic: Access & VBA
12 months ago
(1 Comments , last by avi.l )

Article
Nothing New Since Your Last Visit
372
Hits

Laura Lage
2. MySQL Connectors and MSAccess Office 2007 Errors

Queries on a Microsoft Access database linked to MySQL tables failed with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing (Microsoft Access cannot find the field "fieldname" referred to in your expression).

Posted to KB Topic: Access & VBA
6 years ago

KB Post
Nothing New Since Your Last Visit
2661
Hits

Mike Prestwood
3. Access VBA Array (x = Array())

Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: Access & VBA
10 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
11961
Hits

Mike Prestwood
4. Access VBA Empty String Check (Len(s&vbNullString))

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: Access & VBA
11 years ago
(1 Comments , last by petter.s )

Code
Nothing New Since Your Last Visit
17964
Hits
More...

New: To/From Code

Go To: Access To/From Guides

Code Snippets

  Code Snippet Created
1. Array 3/20/2010
2. Comments 1/1/2009
3. End of Statement 1/1/2009
4. Case Sensitivity 1/1/2009
5. Literals 1/1/2009
6. Variables 1/1/2009
7. Assignment 1/1/2009
8. String Concatenation 1/1/2009
9. File Extensions 1/1/2009
10. Unary Operators 1/1/2009

Topics

  Topic Category Created
1. Array Data Structures 3/20/2010
2. Comments Language Basics 1/1/2009
3. Left of String Commands 1/1/2009
4. Prevent Derivation OOP Details 1/1/2009
5. Abstraction OOP Details 1/1/2009
6. End of Statement Language Basics 1/1/2009
7. Case Sensitivity Language Basics 1/1/2009
8. Literals Language Basics 1/1/2009
9. Variables Language Basics 1/1/2009
10. Assignment Operators 1/1/2009

New: eCertified Study Questions

Go To: eCertified
Question Level Type Based on KB Post KB Topic
Arrays in Access VBA are 0 based. 2 TF {Too Long!} Access & VBA
{Too Long!} 2 TF {Too Long!} Access & VBA
{Too Long!} 1 TF {Too Long!} Language Basics
{Too Long!} 2 YN {Too Long!} Language Basics
{Too Long!} 1 TF {Too Long!} Language Basics
{Too Long!} 3 MC {Too Long!} OOP
{Too Long!} 3 MC Access VBA Destructor OOP

Switch group?

Water-Cooler:
  • AmericanIT HighLights
  • Industry HighLights
  • Linux HighLights
  • Owners HighLights
  • PrestwoodBoards HighLights
  • Windows HighLights
  • IT Professionals:
  • Analyst HighLights
  • Coder HighLights
  • DBA HighLights
  • Proj Man HighLights
  • Tech HighLights
  • Tech Writer HighLights
  • Tester HighLights
  • Desktop Databases:
  • Access HighLights
  • Paradox HighLights
  • V.FoxPro HighLights
  • Website Scripting:
  • ASP Classic HighLights
  • Design HighLights
  • JavaScript HighLights
  • Perl HighLights
  • PHP HighLights
  • General Dev Tools:
  • C# HighLights
  • C++ HighLights
  • Delphi HighLights
  • Java HighLights
  • Prism HighLights
  • VB Classic HighLights
  • VB.Net HighLights

  • Follow PrestwoodBoards on: 


    ©1995-2020 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech