I want to make a demo version of my database solution and I thought that a
version where the maximum number of records in any of the tables was, say 10.
does anyone know if this is possible. or a better idea as a demo version.
Appreciate your ideas.

I am fairly new to Vba and have been trying to implement a Select
statement with 2 criterias but i keep getting the same error No value
given for one or more ewuired parameters. Any Help will be much
appreciated. This is my code as follows:

Could you provide me solution for the below problem..?
I listed the name in a combo box. When i create New name by using Double
click which would open other form and get input for the new Name. But, When i
close that form, it is not coming to current form. It comes only when i ...

The fourth statement in this code returns an error message when the
expression has no value.  The error code is 2427 -"You entered an expression
that has no value."  When MyValue has a value, in this case a date, then
there is no error.   This is part of a function module that I ...

I have a query in my Access database that I need to export in an existing
pre-formatted Excel worksheet. I programmatically place the results of this
query into a recordset, then I use CopyRecordSet to copy the data into a
specific location in the Excel sheet.

This is the VBA code executed from OnClick on a form's command button, to run
4 macros:
Private Sub Command160_Click()
   DBEngine(0)(0).Execute "Append to Delivery List Table", dbFailOnError

I've made an Access application that provides a better interface to a
legacy DBF based DB program. I import all the DBF files as tables and
then use my own forms and queries to view it. When the legacy DB
program vendor ships updates they ship new DBF files. Previously I've

I have discovered that creating a field in VBA code as dbDecimal causes an
error but creating it as dbBigInt works fine. After appending the table the
field properties (in code) show dbDecimal.
Anyone have more information about this issue.

I have a database that is opening excel and doing a few things with it.  My
problem comes at the end it doesn't want to close the Excel process so if the
dB is run again it returns an error.  My code is below.  Thanks.
Option Compare Database

I used Adobe PDFWriter to print access via module.  It works great until my
company upgrade to Adobe 7 professional.   Adobe 7 professional does not have
Adobe PDFWriter.  It uses Adobe PDF instead.  I spent months on google to
find the solution but in vain. Could anyone show me ...

I have written an application that sends a command to play a wav file when a
certain condition occurs. Now I would be able to to send a signal direct to a
serial- or printer port to close a small relay contact at the same time. Does
anyone know how to adress any of the ports with ...

In using VBA in MS-Access, can someone give me a 50 word or less explaination
of the differences between sub routines, private sub routines and fuction
modules?
Thank you in advance.

Hi
I am trying to setup a button that will select a report and attact it as a
excel file to a email
when you click the button it will ask which team leader do you want, you type

In microsoft access vba programming how do i enter the words in a text box
and count the number of spaces between the words to be displayed in a message
box?

I found that using 'environ("Username") ' can only returns the windows login
ID, what can I do if I want to get the window's "Display Name" ?
Thanks
Best Regards