Is it possible to view the entier VB coding for the entire database in one
screen, so you can use the find & replace tool to replace certain text
throughout the whole database?  As if you need to update your naming scheme
and take the spaces out, etc....  VB that includes Tables, ...

I'm not sure if I'm in the correct group here or if I should go to Access
Queries.  Here's my problem.  I am trying to create a query in Access using
SQL because I just can't figure out if it can be done using a regular Access
Query.  I am very, very new to SQL.  (Teaching ...

In Access 2000, I have a project (Citrus.adp) where I'm setting the row
source for the TripCode field in VB.  I'm using a SQL statment that joins 2
tables (Trip and Trip_Payment) and gets fields from both.  Trip_Payment is
the form's unique table.

Me again - new to this, I forgot to click a button.
The question is - I wish to create an MDE of my ACCESS db but the option is
greyed out. I have VBA. How do I activate this option?

I want to create an MDE (executable) version of my little ACCESS database but
it is greyed out on my ACCESS. I have VBA. How do I make it available?

I'm having a TOUGH time trying to get this going...
And what makes it so aggravating is that I'm sure it's something simple.....
I'm just not familiar enough with Access VBA, Modules, etc to do it.
After  lots of reading on this board......it looks like the SHELL command is

Using VBA, I want to loop through an access table to see if it contains a
certain record but I'm having problems.  Can anyone help with this?

Hi, i want to open a form from an already open form, storing a field in a
variable before the new form opens, i then want to use this stored value in
the newly opened form to select a box and set its visible property to false.
I posted a question on this last week and was given ...

I may be totally missing the point but how do you set the Displayed date
when opening the activex calendar control?
I thought xCalendar = Date would suffice, but it always opens showing
14/05/04.

Hi. I need the syntax for opening a form using a condition.
i want to open a form from within another form using a click button.
here is what i have so far
the variable below is given the text box value from the current opened form.

If I use the code below, records are deleted from my table if I replace
tblModel with the name of a real table.  However, I need to use a table
variable instead.  I've set it with tblModel, which gives the correct table
name, but it doesn't work within my RunSQL.  Any ideas how I ...

Hey people,
I have logged onto the discussion groups and can see it flooded with garbage
like sex trial blah blah blah...
Whats happening here. Is Microsoft monitoring these Forums?

Good Morning Everyone,
I'm making a database and I'm playing with it using test data. When
I want to put the actual data in, how do I reset the autonumber back to
1? How do I tell the database to completely delete the fake records so

I have a table of suppliers (tblSuppliers), including a field [email status]
(Yes/No)
I have a query (qrySuppliersToMail) that includes only the suppliers marked
Yes

I always use DAO e don't konw well other methods like ADO. This is the code
I wrote:
table 'tblFOXPRO' connect by odbc
Dim DS As DAO.Recordset