My Assistant
Site Message
(Message will auto close in 2 seconds)
 Removing The 'required'/not Null Restriction Using Vba, Office 2003
|
|
 Sep 14 2011, 06:26 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 293  |
Hi, I am trying to use the ALTER TABLE, ALTER COLUMN command in vba to set required=no of an existing table but can't figure out how to do it.
Here is the code I currently have. What needs to go inplace of ....? Thanks CODE Dim cnn As New ADODB.Connection
LinkPathFile = Mid(FindSource(), 11) With cnn .Open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & LinkPathFile .Execute "ALTER TABLE tblRequests ALTER COLUMN RequestFee ....." .Close End With |
 |
 
|
 |
Replies
|
Sep 14 2011, 12:18 PM
Post
#2
|
|
|
UtterAccess Addict Posts: 293 |
Thanks for the link. I've read that and will use DAO, but could do with some sample code as the code I had I had copied from elsewhere, so it's a bit beyond me.
|
|
|
|
Posts in this topic
ddaddy Removing The 'required'/not Null Restriction Using Vba Sep 14 2011, 06:26 AM
vtd Try NULL in place of .... Sep 14 2011, 10:56 AM ddaddy I've tried that, I get Syntax Error in field d... Sep 14 2011, 11:09 AM vtd Sorry... I was thinking of T-SQL.
I normally use ... Sep 14 2011, 11:51 AM vtd Check Access VBA/DAO Help on the Required Property... Sep 14 2011, 12:38 PM ddaddy Had to make add some more code as i'm using a ... Sep 14 2011, 01:37 PM vtd You're welcome... Glad to help... Sep 14 2011, 08:33 PM
Darwood QUOTE (ddaddy @ Sep 14 2011, 06:37 PM) Ha... Jan 10 2013, 07:00 AM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 02:00 AM |