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  (7 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   (13 visits. Portland, -- USA)

New Access Posts: All Types

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  

Trapping Access Error 3200
I have another post that is related to this one. In my claim form, if I change the key and then tab until I would normally go to the next record, I get error 3200. What I would like to do is trap it. So, I tried putting in the OnCurrent event this code, , on Error Goto err_try, err_try:, if err.number=3200 then, msgbox "blah blah blah", sendkeys "{esc}" to put form back the way it was, end if, , However, I continue to get error 3200 instead of my message box. Have i tried the wrong event? I also tried before and after update and lostfocus. Help!!
Posted to MB Topic: MS Access Interactive
16 years ago
1 Reply:

good and also select it from the listing of tools shown at the top, in Xcode. Kodi Chromecast   an "Organisation Identifier". For this guide nice.
4 months ago
Nothing New Since Your Last Visit

Thread 4 of 5
Thread Starter  

Craig Goodman
Combo Box won't update with specified value
As this is my first post to this board, I will try not to complicate this with unnecessary information. I am trying to set a combo box to a specific value (the name of a loan) using VBA for when the form opens. The combo box is populated with Loan Names from an Access table. Currently, I am using the following code to set the list index property (I have used this with excel vba before and it worked):   Combo_LoanName.ListIndex = 3  The problem is that when the form opens the combo box list is populated but no item is selected. I have tried other variations of the code above but to no avail. Can anyone spot what I may be missing?   Thanks, Craig
Posted to MB Topic: Access VBA Programming
10 years ago
Nothing New Since Your Last Visit

Thread 3 of 5
Thread Starter  

Missing Page Header in Subreports
Hey:, , I have a master report that contains independent subreports (that have no data relationship to the master report - the master report serves as a 'shell'). , , My problem is when the master report is previewed or printed, the page headers in the subreports do not appear. I'm baffled because while in design view, when I select the properties for a subreport's pageheader, the visible property is 'true', yet it does not show., , Anybody have this happen or know how to force the pageheader within a subreport to show?, , (How do I reference a subreport pageheader in using VBA from the master report code?), , Thanks!
Posted to MB Topic: Access VBA Programming
15 years ago
Nothing New Since Your Last Visit

Thread 2 of 5
Thread Starter  

Sparatic Query Behaviour
{Too Long!}
Posted to MB Topic: Access VBA Programming
16 years ago
Nothing New Since Your Last Visit

Thread 1 of 5
Thread Starter  

Schedule database
{Too Long!}
Posted to MB Topic: Access News / Other
15 years ago
Nothing New Since Your Last Visit

New: Access Knowledge Base Posts

Go To: Access Knowledge Base
  KB Article    

Laura Lage
1. 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
32 months ago

KB Post
Nothing New Since Your Last Visit

Mike Prestwood
2. 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
7 years ago

Nothing New Since Your Last Visit  

Mike Prestwood
3. 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
8 years ago

Nothing New Since Your Last Visit

Mike Prestwood
4. Access VBA Self Keyword (Me)

Same as VB. The Me keyword is a built-in variable that refers to the class where the code is executing. For example, you can pass Me from one module to another.

Posted to KB Topic: Language Details
8 years ago

Nothing New Since Your Last Visit

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


  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?

  • 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
  • -
       Contact Us!
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    1,518 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...

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