Access VBA Macro Programming

Bear in mind that when this code runs, it will keep looping continuously forever until you pressCTRL+BREAK,or until you write co ...

One interesting point about the treatment of dates is that in the actual SQL query behind this GUI, the date is always changed t ...

This page intentionally left blank ...

If a query you are going to use in VBA is complicated, encompassing several tables, it is a good idea to work it out first using ...

PA RT IV Access VBA in Action The purpose of this section is to show the reader the worked examples of how they can apply the VB ...

Also, it is important to put theMoveNextstatement in, otherwise your code will never finish and will just stay on the first reco ...

This page intentionally left blank ...

This again works as before, but theAddNewmethod is used to insert a new record. The fields within the recordset are provided wit ...

CHAPTER 23 Getting the Login ID A ccess applications are multiuser and you can have several users loading your application at on ...

Notice that zero values have been inserted into each select statement so the number of columns in each select statement is the s ...

Next, enter a function to return the user name. Enter the following code in the same module: Public Function ReturnUserName() Di ...

To run this from within VBA, you can use the DoCmd object (see Chapter 16 for more information on this object): Sub DeleteQuery( ...

A Simple Use of the User Name Now that you have the identity of the user entering your application, you can begin putting it to ...

This assumes that MyTable has a field called CutomerName. This will create a new table called MyNewTable, which only contains re ...

Not so long ago, I wrote a similar application in Oracle (which is case-sensitive) that had screens to allow users with admin ri ...

I have found that if problems occur, it is worth splitting the Append query into several small sections using criteria so as to ...

Chapter 24 Securing Your Database Chapter 24 Securing Your Database O nce you have created your application, you will want some ...

To run this from within VBA, you can use the DoCmd object (see Chapter 16 for more information on this object): Sub MakeTableQue ...

I have never seen an application that did not come into this category. One of the difficulties is that until several users start ...

Because it does not return records, it is run as a command. In its simplest form, it appears as: UPDATE MyTable SET CustomerName ...