Search results

You can use the shell command Shell "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe C:\PDF_name.pdf"

Hello, I have some tables in an advantage database (similar to SQL Server). I would like to import these tables into an Access database and am looking for the most efficient method of acheiving this. I am currently using dao to accomplish this - using currentdb.execute "select tablename into...

Hello, This may be a stupid question, but is it possible to put multiple ranges in a range statment? for instance, I am using the code: with xlsheet .range("A1").font.bold = true .range("D4").font.bold = true .range("L9").font.bold = true ....etc. Is there a way to combine these three...

FYI - Problem solved Hello, Just wanted to let everyone know that I was able to solve this issue. I loaded the data by opening the .servlet file in excel using vba and saved it as a text file. I then used docmd.TransferText to put the data into the table. I used an append query afterwords to...

Hello, I have a client who downloads data from a website. I must then put this data into an access database. The problem I am having is that the file is a strange format - it comes to me as filename.servlet[3] I am assuming that this is some kind of java file, but am not really sure. I can...

Hello, I am using a Microsoft Web Browser Control to allow a user to access a web page from within my database. This web site requires a logon. I was wondering if there is a way to default the values for the logon on the web site from within the database using vba. Any thoughts appreciated...