I have a write a application with Access front end and sql server backend. I
want to take the advantage of stored procedure and triggers of sql server in
this application. I have not written Access sql server application before. Is
there any article/web site that may be helpful ...

What I need is to be able to format an Excel file from within Access VBA code.
I recorded a macro is excel and tried using the code in Access and obviously
it had different sytax.  Does anyone know a good resource or website that can
help me with this?  I have searched to no avail.  ...

Access 2003
I want to assign the next sequential number to a field (I can't use
autonumber since I already have an autonumber in this table)
I read about dmax but always in conjunction with single user environment,

Hi, I have learned from here to use a code entry as a date.  It works out
great and fast for the users to input the date on a form.  I have set up for
a maximum of 8 days (8 keys), however some users may be out for a long
vacation, the date-field will be input manually.  I don't ...

I have created a matrix of command buttons as shown in the code below. I have
a function with two parameters that are based on the command button name and
position in the matrix. When I call the ClickEventProc (ctl, intY) function,
it creates the Click procedure and the function ...

First post here (and somewhat new to Access), so let me know if I
should post this question elsewhere.  (I'm unsure what daovba is)
My colleague and I are trying to calculate the number of days between
two events.  We're using the code found here: http://www.mvps ...

We copied data from an Excel spreadsheet (created by using Access)
into a FoxPro database. The table had a Pkey in it so we put the next
number into the spreadsheet and incremented it.  The data copied in
just fine.

I'm getting a Run-Time Error '424' Object required error on Ln 7, Col
1 when running the following macro. I'm attempting to open a Query and
export it and name the file name qryEvansDailyRTA & whatever the Date
is in the Date column of the query.xls I cant figure out what's

I will have to develop a userform and I want to control the value of
TextBox which must be an integer not null. What do I have to do? I
wrote this but it is not the good code!!
Private Sub TextBoxl_Change()

I'm trying to import data, modify the data then insert it into a new
table.  The code below works fine for it but it takes a really long
time for 15,000 odd records.  Is there a way I can speed up the
processing substantially? as it currently takes about 10 minutes and

All,
I'm at a total loss, I've used this connection syntax forever and have never had a problem but I'm now not able to get this to work in Access 2007(Vista).
The error Compile Error ("User-defined type not defined") points to "Dim rst As ADODB.Recordset" below you will find ...

What I need is to be able to format an Excel file from with Access VBA code.
I recorded a macro is excel and tried using the code in Access and obviously
it had different sytax.  Does anyone know a good resource or website that can
help me with this?  I have searched to no avail.  ...

Good morning.  Can someone help.  I need to write code in a form where if
column 'A' is blank then allow manual entry into column 'C', else column 'A'
* 94.45.    I'm not sure how to do this or if it can be done.
Thanks!

I'm using code (attached at the end) from a MSDN article to import Word form
data into a Access db.... I made a modification with the help of Mr Doug
Robbins on the open dialog box verus a input box for the file information.
Your help is appreciated!!!!!

I have a simple check keeping database that also prints out checks on laser
single sheet checks.  I created a form to enter the check data, and then a
form to print the check.   This print form only has the pertinent info and is
spaced to fill in the blanks on the laser check.  ...