I am attempting to create a Petty Cash database that will ultimately
print a pre-designed petty cash receipt, a report on expenditures by
account number with account name, and a report which will show the
transactions for a given period and a balance.

I am a .NET/C++ developer who is supposed to do some work with Access.
I do not know much about it except for the DB part.
Questions:
*1*

I need to keep credit card number details for short time to produce a
banking report then to delete all but last 4 didgits displaying * or #
for all other didgits....
Has any one needed to do this...???  

I am having a problem with my Access 2000 front end to a SQL 7 or 2000
database.  I create a table in SQL with a field named, say, amt, data
type MONEY.  When I link the table in Access using ODBC, the field is
defined as CURRENCY, as expected.  Now, if I use SQL to populate the

I am running a complex query using about 25 criteria that are entered
on a query form. If any individual criteria isn't required its field is
left as "*" on the form.  When I run the query the first time the
results take about 3 or 4 seconds to appear on a "Query Results" form.

I need the ability to update a query that is grouped.  Let me try to
explain the situation.  I am creating a database that will compare %
complete of a job by the actuals (Earned Value).
Each task might span 4-5 months.

I have a database that recieves information throughout the night
through a feed. I need to be able to automate the sending of individual
reports to folks based on a time schedule.
My thought is that I would use a task scheduler to open and close a

I would like to set up a task scheduler in a database but I am not
sure how to go about it.  I would like to have a list of things that
need to be attended to for out clients eg. report being sent, phone
call made to client, request for docs from client etc.  I would want

Say I have a field named Numbers in MyTable and the field contains 500
random numbers between 1 and 1000; no duplicates. How do you write a query
to randomly return 50 records with no duplicates from the 500 records in the
table?

I am using the Command Button Wizard to create a 'Find Record' button on my form. The Wizard sets the defaults to be 'Find Next' for the buttons and 'Whole', 'Entire' and 'Current Record' for the criteria. How can I change these so that everytime I open the form, I don't have to ...

   I just started using Access' Template file "Time & Billing Database"
Well among other items I need to change the biggest right now is resetting
the Client, Employee, Project ID #'s to start at 1.  
Is there a simple fix for this?

i'm really hoping someone can help here..
i have just upsized my app to sql server and most of my forms use the autonumber field in access and everything worked fine. now with sql server i can not get everything to work as it used to as sql does not generate the autonumber until ...

Heya,
I am doing some background reading about the database and i am a
little bit confused, i would appreciated any help....
Assume been asked to draw the ER diagram for the following statement:

Hi I have searched and found lots of stuff and played with some but
couldnt get anything to even remotely work. I have a directory with
multiple .csv files i would like to import them all into a
corresponding table. Names run seqentially from cell01 - cellx but may

I have created a procedure called TableFlattening(). When running it
thru a macro, I call this procedure via a function
Public Function DoFlatten()
Call TableFlattening