Has anyone been using the .Net class library
to gain functionality from VBA?
Just curious.
Bill

What's the best way to enter a new record in a table (I know there are so
many ways)?
Before the record is saved:
1. All the field need to be validated before the the record is actually

I have a small app I'm testing (access 2003) which gets installed on the
workstations of remote users. These remote users are connected to the
server (win 2003) via vpn. Normally the remote users are not part of the
same domain. The app queries sql server express data via pass ...

I have a form (Access 2003) that has two list boxes.  One list box, called
sales_orders shows sales orders with the first field called salesorderid.  
If I select any order in this list box, I want a second list box, called
sales_order_details to show only the items in for the ...

What vba script should I use to link an unbound field to a bound field in
Form A so it will update Table B on save.
Here is the situation-I have created unbound fields in Form A to get info
from a query and to carry out calculations.  However, I want this information

I have developed a form (A) from table (B).  I needed to bring info into some
of these fields from a query so I used =DLookUp in the Control Source.  Also,
I used calculation expressions in the control source for other fields
(=[field]*[filed2]).  In order to do this the initial ...

I have a form that displays a list of facilities that are assigned to a user
(it brings up the list based on the username they enter when logging into the
database).  They could have one or many records listed on their form.  
I want them to be able to select a checkbox next to ...

To save development time to it's minimum, I'm considering to use the
datasheet display of each of my forms in read-only together with the normal
formview in editable mode. The reason is that the datasheet display allows a
(more) flexible way to sort, filter and search records ...

I have a form called frm_pip_at.  On this form I have a text box called
pip_id.  I also have a command button with an on click even procedure.  This
opens a report called rpt_pip_at.  The report also has the text box pip_id.  
When the command button is clicked I want the report to ...

I am trying to use the full contents of a listbox as a source to print a
report.  On the form with the listbox is a button to print the list with the
following code tied to it.
Sub cmdPrint_Click()

I've posted this before, but haven't been able to get an answer.....
Here's what I'm trying to do.....
I have a form who's recordsource is a query that pulls records with a date of
30 days before today's date.

Hello, green VBA Coder here
Probably a simple answer here.
I have modied code from Allen Browne's code for the ajbCalendar code.
Instead of using it for a calendar popup, I am using it for a

I am trying to transfer a value from one form to another  when I activate the destination form and then close the source
form (frmRecordViewer).
When I enable error checking, I get runtime error 438 on the KeyVal assignment line.
When I disable error checking the routine works fine; ...

I want to ask if there is a way to make a procedure or a function devided
into segments like the dot net showing plus and minus just like in the
example
Function Post()

ive created a code on beforeupdate event on my mainform to confirm any
changes made
and also in the subform but my problem is a confirmation keeps on popping on
every add of record on my continous form subform