I am looking for a access file that will track stocks and other financial
investments, on a daily basis.  Idealy with inputs for dividends and
additional stock (given in place of dividends)  I have tried to build but
cannot get the results i want.

Hello there, i have searched a lot and I have found no help on how to call up
a form by typing, say shift + insert.
I am using Acces 2003 and wish to call up a form which the user can not exit
out of by the usual X button r anything else. (the latter which I have

I've created a letterwriting application which opens word, prefills a
template with data from Access, prints the word document, saves the document,
then closes it. I've cloned the code in several different routines. For some
reason the latest routine opens word and prints the ...

I would like to ask which operation is faster:
1)    drop table...
       select .... into tblX  or
2)   delete records in tblX

9/1/2005
I am having difficulty opening a query recordset for analysis.
The following code opens the query with no problems when the query has
either no criteria or criteria specified as constants. When I attempt to put

I'm looking in a table for a particular name (the one in a combo box on a
form) that has today's date.  I used the following code, but I'm getting a
type mismatch.  I was not surprised because I was guessing at the code.
If DLookup("txtName", "tblSilTrans", "txtName = " & Chr$(39) ...

Hi - wierdo
here's some nice simple VBA Code to get Author & Title information from a
table in a database.
The 1st field in the table is Record Number, and that's the field that's

I want to put data from other fields in a table into one field in the sam
table.  I guess I may have to use an array to store the whole data in the
table and put it in one field. There is no space is allowe between fields.
Thank you,T.

I've written some code which creates an Excel spreadsheet, enters some text, does some formatting, then saves and closes it.  It all runs without any errors but if I try and open the spreadsheet I just get the header bar.  If I close Access and then try I can open the spreadsheet ...

I'm doing a Time In /Time out / Total for Employee's and I'm using the
function below, but I'm not getting the right totals back.
I'm getting:
Time In        Time Out        Hours:Minutes

I posted this previously, but got no response.  Am I even in the right place
for this question?
I am trying to automate a daily download process that manually requires me
to navigate to a website, select a radio button, fill in two text boxes and

9/1/2005
I am having difficulty opening a query recordset for analysis.
The following code opens the query with no problems when the query has
either no criteria or criteria specified as constants. When I attempt to put

How do I display the current record number in a text box on a form.  I don't
want to use the standard navigation buttons at the bottom of the form.
Can anyone assist me with this please?
Thanks in advance

I've a form in MS-Access that opens with the horizontal scroll position not
on top of the form. What can I do to make scroll position on top?
Thanks for help
Henk

I just upgraded to MS access 2003.  is there a command like filecopy that
will let me copy a file, like test.pdf or test.cvs, from drive c:\ to a
sharepoint site. If yes, can you please provide me sample code. Thank you