Re: Export Date to outside system

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Klatuu wrote:
> Interesting.
> Format(Date,"mm/dd/yyyy") on today's date should return 10/05/2005
> Post back your code so we can see if there is a problem

Format(Date,"mm/dd/yyyy")

....should work in VBA code. In a query or ControlSource expression you need
to add the parenthesis.

Format(Date(),"mm/dd/yyyy")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Build Dynamic Query from Form
    ... I didn't follow the bit about why you "really need to this in the query" *instead* of in VBA code. ... Declare the parameters in your query, so JET knows their data type. ... I got it working in my Report, but all it does now is filter for dates, the ... Dim strDateCondition As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do i count and store "selected" check boxes in a query?
    ... it takes me to the VBA code and highlisted my new line of code. ... the "IsGroup" check and so when i print label for the orders; ... To use an insert query, you will have to use VBA code (as a procedure ...
    (microsoft.public.access.queries)
  • query returning oldest record only
    ... This is the query as run in Access which returns bad results. ... I also get proper results when I use ADO. ... Working continous form VBA code. ...
    (microsoft.public.access.queries)
  • Re: Concatenating the same field from multiple records
    ... It's better to use the Execute method of CurrentDb for executing queries ... Dim dbs As DAO.Database ... if i was to take the SQL for the append query and use it in VBA code, ... it be better to execute the query, or can i use docmd.sql " my sql here" ...
    (microsoft.public.access.queries)
  • Re: CrossTab Query with Parameter
    ... - The parameters are not recognised as parameter, because in xTab1 I do not ... In the cross-tab report, the parameter is not filled properly in the ... 'underlying query'. ... using VBA Code if need be, but please try to provide me with as much ...
    (comp.databases.ms-access)