I have a combo box on my form. If the user chose N, then the label next to
it will show up; if Y, then not. When the form is open, the following VB code
works well, but after I save the record, close the form and re-open the form,
it does not work. You will see the label next to ...

Is it possible to base a form on a recordset instead of a table or query, and
if so, could someone point me to a good example.  The VBA Help on my PC is
not very good (not all the pages appear), so I'm looking more for an
web/external source.

Hi again,
I know I must sound like a broken record but I still have one question
How can I search a field for a range of numbers.  Now I know most of you
will want me to use queries but my boss wants it in VB so I have little

I've seen some good info on this site on creating menus. Right now I have
buttons on my form that I would like a custom menu to perform which will give
me more room on my form.
I'm able to create the custom menus using "Public" modules just fine. But the

If I want to add a field to an existing table in msaccess while a button on
a form is clicked
how do I execute the equivalent of
alter table xyz add fields(abc text(12))

I have posted several questions about this, but I think I am finaly close...
Now I am trying to link two tables, I want the program to search one table
for the user selected criteria, take all of the data in another collumn that
matches that search, and search anouther table to ...

I got help earlier, but I got an error neither of us undersood
The error is:
Run-time error: '3061'
too few parameters. Expected 5

Hello, i've this problem:
Access XP
I've a list view control (different lists) and i want to print the info
inside the list view directly to the printer.

this ones slowly been turning my brains to noodles all day and i need some
help! What ive got is a form which allow a parking space to be set up for a
student, each student has a student reference which is the primary key to the
students database, this also holds the name of the ...

I am trying to create a Loan application tracker that prompts the user to
complete a particular task based on the status the application is in. For
EG...
User is waiting on the return of loan contracts from customer.

Is it possible to make a pause in the code? For example:
Private Sub Form_Timer()
  Set db = CurrentDb
  Set tbl = db.TableDefs("MyTable")

I have used a much publicised code for geting the username.
I have got this working and when stepping through the module fsousername
gets populated with the correct details.
I have a problem getting it in a form, now i am new at this code stuff, i

This question has been confused me for a while. Can I run a web-based
program without webserver? I've developed several Access applications.
Usually, I put the   mdb file on our shared drive and let everyone
access it. Now I would like to use web browser as frontend interface.

Could someone explain step by step the best way to set up an Access 2000
app on a Windows 2003 TS server? There are a couple of threads on this
but nothing very explict.
The backend will be on another Windows 2003 server. There is a skilled

I'm currently having problems coding my form to show in datasheet view
format. I've made changes to Default Views and Views Allowed to Datasheet,
but it still will not take. When I code the form as indicated below:
   DoCmd.OpenForm "Report Date Range", acFormDS, , , acFormEdit, ...