Can VBA indent my code for me? Using Access 2003.
Best,
Christopher

Sorry if the content has been posted before, but I have had problems with my
ISP's news sever.
Hi all.
Could somebody please advise me how you write code to manipulate the CanGrow

I have a form that works best in single form view (it's too big and unwieldy
for continuous view) displaying several records (all from the same table)
about various suppliers that my company uses. What i would like to do is set
up some form of navigation, either in the form of a ...

Is there a way to have a runningsum effect in a textbox to show the number
of the record that a query has returned?
For example if a query returned 5 records
1st record would equal 1

I have a form for user administration.
Only managers ([userlevel] = 2) and administrators ([userlevel] = 3) can
access this page.
By means of a combo box selection I can display any user's details on the

I piched a bit of code from the newsgroup that was sent in yrs ago, to kick
off Groupwise and send a table's contents in Excel format.
It all works great apart from two points that are pedantic for me...
Here's the code:

I have a subform which pulls up certain data to be
modified from a large table.  I have a field in the large
table called dtmDateMofified.  Each time a person pulls up
a record and modifies it in some way using the subform, I

Hello all, and thanks in advance
I’m trying to copy a file then rename using VB in access.  I looked at the
docmd.copyobject, but it looks like it is for objects within access.
First question is can it be done?  If so how, I have tried the old DOS way;

I am new to programming and VBA.
I have a datasheet form where the user enters ticket info...ticketdate,
ticket#, etc.
cboProduct filters data based on the value in 2 other combo boxes.

Ok, this should probably be easy, but I can't grasp what to do.
How can I code a button on a form to launch a website address?  E.g., "Go To
Google"

This is supposed to be easy (from what I've read) but I guess I'm just
not experienced enough with Access 2000.
*******************************
Scenario:

im making a little form in my database, which will require the user to enter
a date, im wondering if it is possible to have it so that when you click on
the date field within my form, the user gets presented with a little calendar
to pick a date from?

I am trying to create an order number that will appear on both my order
form and orderinvoice.
What I have is a combo box that the user selects the order type:
 Either Custom, Program, or Sample

Can anyone tell me why this code does not work?
editper = Forms![requests]![Subrequests].Form![StaffID]
Dim lstrSQL As String
lstrSQL = lstrSQL & "Select firstname, lastname "

In a big mdb files, i want to create a table.
If the table already exist i want to erase it before.
My problem is i want to know if the table exist before deleting it.
I dont want to delete it and do error processing if the table does not