Hi Genius,
I have a ProjectUpdate form. The record source of this form is a query.
I remove the navigation buttons from the form and i want to create custom
navigation button.

I need to Right Justify and blank fill a string variable. Any easy way to do
this other than a character at a time?

I inherited API for Windows open dialog
I want to change the  InitialDir:="C:\"   parameter from C Drive to Desktop
Does anyone know how to do this
DZ

Is there a way to set up the "Print..." button from the "File" menu as a
button on a toolbar?

I have written some routines to bypass one of access' weaknesses in the sense
that I only link the forms and bind the fields to the underlying table once a
user has entered certain data. The entered data is converted into sql strings
and then I link the search result to the form. ...

I have a one page report that I need to have print twice.  In other words I
need the bottom of one copy to say something like "home office copy" and the
second one to say "head office copy"
I have tried dim'ing a value in the vb code for a bound control in the

I have a dropdown box that displays an employee name.  However, I want to
populate the employee number field as well as the name field in the table
Procedures.  The dropdown is pulling from table called Employee and I'm
trying to populate the two fields in a table called ...

I am facing this problem.
is there a way to search for an employee's email in the company's active
directory or Global Address List and store it in a text box?
I have a form with 2 text boxes, 1 listbox, and a command button. I want to

I want to use Automation to obtain properties from an Excel 97 workbook from
another Office App
Here is some code I tried. I need help getting it to work. When I run it,  I
get an error message

I've been struggling with this for a long time now. I thought it would be a
simple thing to do:
I'm programming an ADP ontop of a SQL Server db.
I have a form frmCustomers with a subform frmCustomersDetails , the subform

dear sir .
i have done an data base in access -2003 format , but when ever im putting
to work it with office-2000 / 97 . it starting to give problom with un ussual
errors such as fuction not available , un recognsed format , run time code

I have a combo box in which I have coded a dropdown event, i.e.
combo1.dropdown, after entering some text.  However, after updating the combo
box the dropdown box does not disappear.  I would like to add code to my
combo box update event to make it go away.  Can anyone suggest ...

I am trying to open a recordset but with a filter where a column called
"Updated" is the max record.  The column "Updated" is a Date/Time field and
is updated when the record is added (this is done previously by using
rs.Adnew).

Greeting,
I have a form using as search form. In this form there is a txt box for
input a data(Numbers) and there is cmd button for open other form the display
result. I have made this code put does not work:

From inside Access I want to delete a file in a directory. How will the
Visual Basic look like?
Access 2002
Any help will be appreciated!