IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
KB
   ► KB ► > Access VBA Posts  Print This     

Access VBA Posts

"Access VBA" Knowledge Base Posts

More...
  KB Article    

Mike Prestwood
1. The Future of Paradox Blog

If you have an existing Paradox system you can keep using it but you'll need to skip the Vista operating system and either stick with Windows XP or move to Windows 7. Because better tools exist, you may very well want to put a plan together now for converting to another development tool or at least understand what the future is likely to hold. If you're a power-user or researcher working with data, stick with Paradox.

Posted to KB Topic: Tool Basics
15 years ago, and updated 12 months ago
(44 Entries , last by maria.s3 )

Blog
Nothing New Since Your Last Visit
67100
Hits

Corel Paradox / ObjectPAL Coding

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
10 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
11958
Hits

Microsoft Access

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
11 years ago
(1 Comments , last by petter.s )

Code
Nothing New Since Your Last Visit
17963
Hits

Microsoft Access

Mike Prestwood
4. Access VBA Logical Operators (and, or, not)

Same as VB. Access VBA logical operators:

and and, as in this and that
or or, as in this or that
Not Not, as in Not This

Posted to KB Topic: Language Basics
11 years ago, and updated 11 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
26801
Hits

Microsoft Access

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

Code
Nothing New Since Your Last Visit
11577
Hits

Microsoft Access
More...

"Access VBA" Message Board Posts


Thread 4 of 4

Erik Long
Access VBA Timing Functions
I have several tasks that must be carried out by an operator trainer. This is an evaluation operation. The trainer watches an operator perform tasks and times the machine operator for the amount of time it takes him/her to complete the task., I am setting this up in Access. So that the trainer can open the form from the switchboard, and click a button. The first time it is clicked, it will start timing until it is click again, at which time it will fill the time it started/stopped and the total time in 3 separate fields. ( Sorry, run-on) This is being put on a laptop, for the field., , So far I have NO IDEA HOW TO DO THIS., I NEED HELP! I HATE VBA!, , Thanks,
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago
1 Reply:

dmichael
Use a table with fields for Worker (txt), Job (txt), Start (datetime), and Finish (datetime), , Use a form as an interface to this table. Put buttons on the form for start and end. Pushing start should update the start field to be equal to now(). Pushing end should do the same for the Finish field. Calculating time is done using Datediff("n",... so that it counts minutes., , Hope this helps., darron
13 years ago
Nothing New Since Your Last Visit
2177
Hits

Thread 3 of 4

Peter Ferber
Assigning Bitmap to Access "OLE Object"
{Too Long!}
14 years ago
Nothing New Since Your Last Visit
2387
Hits

Thread 2 of 4

Peter Ferber
Using VB to assign bitmaps to OLE Object Field
{Too Long!}
14 years ago
Nothing New Since Your Last Visit
3245
Hits

Thread 1 of 4

Bon
Pdox to Access VBA conversion :(
Hi!, , Unfortunately, we've had to leave our beloved Paradox behind when the gods deemed Windows 2000 was coming & IS would no longer support our paradox. Does anyone know of any documentation on comparable scripts between the two? I cannot even search for something similar to XTRIM in Access's help database - it's so frustrating! Any guidance on documentation would be greatly appreciated - thanks Confused
Posted to MB Topic: Convert To/From Paradox « Paradox Board
14 years ago
3 replies. Last post:

DeltaSlyHoney
Hi,, , try , , LTrim$() to trim to the left,, RTrim$() to trim to the right,, Trim$() to trim both ends
14 years ago
Nothing New Since Your Last Visit
2992
Hits


Icon Legend:
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).
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]