Search results

Hi, I have problem for exporting data to the Excel from MS Access. I wrote the code to export the data to excel .... .worksheets(1).cells(1,2) = value .... .... I export the data to Excel worksheets row by row because I want to fix the values in the certain position. When the program is...

Hi, When I insert the comment in the worksheet of the Excel application. The shape is rectangle. which button we can change to another shape (eg. Balloon, etc...) ? I know how to do it by programming code. But, I want to know that the menu bar button. Can we have it in the menu bar?

Hi, suppose the cmt is string variable cmt = "Invoice 1:" & Chr(10) cmt = cmt & "Num: 1" & Chr(10) cmt = cmt & "Company: Microsoft" cmt = cmt & Chr(10) cmt = cmt & "Invoice 2:" & Chr(10) cmt = cmt & "Num: 2" & Chr(10) cmt = cmt & "Company: IBM" .Worksheets(1).Cells(1, 5).AddComment cmt...

Hi, suppose the cmt is string variable cmt = "Invoice 1:" & Chr(10) cmt = cmt & "Num: 1" & Chr(10) cmt = cmt & "Company: Microsoft" cmt = cmt & Chr(10) cmt = cmt & "Invoice 2:" & Chr(10) cmt = cmt & "Num: 2" & Chr(10) cmt = cmt & "Company: IBM" .Worksheets(1).Cells(1, 5).AddComment cmt...

Hi, I have a question. Does anybody know about "MS Access Record-Locking Information"? And, the file extension is .xxx Only one person can open the file. Does anybody explain to me and teach me how to make/solve it? Or, offer the link about it to me? I want to know that. Thanks a lot.

Hi, I want to make sure between HTML and ASP. Most of the HTML codes can be used in the ASP, right. The only different is the syntax, and ASP can support database, and ASP is running in the server. In HTML, <img src="boat.gif" alt="Big Boat"> In ASP, Response.write("<img src='boat.gif'...

Hi, I created my own menu bar in one MS Access file, let's say db1.mdb. Can I import it to another database file (let's say db2.mdb)? Thanks.

I have a question of the user-level security. I setup the user-level security in MS Access, there are many users. I want to write the code to find which users are Administrator. Do we have function to check the user's permission? eg. user1: Administrator user2: full permission user3: backup...

When I send e-mail from Access via outlook with a link, there are warning message when the user click the link to open the file: WARNING: web pages, executables, and other attachments may contain viruses or scripts that can be harmful to your computer. It is important to be certain that this...

Hi, I have a question between ASP & SQL Server. I am new. I created a ASP website, I put the MS Access database file in the ASP Account. And then, I wrote the code to open the MS Access file. This one is ok. Recently, I install the SQL Server into my home computer, my computer is NOT server...

Hi, I have a simple question. If I put the database file in the sharing drive, everybody can access it. If there are 2 persons access the same query at the same time, will it affect? The query is only retrieve data. NOT update/add. Example: User 1: qry1: criteria: Vendor = "Microsoft"...

Hi, I have a question. I create a free ASP website. The website I want open the MS Access database file, so I need to put the database file in the ftp, right. After that, it shows Not a valid file. Example: conn.Open "ftp://31@ftp.web.com/try.mdb" I think that there is a problem of this...

.HTMLBody = "<A HREF='C:\Microsoft Office XP\Office10\MSACCESS.EXE' C:\db1.mdb /WRKGRP 'C:\Secured.mdw' >Open database</A>" De-secured, I know that, but that's not what I want. I have to setup the security for db1.mdb, but when I send the mail via outlook, I want every member to open the...

I try to use UNC coding "C:\Program Files\Microsoft Office\Office10\Msaccess.exe" "\\Tryserver\Access\db1.mdb" /WRKGRP "\\Tryserver\Access\Secured.mdw" It doesn't work. What's wrong with it? Please let me know, thanks.

Hi, I have a question, if I have Visual Studio.Net, Can I run the ASP file directly in the Visual Studio.Net application without install IIS? Thanks.

It cannot open it. I don't why, maybe there is security.

Hi, I try to modify it. Private Sub Command0_Click() Dim MiOutlook As Outlook.Application Dim MiCorreo As Outlook.MailItem Dim NombreFichero As String Dim NombreFicheroConRuta As String Set MiOutlook = New Outlook.Application Set MiCorreo = MiOutlook.CreateItem(olMailItem)...

Private Sub Command0_Click() Dim MiOutlook As Outlook.Application Dim MiCorreo As Outlook.MailItem Dim NombreFichero As String Dim NombreFicheroConRuta As String Set MiOutlook = New Outlook.Application Set MiCorreo = MiOutlook.CreateItem(olMailItem) With MiCorreo...

Hi, In VB, Tool->reference, Redemption.dll What library name I use for Redemption.dll? Because I cannot find the library which is related to Redemption. Thanks.

Hi, I have a question. Suppose there is a table: Vendor__________Code ...................... A________________1 A________________2 Dcount("Code","table","Vendor = A") = 2 It is fine. Vendor__________Code ...................... A_______________1 A_______________1 A...