MYSQL functions within Access

[toplisek]

As we know UUID() and NOW() functions are MySQL functions. I like to set equivalent functions and features in Microsoft Access.

What will be the same functions and where to put?

I'm new to this.

 

[Banana]

Access already has a Now() function which returns similar result. (However, if you want same date time, you'll have to wrap it in Format() and pass the ISO definition in)

I'm not aware of an native function to create a GUID but I know there's several examples of using API calls to create a GUID in Access. This would be one of examples you can google for.

 

[toplisek]

Can you enclose some snap please how to put correct NOW()

 

[Banana]

SELECT Format(Now(), "yyyy-mm-dd hh:nn:ss");

 

[toplisek]

Can be this stored in cell or some other table view/menu/tab?

 

[Banana]

Elaborate.

 

[toplisek]

Will test but I'm new to functions. What are steps to insert function like quoted:
SELECT Format(Now(), "yyyy-mm-dd hh:nn:ss");

Office 2007 PRO

 

[DCrake]

Query usage:

RightNow:Format(Now(), "yyyy-mm-dd hh:nn:ss")

However if the query takes longer than one second to run the value will change from the top recrod to the bottom record.

 

[toplisek]

Thanks, how to set UUID()

 

[toplisek]

How to set UUID()

 

[DCrake]

What does UUID() provide in MySQL?

 

[toplisek]

Put the following inot Google input:
UUID function in MYSQL

 

[DCrake]

You can set a primary key to be autonumber and return a GUID in Access which to me is similar to UUID() how you use it is up to you.

 

[toplisek]

You can set a primary key to be autonumber and return a GUID in Access which to me is similar to UUID() how you use it is up to you.

Can be this set the same in Excel?

 

[Banana]

toplisek -

I'm not aware whether Excel provides a built-in function for creating GUIDs/UUIDs. However, I've already linked to an API call you can use to create one and thus insert into cell. See post #2 above.