Search results

As you can directly go live after developing the software using the MS Access 2013, Is it an alternative for the ASP.net as everything now is online directly. Please clarify, Thanks a lot

How to convert the data shown when opening the SQL Server tables as "#" symbol As a way to encrypt the data in the SQL Server, I have observer that when opening the SQL Server tables, I see it shown as "#" syble. How can I achieve this with my SQL Server database so not possible to read it...

Is there a VB code that I can use to automatically compress and repair the database?

I have searched all the sites for the MS Access 2003 Run-time software, but I failed to get it. It is a free software and free to redistribute. It is available in the Access Developer extension copy. I will appreciate If there is anyone who can tell me a web link I can use to download this...

If my computer name is Elephant, and I want to look for all the SQL instances at this computer, How can I get those?

I would like to write a stored procedure that insert data from table [SourceEvents] located at a DB linked to DSN called CARDAX into another table [AllAttendanceEvents] located at the same DB of the stored procedure, which this DB is linked to a DSN called BAHRAIN. If both tables are located...

I have a stored procedure that takes time to execute. It is supposed to work properly, but the problem is that it shows the message "Timeout expired" before showing making the results. How can I increase the total Timeout so it will not give me this message? Thanks in advance.

How can I move from record to the next record as what we do in the VB Code by using movenext and moveprevious. How can I achieve this in the SQL Server code. Thanks,

I want to call a SQL server User Defined Function UDF from MS Access code and get its returned value. I successded in calling it but I dont know how to get its returned value. The code I used is as follow: MyIx = 50034 MySt = "20/12/2007 20:30:00" Set db =...

I have a SQL Server database. I buildt a stored procedure FindPSF as follow: CREATE PROCEDURE dbo.FindPSF(@Ix int) AS SELECT Indx, AttDay, Start, Finish, DATEDIFF(day, Start, Finish) FROM dbo.SelectedEmployeesWorkMode WHERE (Indx = @Ix) AND (NOT (Start IS NULL)) AND (NOT (Finish...

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...

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...

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...

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 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.

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,

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.

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.