I was looking for Microsoft Access assistance for an issue I'm having with importing date data from a .csv file. I'd like to import as Date, Short Date. The only option I'm seeing is Date with Time, which does not work when importing my date data. Using the date with time option actually deletes all of the dates that I'm trying to import. If I select text, I need to go in and change all date fields after each import to be date, short date formatted. Help please! Am I missing something? Can this be fixed, or will I need to first change my file to Excel in order to import the date correctly?

In 64-bit VBA hosts, inlined member calls on user objects don't work like on 32-bit VBA hosts.

Given a UserClass with a getter/setter and a Class_Terminate handler (even it is empty).
And in a TestModule a factory procedure returning an instance of this class and also setting the setter.

When I now use this procedure and inline check the value of the getter like in the following sample, it results in a different behaviour compared to 32-bit VBA:

If CreateUserClass(True).TheValue Then

Please take a look in the attached text file for a complete sample:

UserClass.cls:

Private mValue As Boolean

Private Sub Class_Terminate()
'
End Sub

Public Property Get TheValue() As Boolean

TheValue = mValue

End Property

Public Property Let TheValue(ByVal value As Boolean)

mValue = value

End Property

TestModule.bas:

Public Function CreateUserClass(ByVal value As Boolean) As UserClass

Set CreateUserClass = New UserClass

CreateUserClass.TheValue = value

End Function

Public Sub ShortTest()

Const VALUE_TO_TEST As Boolean = True


Debug.Print "Value to check: " & VALUE_TO_TEST

If Not CreateUserClass(VALUE_TO_TEST).TheValue Then

    Debug.Print "This is wrong"

Else

    Debug.Print "This would be correct"

End If

End Sub

Old versions of office allowed users to install on any hard drive they wanted. The current office 2016 consumes up valuable hard drive space for the Operating System. Allow the user to decide where they want it installed. To make it easy have a express or custom option for installation. I have seen many companies use this option it allows easy installation for those who are less tech savvy and those who have experience to customize their installation. I use Visual Studio 2017 and it allows an installation option. THIS IS A MUST most people have small hard drives for the OS especially SSD which are about 140 GB which is OK for an OS itself.

Draw a line under the product. Create 2 products:
Express/User version which ONLY has macros. (no VB projects)
The express version can be further tweaked to prevent creation of multi user projects

Professional/Enterprise Developer version for Developers

with the some stripped out features put back

The Pro version features:

1.The this version should also allow simple targeting of Mobile devices.
2.Source control
3.AZURE SQL and SQL Server projects

This will Sell MORE cloud services

4.Improve the crappy forms projects so they are as good as VS.NET (Express....)

5.Improve reports and integrate with SQL Server reporting.
Create PDF reporting

6.Scrap the new macro editor it is really annoying.

7.Present a consistant data model. Lets face it : random use of DAO, RDO, and ADO is poor practice
Follow my idea above and give us the .net data model. SCRAP DAO Support

8.Add proper stored procedures both locally and in SQLServer/Azure projects.
9.Provide an in BUILT way for backing up each section of the Accdb to source control if you persist with the single file model

10.Provide a simple way of exporting the schema as DDL
11.Provide a Cloud solution in office 365 for DEVELOPERS.
12.Remove VBA and add VB.net or C# for developers. With a developer framework library

13.DROP the single file model
14. Provide a managed back end for workgroup development in the peer currently
occupied by sqlserver express.

14.Hire me as your product manager currently this product is losing your most important customers FAST.

Well looking at that list makes me think: Visual studio: New project Type ....

Equdos is a microsoft partner.
Equdos ART Team specializes in migrating VBA projects to the cloud
and mobile devices (thanks for the work)

We have developed in EVERY version of this product.