Recent content by accessman2

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.