Search results

Function Sendmail() As Boolean Dim oapp As Outlook.Application Dim mitem As Outlook.MailItem Set oapp = New Outlook.Application Set mitem = oapp.CreateItem(olMailItem) With mitem .To = "mill@yahoo.com" .Subject = "Testing" .Body =...

Hi: Does anybody know how to disable shortcut key, such as Alt+Enter....? I am creating a database application, I don't want user to use shortcut key to do his stuff. How can I lock/disable shortcut key? Please let you know, thanks.

Hi I added a activex control - spreadsheet on the form, then, I want to use copyfromrecordset function to paste qry to the spreadsheet, but it doesn't work. So, here is a question. Does activex control - spreadsheet allow to use copyfromrecordset function? Thanks.

Hi: I want to do the following T-SQL, but it seems not correct. Can anybody correct me? declare @bp table set @bp = getdate() select * into [@bp] from [Invoice Data] Thanks.

Hi: I know that "ALTER Table [Table Name] ALTER Column col1 TEXT" can change datatype. But, can DAO - TableDefs to change datatype of the fields? i=0 Do While i <= tbl.Fields.count - 1 If (tbl.Fields(i).Name = "Codes") Then tbl.Fields(i).Properties("DataType").Type...

Hi: When the users open the database, I do this For i = 1 To CommandBars.count CommandBars(i).Enabled = False Next i Then, the mouse right click does NOT work. How can I enable mouse right click? Or, when I do the loop, which one I should not disable in order to keep mouse right click active...

Hi: I created a contineous form. And there are 5 textboxes on each row. I want to create a mouse move event, when the user move the mouse on one textbox of one row, it will change to blue color of that specific textbox. How can I do that? Because when I do like this textbox1.backcolor = Blue...

Hi, When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So...

Hi, when I run the view, it give out Timeout Expired. How can I make the connection longer to run View? Thanks.

Hi, I have a question for storing, read, and write BLOB in MS Access (ODBC Linked from SQL Server tables). I store the pdf in the table, meaning store binary data in the table. It works well. I know that we can extract the file from the database to the temporary file, and then linked the file...

hi: I use CopyFromRecordset to export the data to Excel worksheet. I have error message. I have one field column which stores message/comments, there is one message/comments is very long, like 6-7 lines long. This record affect to export data to Excel using CopyFromRecordset function. How do...

Hi, Does Access 2007 Runtime have all support files (.dll)? Because when we create ActiveX Control Object in MS Access 2002-2003, we need .dll files to run it.

Hi, I have full version on MS Access 2003. I create database and insert a few ActiveX Control on the forms. After that, I put the file in the sharing drive, then the user can open it and use it. But, The user only have Access RunTime to run this file, but they cannot run the ActiveX Control...

Hi, I am using VB 2005 Express now. I am using DataGridView to display the values. How can I display 10 records limit on each page? Do we have a object to display 10 records limits with arrow button to negavate to go previous/next page...? Do we have that in VB2005 Express? Thanks.

Hi, do we have a T-SQL command to copy table with key and identifier and deflaut value? because I use select * into dbo.newtbl from dbo.oldtbl, it doesn't copy key and identifier and deflaut values.

Hi, How many records I can display on the Listbox? Because I have 500 records in SQL Server, and then I ADO connection to add each value of the listbox. But, it give out the data is too long, and it doesn't work.

Hi, I placed many Excel files in the share folder. And then, I create a MS Access form, and one button, the button will copy the worksheets of one Excel file, and then create the new workbook, and paste it over there. Dim obj As Object Dim objXL As Object Dim objActiveWrb As Object Set obj =...

Forms - Additem of the List Box -------------------------------------------------------------------------------- Hi, When I add new item of the listbox with the following listbox0.additem "a,b,c" it will list 3 rows a b c How can I put it in the same row with a,b,c (with comma)? Thanks.

Hi, When I create the Data Access Pages, I put the table values fields on the page, but it does not allow the user to edit the data. If I just create Textbox there, we can type it. So, Does the Data Access pages only view data? It doesn't allow the user to edit data. And also, I create a few...

SELECT Date, [Check] = CASE WHEN [Elec] = 'A' THEN 'T' ELSE 'Exe' END FROM Employees The View query does not support Case statement. Whereas Query Analyzer support it. In View, how can I make if statement over there?