I've created the following:
Dim objConn, objCommand, objQry
Set objConn = Server.CreateObject("ADODB.Connection")
Set objCommand = Server.CreateObject("ADODB.Command")
objConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;Data...
I've created a form which contains a subform of payments, a list box of unpaid invoices, and a list box of invoices allocated to payments in the subform.
I want to update the allocated invoices list box using the On Current Event in the subform. The list box is based on a SQL user-defined...
I'm currently building a SQL Server database, with an Access 2000 front-end. I've set all numeric fields to not Allow Nulls, and I've set default values to 0. I want to control null values in the Access forms, so that when the user enters a null value a before- or afterupdate event procedure...
I'm currently building a SQL Server database, with an Access 2000 front-end. I've set all numeric fields to not Allow Nulls, and I've set default values to 0. I want to control null values in the Access forms, so that when the user enters a null value a before- or afterupdate event procedure...
We currently use a large Access 2000 database but we're planning to upgrade to a SQL Server back-end and Access front-end. The database is supported in-house and there is a lot of Access expertise (VBA, SQL etc) but no SQL Server experience. Could anyone give me tips on the best way to go...
I'm currently using mail-merge to e-mail in Word XP, but want to add an attachment - either manually or programmatically. Does anyone know how to do this?
Thanks.
The default security features in Outlook 2002 mean that when I programatically email from Access the user is prompted with the following message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this?.
This makes large mail-outs virtually impossible to run...
I've recently converted an Access 97 database to 2002 format. However the autoexpand on combo boxes no longer seems to work. The property is set to Yes and there is no other code referring to this property. I've tried adding a new combo box and the autoexpand worked, and all the old combos...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.