Is it possible to make the new record blank row be at the top of a data table rather than at the bottom?

My update isn't updating the table. Why?
Code is:
strSQL = "Update AVAILABILITY " & _
       "Set AVAILABILITY.[Booking ID] = " & varNewID & _

I'm not able to get the "Advanced Filter/Sort" option under "Records/Filter"
in the table maintenance window to work.  I choose it, and it puts me in the
query builder, and I enter my criteria, but when I came back out and click
"Apply Filter" nothing happens.  When I go back in to ...

I AM TRYING TO FIND OUT IF THERE IS  A WAY TO TO OPEN UP OE AND GET THE
INTERNET TO CONNECT AT THE SAME TIME OR SOMETHING SIMILAR TO THIS
FUNCTION...IS IT POSSIBLE...

I have a report that is grouped by a field named [Region].  The report is
launched from a dialog form which contains a Region List Box.  The report
prints data for Regions selected in the list box.  If there is no data
present for one or more of the Regions selected, the report does ...

How can I backup data in Access 97 so I can retrieve it if
disaster strikes? also, how can I copy Access data to use
in another computer? can I copy or backup data from Access
97 to be restored and used in a later version of Access?

I have two forms FrmA and Frmb.
A command button on FrmA is used to open FrmB.
What code do I need to use to prefill controls on FrmB with values from
FrmA?

What's the best way to
I need to write a little Access application to collect data for later
analysis. I will be hiring some high school kids to do the actual data
entry. They will be working on it over the summer.

With regard to the following code it doesn't update the
table:
strSQL = "Update AVAILABILITY " & _
       "Set AVAILABILITY.[Booking ID] = varNewID " & _

I've set up a database for a nonprofit food distribution center.   The
manager wants to limit the number of times a client can use the center to
once a month.
I have a mainform based on tblClients that has a continuous subform based on

Hey all
How in VBA would you check to see if a file exists to determine whether to proceed or not
Thanks
ari

Hi all,
I have this problem with a subform in that it will not open/refres
with a blank/new record for the user to use. I suspect it is because o
this recordsource...

I get drop zones for Pivot Charts but
NO DROP ZONES FOR PIVOT TABLES.
access 2002
Anyone know what this problem is? Its driving me crazy.

Cannot open a database with a previous version of your
application.....This is the error message we get once we
upgraded our office package.  We were currently on
Office97 Pro and upgraded to Office XP Pro and we get the

Hi al
I have change the Tools->Startup and remove the Allow Fullmenus,Default Shortcut Menu,Builtin toolbar and select a form when startup. How can I remove these setting to default?