Disabling "Unicode Compression" property by SQL Query
Something in the lines of :
ALTER TABLE MyTable ALTER COLUMN MyColumn DISABLE UNICODE COMPRESSION
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I find myself encouraging carpal tunnel by:
> going to "queries"
> "new query"
> "design view"
> closing the "show table" dialog box
> right clicking the new query
> finally selecting "SQL view".
There has GOT to be an easier way that this 6-step process to ~run a query~ in a _database_ . but I haven't run across it yet though
Set qdfNew = .CreateQueryDef("NewQryDef", "SELECT * FROM Categories")
I am having a problem in creating a Property using the CreateProperty Method to create the property "Description" so I can add remarks in the "Description" property as to what the query is intended to do.
Is there anyone out there that can share information as to how to use the CreateProperty to add the Description property and then fill in a remark?
I know how to see the connection of a linked query, linked to SQL Server: ?CurrentDB.QueryDefs("create").Connect
I need to change the server name in the connection.
I tried in the Immediate window
CurrentDB.QueryDefs("create").Connect = ".test server name."
but that did not change the connect property.
How do I change the connect property?
Therefore when I run this query it will append this 'top value' into the destination table "LedgerTxns".
but I need some setting in the table design grid to ensure this procedure cannot be doubled up by inadvertently running the append query twice.
A relevant unique field in the appended data is "OrderNo" and I need some function to insert into the "OrderNo" field property "ValidationRule"
Print #1, EmailAddress & "," & sLastName & "," & sFirstName & "," & aCoursePrint(0) & "," & aCoursePrint(1) & "," & aCoursePrint(2) & "," & aCoursePrint(3) & "," & aCoursePrint(4) & "," & aCoursePrint(5)
For example, how could I insert a CR/LF after sFirstName and a Horizontal Tab (HT) before aCoursePrint(0)?
Docmd.RunSQL ("UPDATE property set property.status="& "'empty'" & " Where property.propertyid="& me.cmbpropertyid.value &"")
It gives the following error:
Missing ),], or item in query expression '(property.propertyid=4'.
I realize I could simply delete the Caption. However, this is a database I receive weekly from an external source, and it has many fields in it.
This problem occurs in both Access 2003 &
All HOWTOs and helps I've read, do not show a way to do this and when I click "File" + "SaveAs" with the query open, table is not an option.
How do I get this done?
Do I need to change my SQL to "INSERT INTO" and then "DoCMD.RunSQL
strSQL = "TRANSFORM.
"GROUP BY .
"PIVOT myField IN ('Apple', 'Orange', 'Banana')
CurrentDb.QueryDefs("myQuery").SQL = strSQL
If I look at the ColumnHeading property in design, it's set to 'Apple', 'Orange', 'Banana'
The query in Access however is sorting as such. Banana, Orange, Total, Apple
Why isn't my PIVOT IN line sorting the column headings in the order I want!?!?
strCriteria01PVT = "Ucase(Trim(ProjectName)) like ""*" & UCase(Trim(Me.Text4)) & "*"""
Of course, unchecking the box restored the operation of the code.
Is there any benefit to selecting the option: "SQL Server Compatible Syntax (ANSI92)"?