Search results

I want to exclude the time value from a date/time variable without affecting the date/time format of the user. For example if the date/time variable is "1/12/2007 09:12:46", I want to get the value as "1/12/2007". I dont want to use the format("dd/mm/yyyy") function because it will affect the...

The following error is given Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '30/12/2007'.

I have a stored procedure "BuildAttendanceEvents_GroupByEmp". It has two parameters: @loadfrom datetime, @loadto datetime. I want to execute this procedure with the two parameters: LoadFrom: "30/12/2007" LoadTo: "15/01/2008" When I write the following SQL statement to execute the...

It is no access object. I want to make it through code.

The following code is written inside a public function in my MS Access project Module. It calls a stored procedure which its work successully when I execute it directly. But when I call it from this function, the error generated is "ODBC call failed" Dim BuildAttendanceEvents_GroupByEmp As...

What you said is not correct. HowEver, thanks for reply.

I created a stored procedure called BuildAttendanceEvents_GroupByEmp the parameters of this procedure is @LoadFrom, @LoadTo To run this stored procedure from the MS Access, I created a pass-through query, at the Database Window. This query is connected to the same database where the stored...

I need a written code example

I created a stored procedure in my SQL Server backend. What is the simplest way I can use to run it from the MS Access code and pass its parameters. Is there is a way similar to what we do with the backend tables where we add them to our Database window by make a link to those in the backend...

I have searched for the Access 2003 runtime, but I didnt find even from the download center of Microsoft. The one I got are either Access 2007 runtime or Access 2000 runtime, there is no one for the 2003. Can anyone send me a link to download that runtime for the Access 2003? Thanks in advance.

The problem with me is that it doesnt reflected with me. I have tried using PostMessage also to send a system notification after setlocaleinfo. Even then it doesn't work. Can Anyone please help me?

I want to change the short date format of the system I am use to a new format "dd/mm/yyyy" and the time format to "HH:mm:ss". The Locale ID is as the current one. I can get the current short date format successfully by calling the API GetLocaleInfo function. But the API SetLocaleInfo function...

I would highly appreciate if someone told me about a website that I can use to get a full dictionary/library of API functions. Thanks,

This doesnt help me Mr. namliam. Thanks

As I get some problems because of the format of date/time of the system. I would like to try to set the format of the date/time of the system once the system try. After the system finish it return the format to its original format.

Thanks again Mr. RuralGuy for your effort to hep me. The problem arised with me when converting or opening with 2007 without converting are: 1. In 2003, the option "Show in Windows taskbar" works properly. Here in 2007 even if I put it in the code as application.setoption...

Dear RuralGuy, Thanks very much for reply. Do you mean that the Access 2007 will not first convert the 2003 application to 2007 then run it?

I would like to automatically set the format of the data entered by the user or the data read from the recordset to the date/time format dd-mmm-yyyy hh:mm:ss. Can I acheive this automatically by a VB code statement without using the format statement every time I read the data.

I have been very proud that I made a nice and perfect access 2003 system. However, as there are some users who work on access 2007 platform, I made another copy of my system by using the convert to 2007 utility of the Access 2007. However, conversion was successful BUT may problems start...

Thanks but its already same. Dear Boblarson, Thanks for answering with explanation. However, My setting already same as what you advise. Please help if there is any other methods.