Can anyone help me with this? I have no idea why this is generating an error
"extra ) in query expression" and also it's not getting the value of
TrackNoValid field... Thanks!
 strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid, [TrackNo

After I run several queries with a macro, all the tables, or datasheet views
stay open.  I have to manually close each one of them.  Is there a vba that
loops through all tables and queries in the database and close all the opened
ones?

I have a hidden form which I want to requery, then take the focus back to the
same record that had focus before the requery.
I presume I use the GoToRecord action but I need to find the record number
beforehand so that I can use this in the Offset argument.   How can I do this?

i have a DB, got it running great, now i'm trying to let other people (about
3 people) in the office to share this same DB not to do update or change
data, just for print report and use query only, i'm not sure i should share
this DB on a network (i use wireless network now) ? or ...

How do it get the result variable passed back to the original sub from a
called function?  
IE the result of this call function is a variable that is used in the sub
Call EnterSubProjValue

So, I've been working hard at learning Microsoft Access and have made pretty
nifty tools to help do my job better. I've started writting some VBA and
custom functions. I want to make one of my queries a little more dynamic,
edit some of the filter without actually going into the ...

How do I compute the next alphabetic character through code?  I have a
variable (string) containing a single alpha letter (ie 'B') and i need to
determine the next alphabetic value (ie "C").  How can this be done?

What code can I use to list all of the tables in a database, or all of the
fields in a table?

Hi I am in the final stages of finishing a database. I have my forms 5 total
set up in a tab control. In three of the forms I have text boxes that I do a
look up from other forms (I use this as a reference tool so I don't have to
keep going back and forth between forms).

I have created a recordset using a SELECT statement that looks like this,
using DBOPENDYNASET
Set prstTest = CurrentDb.OpenRecordset("SELECT 0 AS IsSelected, * FROM
QRY_CUSTOMERS")

I have a subform set to Continuous Form, and a combo box on that subform for
selecting records to add to the table.  After a selection has been made from
the combo box, I want to lock the combo box so no change can be made. Yet, I
still want to be able to add new records.

Does someone have such a function?  Or ref a website that explain the math so
I can create one myself.
Thank you in advance,
Daniel

I am trying to run the below SQL statement in code. VBA doesn't like it. I am
trying to wrap the text as well. I have searched help on wraping of text and
I find the below is one method. I am not sure.
Could anyone help? Thanks Matt

My problem is that I have two linked (Not to each other) tables with
different field names for the same value (integer).  My INSERT INTO table is
using a different field then the SELCET....FROM table.  I am populating the
the SELECT....FROM table from combo boxes on the form ...

I have a network of 3 computers.  Machine 1 has an access mdb file used for
taking customers' orders which works well.  I have copied the program to
machines 2 and 3, and linked these to the tables in the program on machine 1.
Sometimes this works, but I often can not enter any ...